How to assign points for a checkboxes question?

"Google Forms: Count points for each correct item"- Google Docs Editors Community

On a checkboxes question with several right answers, a Google Forms quiz gives the points only when someone ticks exactly the right set. Tick three of the four right answers and the question scores zero. On the thread above, 13 people on Google's forum have asked how to count points for each correct item instead. Working it out in a Google Sheet means a formula per question, and the person who answered never sees the result. With Formfacade, you give every choice in a checkboxes question its own points, and the points for the boxes someone ticks are added into their score. A wrong choice can carry negative points, and people see their score change as they tick.

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 for slash the sugar challenge. The purpose of this form is to track the daily activity and assign positive or negative points for each of the activity. Positive points indicate that users are successful in reducing the sugar intake. We will use a checkboxes question with different activities as answer choices that users can select.
  • Glass of water = 1
  • Fresh fruits & veggies = 2
  • Nuts for snacks = 2
  • Daily exercise = 10
  • Soda, cocktails or drinks = -3
  • Cookies, cakes or sweets = -5
  • Fried food / Fast food = -6
  • Refined grains = -1
  • Click on a question and change it to Checkboxes in the list of question types. Enter your answer choices. Delete the questions you do not need.
  • In the Edit page, click on the checkboxes question, then click on the gear icon.
Slash the sugar challenge on the EDIT tab with the checkboxes 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 Glass of water = 1 to Refined grains = -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 scores a checkboxes question all or nothing, so it can't add up a value for each box someone ticks. With Formfacade, you assign points to each choice, including negative ones, and the points for the ticked boxes make the score. Create your form and complete the steps above.

Last updated: