Understanding an Award Nominee's Score

One of the significant enhancements made to Awards in 7.5.2 is that scoring questions can be defined for reviewers. Therefore, staff and award administrators need to be able to view a nominee’s total, average, and median scores, in addition to total score. Fields in the Awd_Nominee table track average score, median score, and total score.

A nominee's average score and median score will be updated when a reviewer submits a review of the nominee in final by answering scoring questions via the online award nomination review process or by manually entering a Total Score in the back office. For more information, please see Reviewing an Award Nomination Reviewer's Score.

The Numeric Value field for the subcodes of the codes defined for the non-fixed AWD "SCORING_ANSWER" system type is used to determine the numeric value for each subcode. This numeric value is used in the calculation of a nominee's score.

A nominee's total score will be updated when a reviewer manually adds a score for a nominee. For more information, please see Recording Award Nomination Reviewer's Scores.

The table below describes each score in detail.

Screen Element	Table.FIELD Name	Validations	Edit Rules and Action
Score (total score)	Awd_Nominee.TOTAL_SCORE	This is calculated and set each time a score is manually entered for a nominee for the award by a reviewer. The total score is the sum of all score values for the nominee for the award.	If the award is using scoring questions, the user does not edit this score; this is calculated and set by the system each time a reviewer submits a score. This is read-only. For more information, please see Reviewing an Award Nomination Reviewer's Score. If the award is not using scoring questions, the total score can be entered manually. For more information, please see Recording Award Nomination Reviewer's Scores.
Avg Score (average score)	Awd_Nominee.AVERAGE_SCORE	This is calculated and set each time a review for the nominee for the award is saved, assuming that App_Subcode.OPTION_1 for Awd_Reviewer_Scoring. SCORING_ANSWER_ SUBCODE has numeric score values. The average score is calculated by adding the average scores of all reviewers and dividing by the number of reviewers (this will get the average of the averages).	User does not edit this value; this is calculated and set by the system each time a reviewer submits a score. This is read-only. For more information, please see Reviewing an Award Nomination Reviewer's Score.
Med Score (median score)	Awd_Nominee.MEDIAN_SCORE	This is calculated and set each time a review for the nominee for the award is saved, assuming that the Numeric Value field for the subcodes of the codes defined for the non-fixed AWD "SCORING_ANSWER" system type has numeric score values. The median score is calculated by ordering all scores sequentially from lowest to highest and then selecting the middle value, if there is an odd number of scores. If there is an even number of scores, the middle two scores are averaged. To calculate the nominee’s median score if there are multiple reviewers, the median score for each reviewer will be ordered, and the middle value is selected if there is an odd number of values. If there is an even number of values, the middle two scores are selected and averaged. This will get the median of the medians.	User does not edit this value; this is calculated and set by the system each time a reviewer submits a score. This is read-only. For more information, please see Reviewing an Award Nomination Reviewer's Score.

Screen Element

Table.FIELD Name

Validations

Edit Rules and Action

Score (total score)

Awd_Nominee.TOTAL_SCORE

This is calculated and set each time a score is manually entered for a nominee for the award by a reviewer. The total score is the sum of all score values for the nominee for the award.

If the award is using scoring questions, the user does not edit this score; this is calculated and set by the system each time a reviewer submits a score. This is read-only. For more information, please see Reviewing an Award Nomination Reviewer's Score.

If the award is not using scoring questions, the total score can be entered manually. For more information, please see Recording Award Nomination Reviewer's Scores.

Avg Score (average score)

Awd_Nominee.AVERAGE_SCORE

This is calculated and set each time a review for the nominee for the award is saved, assuming that App_Subcode.OPTION_1 for Awd_Reviewer_Scoring. SCORING_ANSWER_ SUBCODE has numeric score values. The average score is calculated by adding the average scores of all reviewers and dividing by the number of reviewers (this will get the average of the averages).

User does not edit this value; this is calculated and set by the system each time a reviewer submits a score. This is read-only. For more information, please see Reviewing an Award Nomination Reviewer's Score.

Med Score (median score)

Awd_Nominee.MEDIAN_SCORE

This is calculated and set each time a review for the nominee for the award is saved, assuming that the Numeric Value field for the subcodes of the codes defined for the non-fixed AWD "SCORING_ANSWER" system type has numeric score values. The median score is calculated by ordering all scores sequentially from lowest to highest and then selecting the middle value, if there is an odd number of scores. If there is an even number of scores, the middle two scores are averaged. To calculate the nominee’s median score if there are multiple reviewers, the median score for each reviewer will be ordered, and the middle value is selected if there is an odd number of values. If there is an even number of values, the middle two scores are selected and averaged. This will get the median of the medians.