I am trying to create a quiz in forms that is four parts of 10 questions each and then create a score in each of those four areas using a likert scale. Trying to figure out how to configure the score to report the four different scores.
Hi Rhonda, There are two ways to set up your form.
#1 If you are planning to create a multi-page form with separate pages for each of the 4 areas, then you can choose to use the POINTS(SECTION) formula to calculate the section score.
Open your form in google forms > click on the addon icon > click Formfacade - Assign points > click Configure score and follow the prompts to assign points.
Calculate Section Scores
Add a short answer question at the end of each section and use the POINTS(SECTION) formula in the Calculate option for that question to calculate the section score. Instructions below.
In the Formfacade Edit page, click on the last question in the first page in your form > click on the + add question icon > a new question will be added below the selected question > enter the title "Section Score", select Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the POINTS(SECTION) formula in the Calculate option > select Hidden for the Appearance option and click Save. Repeat the steps for other sections in your form.
-x-
#2 If you are creating a single page form with all the questions for the 4 areas in the same page, then you can assign categories to different questions and calculate the category scores for each areas.
Assign points, category
In the Formfacade Edit page, click on a question to select it > click on the settings gear icon for that question > Question settings page will be displayed > click Answer > assign the points for different answer choices > click Score category, enter the category name (For example: Communication) and click Save. Repeat the steps for other questions in the form.
Calculate category score
In the Formfacade Edit page, click on the + icon to add a short answer question > enter the title (For example: Communication score) > click on the settings gear icon for this question > Question settings page will be displayed > click Answer > enter the following formula POINTS(CATEGORY, "Communication") in the Calculate option and click Save.
Note: The formula for calculating the category score is POINTS(CATEGEORY, "category_name") where category_name is the category assigned for the questions. This is case sensitive; the name included in the formula must exactly match the name assigned for questions. You can calculate as many category scores as needed.
Formfacade Assign points demo video
https://youtu.be/zberDwRdLv8
Formfacade - Assign points addon
https://workspace.google.com/marketplace/app/formfacade_assign_points/706030115252
Comments (1)
Nov 20, 2024
Hi Rhonda, There are two ways to set up your form. #1 If you are planning to create a multi-page form with separate pages for each of the 4 areas, then you can choose to use the POINTS(SECTION) formula to calculate the section score. Open your form in google forms > click on the addon icon > click Formfacade - Assign points > click Configure score and follow the prompts to assign points. Calculate Section Scores Add a short answer question at the end of each section and use the POINTS(SECTION) formula in the Calculate option for that question to calculate the section score. Instructions below. In the Formfacade Edit page, click on the last question in the first page in your form > click on the + add question icon > a new question will be added below the selected question > enter the title "Section Score", select Short answer question type > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the POINTS(SECTION) formula in the Calculate option > select Hidden for the Appearance option and click Save. Repeat the steps for other sections in your form. -x- #2 If you are creating a single page form with all the questions for the 4 areas in the same page, then you can assign categories to different questions and calculate the category scores for each areas. Assign points, category In the Formfacade Edit page, click on a question to select it > click on the settings gear icon for that question > Question settings page will be displayed > click Answer > assign the points for different answer choices > click Score category, enter the category name (For example: Communication) and click Save. Repeat the steps for other questions in the form. Calculate category score In the Formfacade Edit page, click on the + icon to add a short answer question > enter the title (For example: Communication score) > click on the settings gear icon for this question > Question settings page will be displayed > click Answer > enter the following formula POINTS(CATEGORY, "Communication") in the Calculate option and click Save. Note: The formula for calculating the category score is POINTS(CATEGEORY, "category_name") where category_name is the category assigned for the questions. This is case sensitive; the name included in the formula must exactly match the name assigned for questions. You can calculate as many category scores as needed. Formfacade Assign points demo video https://youtu.be/zberDwRdLv8 Formfacade - Assign points addon https://workspace.google.com/marketplace/app/formfacade_assign_points/706030115252
Add your comment
Add photo