Print or E-mail

Recent Comments

Disclaimer

Please note: the views expressed here are my own and in no way represent the views of my employer.

Interesting Stuff

License


This work is licensed under a Creative Commons Attribution- Noncommercial- Share Alike 3.0 United States License.

Meta

Visitor Maps

Visitors from...

What am I Reading?

Google Docs Spreadsheet Forms

Last week, Google Docs has announced the addition of Forms within Google Spreadsheets. Very cool!

I finally got around to try it out this afternoon. Here are some of the steps I took while� exploring.

Sign into your google docs account and create a new spreadsheet. Click on the “Share” button and choose “to fill in form” then start editing your form.

google-docs-form.png

My example was going to be a survey that I wanted teachers to fill out at our next professional development workshop, which happens to be “All About Google”. So I started adding questions and chose from a variety of possible answer types, such as text, paragraph text, multiple choice, checkboxes and choose from a list.

google-docs-form3.png

Just click on Save when finished and +Add a question when ready for the next one.

google-docs-form1.png

Once your form (survey) is complete, click “Next choose recipients”. That will take you to the next screenshot. You can now invite people by specific e-mails or copy and paste the provided weblink into a page or blog for anyone to find and fill out the form.

google-docs-form2.png

You also have a choice to “Let people see existing responses” or hide them from viewers, which seems to be the default.

google-docs-form4.png

The cool thing will be to see the results populate the spreadsheet I wonder if it will be live or if there will be a time lag. Very nice.� I like the way we will be able to show the correlation and interconnectedness of a survey and the corresponding date collection in a spreadsheet to our students.

2 Responses to Google Docs Spreadsheet Forms

  1. Nedra

    I was introduced to this at Daren’s Open PD class last week. Thank you for the step by step directions. Your directions and the forms will be very helpful.

  2. Angel

    Do you happen to know how to make it apear on another sheet not the first sheet of the document? Or a way to handle where the information appears.

Leave a Reply