Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 7)

Unit 4: Models - rules and investigations
Section 2: Activity 2

QCA

Objectives

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

Activities

Outcomes

Children:
  • Discuss with pupils how the school tuck shop works, eg types and level of stock, amount of sales, costs and prices, what consumers look for in such a service, and what factors might have to be considered when running a tuck shop.
  • Pool ideas on the purpose and nature of a successful school tuck shop and identify the constraints under which the shop would operate.
  • Clarify the purpose behind identifying objectives (or end products), inputs and outputs for a system.
  • With the pupils, identify and describe the rules governing the operation of a tuck shop. Present an outline of a model representing the changing inputs, differing constraints/variables that affect the outputs, eg a rush on an item could create disappointment, a rise in price could affect sales. Finally, explain that one use of the model will be to predict trends and outcomes.
  • describe the rules governing systems
  • present the rules describing a system in a structured manner before constructing a computer-based model

Points to note

  • This activity is conducted away from computers.
  • Teachers could provide a prompt sheet for stimulating discussion about the nature and purposes of a school tuck shop, identifying inputs and outputs. Possible tension needs to be identified between purposes of a tuck shop from the pupils' perspective and from the school's perspective.
  • Constraints include space, frequency of delivery, choice factors, health factors.
  • Explain the reasons for choice of test data for the model.
  • Homework could involve designing a model on paper, based on rules in a system.

Sections in this unit

<< previous section next section >>
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