Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 7 Computing Guides

Year 7 - Computing

Sorting and searching data

Data modelling

Unit Summary

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Lesson Summary

You will learn to use spreadsheet tools to sort and search data to find and analyse information.

Key Notes

  • Data can be sorted in ascending or descending order.
  • Filters can be applied to hide data that is not needed for a purpose.
  • A sort or filter can be applied to a data set to make it easier to analyse or visualise information.
  • A function is a predefined formula in a spreadsheet that can help with calculations.

Vocabulary To Learn

  • sort: arranging data into a meaningful order
  • filter: given criteria used to show a subset of a data set
  • function: a predefined formula that performs a calculation

Common Mistakes To Avoid

  • When a filter is applied to a data set the data that is filtered is removed permanently.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

Data can be sorted in ascending or descending order. Filters can be applied to hide data that is not needed for a purpose.

2. Define this computing term and give one practical example. 'sort'

arranging data into a meaningful order. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: When a filter is applied to a data set the data that is filtered is removed permanently. Correction: A filter can be applied to data to remove selected data from a data set. However, this data is not permanently removed, if the filter is taken off the data will still be there.

More Lessons In This Unit

Browse all guides in the Year 7 Computing guide library.