KS3

Summary - New: 3rd Edition

This unit is suitable for pupils who have a basic knowledge of spreadsheets including cell references, simple formulae and formatting, although these topics are revised in the fi rst lesson, making it also suitable for pupils new to spreadsheets. The unit is centred around creating a fi nancial model for a TV show. Pupils start by looking at different types of model and then use basic spreadsheet techniques to create and format a simple fi nancial model to calculate the expected income from viewers’ voting. The model is then extended to include sales from merchandising, with the introduction of “what if” scenarios. Finally the pupils create a seat booking system to book seats and calculate income from seat sales. Spreadsheet features covered include SUM, MAX, IF and COUNTIF functions, cell naming, conditional formatting, validation, charting and simple macros.

What's included in the toolkit?

The currently available units have been written to satisfy the new National Curriculum for Computing, they are designed for teaching at KS3 but individual lessons in some units may also be appropriate for teaching Key Stages 2 or 4, particularly where Year 10 students may not previously have been exposed to certain topics.

• PowerPoint slides for each lesson
• Detailed lesson plans
• Learning objectives and outcomes
• Statement of which of the Government Guidelines are covered in the unit
• Worksheets and activities
• End-of-unit Assessment material
• Other material and links to online resources

What people say...

“

”

It is with your units that I have built my new curriculum and approach around.

Mrs P Jennings. Curriculum Leader for ICT, Kingsbury School

“

”

Our year 8 girls really enjoyed the Python Unit and even complained when we moved on to another topic.

Don Smith. Head of ICT, Greenford High School