logo
search
Others

How to Award Points for Individual Choices in Microsoft Forms Quizzes

Emma BrownEmma Brown Oct 9, 2026 869 views

Question details

Users want to assign partial credit or award separate points for each correct choice within a multiple-choice quiz question, rather than using an all-or-nothing scoring system.

How to Award Points for Individual Choices in Microsoft Forms Quizzes
Product
Microsoft Forms
Device & OS
not provided
Scenario
A teacher or quiz creator is building a multiple-select assessment and wants students to receive partial points for selecting some, but not all, correct answers.
Observed behavior
Microsoft Forms only awards points if the complete answer is exactly correct. It currently does not support assigning separate point values or partial credit to individual choices automatically.
Before you start

Because Microsoft Forms currently uses an all-or-nothing grading system for multiple-select questions, you will need to restructure your questions or manually adjust scores to simulate partial credit.

Solution 1Recommended

Create Separate Questions for Each Option

Since partial credit isn't supported within a single multiple-choice question, breaking the options into separate True/False or Yes/No questions allows you to assign points individually.

This method forces the automatic grading system to award points for every correct selection a student makes. While it makes the quiz slightly longer, it ensures accurate, automated partial grading without requiring manual review.

1
Add a new question

Open your Microsoft Forms quiz, click on 'Add new', and select 'Choice'.

2
Format as True/False

Enter one of the choices from your original multiple-select question as the question text. Set the two options to 'True' and 'False' (or 'Yes' and 'No').

3
Assign points

Click the checkmark next to the correct answer to set it, and assign a specific point value (e.g., 1 point) in the 'Points' field at the bottom.

4
Repeat for remaining choices

Duplicate the question or create new ones for the remaining options that would have been part of your original multiple-choice question.

Create Separate Questions for Each Option
Automatic Grading: By separating the choices, Microsoft Forms will automatically grade each element, saving you time from manually reviewing and assigning partial credit later.
Free Microsoft Office alternative

Analyze and Grade Quiz Results Easily with WPS Office

While Microsoft Forms lacks built-in partial credit features, you can export your quiz results to an Excel file and calculate custom scores using WPS Spreadsheet. WPS Office is a free, lightweight suite that serves as an excellent alternative for managing educational data and documents.

  1. 1. Export Forms Data: In your Microsoft Forms 'Responses' tab, click 'Open in Excel' to download your students' quiz results.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office, open the downloaded .xlsx file, and view your raw quiz data.
  3. 3. Calculate Partial Credit: Add a new column next to your multiple-choice question data and use a formula (such as IF and COUNTIF functions) to accurately assign partial points based on the selected answers.
Fully compatible with Microsoft Excel formats (.xlsx), ensuring seamless opening of exported Forms data.Easily apply custom spreadsheet formulas to calculate partial credit for your students.Lightweight, fast, and completely free to use for daily educational or professional tasks.Familiar user interface ensures a zero learning curve for users switching from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft Forms add an automatic partial credit feature?

Microsoft frequently updates its tools based on user feedback, but there is currently no official release date for a partial credit feature in Forms. Users are encouraged to submit this request through the Microsoft feedback portal.

Can I use branching logic to award different points in Microsoft Forms?

Branching logic in Microsoft Forms directs users to different questions based on their answers, but it does not change the point value of a single question or award partial credit for specific multiple-choice selections.

Does exporting Microsoft Forms data to Excel automatically fix partial credit?

No. When you export to Excel, the file simply reflects the 0 points awarded by Forms. However, having the data in a spreadsheet allows you to use formulas to manually identify partially correct answers and calculate a new score.