Non-GCSE – Spreadsheets

Resources

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.