This task will enable you to use the Communicating and Handling Information strand of ICT while supporting and enhancing mathematics.

Intermediate Task:

Create a database using numeric and alphanumeric fields. The number of fields depends on the ages and previous experiences of the children.

Create a data capture sheet where the field names are identical to the database.

Prepare a set of questions which will allow simple questioning - eg. How many children have black hair?

Demonstrate to pupils how to:

  • collect data and complete the data capture sheet
  • enter the information from the data capture sheet into the database
  • save the database
  • retrieve and amend information when necessary
  • answer complex questions using AND, OR, NOT operators - eg:
    • how many children have green eyes AND brown hair?
    • how many boys have brown OR black hair?
    • how many children do NOT have black hair?
  • print graphs/lists/records

Prepare differentiated, cross-curricular tasks/activities which will allow pupils to:

  • collect data and complete the data capture sheet
  • enter the information from the data capture sheet into the database
  • save the database
  • retrieve and amend information when necessary
  • answer complex questions using AND, OR, NOT operators - eg:
    • how many children have green eyes AND brown hair?
    • how many boys have brown OR black hair?
    • how many children do NOT have black hair?
  • print graphs/lists/records

Resources

  • database program
  • computer
  • printer

Teaching Strategies: Intermediate