Computing (Non-GCSE)

Y11 Computing (Non-GCSE)

Key Stage 4

Year 11

Spreadsheets

In this lesson, we will revisit and develop KS3 spreadsheet skills. We will check our understanding of spreadsheet layout, and refamiliarise ourselves with formulae

Spreadsheet warm-up

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.

The RSC Live event

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.

RSC merchandise

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.

RSC data visualisation

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.

Key Stage 4, Computing (Non-GCSE), Spreadsheets

Spreadsheet warm-up

The RSC Live event

RSC merchandise

RSC data visualisation

RSC stock control