How to assign different points for multiple choice questions and calculate total score?

You can assign point values to questions in Google Forms by creating a quiz, but you cannot assign different points to each answer in a multiple choice question and calculate the total score. To do that, you can use the Scorecery addon for Google Forms.

Let's create a simple questionnaire with 3 multiple choice questions with five answer choices each (see below). We will calculate the total score to determine how active a person is.

How much time do you spend sitting each day?
(a) 5+ hrs
(b) 4 to 5 hrs
(c) 3 to 4 hrs
(d) 2 to 3 hrs
(e) Less than 2 hrs

How often do you do sports and recreational activities?
(a) Once or twice in a month
(b) Once a week
(c) Thrice a week
(d) 5 days in a week
(e) Daily

How much physical activity does your job require?
(a) Not much
(b) A moderate amount
(c) Average
(d) Intense
(e) Very intense

Points: We will use the same points scale for all the three multiple choice questions
Answer choice (a) - 1 point
Answer choice (b) - 2 points
Answer choice (c) - 3 points
Answer choice (d) - 4 points
Answer choice (e) - 5 points

We will calculate the total score by adding the individual points for the 3 multiple choice questions. The total score would be between 3 and 15.

How to assign points and calculate scores using Scorecery?

Pre-requisite: You must have installed the Scorecery add-on for Google Forms. If you haven't installed the add-on yet, you can install it from Google Workspace Marketplace using this link.

Step 1:  Open your form in Google Forms. Click on the addon icon and click Scorecery.
Step 2: Scorecery menu will be displayed. Click Configure score.
Step 3: Configure score setup wizard will be displayed. Click Next to proceed to the next step.
Step 4: Enable the option to record the score in Google Forms, show it in the confirmation message and click Next.
Step 5: Click on the link to open the edit page for assigning points.

Assign points

You can assign different points for answer choices in dropdown, multiple choice, checkbox, liner scale & grid questions. You have to repeat steps 6 & 7 below to assign points for all the questions in your form.

Step 6: In the Edit page, click on the gear icon next to the question.
Step 7: Question settings page will be displayed. Click Answer. Assign points for the different answer choices and click Save.

Show or hide score

By default, the form respondents will be able to view the score before they submit. You can update the settings to hide the score and display it only after they submit the form.

Step 8: Click on the gear icon next to the Total score question.
Step 9: Question settings page will be displayed. Click Answer, change the Appearance to hidden and click Save.

Customize confirmation message

The default confirmation message is "Your total score is ". You can customize this message or show conditional message based on score.

Step 10: Click on the gear icon next to the Submit button.
Step 11: Button settings page will be displayed. Click On submit. Select Show customized message for this button. Update the message and click Save.
Step 12: Click Share. Copy the short link and share it with your users to collect responses.
Made with formfacade