Data in a Table: Sort, Filter, Show
The class is having a party and must decide which fruit to buy. There are 12 survey answers — all mixed up. Today you will sort, filter and count them, and show them with a chart everyone understands at a glance.
For the parent: a one-page guide — questions for dinner and a family survey with tally marks.
01Remember
Think about each question, then open the answer.
Why does an e-mail have a subject?
So the person knows what it is about before opening it. The lesson “E-mail: Subject, Greeting, Attachment”.
Where do you keep an important file so you don't lose it?
In two places — one of them far away. The lesson “A Backup Copy: Keeping What Matters in Two Places”.
What is a row and what is a column in a table?
A row goes left to right, a column goes top to bottom. Each row is one answer, each column is one kind of information.
02Story
This story is made up.
Mila is in grade 6. The class teacher says: “On Friday we have a party. Decide which fruit to buy.”
Mila runs a paper survey: everyone writes only their favourite fruit, with no name. She collects 12 slips.
Mila lays them out on the desk. Apple, banana, strawberry, apple, pear… It makes no sense.
Then she copies the answers into a table. She sorts them by fruit — and the same ones line up together.
She counts: apples — 4, bananas — 3, strawberries — 3, pears — 2. She draws bars, and everyone sees the tallest at a glance.
“Apples!” says the class. “And a little of everything else, so there is something for everyone,” adds Mila.
03Worked example
The same 12 answers — four steps:
| Step | What you do | What you see |
|---|---|---|
| 1. 📋 Table | Each answer is a row: number and fruit. | Everything is there, but mixed up. |
| 2. ↕️ Sort | You sort by the “fruit” column. | The same fruits line up together. The data is the same — you only changed the order. |
| 3. 🔍 Filter | You show only “apple”. | You see 4 rows. The others are not deleted — only hidden. |
| 4. 📊 Show | You count and draw bars. | The tallest bar answers the question. |
First the question, then the chart: bars — I compare groups; a line — I see how something changes over time; a pie — parts of a whole.
04Try it now
1 · Predict
The question is: “Which fruit is the favourite of the most children?” Which chart will show this most clearly?
2 · Run: the class table
This is our table. The survey is invented and has no names — only the answer number. Sort, filter, count.
Show it with a chart
3 · Change: another question
A new question: “How does the morning temperature change during the week?” Press and try the three charts again. Which is best now?
05No screen: a family survey with tally marks
You need: paper, a pencil and your family. Building blocks, if you have them.
Think of a question with 3–4 answers, for example “Which fruit shall we buy on Saturday?”.
Ask everyone at home. Don't write names — only a tally mark next to the answer.
Count the marks. Build bars from blocks or draw squares on the paper.
Show the family: which bar is the tallest? What do we decide?
06Make your own
Make your own chart for the family.
- Choose a question the family really needs to answer: a film for Friday, a game for Sunday, a fruit for the party.
- Collect the answers with tally marks, no names. Count them.
- Draw bars. Write the question at the top and the answer under each bar.
- Explain to someone else: show a friend or a younger child how “Sort → Filter → Count → Show” helps you decide something.
07What I learned
- A table has rows (one answer each) and columns (one kind of information each). Sorting changes the order, not the data.
- A filter hides rows for a while; it does not delete them. Counting turns many rows into a few numbers.
- First the question, then the chart: bars compare groups, a line shows change over time, a pie shows parts of a whole.
When every voice is counted, the decision belongs to everyone. What question would your family like answered?
Check yourself
1. You sorted the table by fruit. What has changed?
2. The filter shows only “banana”. What happened to the other rows?
3. You want to show how a plant grows day after day. Which chart do you choose?
It is yours when you can show someone how to get from mixed-up answers to a clear chart. No points and no ranking — only a skill.
08I have a question
Do you still have a question? Write it here. It goes to your parent, not to strangers. Your parent confirms their e-mail first.
The form is loading… If it does not appear, write your question on paper and show it to a parent or teacher.
·Sources
- Title: Data in a Table: Sort, Filter, Show (DB-RK-28) · Author: Children's Library, East Accelerator Foundation · Source: original content and original game code, 2026 · Rights: CC BY-SA 4.0.
- The story is made up. The survey and the numbers in the game are invented and have no names; nothing is saved or sent.
- Which chart when: Government Analysis Function (UK) — “Data visualisation: charts” (published 19 May 2022, opened and checked on 18 Nov 2026) — bar charts work well for comparing the size of groups; line charts are mainly for data over time; a pie only when the parts make a meaningful whole, and if several parts are almost the same size, bars are better.
- Sorting, filtering and counting in a table are common practice when working with tables, not a sourced fact.
- Licence: CC BY-SA 4.0 · Children's Library, East Accelerator Foundation, 2026. You may share and adapt this lesson if you credit the author and keep the same licence. Learning is free forever.