Computer Science & IT

Business

Design & Technology

Information

Search


Back to All Units

KS3

£120.00 + VAT

+

Spreadsheet modelling

Develop and test a new business model

 
K

Inside the Unit...

Areas Covered

  • Lesson 1 Computer modelling
    Download free sample below
  • 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 fi rst lesson, making it also suitable for pupils new to spreadsheets. The unit is centred around creating a fi nancial 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 fi nancial 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...

“
”

Having used your resources at KS3, these are well received by the students and teachers alike. They are well structured and resourced with answers.

Mr Myles Coulson. Teacher of Computer Science, Tabor Academy

“
”

I am very impressed with the quality of the lesson plans, other resources and the presentation of the documents. We are giving our KS3 a curriculum a complete overall and your projects make up 90% of the new lessons.

David Smale. Head of IT & Computing, Al Bateen Secondary School, Abu Dhabi

Inside the Unit...

  • Areas Covered

    • Lesson 1 Computer modelling
      Download free sample below
    • 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.

    Download Free Sample 6.7mb

  • 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

  • Pricing and Discounts

    • Lifetime site licence for:
    • 1 KS3 unit £120 + VAT
    • GCSE & IGCSE units are individually priced
    • A Level units are individually priced
    • Discount for 2-5 units 10%
    • Discount for 6-11 units 15%
    • Discount for 12 or more units 20%
    • Budget plans are available. There are no annual renewal fees.