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. Create your form and follow the steps below.

How to assign points and calculate scores using Formfacade?

  • On the page that opens, name your form, click Create form and click Proceed.
The tabs Edit, Preview, Share and Responses, with Edit marked
  • In the Assign points dialog, under "How do you want to set up scoring?", select "Assign points manually" and click Proceed.
The Assign points dialog asking How do you want to set up scoring?, with Assign points manually and Proceed marked
  • Pick Multiple choice as the question type to score, assign points to its choices and click Next. The same points go to every multiple choice question in your form.
The step To which questions would you like to allocate points?, with Multiple choice picked, points for Rarely, Weekly and Daily and Next marked
  • Under "How do you want to show the score?", leave both options ticked and click Next.
  • Click the × on "You're all set" to go back to the "Edit" tab.
The Assign points dialog saying You're all set! Score calculation is enabled, with Preview form
Your form now has a Score question and the same points on every multiple choice question. The steps below give each question its own points.
Let's change this form into a simple form to collect feedback on ordering experience. 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
  • Click on a multiple choice question in the Edit page and enter these answer choices. Delete the questions you do not need.
  • In the Edit page, click on the question, then click on the gear icon.
The Ordering experience feedback form on the EDIT tab with the likert scale question selected and EDIT, the question and the gear at the bottom of its card marked
  • Click Answer. Assign points for the different answer choices and click Save.
The Answer tab with Assign points for each choice from Extremely satisfied = 5 to Extremely dissatisfied = 1 and Answer, the first points box and Save marked
Click on "Share" tab, copy the link and open it to fill the form. The Score changes as you answer. When you submit, you will see "Your total score is" followed by your score.

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. Create your form and complete the steps above.

Last updated: