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 Scorecery add-on for Google Forms. If you haven't installed the add-on yet, you can install it from Google Workspace Marketplace using this link. https://workspace.google.com/marketplace/app/scorecery/706030115252
You can assign different points for answer choices in dropdown, multiple choice, checkbox, liner scale & grid questions. You have to repeat steps 6 & 7 below to assign points for all the questions in your form.
By default, the form respondents will be able to view the score before they submit. You can update the settings to hide the score and display it only after they submit the form.
The default confirmation message is "Your total score is ". You can customize this message or show conditional message based on score.
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.