New to PG?
Start here

KS3

£120.00 + VAT Discounted rate from £96.00

+

Spreadsheet modelling

Develop and test a new business model

 
K

Inside the Unit...

Download Free Sample 6.7mb

Areas Covered

  • Lesson 1 Computer modelling
    Download free sample above
  • Lesson 2 Creating a financial model
  • Lesson 3 ‘What if’ scenarios
  • Lesson 4 Conditional formatting and validation
  • Lesson 5 Macros and charts
  • Lesson 6 Assessment

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?

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...

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.

NQT.

Inside the Unit...

  • Download Free Sample 6.7mb

    Areas Covered

    • Lesson 1 Computer modelling
      Download free sample above
    • Lesson 2 Creating a financial model
    • Lesson 3 ‘What if’ scenarios
    • Lesson 4 Conditional formatting and validation
    • Lesson 5 Macros and charts
    • Lesson 6 Assessment

    There are 5 worksheets with skeleton and completed spreadsheets for pupil use and demoanstration 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