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.

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.

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.

Customize confirmation message

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