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 hrsHow 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) DailyHow much physical activity does your job require? (a) Not much(b) A moderate amount(c) Average(d) Intense(e) Very intensePoints: We will use the same points scale for all the three multiple choice questionsAnswer choice (a) - 1 pointAnswer choice (b) - 2 pointsAnswer choice (c) - 3 pointsAnswer choice (d) - 4 pointsAnswer choice (e) - 5 pointsWe 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.
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 (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.
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.