AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Contents · Computing

Filtering data and review

Lessons 29–30 · 2 lessons · B. Boltayev, A. Azamatov, A. Asqarov, M. Sodiqov, G. Azamatova. Fundamentals of Informatics and Computer Technology, Grade 8. Second edition. “O‘zbekiston milliy ensiklopediyasi” State Scientific Publishing House, Tashkent, 2015
30

Review: sorting and filtering data

Textbook: p. 127
GoalCombines sorting, filtering and formulas to build a table from own data and uses it responsibly.
New words
age formula: current year minus birth year · yosh formulasiaverage score: the total of the marks divided by their count · o‘rtacha ballpersonal data: facts about a person, such as name and birth date, that must be protected · shaxsiy ma’lumotsequence of steps: table → formulas → sort → filter → copy · ketma-ket qadam
Explanation

In review tasks a table is usually prepared in this order: build and format a table with headers, calculate with formulas (age = current year – birth year, average = total : count), then sort in the order needed and filter by a condition. For example, add a “group” column to a table of subjects, write 1 for natural sciences and 2 for social sciences, sort by group and then subject name, and filter those with an average of at least 4. After sorting, check the result: does each row still keep its own data, and are the formulas right? Do not post a table with classmates’ personal data such as names and birth dates openly on the internet, and when sharing it in a cloud service set the permission to “view only”; made-up data can be used for practice too.

💡 Where will I use this?
In real life

A list of items for a school display was made with names and numbers (invented). It was sorted by number, the ones in short supply were picked out and the total was calculated.

Who uses it

Warehouse and shop staff and event organisers sort lists and pick out items running low.

Try it today

Write five items and their numbers in a table, sort them from smallest to largest number and mark the two smallest.

Worked examples
Age: if the birth year is 2012 and the current year 2026, the formula =C2-B2 gives 14. If the current year is in a separate cell, next year only that cell needs changing.
SubjectMark
Algebra5
History4
Physics3
Literature4
Chemistry2
Subjects: Algebra 5, History 4, Physics 3, Literature 4, Chemistry 2. The filter “at least 4” keeps Algebra, History and Literature (3 records).
Class activity

“Imaginary class”: a group builds a table of 6 made-up pupils, calculates the age column, sorts, filters and discusses why made-up data is safer.

Practice
1
If the birth year is 2012 and the current year 2026, what does the age formula give?
2
What is the average of the marks 4, 5, 3 and 4?
3
The subject marks are 5, 4, 3, 4, 2. How many subjects remain after the filter “at least 4”?
4
Why should a table with classmates’ names and birth dates not be put on the open internet?
Story of the Week · The Khwarizmi WayFair dayClose the week: all of this week’s subjects in one storyRead →