Locked lesson.

Upgrade

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.

Exercise files

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
Link

Quick reference

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.

Instructions

Summary

  • Insights
    • 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

Individual

  • Look at individual responses
  • Print or delete individual responses

Create spreadsheet

  • Create a spreadsheet that contains a list of responses from the form

or

  • 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
Login to download
  • 00:04 Once your form is live and you have been sharing it with others,
  • 00:07 you're gonna want to come back and review their responses.
  • 00:11 Here at the top of the form, right next to QUESTIONS, is our RESPONSES tab.
  • 00:15 And you will see it will give you a summary of the total number of responses
  • 00:20 which you have received.
  • 00:22 By clicking on RESPONSES, we get a nice summary view of all of the results.
  • 00:27 So here we are looking again at our Color Survey.
  • 00:31 The first question is, What is your name?
  • 00:33 So we get a list of everyone who has completed this form.
  • 00:37 Our next question was, what is your favorite primary color?
  • 00:40 And here we can see that both red and
  • 00:43 blue receive many more votes or a few more votes than yellow.
  • 00:47 And if you hover over the pie chart, you will get the specific total count.
  • 00:52 Lastly, we asked how likely is it that they will share this quiz with others?
  • 00:57 And you may recall that this was a linear scale.
  • 00:59 We can see the majority of responses gave it 5 out of 7,
  • 01:04 one gave it a 3, and someone gave it a 7 over here.
  • 01:09 Now, this is a great summary view of all of our responses, but
  • 01:12 perhaps you want to dive a little bit deeper.
  • 01:15 Perhaps you'd like to know how Julie responded.
  • 01:18 In order to find that information, we will wanna click the INDIVIDUAL button.
  • 01:23 Here we have the opportunity to cycle through all of the individual responses
  • 01:28 by clicking on the arrows here, or we can type in a specific number.
  • 01:34 Here you can see I have found Julie's entry.
  • 01:37 Her favorite color is blue, and
  • 01:39 I can also see that she was the only person who gave a 7 in the last question.
  • 01:45 This may be helpful, because perhaps if I have Julie's contact information,
  • 01:49 I may want to reach out to her and either congratulate her for sharing this
  • 01:54 with others or give her an additional incentive to share this quiz with others.
  • 01:59 Now, in some cases, you may wish to delete a particular response.
  • 02:03 In order to do that, just find that individual response and
  • 02:07 select the trash can here.
  • 02:10 Now, let's go back to the SUMMARY tab for just a moment.
  • 02:14 In the top right hand corner, we have a few more options available to us.
  • 02:19 This little green icon will allow us to create a new spreadsheet
  • 02:23 with the information that we see here.
  • 02:26 And next to that we have three dots which give us even more options.
  • 02:32 The first one allows us to get email notifications for new responses.
  • 02:37 So this may be helpful if you wanna be notified immediately
  • 02:41 once someone has taken your form.
  • 02:44 Next, we also have the ability to download our responses into a CSV file,
  • 02:48 perhaps if we'd like to manipulate it in some other application.
  • 02:52 We can also print all of our responses if we desire.
  • 02:55 And lastly, if we'd like to reset our quiz or reset our form,
  • 03:01 we have the ability to delete all of our responses.
  • 03:07 Let's take a closer look at what our RESPONSES tab looks like for a quiz and
  • 03:12 also how we can send our collected data to a separate spreadsheet.
  • 03:17 Remember, we can create a quiz from any form within Google Forms and
  • 03:23 give each question a point value.
  • 03:25 In this example, you can see at the top, I can quickly view the average, the median,
  • 03:30 and the range of those who have submitted answers to this quiz.
  • 03:35 I'm also given a highlight of the most frequently missed questions.
  • 03:40 Now, these are not questions that have been omitted by those who have
  • 03:43 taken the quiz.
  • 03:43 This is highlighting questions where those who responded
  • 03:48 answered incorrectly more than 50% of the time.
  • 03:51 And as I continue to scroll down,
  • 03:53 you can see I can view a nice breakdown of the answers.
  • 03:57 Those who answered correctly and
  • 03:59 those who did not answer correctly to the specific questions here within this quiz.
  • 04:06 Now, we also have the ability to send this data,
  • 04:09 send this information to a spreadsheet.
  • 04:13 By selecting the three dots, the more options,
  • 04:16 we can select the Select response destination.
  • 04:20 And here we can either create a brand-new spreadsheet and give it a new name here.
  • 04:25 Or we can select an existing spreadsheet if we would like to add data
  • 04:29 to something that already exists.
  • 04:31 In this example, I'm gonna select Create a new spreadsheet, and select CREATE.
  • 04:37 And now I can go view this data and
  • 04:40 manipulate it, and create additional charts within that spreadsheet.
  • 04:44 Now, if you no longer wish to send that information to the spreadsheet, again,
  • 04:48 we want to select the more options area.
  • 04:50 And in this case, we are going to select Unlink Form.
  • 04:54 You'll be given a warning, asking if this is what you would really like to do.
  • 04:59 If you are sure, you can select UNLINK and your data will remain here
  • 05:04 within the RESPONSES tab and no longer be linked to that spreadsheet.

Lesson notes are only available for subscribers.

Gift this course