DATA HANDLING PROJECT
 Click here to change version
COMPUTER
EXPERIENCE
OF PUPILS
ENTERING
YEAR 7

Page 1
 Page 2
Page 3
Page 4
Page 5
 Mark scheme
Close

Helpsheets - new window Program Helpsheets
Back to IT Back to
GCSE ICT

 

PROCESSING THE RESULTS
  1. Print a copy of the sample questionnaire and label it 4 - The Questionnaire.
  2. Report Page 2 - Barcharts of Q1, 2 and 3Now perform a simple search of the database to find out how many pupils ticked each answer in fields Q1, Q2 and Q3
  • Fill in the answers for these fields on your printed questionnaire.
  1. In fields Q4 to Q8, more than one answer was possible. For example you might get entries like137, 17, 57 and so on. We want to find all the records which contain a 0, a 1, or a 2 and so on, in order to continue filling in the totals for each answer on the questionnaire.
  • Format a 'custom' search for each possible response in field Q4:
    Q4 contains 1
    Q4 contains 2    , then 3 and so on.
    Don't forget to fill in the answers on your questionnaire.
  • Continue this for each of the remaining fields Q5-Q8. As this is quite a repetitive chore you could share the load with someone else.
  1. Now lets get some more complex answers from the survey as a whole. Format a 'custom' search to ask the following questions. You will need to look very carefully at your questionnaire to decide which field or fields to select and how to phrase your query. Check the result that you get to make sure that it actually does answer the question.
  • How many pupils have got a computer at home?
  • How many pupils possess a printer at home?
  • How many pupils have a printer and use it to produce homework?
  • How many pupils say that they have a word processor but (and) do not have a printer?
  1. Print the last page.
  2. Label your printout 6 - Survey results and write the above questions and answers on the printout to explain each query you have made.

previous pagetop of pagenext page

Page last updated 23/05/2003 © Copyright, I.D.Lee, Didcot Girls' School.
All rights reserved. The original material provided on this site may not be copied or redistributed without written consent from the school. But please feel free to add a link to this page on your own website if you find it useful.