Posts
A Googley Way to Collect Info
Posted On Tuesday, September 30, 2008 at at 2:54 PM by S. BolosThis past summer at the Google Teacher Academy, I learned of an efficient way to collect student info or even create quick surveys. It's all via Google Docs, specifically the Spreadsheet function. My own knowledge of spreadsheets is woefully inadequate, since I am math-challenged. But this is just populating lists and cells, which I actually do understand! Here's how to create a web-based form from a spreadsheet:
So here's how I use a Google Docs form in my classroom. At the beginning of the year, I need the following information from my students:
- Name (i.e., what they prefer to be called, NOT what the computer spits out)
- Email address (i.e., an email address they actually prefer to use to contact a teacher)
- Blog address (because each one of my students has his/her own Blogger weblog)
The beauty of this form is that because it is online, any link in an individual cell becomes "live", meaning, I can click on the web address next to my student's name and it will take me to the student's blog.
And here's what my form looks like (scroll to see the input fields):
