How to Score Microsoft Forms Quiz Sections and Handle Not Applicable Answers
Question details
The user needs to calculate scores for individual sections in a Microsoft Forms quiz and assign points when respondents select conditional answers like 'Yes' or 'Not Applicable'.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Evaluating quizzes with section-specific scoring and conditional or either-or correct answers.
- Observed behavior
- Microsoft Forms only provides an overall quiz score and does not support automatic either-or scoring or section-specific score breakdowns out of the box.
Ensure you have access to your Microsoft Forms quiz responses and a spreadsheet application to calculate custom scores if needed.
Manually Review Responses for Conditional Answers
Since Microsoft Forms doesn't support automatic 'either-or' scoring, you need to manually review submissions where 'Not Applicable' or alternative answers should grant points.
Microsoft Forms currently relies on a single predefined correct answer for automatic grading. To accommodate flexible grading criteria like awarding points for a 'Not Applicable' selection, you must bypass the auto-grading feature for those specific questions and adjust the scores manually.
Navigate to your quiz in Microsoft Forms and click on the 'Responses' tab located at the top of the page.
Click on the 'Review answers' button to go through the individual student submissions.
Locate the questions where a respondent selected 'Not Applicable' or another valid conditional answer. Manually input the correct points into the score box next to the question to override the auto-graded zero.
Calculate Section Scores Externally in a Spreadsheet
Export your quiz data to a spreadsheet application to manually or automatically calculate scores grouped by specific sections.
Analyze Quiz Data with WPS Office
While Microsoft Forms lacks built-in section scoring, you can easily export your quiz data and calculate advanced custom scores using WPS Spreadsheet. WPS Office is a free, lightweight alternative that is fully compatible with Microsoft Excel formats.
Frequently Asked Questions
Can Microsoft Forms automatically score 'Not Applicable' as a correct answer?
No, currently Microsoft Forms requires a single predefined correct answer for automatic scoring. To award points for a 'Not Applicable' response, you must manually review the submission and override the auto-graded score.
Is there a way to show section scores to students in Microsoft Forms?
Microsoft Forms only displays the total overall score to respondents. To share individual section scores, you need to calculate them externally in a spreadsheet and share the breakdown with the students manually.
Can I use Power Automate to calculate section scores?
Yes. You can create a Power Automate flow that triggers when a new quiz response is submitted. The flow can extract the response details, group the points by section using variables, and automatically email the customized section score breakdown to the respondent.
