How to calculate the average score of multiple judges
Judges often score multiple judges. For the sake of fairness, the highest and lowest scores will be removed, and then the average of the remaining scores will be taken to obtain the final scores, how to remove the highest score and the lowest score to calculate the average value?
1. Design ideas
In the judge scoring table, multiple judge teachers score, in which the maximum and minimum values are taken out, and then written into the scoring information table through business association rules, take out the maximum and minimum values after each data submission in the scoring information table and compare the size, similar to bubble method.
2. Design steps
(1)First, design two forms
- A scoring information table: used to view the scoring results of members
- A judge scoring table: records each score and updates the latest score (through business association rules) to the scoring information table.
Form design
The current maximum and minimum values in the score information table are linked in the Judge score table.👇
(2)Data Linkage settings
Through data linkage, the maximum and minimum values of the submitted data can be linked in the scoring table.
Maximum and minimum data linkage values
(3)Formula editing
Calculated by formulaAfter the current scoreMaximum and minimum values and average scores.👇
- Maximum/minimum calculation
First, passFormula OneCompare the score of the current form with the previous maximum and minimum values.
Then passFormula 2AndFormula ThreeExtract the maximum and minimum values of the three values respectively, thus obtaining the maximum and minimum values after this score.
Formula calculation maximum and minimum
- Average calculation
The number of times that the current person has been evaluated is judged by the auxiliary field (the average score is calculated only when the submitted data is greater than or equal to 2, because the maximum and minimum values need to be subtracted, avoid negative numbers of submitted data), and finally use the total score plus the currently submitted score minus the maximum and minimum value to obtain the current average.
Average calculation
The data after this score can be modified by the business association formulaScoring information tableThe maximum/minimum value, the total score, and the average score update are used for subsequent data calls, so that the information in the scoring information table is always the latest data.👇
(4)Business Association rules-Modify or add data
If there is no scoring record of the member when the first judge scores, add a scoring data first; After the subsequent judges score, the latest maximum, minimum, the average value is updated to the score information table of the member. For more information about how to set business association rules, see:Introduction to Business Association formulas 」
Business Association formula
3. Effect demonstration
Add scoring records:Click Add
View rating results:Click View
Video demonstration of judge scoring table
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
