How to assign points for a dropdown question?

A screening survey in Google Forms often has no right answers, only Yes and No in a dropdown, and the result is how many times someone said yes. A Google Forms quiz gives points only to a correct answer, so it can't count those answers into a score. That leaves you counting each response by hand or writing a formula in the Sheet afterwards. With Formfacade, you give each choice in a dropdown question its own points, 1 for Yes and 0 for No, and the score is worked out while the form is being filled in. You can then show a different result for each score range, so people know what their number means.

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

How to assign points for dropdown questions and calculate scores?

  • 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 survey to assess gaming addiction as an example. The questions are based on diagnostic criteria for addictive gambling behavior. If a user answers "yes" to six or more of these questions, then they most likely have an addiction to video games. If a user answers "yes" to five or fewer questions, they may have a problem.

Assign Points

You can assign different points for answer choices in dropdown, multiple choice, checkbox, linear scale & grid questions.
  • 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 Yes 1 point and No 0 points in each dropdown question and 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

When a dropdown question has no right answer, a Google Forms quiz can't turn the answers into a score. With Formfacade, you assign points to each answer choice in the dropdown and the score is calculated as people fill in the form. Import your Google Form and complete the steps above.

Give each dropdown choice in your Google Form its own points.

Import your Google Form and describe the points for each dropdown choice. The form adds them into a score that changes as people answer.

Last updated: