How to assign varying points for each question & calculate the total score?

"I can't seem to find a way to give different points per each questions."- Google Docs Editors Community

Some questions should weigh more than others. In an activity questionnaire, a job with heavy lifting tells you more than the hours spent sitting, so the same answer choice can't be worth the same on every question. A Google Forms quiz can set points per question, but only for one correct answer, so the weights end up in a spreadsheet. With Formfacade, you write a SCORE function for each question with its own points, SCORE(entry#id, 5, 10, 15, 20, 25) for the heaviest one, and add them together in the Score question. The weighted total is worked out as people answer, and you can email each person their total.

Let's start. Import your Google Form and follow the steps below.

How to assign different points using SCORE - QUESTION function?

  • On the page that opens, paste your Google Form's link or click Browse to pick it, then click Next.
The import page with a Google Form's link pasted, and the link box and Next marked
Let's take a simple questionnaire with 3 multiple choice questions with five answer choices each as an example (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 hrs
Q2. 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) Daily
Q3. 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
  • Points: Assign varying points for each multiple choice question
  • Q1: (a) - 1, (b) - 2, (c) - 3, (d) - 4, (e) - 5
  • Q2: (a) - 2, (b) - 4, (c) - 6, (d) - 8, (e) - 10
  • Q3: (a) - 5, (b) - 10, (c) - 15, (d) - 20, (e) - 25
We 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.
Your form may have its own multiple choice questions. You can also follow the steps with those.
  • A description is already written under "Describe how you want to score this form". Change it to say how you want to score your form, for example: "Give the answer choices (a) to (e) of each question these points: Q1: 1, 2, 3, 4, 5. Q2: 2, 4, 6, 8, 10. Q3: 5, 10, 15, 20, 25. Add them up into a total score." Click Next.
  • "How do you want to score?" shows what it did. Click View points to check the points for each answer, then click Next.
  • On "You're all set!", click Preview form. Your form opens with its score in a new tab.
  • Back on this page, click Share form under Manage: your form opens on the Share tab. Click the Edit tab.
  • Your form already has a Score question for assigning points and calculating the score, which may be named Total Score. Click on the score question, then click on the gear icon.
The form on the EDIT tab with the Total Score question selected and EDIT, the question and the gear at the bottom of its card marked
  • Select "Answer" tab.
The Answer tab of the score question with Answer and the Calculate box holding POINTS() marked

SCORE - QUESTION function

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
  • scope - determines whether to assign points to a specific question in the form, all questions in the section, all questions in the form or only the questions that have the matching search term in the description
  • point-1, point-2, … point-n - points to be assigned for different answer choices (a), (b), (c), (d), (e) etc in sequential order
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)
  • Type @ and select the required question from the list to add its entry #id in the above formula.
  • 1, 2, 3, 4, 5 to assign points for answer choices (a), (b), (c), (d), (e) respectively.
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)
  • Type @ and select the required question from the list to add its entry #id in the above formula.
  • 2, 4, 6, 8, 10 to assign points for answer choices (a), (b), (c), (d), (e) respectively.
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)
  • Type @ and select the required question from the list to add its entry #id in the above formula.
  • 5, 10, 15, 20, 25 to assign points for answer choices (a), (b), (c), (d), (e) respectively.
To calculate the total score, add the three scores as shown in the screenshot 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)
  • The "Calculate" box already has POINTS(). Delete it, write the SCORE function in "Calculate" and click on the Save button.
The Calculate box with three SCORE functions added together and the Save button marked
If the respondent selects answer choice (b) for Q1, answer choice (c) for Q2 and answer choice (c) for Q3, then the total score will be (2+6+15)=23.
The How active are you? form with answers (b), (c) and (c) selected and a total score of 23

Summary

When questions carry different weight, a Google Forms quiz can't give each answer choice its own points per question. With Formfacade, you write a SCORE function for each question and add them up in the Score question, so the total follows your weights. Import your Google Form and complete the steps above. If you have any questions, write to support.

Give some questions in your Google Form more weight.

Import your Google Form, write a SCORE with its own points for each question and add them up in the Score question, so the total follows your weights.

Last updated: