Home » Google » Apps » Forms » Google Forms: Show Summary of Responses

Google Forms: Show Summary of Responses

If you are using Google Forms, you definitely want to be using the summary of responses that is automatically generated from your data.

Administer a Google Form

In order to summarize the responses, you need responses. If you already have a Google Form go open up the spreadsheet that contains the data. If you did not connect your Google Form to a spreadsheet you can view the summary of responses from the Form’s edit screen.

Form Menu

In the Google spreadsheet there is a menu option “Form” to the left of the “Help” menu. Under this menu option is the choice to “Show Summary of Responses”
show summary

Automagically

With zero effort your data is graphically displayed. This is great for formative assessment to shape your instruction immediately in class. Screen Shot 2014-05-17 at 7.59.19 AM

13 thoughts on “Google Forms: Show Summary of Responses”

  1. Pingback: Google Forms: Show Summary of Responses - Educacion enpildoras.com

  2. The creation of a Google Form is flexible and straight-forward. Generation and updating of the accompanying spreadsheet is automatic and very helpful. Production of the “Summary of Responses” in its graphical form is terrific and eye catching, however …

    I have found that if you modify the spreadsheet, e.g., delete a row because it is a duplicate or whatever reason, the Summary of Responses is NOT modified accordingly. In fact it remains as it was before the spreadsheet adjustment.

    It is my understanding that Google is aware of this problem and a fix (?) may be forthcoming. Have you had this experience?

    Thanks.

    1. Summary of response is linked to the Form results NOT the spreadsheet. Summary of responses will reflect the complete history of the Google Form’s use.

          1. This is not a bug, because if it was it would have been fixed by now. See post from 2008! http://googlesystem.blogspot.ca/2008/08/response-summary-for-google-forms.html

            Also, if you look at the official explanation, it says that individual responses can not be deleted, last sentence (https://support.google.com/docs/answer/2923993?hl=en)

            So…. This is frustrating for many users especially when you test your form and forget to erase test entries or when duplicates show up. I wouldn’t hold my breath on this one.

          2. This is true, the summary of responses is not the best solution when you are reusing a Form or tested your Form. In that case I create my own charts.

  3. Pingback: 07: 2015-03-03 CI100 | CSUF CI 100 Keeler

  4. Pingback: 07: 2014-03-03 CI225 | CSUF CI225

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.