Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 8)

Unit 12: Systems - integrating applications to find solutions

QCA

Objectives

Section 1: Activity 1
Children should learn:
  • to reach a decision on the nature of the event
  • to identify the component tasks
  • to allocate ICT-based solutions to each of the identified problems

View related activities and outcomes

Section 2: Activity 2
Children should learn:
  • to identify the rules governing the model that will determine the profit or loss of the event
  • to construct the financial model for the event using spreadsheet software
  • to use the model to prepare a budget for the event

View related activities and outcomes

Section 3: Activity 3
Children should learn:
  • to use a vector graphics program to design a simple logo
  • the importance of choosing particular file types for graphics
  • to use an image manipulation program
  • to combine both vector-based and bitmap-based images for use in printed material

View related activities and outcomes

Section 4: Activity 4
Children should learn:
  • to design the structure for a simple flat-file database (revision)
  • to enter data into a database (revision)
  • to design simple standard letters for mail-merging
  • the difference between database fields and standard field codes
  • to incorporate the corporate identity graphics into the design of standard letters
  • to test the output from mail-merge printing
  • to incorporate existing graphics files into designs for other documents

View related activities and outcomes

Section 5: Activity 5
Children should learn:
  • to apply desktop publishing techniques to the production of posters and related documents

View related activities and outcomes

Section 6: Activity 6
Children should learn:
  • to update a database with new information for each record (into pre-existing fields)
  • to interrogate a database to produce reports
  • to use e-mail address book entries for sending e-mails to a circulation list

View related activities and outcomes

Section 7: Activity 7
Children should learn:

View related activities and outcomes

Section 8: Activity 8
Children should learn:
  • to evaluate the planning and organisation of the event, and the ways in which these have been enhanced through the use of ICT
  • to discuss and respond to virtual ideas, carry out the task and then review and refine ideas

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
5. Activity 5
6. Activity 6
7. Activity 7
8. Activity 8