Google Forms is a powerful tool for creating quizzes and assessments. But its true potential lies in its ability to automatically grade responses and calculate percentage scores. When using Google Forms for quizzes, calculating scores by percentage is important for educators and professionals seeking efficient assessment methods.

This article will equip you with the knowledge to get the score by percentage in Google Forms Quiz and unlock valuable insights from your quizzes.

How to get Score by percentage from Google Form Quiz

How to Calculate the Percentage Scores in Google Forms

To find the percentage score in a Google Forms quiz, enable auto-grading and apply Google Sheets formulas for correct answers.

Step 1: Create the Quiz in Google Forms

Access Google Forms in Google Drive, create quiz questions with different types, and set correct answers for graded quizzes.

Step 2: Click on the “Settings” options

Click the “Settings” menu icon in the top-right corner of the Google Forms, and toggle on options like collecting email addresses and allowing quiz features.

Step 3: Set point values of Questions

After enabling quiz features, you can customize point values, display scores instantly, and choose what feedback to provide respondents.

customize point values, display scores instantly, and correct answers

Step 4: Collect Responses in a Google Sheets

Share the Google Forms quiz link with your audience. Responses go to a Google Sheets spreadsheet linked to the form.

Step 5: Get the Response Data in Google Sheets

View respondents’ answers and scores in the Google Sheets located in the same folder as your form.

Step 6: Get the Percentage Score in Google Sheets

Add a “Percentage Score” column beside the scores. In the first cell, use a formula (e.g., “=C4/B4*100”) with the respondent’s score and total points. Drag down to apply it to all rows.

Step 7: Display percentages in Google Sheets

Format the percentage score column by selecting it and going to Format –> Number –> Percentage.

Step 8: Review the percentage scores

Review and analyze percentage scores to assess performance. Use Google Sheets for sorting, filtering, visual aids, and analyzing data further.

How to create a quiz in Google Forms?

Creating a quiz in Google Forms is easy with this helpful guide for a smooth quiz creation process.

Step 1: Click Google Forms Settings

In Google Forms, choose the Settings menu icon.

Step 2: Pick the “Quiz” option

Go to the “Quiz” tab section and save your modifications.

Step 3: Click on the “Answer key.”

Select a question, then click “Answer key” to assign points.

Step 4: Choose correct answers

Select correct answers, assign points, and then click Done. Use “Add answer feedback” for explanations.

Step 5: Edit points and add feedback

You can assign points and give feedback on all question types, with points displayed at the question’s bottom left.

Creating a Quiz with Sections and Individual Scores

You can assign point values to Google Forms quiz questions to calculate the total score but can’t determine individual section scores. Use the Scorecery addon for score calculations.

Step 1: Open the Google Forms

Open Google Forms. Add Short Answer questions with number validation. Include in each section and for total score calculation.

Step 2: Choose the Scorecery option

Click the Add-on icon, then choose Scorecery.

Step 3: Click More options

Display the Scorecery menu and select More options.

Step 4: Click on the Customize option

Display the sidebar widget, then click Customize.

Point to Remember
Assign various points to answer choices in different question types; repeat steps 5 & 6 for all form questions.

Step 5: Click on the menu icon

On the Edit page, click the menu icon next to the question.

Step 6: Click on the Answer option

Display question settings page, click Answer, assign points to answer choices, then Save.

Step 7: Choose Calculate section score option

Click the Gear icon beside the Calculate section score question.

Step 8: Select the Calculate Formula

Use the POINTS(SECTION) formula on the question settings page in the Calculate option and Save.

Step 9: Go to Question settings

Click the Gear icon next to the section score question, go to the Question settings page, add the POINTS(SECTION) formula in Calculate, and then Save.

Step 10: Access Question settings

Click the gear icon next to the section score question, access Question settings, and add the POINTS(SECTION) formula in the Calculate option to save.

Point to Remember:

Use SUM() to add section scores for overall score calculation.

Step 11: Add the formula

Click the gear icon next to the overall score question, go to Question settings, add the SUM formula in the Calculate option, and then Save.

Conclusion

Mastering calculating percentage scores in Google Forms is vital for educators, trainers, and professionals assessing participant performance. This step-by-step guide helps derive insights, track progress, and make data-driven decisions to enhance learning outcomes. Percentage scores provide a standardized performance measure, enabling evaluation, identifying improvement areas, and tailoring instruction.

They also foster transparency and accountability and guide decision-making. Embracing percentage scores’ importance unlocks opportunities for excellence, growth, and success in education and professional development. Gain confidence in calculating scores to impact your participants effectively.

How to get Score by percentage from Google Form Quiz – FAQs

How to calculate score from Google Form?

To calculate scores in Google Forms

• Step 1: Create a quiz
• Step 2: Set correct answers
• Step 3: Assign point values to each question.

Responses will be automatically graded.

How to calculate percentage in Google Form?

To calculate percentages in Google Forms:

• Step 1: Create a Quiz in Google Forms.
• Step 2: Collect Responses in Google Sheets.
• Step 3: Calculate Percentage in Google Sheets. Use the formula “ = (A1 / Total_Possible_Score) * 100 “. Replace A1 with the cell reference of the total score and Total_Possible_Score with the maximum score possible.

This will calculate the percentage for each response.

How do I auto score a Google form?

To auto-score a Google Form:

1. Open Google Forms.
2. Go to Settings > Quizzes > Make this a quiz.
3. Add your questions. Assign point values to each question. Set correct answers.
4. Share the form.
5. View scores under the Responses tab or in Google Sheets by clicking the Sheets icon.