Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 7)

Unit 4: Models - rules and investigations

QCA

Outcomes

Section 1: Activity 1
Children:
  • carry out calculations and graphing techniques
  • create correct formulae

View related objectives and activities

Section 2: Activity 2
Children:
  • describe the rules governing systems
  • present the rules describing a system in a structured manner before constructing a computer-based model

View related objectives and activities

Section 3: Activity 3
Children:
  • run spreadsheet software
  • save and reload data files
  • enter formulae using cell references
  • build a spreadsheet model saving each iteration
  • translate rules into formulae
  • use formatting features of software to clarify the screen view of the model

View related objectives and activities

Section 4: Activity 4
Children:
  • enter test data into a model and record outputs
  • apply suitable test data to a spreadsheet model and evaluate the outcomes in relation to the objectives

View related objectives and activities


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