Global Home		Global ICT Resources Other ways to bring the real world into the classroom using ICT.  Website we use to create online surveys. A web page of resources on how to bring the real world into the classroom.
Links:	Introduction
	The resources on this page relate to the KS3 ICT unit 9.2b creating an online survey. It is appropriate for students who already have a good working knowledge of how to create a survey and use Excel to handle and analyse data. We are currently making resources for younger students (KS3 ICT unit 7.5 and a KS2 Unit on Water). There will be links to them by Easter 2006. The links below are to show teachers how to deliver the project. To view the course for students click on 9.2
9.2	A 10 hour project on creating and analysing a survey using the resources below.
	Example Online Surveys
TV Survey	A simple online survey looking at TV trends
Water Survey	An online survey to input the data from the water sheet.
UK/USA Lifestyles	An online survey comparing the lives of young people in the UK and USA (KS3 ICT unit 9.2b)
How am I teaching ?	An online survey for student feedback on ICT lessons. Useful for SEF.
SurveyAtSchool	The website used to create the above surveys
	How to create a survey
Hypothesis	A powerpoint presentation on how to create an hypothesis
Questions	A powerpoint presentation on how to create questions
Water Sheet	An example data collection sheet for water use
Diary	An Excel document on how to plan a survey
Teacher Diary	A teacher version of the above with answers
	How to analyse survey data
Dirty Data	A csv file for the TV Survey containing dirty data
Import a csv	A powerpoint presentation showing how to import a .csv
AutoFilter	A powerpoint presentation on how to use autofilters
TV Survey	An Excel activity to show how to clean and search data using auto filters and process data to produce charts.
Teacher TV Survey	A teacher version of the TV activity with answers.
National Statistics	An Excel activity to analyse national statistics and create scatter charts.
youth_data.csv	A csv file for the UK/USA survey
UK/USA results	An Excel activity for students to analyse the UK/USA data
Health Survey	An Excel activity for lower ability students on UK/USA survey (completed to show answers)
	How to produce a report
Evidence	A powerpoint presentation on information to help produce a report.
Survey report	A powerpoint presentation for lower ability students. View in edit mode to see instructions to left of each slide. This uses the charts from the Health Survey (see above).
Check sheet	A Word document printout for students to record what they have achieved and what they need to do.