Hi Rose, You have created a form with 18 multiple choice questions with Meets, Opportunity, N/A as the three answer choices. You can use the Scorecery addon to assign the points for each of these answer choices. If you would like to exclude all questions with N/A as answer from the calculations, then you can assign points only for the first two answer choices Meets, Opportunity.
For example: In the Scorecery Edit page, click on the gear icon next to the first multiple choice question > Field settings page will be displayed > click Answer > enter 5 as the points for "Meets", 0 as the points for "Opportunity" and click Save. Do not enter any points for N/A. Repeat the steps for other questions.
SCORE CALCULATIONS
You can easily calculate the average points, total number of questions answered, percentage score etc.
1. Calculate the number questions answered
In the Scorecery Edit page, add a short answer question "Total number of answered questions" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula ANSWERED() in the Calculate option and click Save.
If the user selects N/A as the answer for 4 of the 18 questions, then the total number of questions answered will be updated as 14. ANSWERED will count the number of questions with answer choices that has points assigned and will ignore questions with N/A as the answer choice since no points were assigned.
2. Calculate average points
In the Scorecery Edit page, add a short answer question "Average points" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula AVERAGEPOINTS() in the Calculate option and click Save.
If the user selects N/A as the answer choice for 8 questions, Meets as the answer choice for 6 questions and Opportunity as the answer choice for the remaining 4 questions, then the AVERAGEPOINTS() formula will return (6 * 5 + 4 * 0) / 10 = 3 as the answer.
3. Calculate percentage score
Currently we do not have a function to directly calculate the percentage score, but you can use the POINTS and SCORE function to easily calculate the percentage score.
In the Scorecery Edit page, add a short answer question "Percentage score" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula POINTS()/SCORE(ALL, 5, 5, 0) in the Calculate option and click Save.
POINTS() will add up the points assigned for the answer choices selected by the users.
SCORE(ALL, 5, 5, 0) will add 5 points for each question with Meets as the answer choice and 5 points for each question with Opportunity as the answer choice to calculate the total possible score.
For example, If the user selects N/A as the answer choice for 8 questions, Meets as the answer choice for 7 questions and Opportunity as the answer choice for the remaining 3 questions, then
POINTS() will return 7 * 5 + 3 * 0 = 35 as the total points.
SCORE(ALL, 5, 5, 0) will return 5 * 7 + 5 * 3 + 0 * 8 = 50
Percentage score will be equal to 35 / 50 = 0.7
Please try this and confirm.
Hi Rose, you have already assigned 0 as the points for the "N/A" answer choice. In the Scorecery Edit page, click on the gear icon next to the first multiple choice question > Field settings page will be displayed > click Answer > delete 0 for the "N/A" answer choice and click Save. Repeat the steps for the other questions in the form.
Comments (3)
Mar 1, 2024
Hi Rose, You have created a form with 18 multiple choice questions with Meets, Opportunity, N/A as the three answer choices. You can use the Scorecery addon to assign the points for each of these answer choices. If you would like to exclude all questions with N/A as answer from the calculations, then you can assign points only for the first two answer choices Meets, Opportunity. For example: In the Scorecery Edit page, click on the gear icon next to the first multiple choice question > Field settings page will be displayed > click Answer > enter 5 as the points for "Meets", 0 as the points for "Opportunity" and click Save. Do not enter any points for N/A. Repeat the steps for other questions. SCORE CALCULATIONS You can easily calculate the average points, total number of questions answered, percentage score etc. 1. Calculate the number questions answered In the Scorecery Edit page, add a short answer question "Total number of answered questions" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula ANSWERED() in the Calculate option and click Save. If the user selects N/A as the answer for 4 of the 18 questions, then the total number of questions answered will be updated as 14. ANSWERED will count the number of questions with answer choices that has points assigned and will ignore questions with N/A as the answer choice since no points were assigned. 2. Calculate average points In the Scorecery Edit page, add a short answer question "Average points" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula AVERAGEPOINTS() in the Calculate option and click Save. If the user selects N/A as the answer choice for 8 questions, Meets as the answer choice for 6 questions and Opportunity as the answer choice for the remaining 4 questions, then the AVERAGEPOINTS() formula will return (6 * 5 + 4 * 0) / 10 = 3 as the answer. 3. Calculate percentage score Currently we do not have a function to directly calculate the percentage score, but you can use the POINTS and SCORE function to easily calculate the percentage score. In the Scorecery Edit page, add a short answer question "Percentage score" > click on the gear icon next to this question > Field settings page will be displayed > click Answer > enter the formula POINTS()/SCORE(ALL, 5, 5, 0) in the Calculate option and click Save. POINTS() will add up the points assigned for the answer choices selected by the users. SCORE(ALL, 5, 5, 0) will add 5 points for each question with Meets as the answer choice and 5 points for each question with Opportunity as the answer choice to calculate the total possible score. For example, If the user selects N/A as the answer choice for 8 questions, Meets as the answer choice for 7 questions and Opportunity as the answer choice for the remaining 3 questions, then POINTS() will return 7 * 5 + 3 * 0 = 35 as the total points. SCORE(ALL, 5, 5, 0) will return 5 * 7 + 5 * 3 + 0 * 8 = 50 Percentage score will be equal to 35 / 50 = 0.7 Please try this and confirm.
Mar 4, 2024
It automatically populates a 0 in the N/A field.
Mar 4, 2024
Hi Rose, you have already assigned 0 as the points for the "N/A" answer choice. In the Scorecery Edit page, click on the gear icon next to the first multiple choice question > Field settings page will be displayed > click Answer > delete 0 for the "N/A" answer choice and click Save. Repeat the steps for the other questions in the form.
Add your comment
Add photo