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
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.
Click Submit to finish.
To use this feature, you need our Gsuite addon.
Install this addon to calculate score.