How to assign points for a grid question?

"I have a quiz of 20 questions, each with multiple choice grid of five options."- Google Docs Editors Community

A multiple choice grid keeps a long questionnaire short: ten statements, one set of columns. Scoring it is another matter. A Google Forms quiz can mark a right answer on each row, but it can't give each column its own points, like -1 for Left, +1 for Right and 0 for Both, so the total ends up worked out by hand. With Formfacade, you give each column of the grid its own points and every row is scored with them. People see their score on the form as they answer, and when they submit the message tells them their total. If some rows need different points, the GRIDSCORE function handles that.

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 the Dutch Handedness Questionnaire, which measures the extent of left or right handedness, as an example. This questionnaire contains one question about the hand you preferentially use for writing and ten questions about your hand preference for other activities.
We will use the multiple choice question to record the hand preference for writing and a multiple choice grid question with ten statements about the hand preference for other activities. Left, Right and Both are the three answer choices for the statements in multiple choice grid question. The points must be assigned as follows: Left = -1, Right = +1, Both = 0.
You can use this option if all the statements in the multiple choice grid question have the same points. Otherwise, you can use the GRIDSCORE function.
  • 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: "In the grid question, give Left -1, Right +1 and Both 0 on every row. 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

Google Forms can't give the columns of a grid question their own points, so a grid questionnaire has to be scored by hand. With Formfacade, you assign points to each answer choice in the grid and the score is calculated as people fill in the form. Import your Google Form and complete the steps above.

Give the columns of your grid question their own points.

Import your Google Form and describe the points for each column of the grid. Every row is scored with them and people see the score as they answer.

Last updated: