Support Team
Unknown
Posts
Support
Can we group questions and create a sub-score for a grouping?
We have 57 questions and those questions go into 12 question categories. We want to score the entire set of questions, but also be able to group and score the groups so that in the report we can provide specific feedback bespoke to how the respondant answered the questions in each group.
Yes, you can use the Formfacade - Assign points product to calculate category scores. You can either use our templates to create your form or configure your existing google form using the Formfacade - Assign points addon.
Open your form in google forms > click on the addon icon > click Formfacade - Assign points > click Configure score and follow the prompts.
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
Wed Oct 30 2024