Standards Site

 
 
Schemes of Work
QCA

ICT at key stage 3    (Year 8)

Unit 12: Systems - integrating applications to find solutions
Section 6: Activity 6

QCA

Objectives

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

Activities

Outcomes

Children:
  • Review with the class the replies to the standard letter mailings. Introduce the use of an e-mail address book.
  • Ask groups of pupils to update the database as a result of the replies, including e-mail contacts, followed by transferring e-mail addresses to an address book.
  • Ask groups of pupils to compile a distribution list for each type of respondee to the mailings and then send standard e-mails to each distribution list.
  • update and amend a database
  • produce reports from a database
  • use an e-mail address book
  • use a presentation program for a short, automated presentation

Points to note

  • The updated database will now contain a full list of sponsors and helpers and any other category appropriate for the chosen event.
  • The sending of standard e-mails to different distribution lists is a similar operation to the original mail-merge, but using a different technology.
  • The programmes can be printed out at this stage.

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