There are 5 worksheets with skeleton and completed spreadsheets for pupil use and demonstration 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.
You have done a great job!! The resources are great and students find them very easy to understand and follow!
Robinson Zapata. Leader of ICT, Richard Challoner School
“
”
May I take the opportunity of passing on my department’s gratitude to you guys for the excellent customer service that you’ve provided to us. It is much appreciated and very impressive.
Mike Elward. Assistant Headteacher, St Crispin's School
