The KAGAMI mark КАГАМИ
Children's Librarypublished by: East Accelerator Foundationhost: kagami.bgfree for everyone
kagami.bg/en/deca · children's library · lesson · machine-readable viewVERIFIED 2026-11-18 · AI-assisted: yes · reviewer: awaiting teacher and psychologist
IDENTITY
id
DB-RK-28 · Data in a Table: Sort, Filter, Show (BG: Данни в таблица: подреди, филтрирай, покажи)
track
RK · Working with the Computer · lesson 28
level
Master (apply · compare · explain) · grades 6–7 · ages 11–13
duration
10–15 min on screen + 10–15 min without a screen (with other children or an adult)
school link
not asserted; curriculum alignment unverified ⚠️ (not shown publicly)
publisher
East Accelerator Foundation (Фондация „Източен Акселератор“) · host: kagami.bg
access
free · no account · no data collected · works offline
trust
VERIFIED 2026-11-18 · AI-assisted: yes · reviewer: awaiting teacher and psychologist
versions
bg: /deca/DB-RK-28_danni-v-tablitsa.html · en: /en/deca/DB-RK-28_danni-v-tablitsa.html · parent guide: /deca/pomagalo/DB-RK-28_danni-v-tablitsa.html
LEARNING OBJECTIVES
KEY CONCEPTS
STRUCTURE
ANSWERS
SAFETY
NEXT

DB-RK-29 · My Skills Map: What I Can Do and What I Want to Learn · back: DB-RK-27 · E-mail: Subject, Greeting, Attachment

SOURCES · LICENCE
IMPACT METADATA
path
2 · Learning
determinant
economic and social (education)
sdg_target
4.4 · 4.7
who_criterion
effectiveness
impact_type
knowledge and education
DIGCOMP 3.0
framework
DigComp 3.0 (JRC144121, doi:10.2760/0001149)
primary
1.3 Managing information (proposed mapping; DigComp 3.0 name, JRC144121, checked 2026-11-18)
secondary
3.1 Developing digital content (proposed mapping; DigComp 3.0)
mapping
proposed 2026-11-18 by the lesson goal · confidence: medium · not a measured outcome
TAGS
kidsgrades-6-7datatablesortfilterchartsurveyunpluggedbgen
VERIFIED · 18.11.2026 AI help: yes reviewer: awaiting teacher and psychologist

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.

⏱ 10–15 min Master Working with the Computer · 28 grades 6–7
You will be able to sort and filter a data table, count the answers and choose the chart that answers the question most clearly.

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:

StepWhat you doWhat you see
1. 📋 TableEach answer is a row: number and fruit.Everything is there, but mixed up.
2. ↕️ SortYou sort by the “fruit” column.The same fruits line up together. The data is the same — you only changed the order.
3. 🔍 FilterYou show only “apple”.You see 4 rows. The others are not deleted — only hidden.
4. 📊 ShowYou 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.

  1. Think of a question with 3–4 answers, for example “Which fruit shall we buy on Saturday?”.

  2. Ask everyone at home. Don't write names — only a tally mark next to the answer.

  3. Count the marks. Build bars from blocks or draw squares on the paper.

  4. Show the family: which bar is the tallest? What do we decide?

✋
A survey without names
In the survey we don't write names, addresses or other personal things. Only tally marks and numbers.

06Make your own

Make your own chart for the family.

07What I learned

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?

Skill badge: “Sort, filter, show”
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