Scoring Competitions & Awards in Excel: Judges' Panels, Dropping High & Low, Weighted Criteria, Judge Normalisation & Tie-Breaks
Run the score sheet for a baking contest, dance show, science fair or award: judges' marks, dropped extremes, weighted criteria, fair adjustments for strict judges, penalties and clean tie-breaks, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs the score sheets of a fictional village fair – a baking contest, a dance showcase and a science fair – in a spreadsheet. You total and average a judges' panel and find missing marks with COUNT and COUNTA, drop the highest and lowest mark with SUM, MAX and MIN, score weighted criteria with SUMPRODUCT, measure strict and generous judges with AVERAGEIFS and STDEV.S and turn marks into z-scores, apply time and rule penalties with ROUNDUP and MAX, rank entries and break ties with RANK.EQ and a secondary criterion, find category winners with MAXIFS and LARGE, and highlight inconsistent marks before charting the final results.
Lessons
- Panel Score Sheets: Totals, Averages and Missing Marks Pro
- Dropping the Highest and Lowest Mark: Trimmed Totals, Trimmed Means and New Ranks Pro
- Weighted Criteria: Weights That Add Up to 100 % and a SUMPRODUCT Score Pro
- Strict and Generous Judges: Judge Averages, Centred Scores and z-Scores Pro
- Penalties and Deductions: Time Overruns, Rule Points and Net Scores Pro
- Ranks and Tie-Breaks: RANK.EQ, a Secondary Criterion and a Tie Check Pro
- Categories and Leaderboards: Winners per Category and a Top-3 List Pro
- Judge Consistency Check and the Final Results Chart Pro