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 11

Spreadsheets

9 lessons

Threads

  • Data and information
  • Effective use of tools

Description

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.

Spreadsheets are a versatile tool used in a range of different contexts. As pupils reach the end of year 11 they will increasingly find more opportunities to use them in more complex ways. This unit will extend the basics of spreadsheets covered in previous units and provide pupils with the knowledge to build spreadsheets that will be robust and present data effectively. The culmination of the unit provides an opportunity for pupils to apply this understanding to a genuine scenario they may face when they leave school.

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

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