School Survey Data Collection Worksheet
Print the worksheet and use it to tally the information collected from your survey. After you have tallied the data, use the 'Create Chart' tab below to
enter your data into a chart.
K 1 2 3 4 5 6
Grade level
6:00 - 6:30 - 7:00 - 7:30 - After
6:30 7:00 7:30 8:00 8:00
Between A.M. A.M. A.M. A.M. A.M.
Wake-up time
7:00 and 7:30 and 8:00 and 8:30 and 9:00 and after
7:30 8:00 8:30 9:00 9:30 9:30
Between P.M. P.M. P.M. P.M. P.M. P.M.
Bedtime
Ride Ride
with with
Parent Friend Walk Bus Other
Getting to school
Social
Reading Spelling Math Science Studies P.E. Recess Lunch
Favorite school
activity or
subject
January February March April May June July August O
September ctober NovemberDecember
Birthday month
0 1 2 3 4 4+
Siblings
Red Blue Yellow Green Pink Purple Black Brown Other
Favorite color
Create a Chart
2. type answer choice here (e.g.
K)
1. Type question here (e.g. Grade Level)
Student Directions
1. Select one of your survey questions from the
Tally sheet. Type the category of the question in
cell A6.
2. In row B5, B6, B7, B8, etc. type in the
'answer' choices for the category you chose.
3. Highlight all of the cells containing data by
clicking and dragging over the cells.
4. Click on the chart wizard icon in your toolbar.
Follow the instructions until you have a chart
that best represents your data.
2. continue answer choices
2. type next answer choice here across this row until all choices
(e.g. 1st) are entered