Lessons (5)
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
In this lesson, we will revisit and develop KS3 spreadsheet skills. We will check our understanding of spreadsheet layout, and refamiliarise ourselves with formulae
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will implement a spreadsheet which represents seating for the live event of Rock Star Challenge. The spreadsheet includes different seat prices for adults, students, and over 60s. We will use a drop-down list to select seats, and formulae will be used to calculate the price.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will learn how databases are used to manage sales and stock levels. We will look at a partly completed spreadsheet showing items of merchandise to be sold at the RSC Live event.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will learn how to create accurate and useful charts based on generated data. Charts are often used to quickly give information and to help visualise sometimes quite complex data, but it is important to select the right chart for the data and to implement the chart accurately.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will go behind the scenes to examine the database of RSC merchandise. We will discuss the use of barcodes and QR codes (2D codes) and the different kinds of data they can hold.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video