The end of a great data project using Google Docs and Moodle

Each year for the last 4 years I’ve taught surveys and databases to my year 7 class.We used to start off by creating a spreadsheet with columns for name, age, favourite food and send all the students wandering around the classrooms to collect details from their friends.Next we went on to make a survey on paper, create a hypothesis, hand the surveys to friends to fill in, collect and type up results into a spreadsheet and then create graphs and a presentation about what they found out…It was a pretty good series of lessons that students enjoyed; but this year we kicked things up a notch with a bit of techology. Here’s how:

  1. We ditched the paper surveys for online surveys using Google Docs. Students created their surveys using the forms part of Google Docs. (We use the free Google Apps Education Edition via our own domain).
  2. Students posted the links to their surveys on a forum on our VLE. This was one of the trickier parts as most students hadn’t done this before. They could then complete their friends’ surveys. It also gave us an opportunity to discuss what makes a good or bad question or survey.
  3. Students analysed results – some downloaded their Google Spreadsheet to Excel while others did them on online. They all had to create a graph from their data.
  4. Students created a presentation to show their findings – most did this using Powerpoint though some used Google Presentations. All presentations had embedded graphs.
  5. Students uploaded their presentation to a Moodle Database and then had to view and comment on their friends’ presentations.

Students seemed to enjoy the work and interacting with their friends. Some parts had a steep learning curve but for most students it was the first time they had done anything like this before.  From a teacher’s point of view it was hard work and for a less able class I would certainly break the tasks up into smaller tasks but if you like the sound of it give it a go and let me know how it goes.

Published by D Needlestone

Teacher

Join the Conversation

1 Comment

Leave a comment

Leave a Reply