Score calculation in forms
- Annu
In UpRaise templates, there are a few questions types those can have scores associated with them. Also, if you add section wise questions in the template, you can associate scores these sections to have section wise scores. Calculation in both the cases is different. Details & examples are as below.
Score calculation without sections
In the below image, you can notice all questions have weightage of 5 and the score for first three questions is 6,8 & 3 respectively.
Weightage comes into picture when the average score at the form level is being calculated.
Actual obtained scores
At the top score is 5.67/8.33.
Calculation of this score - sum of (weightage for respective question multiplied by the corresponding score received) / total weightage of all scored questions
30(weightage: 5 * actual score:6) + 40(weightage:5 * actual score: 8) + 15(weightage:5 * actual score: 3)
= 85 / 15 (total weightage: 5+5+5) = 5.67.
Actual possible scores
Whereas the possible scope of obtaining score in this form for was 8.33 (this will be shown on view responses page and my forms page in scores column)
Calculation of these possible scores will be - sum of (weightage of each question multiplied by corresponding maximum possible score) / total weightage of all scored questions
50(weightage: 5 x score:10) + 50(weightage:5 x score: 10) + 25(weightage:5 x score: 5)
= 125 / 15 (total weightage: 5+5+5) = 8.33
So the bottom line is, in the below example reviewer obtained a score of 5.67 out of maximum possible 8.33
Score calculation with sections
UpRaise allows you to create a section-wise weighted form. Each section can be associated with scores, also questions (Star rating, Multiple choice, Opinion scale, Drop-down) within section can also be associated with score. Let us see how does this scoring work.
While creating a template, you can associate scores & weightage with the sections & questions. Default weightage of these scorable sections & questions is of and you can change it between 0-10 as required. Since the weightage is relative, the section/question with weightage 10 will carry double importance as compared to the section/questions with weightage 5, on the final score calculation at the form level.
Calculation of score
In section wise weighted forms, scores are calculated twice -
Score calculation of individual section - reflected in the form in front of each section
Aggregated score of all sections as final score of the form - reflected on my forms page and view responses page.
Score calculation of an individual section
Score calculation of the each individual section happens based on the selected answers as response and the weightage of questions in that section. For example, in start rating question, if user selects one star then the score will be 1, if user selects 2 stars as his answer then the score will 2 and so on. And then it will be multiplied with the assigned weightage of the question.
In the image above there are three sections. Recruitment section has 3 questions. Question Decision section is not associated with score. And the last section, Convenience has 2 questions. All these questions & sections carry weightage of 5. Weightage of questions is considered at the time of average score calculation of the section whereas weightage of sections is considered for final score of the form.
In the image above, it is shown that the team member has obtained 5 as score in Recruitment section & 3 in Convenience section.
Calculation of score at section level (formula) - sum of (weightage for respective question multiplied by corresponding score received) / total weightage of all scored questions
Score of Recruitment section -
40(weightage: 5 x score: 8) + 15(weightage: 5 x score: 3) + 20 (weightage: 5 x score: 4)
= 75 / 15 (total weightage: 5+5+5) = 5
Score of Convenience section -
40(weightage: 5 x score: 8)
= 40 / 5 (total weightage: 5) = 5
In this way, each section's score is calculated and then reflected in front of the section title.
Aggregated score of all sections as final score of the form
Now let us see how the final score of all sections is calculated and reflected as the final score of the users involved in the form.
There are two steps when the aggregate score of all sections is calculated. The system calculates possible scores and actual scores of each section and then it retrieves the final actual and possible score of the form. Check the top highlighted part of the image above (Total score). Actual score 6.5/ possible score 8. Below is the example of this calculation.
Actual obtained scores
While calculating actual scores system considers the obtained score in the question that is based on slected option as answer.
Step 1- In step one system calculates actual score of each section
Actual Section wise score (formula) - sum of (weightage for respective question multiplied by the corresponding score received) / total weightage of all scored questions
Recruitment section -
40(weightage: 5 x score: 8) + 15(weightage: 5 x score: 3) + 20 (weightage: 5 x score: 4)
= 75 / 15 (total weightage: 5+5+5) = 5
Convenience section -
40(weightage: 5 x score: 8)
= 40 / 5 (total weightage: 5) = 5
Step 2 - In step two system calculates the actual aggregate score from all sections.
Actual aggregate score of all scored sections (formula) - sum of (weightage for respective section multiplied by the corresponding score received) / total weightage of all scored sections
Actual aggregate score of all scored sections -
25(weightage of section: 5 x score: 5) + 40(weightage of section: 5 x score: 8)
= 65/10 (total weightage of all sections: 5+5) = 6.5
Possible scores
While calculating possible scores system considers the maximum possible score in the question that is last option in the answer/choices given
Step 1- In step one system calculates possible score of each section
Calculation of these possible scores (formula) - sum of (weightage of each question multiplied by corresponding maximum possible score) / total weightage of all scored questions
Recruitment section -
50(weightage: 5 x score: 10) + 15(weightage: 5 x score: 3) + 25(weightage:5 x score: 5)
= 90 (50+15+25) / 15 (total weightage: 5+5+5) = 6
Convenience section -
50(weightage: 5 x score: 10)
= 50 / 5 (total weightage: 5) = 10
Step 2 - In step two system calculates the possible aggregate score from all sections.
Possible aggregate score of all scored sections (formula) - sum of (weightage of each section multiplied by corresponding maximum possible score) / total weightage of all scored section
Possible aggregate score of all scored sections -
30 (weightage of section: 5 x score of section: 6) + 50 (weightage of section: 5 x score of section: 10)
= 80 (30+50)/10 (total weightage of all sections: 5+5) = 8
You can refer these scores to compare performance of two different users. You will be able to see these scores in reports, on my form page and on view responses page along with maximum possible scores that can be achieved in the distributed form.
Other related readings