If you have not recently created a spreadsheet in Google Documents and used the free option to create a form, you should give it a try. I still subscribe to Surveymonkey and use it for some web surveys, but increasingly I find myself using Google Documents for web forms. Why?

  1. It is free so when I show it to someone and they say, “Boy that’s cool, I’d like to do that” my answer can be, “You can! Just use your Google Account and go to Google Documents.”
  2. It is easy to share access with others, whether you want to collaborate or just provide read-only access.
  3. Data in the spreadsheet is easy to aggregate, analyze and graph either online or in a downloadable Excel or Open Office Spreadsheet formatted file. We want students to understand the power and possibilities latent in data-driven decision making– There is no better way to do this than empowering students to become data gatherers and utilizers with a tool like Google Forms.
  4. Asking even a small number of people to email in responses to a series of questions can quickly become cumbersome. It is so much easier to ask folks to submit a quick online form. (Lee Lefever’s “Google Docs in Plain English” video is a good visual explanation of how this can get complex and unwieldy fast with a newsletter, but the same applies for other bits of info you need to collect from others.)
  5. You feel VERY powerful and uber-connected when you realize you have the power at your fingertips to share links to customized online forms anytime, anywhere. :-)

Google forms now allows you to REQUIRE that folks enter certain fields before submitting the form:

Google docs forms let you require fields

As before, you can have text fields, text area fields, multiple choice, and other field types. I LOVE the language at the top of the page when you start creating a Google spreadsheet form: “Results will be magically entered into this spreadsheet!”

Results will be magically entered

Isn’t that so true! All technology at some level is “magical.” Some people have more words to describe what is happening and how it works, but there is still an aura of magic and mystery around many technologies which can be at times hidden, and at other times very overt.

I love Google Documents, and especially the fact that access to them is free!


Did you know Wes has published 3 eBooks, and 1 of them is available free? Check them out!

Do you use a smartphone or tablet? Subscribe to Wes' free magazine "iReading" on Flipboard!


If you're trying to listen to a podcast episode and it's not working, check this status page. (Wes is migrating his podcasts to Amazon S3 for hosting.) Remember to follow Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wesley's Facebook pages for "Speed of Creativity Learning" and his eBook, "Playing with Media." Don't miss Wesley's latest technology integration project, "Mapping Media to the Common Core / Curriculum."

On this day..

Share →
  • Melanie Jennings

    When I first discovered this feature, I fell in love. However, in using it to collect data from teachers in my technology training courses, I find that for some reason, they frequently do not receive the e-mail form or the form does not display properly. Have you had similar experiences? If so, do you have a “fix” for the problem. For now, I’m just e-mailing them the URL to go to the form directly, but that certainly takes away from the “cool factor” of having a working form within their e-mail message.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.

Made with Love in Oklahoma City