A Googley Way to Collect Info

Posted by on Tuesday, September 30, 2008

This 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):




Disclaimer

Although this blog is authored by New Trier High School (NTHS) staff, the audience is global and the views expressed here do not necessarily represent those of NTHS as an institution.

Copyright and Fair Use

This site contains images and excerpts the use of which have not been pre-authorized. This material is made available for the purpose of analysis and critique, as well as to advance the understanding of technology in education. 
The ‘fair use’ of such material is provided for under U.S. Copyright Law. In accordance with U.S. Code Title 17, Section 107, material on this site (along with credit links and/or attributions to original sources) is viewable for educational and intellectual purposes. 
If you are interested in using any copyrighted material from this site for any reason that goes beyond ‘fair use,’ you must first obtain permission from the copyright owner.