Accessibility Skip to Navigation Print Page Feedback
EduWight Isle of Wight header image

ICT Home

Key Stage 1
Key Stage 2
Key Stage 3
KS3 Framework
Key Stage 4


Assessment Sheets

Units:  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15 

Other Sections:
Useful websites  National Curriculum in Action  KS3 National Strategy  KS3 Resources  KS3 Framework  Newsletter 

Key Stage 3

ICT KS3 Unit 4 - Models - rules and investigations

images/4.gif

In this unit pupils learn how simple models are built by first investigating rules, then by seeing how rules can govern the behaviour of simple models.

The unit concentrates on setting up a model of the operation of a successful tuck shop. Pupils identify the objectives for the retailer, outcomes from a consumer perspective, the constraints under which the tuck shop has to operate and the likely effects on the retailers' objectives.

Pupils discuss the ways in which the model could be presented in a spreadsheet, identifying the inputs, the rules (formulae) and the outputs. Pupils then work in groups to construct this model, revising cells, formulae and cell references. They test the effectiveness of the model by using sample data representing a number of scenarios.

This unit is expected to take approximately 5 hours.

WEBLINKS Lesson ideas
Download the KS3 Strategy unit from the dfes
Suggestions from The Standards Site
SOFTWARE
  • Spreadsheet software  
    Eg.  Excel (Microsoft)

BOOKS

Sorry no Books defined.

The facilities below are only available to Isle of Wight Schools

Click here to order your Projects from School Library Service
Click here for Education Centre - Library Resources


OTHER RESOURCES

Sorry no Resources defined.

Units:  1  2  3  4  5  6  7  8  9  10  11  12  13  14  15 
  Copyright ©2007 Isle of Wight Council. All rights reserved. Disclaimer EduWight logo
Bobby Approved (v 3.2)