Let's create a simple questionnaire with 3 multiple choice questions with five answer choices each (see below). Q1. How much time do you spend sitting each day?Watching TV, Playing computer games etc(a) 5+ hrs(b) 4 to 5 hrs(c) 3 to 4 hrs(d) 2 to 3 hrs(e) Less than 2 hrsQ2. How often do you do sports and recreational activities?Playing sports, going to gym, walking, cycling etc(a) Once or twice in a month(b) Once a week(c) Thrice a week(d) 5 days in a week (e) DailyQ3. How much physical activity does your job require? Carrying or lifting heavy loads, construction, digging etc(a) Not much(b) A moderate amount(c) Average(d) Intense(e) Very intensePoints: Assign varying points for each multiple choice question Q1: (a) - 1, (b) - 2, (c) - 3, (d) - 4, (e) - 5Q2: (a) - 2, (b) - 4, (c) - 6, (d) - 8, (e) - 10Q3: (a) - 5, (b) - 10, (c) - 15, (d) - 20, (e) - 25We will calculate the total score by adding the individual points for the 3 multiple choice questions. The total score would be between 8 and 40.
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 can be used to assign points to answer choices in multiple choice, checkboxes and grid questions and calculate the total score. Syntax: SCORE(scope, point-1, point-2, …, point-n) where
In this example, we will use the entry#id for a question as the scope to assign points for that specific question and calculate the individual score for that question. 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 SCORE(entry#id, 1, 2, 3, 4, 5)
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 SCORE(entry#id, 2, 4, 6, 8, 10)
How much physical activity does your job require? Carrying or lifting heavy loads, construction, digging etc (a) Not much (b) A moderate amount (c) Average (d) Intense (e) Very intense SCORE(entry#id, 5, 10, 15, 20, 25)
To calculate the total score, simply add the three scores as shown in the screen shot below. SCORE(entry#id, 1, 2, 3, 4, 5) + SCORE(entry#id, 2, 4, 6, 8, 10) + SCORE(entry#id, 5, 10, 15, 20, 25)
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.
Try It Free