Skip to content
Oak National Academy
Oak National Academy
Teachers
Pupils
Choose a curriculum

All exam boards (KS4)

KS3 & KS4 computing curriculum

Unit sequence

Skip to units

Filter and highlight

Year group

Highlight a thread
Computing
Year 7

Data modelling

6 lessons

Threads

  • Data and information
  • Effective use of tools

Description

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.

This unit progresses pupils' knowledge and understanding of modelling data using spreadsheets. They will employ the principle of storing data in variables, learnt in previous programming units, to process this data into useful information to model real-life data sets and find out facts from collected data. These techniques are fundamental to many future applications of data processing both in computing and in other subjects.

  1. Formatting data in a spreadsheet
  2. Spreadsheet calculations
  3. Collecting data for a purpose
  4. Analysing and visualising data
  5. Sorting and searching data
  6. Applying conditional formatting to data
See lessons in unit

67 units shown,

Need help with our new curriculum?

Visit our help centre for technical support as well as tips and ideas to help you make the most of Oak.

Go to help centre