Topic 2: Sorting and Filtering Data
Sorting arranges data in a specific order, like alphabetically or numerically, while filtering shows only data that meets certain criteria.
Core concept
Sorting data, like arranging names alphabetically or numbers from smallest to largest, helps us find and organise information more easily.
How it works
Filtering data means showing only the information we need, like filtering a list to show only students who scored above 80.
Why it matters
In spreadsheets, we can sort a column with one click and use filters to narrow down large datasets to relevant information.
Key detail
Sorting and filtering are essential skills for managing and analysing data efficiently, whether in a spreadsheet or a large database.
Exam highlight
Key diagram

- A picture showing a data table before and after sorting by a column.
Keywords worth remembering
Trending
Most searched
Study resources
Notes & downloads
Quick notes
• Sorting arranges data in a specific order.
• Example: alphabetically or numerically.
• Filtering shows only data meeting certain criteria.
• Example: showing only scores above 80.
• Spreadsheets allow easy sorting with one click.
• Filters narrow down large datasets.
• Sorting and filtering help manage data.
• These are essential data analysis skills.