Once you’ve made your form and shared it, you’ll then want to see the responses and probably want to have a visual summary of them. Google Forms provides a wonderful graphical summary of the responses automatically right within Forms itself, so there’s no need to create charts yourself.
Open your form and you’ll be in the form editor. There are two main parts to the editor, the questions and the responses. Click on “Responses”. Here it will tell you how many responses you’ve received and gives you the option of seeing a summary of them or seeing the individual responses.
VIEWING A SUMMARY OF THE RESPONSES
Click on “Summary”. Here you’ll see all the typed in responses and for questions where there were limited options, you’ll see a graph.
In this question, I can quickly see that some of my students don’t know the capital of Wales, so I’ll need to do something about that in a future class.
Here’s an example of a question asking for their comments:
This one was a Checkbox question and I can quickly see the most popular sessions at this conference.
This question was a linear-scale question. Here I can see that our customers are happy.
This question was a multiple-choice grid and within one graph can show a lot of information. In this case, we asked them to rate the teachers on a set of criteria.
With date and time questions, Forms will put the date or time entered along with the number of people who entered it, so you can see the most popular one.
VIEWING INDIVIDUAL RESPONSES
If you want to see want a specific person filled out on your form, click on “Individual”. You can flick through the responses by clicking on the arrows next to where it says. e.g. “1 of 9”.
This shows you exactly what the form-filler completed. It also gives you the option of deleting a response, by clicking on the bin icon to the right.
Back to the top of the page, there are some further options that you can change.
On the right, you can switch off “Accepting responses”, which means that no-one can submit more responses using your form.
When you first create a form, you can link a spreadsheet to it, so that the responses are stored in a place other than within Forms. Either click on the green spreadsheet icon or the 3 dots and click on “Select responses destination”.
You then have the choice of creating a new spreadsheet (and naming it) or adding a new page to an existing spreadsheet. If you want a new one, just click “Create”. If you want it to add to an existing one, click “Select existing spreadsheet”.
Clicking the second option, opens up a dialogue box where you can choose the spreadsheet you want by clicking on it, then click “Select”.
If you’ve already set up a spreadsheet, clicking on the green spreadsheet icon will open the spreadsheet where the responses arrive and live.
There are also some other useful options by clicking on the 3 dots.
Get email notifications for new responses – By selecting this, Forms will send you an email every time someone fills out and submits your form.
Unlink form – Choose this if you want to disconnect a spreadsheet from a form.
Download responses (.csv) – This downloads the responses in .csv format which can be useful for uploading the data to another application.
Delete all responses – Sometimes you want to use your form with a different set of people, e.g. a new class, but you don’t want to mix the old and new responses. So, here you can delete all the responses from the form. Note, this deletes them from the form but those already collected in the spreadsheet remain.
eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions:
- “Beginner’s Guide to Google Drive” – iBooks store / Kindle store
- “Beginner’s Guide to Google Forms” – iBooks store / Kindle store
- “Beginner’s Guide to Google Sheets” – iBooks store / Kindle store
- “Beginner’s Guide to Google Docs” – iBooks Store / Kindle store
- “Beginner’s Guide to Google Slides” – iBooks Store / Kindle store
- “Google Sheet Functions – A step-by-step guide” – iBooks Store / Kindle Store