New to PG?
Start here
BooksBusinessComputingDesign & TechnologyEnglishHumanitiesLanguagesMathsPEScienceClearReviseAI TutorAbout
Back to All Units

KS3

£120.00 + VAT Discounted rate from £96.00

+

10AE Spreadsheet modelling

Develop and test a new business model

22

Inside the Unit...

Download Free Sample 8.1mb

Areas Covered

  • Lesson 1 Introduction to spreadheets
  • Lesson 2 Computer models
  • Download free sample lesson
  • Lesson 3 Creating a financial model
  • Lesson 4 What if scenarios
  • Lesson 5 Conditional formatting and validation
  • Lesson 6 Macros and charts
  • Lesson 7 Assessment

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?

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:

  1. Revised content based on teacher feedback that fully meets the national curriculum requirements 
  2. Full HD 16:9 widescreen presentations with enriched illustrations 
  3. New starters and plenaries with every lesson 
  4. Full answer slides for all questions asked in presentations 
  5. Worksheets with answers for every lesson 
  6. Homework sheets with answers for every lesson 
  7. Updated learning objectives and unit assessments 
  8. Updated lesson plans for new and non-specialist teachers 
  9. Pointer slides to worksheet activities in all presentations 
  10. An improved foundation and progression for the latest GCSE and vocational qualifications 

What people say...

“
”

I am pleased to have used so many resources created by PG Online. They are the best companion in the life of a teacher!

J Kulandairaj. Computer Science Teacher, Brimsham Green School

“
”

I have used two sets of resources so far but the best has been the cyber crime one.  The students have loved it - they all have a tale to tell about email scams and hacking!!

Beverley Castle. Teacher of Computing, St Joseph's Catholic High School

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 8.1mb

    Areas Covered

    • Lesson 1 Introduction to spreadheets
    • Lesson 2 Computer models
    • Download free sample lesson
    • Lesson 3 Creating a financial model
    • Lesson 4 What if scenarios
    • Lesson 5 Conditional formatting and validation
    • Lesson 6 Macros and charts
    • Lesson 7 Assessment

    There are 6 worksheets with skeleton and completed spreadsheets for pupil use and demonstration purposes in this unit.

  • How to order

    1. Add individual units to a draft order or download a blank order form below to complete manually

    2. Using a draft order you can either:

    1. Save your order online
      (registration or log in required)
    2. Email us your complete order
      (registration or log in required)
    3. Create a PDF
      (to fax or email at a later date)

    Download blank order form

    PDF

    Word

  • Unit Pricing and Discounts

    Each unit is individually priced for LIFE. Please view each unit for detail. 

    Discounts are cumulative based on the total number of units licenced to your department.

    All prices subject to further discounts and VAT.

    There are no annual renewal fees.

    2-5 units 10% discount
    6-11 units 15% discount
    12+ units 20% discount