There are 5 worksheets with skeleton and completed spreadsheets for pupil use and demoanstration purposes in this unit.
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 first lesson, making it also suitable for pupils new to spreadsheets. The unit is centred around creating a financial 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 financial 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.
I am stunned at the PG Online resources – really professional and high quality for teachers to save time and brilliant to immediately engage pupils. A must-try for NQT's, non-specialist and qualified teachers. Thank so much PG Online for your helpful service as well.
Rachel Shelton. Department of Design Technology, Staffordshire
The resources are great, thanks. I'm really enjoying teaching the lessons. I was observed a couple of weeks ago now when doing an HTML lesson, it came out ‘Good with outstanding features’. Outstanding is very hard to get at this school, believe me! - so I am really pleased.