There are 6 worksheets with skeleton and completed spreadsheets for pupil use and demonstration purposes in this unit.
Summary
This revised unit is suitable for pupils regardless of their previous spreadsheet experience. An introduction to spreadsheets lesson has been added to this new 10th Anniversary Edition which goes through the basics for those who are new to spreadsheets. For those with more experience it serves as a useful revision lesson.
The unit covers relative and absolute cell references, formulas, functions and formatting. The unit is centred around creating a financial model for a TV talent 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 some of which are solved using Goal Seek. Finally, the pupils create a seat booking system to calculate income from seat sales. Further spreadsheet features covered include SUM, MAX, IF and COUNTIF functions, conditional formatting, validation, charting and simple macros.
What's included in the 10th Anniversary toolkit?
The new 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.
The 10th Anniversary Upgrade includes:
Revised content based on teacher feedback that fully meets the national curriculum requirements
Full HD 16:9 widescreen presentations with enriched illustrations
New starters and plenaries with every lesson
Full answer slides for all questions asked in presentations
Worksheets with answers for every lesson
Homework sheets with answers for every lesson
Updated learning objectives and unit assessments
Updated lesson plans for new and non-specialist teachers
Pointer slides to worksheet activities in all presentations
An improved foundation and progression for the latest GCSE and vocational qualifications
What people say...
“
”
Really appreciate your work with KS3.
David Price. KS3 Coordinator, Bishopshalt School
“
”
PG Online material for KS3 has been instrumental in helping me transit from ICT to Computing with a department of just two. Cutting down work load in planning SOW and resources. All material have been adapted to suit our school with ease and the pupils are really enjoying the programming elements.
Mark Fegan. Head of Computing and ICT, Sacred Heart High School
