Check and share your quiz results

Tip:  Learn more about Microsoft Forms or get started right away and create a survey, quiz, or poll. Want more advanced branding, question types, and data analysis? Try Dynamics 365 Customer Voice.

Microsoft Forms provides a rich grading workflow that enables you, as the author, to efficiently award points per question to students and provide feedback in a number of ways. You can export quiz results to Microsoft Excel for more in-depth analysis and charting, as well as delete or print a summary of all responses.

View response summary information for your quiz

In Microsoft Forms, open the quiz for which you want to review the results, and then select the Responses tab.

Across the top, you'll see real-time summary information about your quiz, such as number of responses and average score. Next to each question, you'll see the number of responses and a chart that shows the distribution of responses across all of the possible answers.

Note: If there are intelligence-based data insights determined for a question, you'll see the Insights icon next to it. Learn more.

You can select More options to delete all responses, print a summary, or get a summary link to share with others.

 

Review answers for each question

Select Review Answers to provide points and feedback.

Per personPer question



On the People tab, you can see individual details for each student, such as time it took to complete your quiz, number of points earned, and the option(s) your student selected.

In this view, you can grade all questions for one student, then do the same for subsequent students. Select the arrow next to a student's name to jump to the results of another student. You can also select the left and right arrows to toggle through the result details of the other students.

To provide general feedback for a student, select the feedback icon and type in the text box.

To provide feedback for a particular question, select the feedback icon to the right of points, and then type in the text box.

You can also select More options and choose whether to Delete response, Print response, or Post scores for a particular individual.

Note: Deleting a response cannot be undone.

Tip: Learn more about printing forms.

On the Questions tab, you can see each question and number of responses for each answer.

In this view, you can grade one question across all students by assigning points per answer. Select on the link for each answer's responses to get a snapshot of which students selected that particular answer. Select the feedback icon to the right of each answer's points to provide bulk feedback to all students who selected that answer.

Select the left and right arrows to toggle through the details of other questions.

Post scores

When you're ready to share your feedback and points to students, select Post scores in the Responses tab.

For each student, you can see the status of their quiz and number of points earned. If you want to post the scores of all students, tick the check box to the left of Name in the Name column. To post individual scores, tick the checkbox to the left of each student's name.

Select Post scores.

Once you post scores, you can go back to your quiz to review your results and feedback. Students can view their scores and feedback by opening the quiz.

Tip: If a student goes back into a quiz after submitting, they'll be able to see their previous responses. If you want them to retake the quiz without seeing their responses, you can create a copy of the original quiz. 

Analyze your quiz results in Excel

You can easily view all of the response data for your quiz in Microsoft Excel. Select Open in Excel on the Responses tab.

In your Excel workbook, details of each question in your quiz are represented in columns and each response is shown in a row. The first five columns display respondent ID, start and completion times for each response, and the name and email address of each student. The subsequent columns display total points, quiz feedback, grade posted time, quiz questions, points for individual questions, and feedback for individual questions.

Notes: 

• The respondent ID is exclusive for each student.

• Any changes you make to the quiz data in Excel won't modify the content of your quiz.

• Names and email addresses won't be displayed if you allow your quiz to accept anonymous responses.

Share results with others

 

1. Select the Responses tab.

2. Select More options  > Get a summary link.

3. Select Copy.

When you paste this link, anyone that has the link will be able to view a summary of responses for your quiz.

Notes: 

• If you're collaborating on a quiz with specific teachers in your school, only you, as the quiz owner, can create a summary link for your quiz if one doesn't yet exist. Co-authors can still copy and share your summary link, but can't create one, themselves. In other collaboration modes not set for specific people in your organization, co-authors can create new summary links.

• Also note that if you share your quiz responses with anyone in your school, and then decide to share with only specific people in your school, any summary sharing link that already exists can still be accessed by anyone inside or outside of your school. You can delete an existing summary link to disable it, which will reduce access to the response data. You can do this by going to the Responses tab > More options > Get a summary link > Remove link (trash can icon). Optional: You can then create a new summary link if you want to share it with a new audience, but this new summary link will still be accessible by anyone who gets a hold of it.

Feedback for Microsoft Forms

We want to hear from you! To send feedback about Microsoft Forms, go to the upper right corner of your form and select More form settings  > Feedback.

See Also

How to ensure your form and workbook are in sync

Troubleshoot exporting form data to Excel