How to assign same points for each question and calculate scores for each section?

How to assign same points for each question and calculate scores for each section?

You can assign point values to questions in Google Forms by creating a quiz and calculate the total score, but you cannot calculate the individual scores for each section. To do that, you can use the Formfacade addon for Google Forms.

You can assign point values to questions in Google Forms by creating a quiz and calculate the total score, but you cannot calculate the individual scores for each section. To do that, you can use the Formfacade addon for Google Forms.

How to calculate individual scores for each section 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. https://gsuite.google.com/marketplace/app/formfacade/743872305260

Step 1: Add a Short Answer question in each section to calculate the score. If you would like to calculate the overall score, add another Short Answer question in the last section.
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 in first section.
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 or questions across all the sections 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 function to calculate the individual scores for the three sections Sedentary behaviour, Sports & recreational activities and Everyday physical activities.

SCORE(SECTION,1,2,3,4,5)
First parameter: SECTION option to calculate the score for questions in the current section.
Second parameter: 1, 2, 3, 4, 5 to assign points for answer choices (a), (b), (c), (d), (e) respectively for all the questions in the current section.

Step 7: Write the SCORE function in "Calculate" and click on the Save button.
Step 8: Similarly, click on gear icon next to score question in second section. Write the SCORE function in "Calculate" and click on the Save button.
Step 9: Similarly, click on gear icon next to score question in third section. Write the SCORE function in "Calculate" and click on the Save button.
Step 10: To calculate the overall score, click on the gear icon next to the "Overall score" field. In the "Calculate" option, add the three scores for each section as shown below.