Skip to content

Data modelling

Download complete unit ↓(not available yet)

Why this, why now

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.

Prior knowledge requirements

  • Ardaydu waa inay yaqaanaan aasaaska maadada.
  • Ardaydu waa inay awoodaan inay raacaan tilmaamo fudud.
Unit 6 / 6

Data modelling

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.

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