ICT at key stage 3 (Year 7)
Unit 5: Data - designing structure, capturing and presenting data
Section 2: Activity 2
|
|
Objectives |
| Children should learn: |
- that getting information successfully from a database depends crucially on collecting appropriate data
- to design a questionnaire that elicits the correct information
- to set up an appropriate database structure that enables successful queries
|
Activities |
|
Outcomes |
|
Children: |
- Ask the class to discuss, in groups, what data they are going to collect in order to produce a report informing the bidders about the most appropriate facilities. They should form a hypothesis at this point related to their own opinions,
eg expecting swimming to be the most popular choice or girls to dislike football. Explain to the pupils how to ask questions to gain clarification and further information. They need to agree as a class what data to collect and its format. Ask the pupils to construct questionnaires to collect data. Ask them to construct the database to enable data entry of the collected data. Ensure pupils understand the sorts of questions they need to ask from the data before the structure is finalised.
|
|
- ask questions using appropriate terminology
- design a questionnaire which matches the structure of the database
- design and set up a database structure
|
|
Points to note |
- Homework could involve pupils collecting data, but they should not collect more than 10 questionnaires. Pupils should only enter data for their own benefit to demonstrate test validation and verification techniques. It is essential that all the files have the same structure so that they can be merged to give a comprehensive number of records for pupils to search.
- It would be appropriate to demonstrate merging files to students and the use of such file types as CSV (comma separated variable) to import and export data for this purpose.
|
|
|
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.
|
|
|
