Sorting and Filtering a Table to Answer a Question · seed 1 · A4, ink-friendly. The answer key prints on its own page for grown-ups.

Let the table answer the question

Computing · Digital Literacy · ages 12-13
Name ______________________   Date ____________

  1. You want the smallest values on top. Which sort do you pick?

    • Largest to smallest
    • Smallest to largest
    • No sorting at all

  2. What should you do before touching a big table?

    • Turn the question into the sort or filter it needs
    • Delete half the rows at random
    • Read every row from the top

  3. You only want rows from one class. What do you use?

    • A filter on the class column
    • A brighter screen
    • A new table

  4. You need the five best scores from Birch class. What is the correct order of moves?

    • Sort all scores largest to smallest, then read the top five
    • Filter to Birch, sort largest to smallest, read top five
    • Read five random rows

  5. You sort scores largest to smallest. Why do names move with their scores?

    • To keep the screen colourful
    • Because each row is one record that must stay together
    • Because names like travelling

  6. A table has 20 rows. A filter on Birch class leaves 8 rows. A second filter on scores above 80 leaves 3 rows. How many rows survived both filters?

    Answer: ______________

  7. Two filters leave zero rows. A friend says the table is empty. What is the sharper reading?

    • Zero means the answer is zero pupils exist
    • The table is broken forever
    • No row meets both filters, so loosen one

  8. A friend sorted scores but kept names fixed, then praised the top pupil. What is wrong with the praise?

    • Nothing, the top score is always right
    • The names no longer match the scores
    • Praise is never allowed
LightMySky · lightmysky.comW1-mt_6-UzZXVWwV-s1

Answer key

For grown-ups. Fold this page away before handing over the rest.

Let the table answer the question W1-mt_6-UzZXVWwV-s1

  1. Smallest to largest · Smallest-to-largest lines rows up from the lowest value down the column.
  2. Turn the question into the sort or filter it needs · A planned sort or filter aims the table at your question from the start.
  3. A filter on the class column · Filtering to one class drops every row that does not bear on the question.
  4. Filter to Birch, sort largest to smallest, read top five · Filter to the class first, then sort, and the top five rows are your answer.
  5. Because each row is one record that must stay together · A row ties one pupil to her score, and splitting them invents false records.
  6. 3 · Each filter narrows the set, and only 3 rows pass both conditions.
  7. No row meets both filters, so loosen one · Empty survivors mean the conditions exclude everything, so inspect and loosen them.
  8. The names no longer match the scores · Split rows pair scores with wrong pupils, so the named winner may not own the top score.
Worksheet · LightMySky