Panel Score Sheets: Totals, Averages and Missing Marks
This lesson is part of the course
In this lesson
You total and average the marks of a five-judge panel, see why a total is unfair when a mark is missing, count the missing marks per entry with COUNT and find all gaps in the sheet before results are announced.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Panel Score Sheets: Totals, Averages and Missing Marks Locked
- Dropping the Highest and Lowest Mark: Trimmed Totals, Trimmed Means and New Ranks Locked
- Weighted Criteria: Weights That Add Up to 100 % and a SUMPRODUCT Score Locked
- Strict and Generous Judges: Judge Averages, Centred Scores and z-Scores Locked
- Penalties and Deductions: Time Overruns, Rule Points and Net Scores Locked
- Ranks and Tie-Breaks: RANK.EQ, a Secondary Criterion and a Tie Check Locked
- Categories and Leaderboards: Winners per Category and a Top-3 List Locked
- Judge Consistency Check and the Final Results Chart Locked