Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 7)

Unit 4: Models - rules and investigations

QCA

Expectations

At the end of this unit

most pupils will: understand and be able to describe the rules that govern the operation of models such as a school tuck shop; construct and manipulate a spreadsheet model using formulae; explore patterns and relationships; predict consequences of decisions

some pupils will not have made so much progress and will: understand that rules govern the behaviour of models; test the behaviour of simple spreadsheet models; solve problems

some pupils will have progressed further and will: refine and extend a spreadsheet model, varying the rules, based on the results of test runs


Sections in this unit

This unit is divided into sections. Each section contains a sequence of activities with related objectives and outcomes. You can view this unit by moving through the sections or print/download the whole unit.
1. Activity 1
2. Activity 2
3. Activity 3
4. Activity 4