Review: sorting and filtering data
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.
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.
Warehouse and shop staff and event organisers sort lists and pick out items running low.
Write five items and their numbers in a table, sort them from smallest to largest number and mark the two smallest.
| Subject | Mark |
|---|---|
| Algebra | 5 |
| History | 4 |
| Physics | 3 |
| Literature | 4 |
| Chemistry | 2 |
“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.