Skip to content

Get Email Alerts and Download Quiz Responses in a Spreadsheet

Playback Speed:
Transcript

After your classmates take your quiz, their responses are recorded so you can review them later.

In this extension, you will get email notifications for quiz responses and analyze the quiz data using a spreadsheet created with your quiz results.

It’s useful to view the results of your classmates’ quizzes so you know When quizzes were submitted Their individual scores And which responses were given for each question To start, open your quiz.

If you haven’t shared your quiz yet, that’s okay.

You can take your own quiz and analyze your own responses.

Or, take the quiz multiple times to populate your data.

In the quiz edit mode, view the responses tab.

Update the settings so that you are emailed each time a response is submitted.

You will receive an email in your inbox each time someone completes the quiz.

A link will be included for you to view the response directly.

This allows you to review each quiz score as it is submitted.

Then, download the responses into a spreadsheet.

A spreadsheet gives you a more detailed view of the quiz responses, which you can then filter, adjust, and view in different ways to get a clear picture of your quiz taker’s responses in a single location.

A spreadsheet is especially useful if you have a large number of quiz takers--like your entire school.

It allows you to view all the responses and find the information you need more easily.

The sheet is divided into columns with headings, including: The timestamp, or the time at which the quiz was submitted for each person The score And each individual question.

Each row is populated by the responses given.

Sort the spreadsheet to show the scores from highest to lowest.

Or sort by another column to see how many people gave the same answer to a question.

If you delete data from the spreadsheet, you will need to create a new spreadsheet from your quiz to see that data in place again.

It will remain missing from the spreadsheet, even as it updates.

Finally, if you would like a hard copy of your quiz responses, you can print a copy.

Or, save the responses as a PDF.

Viewing quiz data in a spreadsheet, especially if you have a large number of quiz takers, allows you to view their responses in detail and filter them in different ways, so you can understand how well your quiz takers understand a topic.

Choose an Extension
Change Settings to Customize Your Quiz
Middle school and high school students improve their digital skills by updating the settings in their quiz form, in this project-based learning lesson.
Create Paragraph and Short Answer Questions
Use project-based learning to teach middle school and high school students how to create additional question types for their quiz, plus additional digital skills.
Add a Theme
Middle school and high school students improve their digital skills by updating the settings in their quiz form, in this project-based learning lesson.
Add Images to Your Quiz Questions
Middle school students and high school students use project-based learning to improve basic digital skills by integrating images into quizzes and giving their form more visual appeal.
Analyze Quiz Data
Use project-based learning to teach middle school and high school students how to analyze data and individual responses to their quiz, plus additional digital skills.
Get Email Alerts and Download Quiz Responses in a Spreadsheet
Middle school students and high school students improve their digital skills by updating the settings in their quiz form, in this project-based learning lesson.
See more extensions
Next Lessons Dashboard
Instructions
Choose an extension.