Computing (Non-GCSE)

Y11 Computing (Non-GCSE)

Key Stage 4

Year 11

Spreadsheets

Non-Computer Science

THEME

Media

IT and the world of work

Online Safety

Project management

UNIT

The purpose of this lesson is to revisit spreadsheet skills learners may have developed in KS3, check their understanding of spreadsheet layout, and familiarise them with formulae

Spreadsheet warm-up

The aim of this lesson is to implement a spreadsheet which represents seating for the live event of Rock Star Challenge. There are different seat prices for adults, students, and over 60s. Learners will use a drop-down list to select seats, and formulae will be used to calculate the price.

The RSC Live event

This lesson aims to begin the process of demonstrating to learners how databases are used to manage sales and stock levels; it links to Lesson 5. Learners will be given a partly completed spreadsheet showing items of merchandise to be sold at the RSC Live event.

RSC merchandise

The purpose of this lesson is to demonstrate to learners how to create accurate and useful charts based on data generated in previous lessons. 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

The aim of this lesson is to link with the sales activity of Lesson 3 and go behind the scenes to examine the database of RSC merchandise. Learners 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

Lessons in this unit

Spreadsheet warm-up

The RSC Live event

RSC merchandise

RSC data visualisation

RSC stock control

Key Stage 4, Computing (Non-GCSE) Spreadsheets

Lessons in this unit

Spreadsheet warm-up

The RSC Live event

RSC merchandise

RSC data visualisation

RSC stock control

Key Stage 4, Computing (Non-GCSE)
Spreadsheets