How to assign points for likert scale question?

"creating scores for a Likert Scale response form/quiz"- Google Docs Editors Community

This is a common question: 152 people on Google's forum have asked how to score a Likert scale in Google Forms. On a satisfaction question, Extremely satisfied should be worth 5 and Extremely dissatisfied 1, with each answer between worth its own amount. A Google Forms quiz treats one answer as right and the rest as wrong, so it can't give 5 to one answer and 4 to the next, and the score ends up in a spreadsheet formula. With Formfacade, you give each choice of the multiple choice question its own points and every response comes in with its score. Sync the responses to Google Sheets and the score sits in its own column, so you can sort by it and follow up with the lowest first.

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

How to assign points and calculate scores using Formfacade?

  • 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 to measure customer satisfaction.
  • Extremely satisfied = 5
  • Somewhat satisfied = 4
  • Neutral = 3
  • Somewhat dissatisfied = 2
  • Extremely dissatisfied = 1
  • 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. The Score changes as you answer.

Summary

A Google Forms quiz marks answers right or wrong, so it can't give each step of a Likert scale its own points. With Formfacade, you assign points to each answer choice and every response gets a score as it's filled in. Import your Google Form and complete the steps above.

Set the points for each answer on your Likert scale.

Import your survey and describe the points for each answer on the scale. Every response gets its score as people fill in the form.

Last updated: