lesson

Reorder is not remove

1 · Learn

Sorting changes the order of records, such as shortest to longest by page count. Filtering shows records that match a condition, such as category equals nature.

A filter should not delete the records it hides. Clear the filter to see the full collection again. Use the correct field type so numerical sorting does not accidentally behave like alphabetical sorting.

Sort: change orderFilter: show matchesClear filter: show all
Key words and supplied examples.

2 · Worked example

With page counts 8, 12 and 100, numerical ascending order is 8, 12, 100. Sorting text representations can behave differently in some tools.

3 · Your turn

A filter shows only nature books. Does that mean every other record should be deleted?

Check your answer

No. They are hidden by the view condition, not removed from the dataset.

4 · Apply your learning

Sort and filter an invented table, note the matching record count, then clear the filter and confirm the originals remain.

Adult guidance and safety

Use adult-approved offline or school-managed tools, invented data and original media. Keep projects private unless sharing is explicitly approved. Paper traces support, but do not replace, practical programming and saved digital work. No real passwords or personal records belong in these exercises.

Open your writing and drawing pad

Write, draw or show your working. Use a mouse, pen or finger. This pad is not a submitted answer.

Not saved to your account. Download your drawing as PNG and your typed notes as TXT before leaving or refreshing. They are separate files. Do not enter private information.

Open a picture saved on this device to draw on it again. Opening replaces the drawing, but Undo can restore it. PNG only, up to 4 MB and 4096 × 4096 pixels. The picture stays in this browser; it is not uploaded. Paper lines in a saved picture become part of that picture.

Drawing is unavailable. Use the typed working area below.

Your pad is empty.

Open a UTF-8 TXT file from this device, up to 40 KB and 10,000 characters. It stays in this browser. Opening can be undone until you type again. Downloads keep a new copy; they do not change the file you opened.

Typed notes are not submitted answers.

Check a calculation · Year 5 onward

Use this only when your teacher or adult allows a calculator for the task. Show your thinking first. It does not replace mental or written arithmetic and does not mark your lesson answer.

Practice this lesson

Lesson resources

Browse the available practice activities and worksheets for this lesson.

Open course resources

Your progress

Ready to continue?