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


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