How to assign points for a grid question?

Standard questionnaires often come as a grid. The Dutch Handedness Questionnaire asks about ten activities, each answered Left, Right or Both, scored -1, +1 and 0. A Google Forms quiz can't put points on the columns of a multiple choice grid, so the score gets counted by hand. With Formfacade, one SCORE function in the Score question lists the points for each column, SCORE(entry#id, -1, 1, 0), and applies them to every row of the grid. Each person gets their score on the form, from -10 for fully left-handed to +10 for fully right-handed. When some rows score differently from others, use GRIDSCORE instead.

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

How to assign points using the SCORE function?

  • 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. Please follow the instructions below to assign points and calculate the score.
  • 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 in a new tab.
  • Back on this page, click Share form under Manage: your form opens on the Share tab. Click the Edit tab.
  • Your form already has a Score question, which may be named Total Score. Click on the score question, then click the ⚙️ icon.
Dutch Handedness Questionnaire on the EDIT tab with the Total Score question selected and EDIT, the question and the gear at the bottom of its card marked
  • Select the "Answer" tab and write the formula to assign points and calculate the score.
The Answer tab of the Score question with Answer and the Calculate box holding POINTS() marked

SCORE function

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 assign points to the answer choices in multiple choice grid question using SCORE function.
SCORE(entry#id, -1, 1, 0)
Note: Type @ and select the required multiple choice grid question from the list to add its entry #id in the above formula.
  • The Calculate option already has POINTS(). Delete it and write the SCORE function in the Calculate option as shown below and click Save. The score varies from -10 for extreme left-handedness to + 10 for extreme right handedness.
The Calculate box with the SCORE function for the grid question and the Save button marked
The score is calculated as users answer the question.
The Dutch Handedness Questionnaire with a multiple choice question, a grid with Left, Right and Both answered and a Score of 2

Summary

Google Forms can't give points to the columns of a grid question, so a grid questionnaire has to be scored by hand. With Formfacade, you write the SCORE function with a value for each column and every row of the grid is scored with it. Import your Google Form and complete the steps above. If you have any questions, write to support.

Score every row of your grid with one SCORE function.

Import your Google Form and write SCORE with a value for each column in the Score question's Calculate option. It scores every row as people answer.

Last updated: