About this lesson
How to make a quick visualization of summary of response and exploration of common pitfalls such as sorting columns and deleting cell data.
The exercises below will open in a new tab. When signed in to your Google account, go to File --> Make a copy to get an editable copy of the file.The Responses Tab Solution
Link The Responses Tab
The Responses Tab
The responses tab in Google Forms summarizes and analyzes the responses submitting to a form.
When to use
When you want to see what sort of answers people are giving to your form, and compare their answers to each other.
- Average: The average of all the scores
- Median: The score of the middle response
- Range: The range between the lowest score and the highest score
- Total point distribution: A chart showing how many respondents scored each number of points
- Frequently missed questions - The questions that often received wrong answers
- Questions - Each question in the form has a chart displaying how many people chose each option, as well as the correct answer if there is one. The chart is different for each type of question
- Look at individual responses
- Print or delete individual responses
- Create a spreadsheet that contains a list of responses from the form
- Add a list of responses from this form to another spreadsheet
NOTES: The spreadsheet is linked to the form, so that new responses are automatically added to the spreadsheet. Making changes to the spreadsheet does not affect the form.
The three dots
- Get email notifications for new responses - Receive an email every time someone submits a response to this form
- Select response destination - Change the spreadsheet the form is linked to
- Unlink form - Stop automatically updating the spreadsheet with new responses
- Download responses - Download the responses as a .csv file
- Print all responses - Print all the responses
- Delete all responses - Delete all of the responses
Lesson notes are only available for subscribers.