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.



Lesson 1 - Spreadsheets warm-up

In this lesson learners will revisit their spreadsheet skills, check their understanding of the layout of a spreadsheet, and refamiliarise themselves with formulae. The topic will be a television talent show, Rock Star Challenge. Viewers will be invited to phone in and vote for their favourite bands; the phone...

Lesson 2 - The RSC Live event

In this lesson learners will be given a partly completed spreadsheet which represents seating for the live event of Rock Star Challenge. There are different seat prices for adults, students, and over 60s. Users will select seats from a drop-down list and formulae will be used to calculate the price; by using...

Lesson 3 - RSC merchandise

In this lesson learners will be given a partly completed spreadsheet which shows items of merchandise to be sold at the RSC Live event. Learners will research the kinds of merchandise available at events and some prices, and this information will be used to populate a financial model. They will complete the...

Lesson 4 - RSC data visualisation

In this lesson learners will use the spreadsheets created in previous lessons to create charts to visualise the data in the spreadsheets. Learners who were absent for previous lessons could be given the completed versions of the spreadsheets from Lessons 1–3. Charts are often used to quickly give information and to...


Published by


Share this resource