Survey Results (by gender) Girls Boys Total
Number replying to survey 50 50 100
I usually bath 10 20 30
I usually shower 40 30 70
I leave the tap running when brushing teeth 26 32 58
I don't leave the tap running when brushing teeth 24 18 42
I own a mobile phone 33 22 55
I don't own a mobile phone 17 28 45
Q1: How many boys replied to the survey?
A1:
Q5: Which of the survey questions does
Q2: Which is more popular with girls, baths or showers? A5:
A2:
Q6: How reliable are the survey data? How do y
Q3: When brushing teeth, do most people leave the tap running?
A6:
A3:
Q4: Who uses more water, boys or girls? Q7: How could the data be made
A4: A7:
This is the Input sheet, containing raw
data from a survey.
Instructions:
Use the data table to answer the
questions in the blue boxes.
When complete, answer the extension
questions in the yellow boxes.
Extension Questions
Which of the survey questions does not help us answer Q4?
reliable are the survey data? How do you know?
How could the data be made more reliable?
Survey Results (All replies) Total
Number replying to survey 100 This is the Process sheet, where just the total
number of replies to the survey (male or
I usually bath 30 female) are shown.
I usually shower 70
Instructions:
I leave the tap running when brushing teeth 58
I don't leave the tap running when brushing teeth 42 Watch the demonstration by your teacher of
I own a mobile phone 55 how to create a chart from the results.
I don't own a mobile phone 45
Now you create a chart.
Make sure your chart has labels
Save it as a new sheet called Output
Extension:
Format the chart to make it easier to read.
Hint: Right-click on part of the chart and
choose Format..
sheet, where just the total
o the survey (male or
tration by your teacher of
from the results.
labels and a title.
called Output.
o make it easier to read.
n part of the chart and