How to assign same points for each question & calculate the 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 Formfacade 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 Formfacade?

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

Step 1: Add a Short Answer question in your Google Form for displaying the score.
Step 2:  Click on the add-on icon and select "Formfacade"
Step 3: Formfacade popup menu will be displayed. Select "Customize this form".
Step 4: Customize introduction popup screen will be displayed. Click on the Proceed button.
Step 5: Formfacade customize interface will open in a new tab. Click on the gear icon next to the score question.
Step 6: Field settings screen will be displayed. Select "Answer" tab.

SCORE function

SCORE() function allows you to assign scores to each answer choices in multiple choice questions, checkboxes questions and grid questions. It takes two input parameters:
1. The first parameter specifies whether the score should be calculated for all questions in the section (SECTION) or questions across all the sections (ALL) or only the questions that matches the search term in the description.
2. The second parameter is the points to be assigned for different answer choices (a), (b), (c), (d), (e) etc.

In this example, we will use SCORE(ALL,1,2,3,4,5) to calculate the physical activity score.
First parameter: ALL option to calculate the total score across the three multiple choice questions.
Second parameter: 1, 2, 3, 4, 5 to assign points for answer choices (a), (b), (c), (d), (e) respectively.

Step 7: Write the SCORE function in "Calculate" and click on the Save button.
If the respondent selects answer choice (e) for Q1, answer choice (d) for Q2 and answer choice (c) for Q3, then the total score calculated using the SCORE(ALL,1,2,3,4,5) will be (5+4+3)=12.
Made with formfacade