How to calculate scores for each section in Google Forms?

"How can I calculate section-wise scores and total scores for a quiz with multiple sections"- Google Docs Editors Community

Your quiz in Google Forms has sections, say general knowledge, maths and English, and you want a mark for each one as well as the total. Google Forms adds every point in the form into one score, so a strong maths result and a weak English one look the same. You can split the totals in a Google Sheet, but that takes a formula per section, and the person who took the quiz still sees only one number. With Formfacade, you add a score question to each section, and its POINTS(SECTION) formula adds up only that section's answers, with the points you set on each question. People see each section's score as they go, and the Score question can add them into an overall total.

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

How to calculate individual scores for each section?

  • 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

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 each answer its points and calculate a score for each section, plus an overall 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.

Add a score question in each section

  • Click on the last question of a section, then click on the Add page icon on the right. The questions below it move to a new page. Type the name of the next section in the page title.
  • Click on a question in each section, then click on the Add field icon on the right. It adds a Short answer question after it. Type the section's name as its title.
A Short answer question called Sports & recreational activities (SCORE) on the EDIT tab, with the Add field icon marked
If you would like to calculate the overall score, use the Score question your form already has.

Calculate section score

  • Click on the section score question, then click on the gear icon.
The form on the EDIT tab with the Sedentary behaviour (SCORE) question selected and EDIT, the question and the gear marked
  • Click Answer, add the POINTS(SECTION) formula in the Calculate option and click Save.
The Sedentary behaviour (SCORE) question behind its Answer tab, with POINTS(SECTION) in Calculate and Calculate and Save marked
  • Similarly, click on section score question in second section, then click on gear icon. Click Answer, add the POINTS(SECTION) formula in the Calculate option and click Save.
The Sports & recreational activities (SCORE) question behind its Answer tab, with POINTS(SECTION) in Calculate and Calculate and Save marked
  • Similarly, click on section score question in third section, then click on gear icon. Click Answer, add the POINTS(SECTION) formula in the Calculate option and click Save.
The Everyday physical activities (SCORE) question behind its Answer tab, with POINTS(SECTION) in Calculate and Calculate and Save marked

Overall score

You can use the SUM() formula to add the section scores and calculate the overall score.
  • Click on the Score question in the last section, then click on gear icon. Click Answer, delete POINTS() in the Calculate option, add the SUM formula (as shown below) and click Save. To add each section score to the formula, type @ and select it from the list.
The Answer tab with the SUM formula of the three section scores in Calculate, and Answer, Calculate and Save marked
Each section gets its own score as users answer the questions and the Score question shows the overall score.

Summary

A Google Forms quiz gives one total, so it can't show where someone did well and where they fell short. With Formfacade, you add a score question in each section with the POINTS(SECTION) formula, and add the section scores into an overall score with SUM. Import your Google Form and complete the steps above. If you have any questions, write to support.

Give each section of your Google Form its own score.

Import your Google Form, add POINTS(SECTION) to a score question in each section and SUM them for the total. People see each section's score as they go.

Last updated: