Did you know that a spreadsheet can show fewer rows without losing a single record? When students work on a shared class survey or Science log, three familiar commands—sort, filter and hide—make very different promises. Reading the command accurately is part of protecting the evidence and your teammates’ work.
The quick answer: sort changes the order in which records appear; filter displays records matching chosen conditions while leaving the others in the sheet; hide manually conceals selected rows or columns. None of these words means delete. In a shared document, the crucial extra distinction is whether your operation changes everyone’s view or only a personal filter view.
A four-row investigation: what actually changes?
Imagine four fictional records in a Secondary 2 class garden project. These are demonstration figures, not measurements from any school. Every record has an ID, plant, observation day and height: A01 / bean / Monday / 12 cm; A02 / basil / Wednesday / 7 cm; A03 / bean / Friday / 16 cm; A04 / mint / Tuesday / 9 cm. The ID is the anchor linking every measurement to one plant and day.
Suppose a learner wants to find the tallest observation. A sort by height, descending should display A03 (16), A01 (12), A04 (9), A02 (7). All four remain. Suppose the teacher instead asks to examine only beans: a filter where plant equals bean displays A01 and A03, while A02 and A04 stay in the underlying dataset. If A02 is hidden manually, just that row is concealed, regardless of its plant. Each action answers a different question.
The mistake to avoid is sorting the Height column alone and leaving IDs and observation dates in their original positions. The resulting table might falsely pair A02 with 16 cm. When sorting tabular data, select the complete records or use a proper table/filter action so related cells travel together; confirm headings and ranges first.
What sort really means: change sequence, not membership
Sort belongs to a word family: sort, sorted, sorting, sort order and sort key. An ascending numeric sort goes from smaller to larger; descending goes the other way. Alphabetical sorts have their own ordering conventions; dates must be recognised as dates rather than inconsistent-looking text.
A school librarian may sort a list by due date to find what needs attention first. A student comparing plant heights may sort by size. Neither action chooses a representative sample: moving a row to the top does not make it more common or more important in the population.
- Diagnostic: After sorting the four plant records, how many observations should be present? Answer: four.
- Diagnostic: If the largest height was 16 cm before sorting, does sorting increase it? No; the value stays 16 cm.
- Transfer: In Mathematics, sorting can make a median easier to locate, but the labels for each observation must remain attached.
What filter really means: a question translated into a condition
Filter operates on a rule. In the example, the rule is plant is bean. More advanced filters might ask for height greater than 10 cm, or plant is bean AND observation day is Friday. The conditions are not interchangeable. AND narrows to records meeting both conditions; OR can include records meeting either condition.
If the filter shows two of four records, the correct sentence is, ‘Two records match this filter.’ It is not, ‘The class collected only two observations.’ Vocabulary tells us whether a sentence describes a view or the complete evidence. That distinction matters when a learner writes a Science conclusion.
A filter may be active without an obvious explanation in a screenshot. Ask: what range is covered, which columns contain conditions, and how many records exist in total? In a shared sheet, read the filter indicators before announcing that classmates have forgotten to enter data.
What hide means: remove from view without applying a scientific rule
A manually hidden row might contain a long teacher note, a draft field or extra calculations. Hiding is not the same as excluding a scientifically invalid observation. An observation can be hidden for display convenience yet still belong in the calculation; an excluded observation needs a defensible rule and a recorded justification, not merely a click.
Hidden, filtered out, deleted and excluded from analysis should therefore be treated as different labels. A hidden row can be unhidden; a filter can be cleared; deletion removes values and may require recovery from version history; a formal exclusion changes the analysis set for an explicit reason.
If a class shares a filtered screenshot, include a clear caption such as ‘Bean rows shown; other plants retained in master sheet.’ It prevents a reader from mistaking two displayed rows for the entire project.
A shared spreadsheet adds one important word: view
Google Sheets distinguishes a basic filter from a filter view. Google’s documentation explains that a basic filter can affect what collaborators see, while a filter view lets someone analyse a subset without changing the others’ working display. A student preparing a personal revision shortlist should prefer a personal filter view when supported, rather than rearranging a shared teacher master sheet.
In a small project, this becomes an etiquette rule: before applying a sheet-wide sort or basic filter, tell collaborators what you are doing, check that other people are not in the middle of data entry, and make a copy or preserve version history for risky rearrangements. For a graded submission, follow the teacher’s file-sharing and privacy instructions.
A five-minute practice students can actually complete
- Minute 1 — Identify: Copy the four fictional plant rows into a scratch sheet. Name each column. Say aloud what each record represents.
- Minute 2 — Predict: Without clicking, write the ID order after sorting heights from largest to smallest; then test it.
- Minute 3 — Filter: Show only beans and count the visible records. Clear the filter; check that all four return.
- Minute 4 — Hide: Hide mint deliberately, then unhide it. Explain why no evidence has been removed.
- Minute 5 — Teach back: Explain ‘sort’, ‘filter’, ‘hide’ and ‘delete’ to a partner using a different example, such as CCA attendance or a book inventory.
For Primary 5–6 students, keep the task to naming rows and distinguishing visible from total. For secondary G1/G2/G3 Science and Mathematics, add AND/OR conditions, numeric comparisons and a written interpretation. At JC or polytechnic, extend the conversation to reproducible filters, missing-data rules and documented exclusions. These are suggested teaching levels, not claims about the exact assessment requirements of any cohort.
Where learners go wrong—and the sentence that repairs each error
- ‘Only two rows means only two pupils answered.’ Repair: ‘Only two rows are visible under this filter; the full response count must be checked.’
- ‘We sorted the numbers, so the data are improved.’ Repair: ‘Sorting changes order, not accuracy.’
- ‘I hid the outlier, so the mean is now valid.’ Repair: ‘Hiding a value is not a justified exclusion. Investigate the reading and disclose the method.’
- ‘The filter showed a higher average, so the class improved.’ Repair: ‘That could be a different subset. Check denominators and calculations before comparing.’
The last error connects to a different, already-owned lesson: why a spreadsheet average can change—or fail to change—when rows are hidden or filtered. Use that guide when the question is about formulas such as AVERAGE and SUBTOTAL; this lesson is about what the interface words instruct you to do and how to avoid changing your teammates’ interpretation.
The vocabulary deepens when sentences become precise
A strong description says, ‘I filtered for observations taken on Friday,’ not merely ‘I moved Friday up.’ We sort by a column, filter for a value or filter out a set, hide a row, unhide a column, and restore the complete view. These collocations are useful because software menus and teacher instructions often use the same verbs.
Notice register, too. ‘Show only beans’ is friendly classroom speech; ‘apply a filter where Plant = bean’ is a reproducible data instruction; ‘analyse only observations meeting the inclusion criteria’ is formal research language. A learner who can move between the three can explain a method instead of merely clicking buttons.
Three checks before sharing results
- Membership: Are there four underlying observations, or only two? Show both full and filtered counts.
- Identity: After sorting, does each ID still match the right plant, date and height?
- Visibility: Does the screenshot or chart reveal that a filter is active, and has the filter been cleared for the next collaborator?
Parents can ask their child to describe which records are invisible without making the child redo the whole project. Teachers can attach one ‘show all rows’ checkpoint to the task, then invite learners to explain why hiding a row and removing an invalid measurement are not equivalent. Students should retain the unfiltered source as the shared source of truth.
Frequently asked questions
Does sorting automatically remove duplicate rows?
No. A standard sort rearranges records. Identifying duplicates requires a separate check and a policy for what counts as a duplicate—for example, matching ID and observation day rather than matching heights.
Can a filter make a misleading chart?
Yes, if the caption suggests the chart covers everyone while the filter selects only some. The filtered chart may be perfectly accurate for its stated subset. The error is reporting the scope incorrectly.
Is a hidden row confidential?
No. Hiding is a visibility convenience, not an access-control or privacy measure. Remove or properly restrict sensitive information rather than assuming hidden rows keep it secret.
Do all spreadsheet apps handle personal filter views identically?
No. Menus and collaboration behaviour vary by app and version. Verify the operation in your software’s current help pages; do not transfer one app’s shortcut blindly to another.
Reliable reference points and a next learning step
Google’s Sort & filter your data instructions and its basic filter versus filter view comparison explain the interface distinctions. For larger learning routes, begin at the eduKate vocabulary learning hub; for careful interpretation of spreadsheet means, use the separate formula guide above. The unchanged Clementi Secondary 1 Mathematics teaching reference illustrates the value of diagnosing one misconception before extending it.
Keep this question: Did I change the order of the evidence, the visible subset, or just the screen? If a student can answer that before a click, vocabulary has become a practical safeguard for Mathematics, Science, group work and adult data decisions.