Sorting and Filtering a Table to Answer a Question
A table of a few hundred rows will not answer a question by being read. Sorting brings the extremes to the top and filtering drops the rows that do not bear on the question, and what is left is the answer.
What a learner can do afterwards
- Turn a question into the sort or the filter that would answer it, before touching the data
- Sort by one column and say why the other columns had to move with it
- Filter on two conditions and say how many rows survived and why
1 · Read
In a sheet you can already build, a table with hundreds of rows will not answer you by being read. Turn your question into a sort or a filter before you touch the data. Sorting lines rows up by size, and filtering drops the rows that do not matter.
You need the five best scores from one class. First filter the class column to that class, so other classes vanish. Then sort scores from largest to smallest, and read the top five rows.
When you sort by one column, the other columns must move with it. Each row is one record, like one pupil with her class and score. If scores moved alone, they would land beside the wrong names.
Stack two filters to narrow further, then count the rows that survive. Say the count and why each filter removed its share. The top row after a good sort and filter is your answer, not a guess. If no rows survive, loosen a filter and check why.
Translate the question into a sort or filter, keep rows together, and read the answer off the survivors.
2 · Watch
Take it off screen
Where it sits
8 questions wait behind this lesson, each with its answer explained. Every answer feeds the sky: stars light as they are learned, and dim when it is time to come back.