Skip to content

Spreadsheets

Download complete unit ↓(not available yet)

Why this, why now

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions.

Prior knowledge requirements

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

Spreadsheets

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions.

9 lessons
  1. Formulas in a spreadsheet model
  2. Lookup and reference functions
  3. Formatting in a spreadsheet model
  4. Spreadsheet project I
  5. Data validation in a spreadsheet model
  6. Visualising data using charts in a spreadsheet
  7. Spreadsheet project II
  8. Improving a spreadsheet model
  9. Spreadsheet modelling