How to assign points for a Likert scale question?

"How to add scores according to respondent's answer in a Likert scale?"- Google Docs Editors Community

A customer feedback form in Google Forms often asks how satisfied someone is on a five-step Likert scale, from Extremely satisfied to Extremely dissatisfied. To compare customers, each answer needs a number, 5 down to 1. A Google Forms quiz gives points only to a correct answer, so it can't score a scale where every answer counts, and 12 people on Google's forum have asked how to score by the answer picked. With Formfacade, the SCORE function in the Score question gives each answer its points, SCORE(entry#id, 5, 4, 3, 2, 1), and the score is worked out as each customer fills in the form.

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

How to assign points using the SCORE 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 form to collect feedback on ordering experience as an example. We will use a multiple choice question with a 5 point likert scale for satisfaction as answer choices. Please follow the instructions below to assign points and calculate the score.
  • 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 of the multiple choice question these points: Extremely satisfied = 5, Somewhat satisfied = 4, Neutral = 3, Somewhat dissatisfied = 2, Extremely dissatisfied = 1. Add them up into a 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, which may be named Total Score. Click on the score question, then click the ⚙️ icon.
Ordering experience feedback 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 the "Answer" tab and write the formula to assign points and calculate the score.
The Answer tab of the Score question with Answer and the Calculate box holding POINTS() marked

SCORE function

The form is used to collect feedback from users about their ordering experience. A 5 point likert scale is used to measure customer satisfaction. You can assign points to the answer choices in multiple choice question using SCORE function.
  • Extremely satisfied = 5
  • Somewhat satisfied = 4
  • Neutral = 3
  • Somewhat dissatisfied = 2
  • Extremely dissatisfied = 1
  • SCORE(entry#id, 5, 4, 3, 2, 1)
Note: Type @ and select the required multiple choice question from the list to add its entry #id in the above formula.
  • The Calculate option already has POINTS(). Delete it and write the SCORE function in the Calculate option as shown below and click Save.
The Calculate box with the SCORE function with the points 5, 4, 3, 2, 1 and the Save button marked
The score is calculated as users select their answers.
A feedback form with Somewhat satisfied selected on a 5 point likert scale and a Score of 4

Summary

A Google Forms quiz can't give each answer on a Likert scale its own points, because it only knows right and wrong. With Formfacade, you write the SCORE function with the points for each answer choice and the score is calculated as the form is filled in. Import your Google Form and complete the steps above. If you have any questions, write to support.

Turn your Likert scale answers into a score with SCORE.

Import your survey and replace POINTS() in the Score question with SCORE and the points for each answer. Each person is scored as they fill it in.

Last updated: