Skip to content
Oak National Academy
Oak National Academy
View my library
0
Teachers
Pupils

OCR (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.

Building on their understanding of variables from programming, pupils now apply this concept to organising and processing data in spreadsheets. This unit helps them see how raw data can be structured and transformed into meaningful information, allowing them to model real-life situations and draw conclusions. These skills are essential for future computing work and are widely used in subjects such as maths, science and geography, as well as in everyday tasks where data analysis supports decision-making.

  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

45 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