Last week I was talking with some teachers about different ways of planning together. Google Apps are often a "go to" tool for this and many teachers use them in amazing ways to share information, monitor and track data, record notes etc.
Google Forms has been on my radar recently as a great way of recording information. Often used as a survey tool, it has the potential for SO many other uses. Recording anecdotal notes, as an exit ticket - the list is endless. It also has the ability to turn your data into graphs and tables as well as the ability to sort the data in different ways in the spreadsheet where the form responses are stored. Here's a really basic example of what a form for anecdotal notes might look like.
So a teacher I was working with really liked the idea of using Google Forms to record information about her learners. She would be able to have her iPad with her during group time and quickly make notes on the form. The only thing was, she already had a great setup in Google Sheets, where she had data shared with her collaborative teaching partners. They were using this really well and were making notes attached as a comment in cells on the spreadsheet. The issue was, that they had to hover over each comment to read. "If only the data on the Google Form could be stored in the Google Sheets too?" we thought. Well, the good news is it can!
Here's the steps:
1. Set up your google form with the questions that you want. (This is actually a big deal! Clever drop down boxes, checklists and questions will guide the information you want to collect. Don't rush this - set it up well!)
2. Set up your Google Sheet with whatever data you want.
3. Set the destination for your Google Forms data to "an existing spreadsheet".
4. Now when you complete the Google Form, it will just create a new tab in your spreadsheet and your information will be there. New google form, same destination? New tab!
You can of course rename the tab however you wish - group names, teacher name etc. The Google Form tools can be accessed so you can view graphical representations of your data.
And there you have it - everything in one place. You can have tabs to store data and tabs to store form responses. Gotta love Google!
My name is Ngaire Shepherd-Wills. This website is a record of my TeachNZ sabbatical, Term 2, 2013 and then I have continued to share my wonderings and discoveries about Innovative Learning Practices. I now work for CORE Education. Views are my own.