Using Google Forms to collect responses
January 30th, 2012 by Monika Jankowska-Pacyna
When we redeveloped the AlphaPlus website, we organized an online scavenger hunt to challenge our users and to make exploring our new site fun. Using Google Forms, we developed a questionnaire and had it embedded directly into our contest page. It gave our participants a chance to see the questions and immediately type in the answers below.
After all the questions were answered, participants simply clicked “Submit” and their responses were automatically added to a spreadsheet that provided us with a time stamp, their name and all the questions they answered.
After the contest ended, we were able to close the questionnaire and stop receiving the responses.
Visit Google Forms – an easy way to create online polls, registration forms or quizzes to learn more about Google Forms.
It was a great and quick way to gather the answers and, at a glance, know how many participants filled out the form. Checking the answers was easy because the first response was our test with the right answers. We simply had to compare the new entries with the first one to see if the answers were right or wrong. Since the responses were in spreadsheet format, we could also add the score and notes in a new column without having to open or create a new document.
We found Google Forms to be a great tool, and we use it often. Many of our registration or waiting list forms for Moodle training, such as Request a Seat in Introduction to Moodle Training 2012, are developed using Google Forms.
Below is an example of a Google Form embedded into this web page. You can go ahead and answer the questions right on this page:
<!– You can place html anywhere within the source tags –>
<iframe src=”https://docs.google.com/spreadsheet/embeddedform?formkey=dHhLOFZQYWZRaEdHRGxCRjAxazJiU1E6MQ” width=”680″ height=”800″ frameborder=”0″ marginheight=”0″ marginwidth=”0″>Loading…</iframe>
Note that after you submit your responses, in the confirmation message you can click on “See previous responses” – we activated it when we set up the survey to show you that you have that option and to give you a preview of how responses are organized in a summary format.
Summary of responses:
This form can also be provided as a link that opens in a web browser:
The responses are automatically organized in an online spreadsheet: