Skip to main content

Education recovery: Explore our curated collection of CPD, resources and support.
Online courses: FutureLearn are changing what data they store as part of GDPR on 20 Oct 2021. You may need to take action.



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]