Skip to main content



Curriculum > KS4 > Unit

In this unit, learners will gain an understanding and knowledge of how to use spreadsheets to store and manipulate data, how to use common functions, and how to extract data to create visual representations using charts. Learners will use spreadsheets to track and calculate income, make predictions, and answer “what if…?” questions. It is assumed that learners have had some experience of spreadsheets at KS3 level and therefore know how to use cell references, fill colours, and borders, and are familiar with the basic functions, e.g. SUM, AVERAGE, MAX, and MIN.

Unit guide

Learning graph

Summative assessment

Summative answer

Help us make these resources better

Provide your feedback

Or email us at [email protected]