Periods 3 and 3, my year 7 and 8 IT students filled in a simple online survey form re entertainment gadgets in their home. The teacher who had set it watched the results come in.
The extroadinary part of this statement is that my students are in SE Victoria in Australia and the teacher watching the details being entered immediately was in Florida. Alison instantly placed a comment on the google spreadsheet to say she could see it all as they completed it, even before half my students had hit submit. So, my students watching the output via a datashow could also be amazed at this immediate activity and watch their results appear on our shared google sheet.
Last year, I worked with Alison Saylor, on google spreadsheets. Prior to this we set up a “Guess where I am from” where students from each school, had to work out in 20 questions or less, using only a ‘yes’ or ‘no’ answers, where each school was.
This year, we will work together again, as both our IT classes are currently learning spreadsheets. Google has introduced this wonderful survey form, which can be set up and attached to a spreadsheet. The link to the form is given to potential respondents who fill them in and then submit the form. Hey presto!!! The answers are immediately added to the original spreadsheet.
So, using skype this morning Alison and I worked through the forms trying to determine an efficient and effective method of getting student responses form 4 or more possible schools in Florida, Hawkesdale, Palestine and England.
Alison set it up and as I had my classes almost immediately after offered to trial it. The link to the form was saved on a word document and saved on a public drive on our school network. My students then logged on and copied the url into their webpage. The form appeared and students had to ensure they filled in the Hawkesdale sections. They were asked how many TV sets, radios, cell phones (mobile phones), dedicated game stations, digital cameras etc exist in their households.
When all results are in, we will work with the figures, average them out and write up reports, summaries, comparisons and evaluations on their blogs. We think it will be interesting to compare across the globe.
Who do you think will have the highest household average for each item?
