1. Introduction: Understanding data and data capture methods

Relevant tutorials for demonstrating the skills for this lesson can be found in the preparation section.

This lesson is about data capture. It is important that pupils are aware of the significant concerns over personal data and privacy including that of identity theft. They should understand that data capture forms can be sensitive and questions must be carefully thought about and relevant.

During the first 3 lessons, pupils have only used a prepared example database.

The next three lessons require them to design and create their own. This will contain data about some of the more obvious trades needed to build a house for their chosen famous person, e.g. bricklayer, carpenter, plumber, electrician, landscape gardener, etc.

Pupils need to understand how this data will be collected and the form it will take.

Show pupils the presentation on data and data capture, there are notes4a to accompany it.

Give out worksheet4a.

Give out handout4b and explain what the pupils will be doing over the next 3 lessons.

In summary:

• Create a new database for their famous person so that they can select different tradesmen.
• Design and create a data capture form.
• Complete the data for at least 20 records
• Create the database with a table, form, query and report.

Show pupils the language cards language4 for this lesson.

Explain to pupils that the design of the data capture form/questionnaire is important and a poorly thought out one may lead to data being recorded that is inconsistent and of little use.

Give out handout4c - this gives guidelines for creating a data capture sheet.

Give out worksheet4d - specifications that pupils need to follow to when creating their own data capture sheet.

You may wish to demonstrate the creation of a simple A4 data capture sheet using Microsoft Word or similar.

Pupils then create their own data capture sheet and print one copy for homework or it could be E-mailed home and completed in electronic format.

They may wish to compare ideas using shared areas or other digitally shared methods.

Make sure that pupils have a data capture method.

Explain that they need to complete at least 20 records with a spread of trades.

Develop this by:

• Discussing where the information could be found, e.g. Yellow Pages, local papers.

Give out homework4 - this gives guidance and reminders for gathering and completing their data capture sheet.

Pupils will need a print out of the data capture sheet or would have E mailed it home to complete in electronic format.

You may feel it appropriate to provide the homework sheet in electronic format for those pupils with computer access at home. Consideration should then be given to:

• How they would return the work and the style - electronic or printed
• Virus protection
• Authenticity of the work