Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 7)

Unit 5: Data - designing structure, capturing and presenting data
Section 4: Activity 4 (1)

QCA

Objectives

Children should learn:
  • to add extra fields to a database
  • to search a database using simple and complex queries
  • to produce graphs

Activities

Outcomes

Children:
  • Show pupils how to add an extra field to the database that was not considered earlier but would provide useful information, eg opinions on local facilities already provided. Discuss why this late addition would prove costly to research and add at this stage.
  • Revise searching and graphing using the merged database, ensuring that pupils are saving the results that they need for their report. This activity should be related to the hypotheses formed earlier.
  • add an extra appropriate field
  • search the database and produce graphs as required

Points to note

  • Pupils do not need to add the extra data but should understand the need and how to be able to do so.

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 (1)
5. Activity 4 (2)