Monday, November 8, 2010

Using Google Forms

You can easily create a form to collect data. This week's lesson will focus on using Google Forms and the spreadsheets created by the form. Please review the videos below.


Creating a Form



Viewing the responses to your form



In ETV we use Google Forms to collect student project information. The form is posted on the ETV website along with the results of the form. By doing this students can view the projects that have already been selected before they decide on a project. Since our Google Apps domain is private only members of the Eisenhower community can see the form results after they have logged in to their Google Apps accounts. To see the Form and the Results click here to go to the ETV projects web page. Then, click on the links on the page.

Week 1 Assignment
Develop a Google Form and get data from one of your classes or from the members of this class. To get the url, address, of your form just copy the url from the bottom of your form, see image below.


You can email the url of the form or post the link on a webpage. Then, add links to your form and the responses to the comments section of this post. Please write about the process. Also, please comment on the surveys that the other members of this class have posted.

Also, all documents created for this class should be shared with the class by adding them to the Google Apps Class Folder in Google Docs.

If you have any questions about the process post them to this blog. All of us should monitor the blog and respond to the questions on this blog.

Response to Annie's question:
Your form looks like a spreadsheet when you first look at it in Google Docs. To see it as a form or to edit the form:
1. Open the spreadsheet
2. Go to the Form Menu and select from the choices. You can view, edit or embed the form in a webpage. See the image below:


Show Summary of Responses
From the Form Menu you can select Show summary of responses. If you have used multiple choice or choose from a list type questions you can get a nice graphic summary of the responses to your form. See image below:


3 comments:

Annie Dugan said...

I was wondering how come my funky form turned into a plain spreadsheet when I shared it in the Google Apps class folder?

Harold Olejarz said...

Your form looks like a spreadsheet when you first look at it in Google Docs. To see it as a form or to edit the form:
1. Open the spreadsheet
2. Go to the Form Menu and select from the choices. You can view, edit or embed the form in a webpage. See the image posted in the blog.

Annie Dugan said...

I take back when I made fun of you for getting so excited about Google apps! I got pretty excited when I logged on and saw that my students had responded to my form!