How to assign different points for multiple choice questions and calculate total score?
"I need to assign individual point values to multiple choice answers, from zero to five."- Google Docs Editors Community
In a Google Forms quiz, a multiple choice question has one right answer and every other choice earns nothing. That works for a test, but not for a questionnaire where "Daily" should count for more than "Once a week" and the total shows how active someone is. On the thread above, 5 people on Google's forum asked for points from zero to five on each choice. Adding them up in a Google Sheet means a formula to maintain, and the person who answered never sees the total. With Formfacade, you give each choice in a multiple choice question its own points, and the total score shows on the form as people answer. You can also hide it until they submit and write the message they see.
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.
Let's take a simple questionnaire with 3 multiple choice questions with five answer choices each as an example (see below). We will calculate the total score to determine how active a person is.
How much time do you spend sitting each day?
(a) 5+ hrs
(b) 4 to 5 hrs
(c) 3 to 4 hrs
(d) 2 to 3 hrs
(e) Less than 2 hrs
How often do you do sports and recreational activities?
(a) Once or twice in a month
(b) Once a week
(c) Thrice a week
(d) 5 days in a week
(e) Daily
How much physical activity does your job require?
(a) Not much
(b) A moderate amount
(c) Average
(d) Intense
(e) Very intense
Points: We will use the same points scale for all the three multiple choice questions
Answer choice (a) - 1 point
Answer choice (b) - 2 points
Answer choice (c) - 3 points
Answer choice (d) - 4 points
Answer choice (e) - 5 points
We will calculate the total score by adding the individual points for the 3 multiple choice questions. The total score would be between 3 and 15.
Your form may have its own multiple choice questions. You can also follow the steps with those.
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 the answer choices of each multiple choice question these points: (a) 1, (b) 2, (c) 3, (d) 4 and (e) 5. Add them up into a total 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. The Score changes as you answer.
Back on this page, click Share form under Manage: your form opens on the Share tab. Click the Edit tab.
Show or hide score
By default, the form respondents will be able to view the score before they submit. You can update the settings to hide the score and display it only after they submit the form.
Click on the Score question, then click on the gear icon.
Click Answer, change the Appearance to hidden and click Save.
If your form also has a Percentage question, do the same for it.
Customize confirmation message
The default confirmation message is "Your total score is <score>". You can customize this message or show conditional message based on score.
Scroll down to the end of the form and click on the gear icon on the last "After page" row, above the Submit button. It says "After page 1" on a form with one page.
Click On submit. Select Show customized message for this button. Update the message and click Save.
Click on "Share" tab. Copy the short link and share it with your users to collect responses.
When a user fills the form and submits it, they will see your message with their total score.
Summary
A Google Forms quiz scores a multiple choice question as right or wrong, so answers that should be worth different amounts can't be told apart. With Formfacade, you assign points to each answer choice and the form adds them into a total score. Import your Google Form and complete the steps above. If you have any questions, write to support.
Put points on your multiple choice answers. Add up the total.
Import your Google Form and describe the points for each answer choice. The form adds them into a total score that people see as they answer.