Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 7)

Unit 4: Models - rules and investigations

QCA

Objectives

Section 1: Activity 1
Children should learn:
  • to revise calculation and graphing techniques in a spreadsheet
  • the basic structure of spreadsheet formulae

View related activities and outcomes

Section 2: Activity 2
Children should learn:
  • that systems can be described by rules
  • to describe rules for a system in a standard and structured manner
  • to plan the layout of a spreadsheet model

View related activities and outcomes

Section 3: Activity 3
Children should learn:
  • to enter formulae representing the rules governing the model into a spreadsheet
  • to run spreadsheet software, saving and loading data files
  • to enter test data into a spreadsheet model

View related activities and outcomes

Section 4: Activity 4
Children should learn:
  • to record inputs and outputs from testing a model
  • to use test data to evaluate the success of a model

View related activities and outcomes


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