QuizScoreBoard

 If you run quizzes as either (or both) social events or fundraisers you might be interested in the Small Charity Support Quiz Score Board.

QuizBoard24Written in MS-Excel®, it can easily be adapted to suit your own particular event.
The spreadsheet includes an Instructions page to tell you how to do that.

The spreadsheet allows the scorers to keep an tally of the scores table-by-table, round-by-round with automatic calculation of accumulated scores to highlight which table is currently in the lead.
If your quiz includes double-points "Joker" rounds, it can automatically calculate and show those, too.

And if you have projection facilities, you can display the scoreboard for everyone to see how they are doing "in real time".

The updated (May'25) version of the spreadsheet now contains two alternative scoring schemes {illustrated right}.   And it has been extended to accommodate quiz events with up to 26 tables/teams and 12 quiz rounds plus 2 "marathon" rounds.   (If your events aren't that large the spreadsheet can easily be "scaled down" to the appropriate size.)

Scoreboard:   The Teams/Tables in columns and the Quiz Rounds in rows with the highest-scoring table highlighted at the bottom:

Leaderboard:   The Quiz Rounds in columns and the Teams/Tables in rows with the highest scoring table highlighted next to its name.

Both version now include the facility to auto-sort the Teams/Tables in descending order by their scores at the end of each Quiz Round - putting the highest scoring tables left-to-right in the Scoreboard and and top-to-bottom in the Leaderboard.

To download and try-out the spreadsheet, just click on its image (above-right) and take it from there.
Note: to reduce the risk of "clumsy fingers" creating inadvertent errors while scoring, many of the cells in the spreadsheets are password-locked.   To use the spreadsheet, please e-mail This email address is being protected from spambots. You need JavaScript enabled to view it. to request the password.


BiDirSwitchTip:   Does your QuizMaster project the questions onto a screen?   If so, to avoid having 2 projectors (or fiddling to switch cables to display the scores) why not invest in the modest cost (<£10) of a simple bi-directional HMDI swith (like the one illustrated) to allow both the questions and scorer laptops to be connected to the same projector.   The scorer can then be entering the scores while the quizmaster is displaying the next quiz round.   Then, with the flick of a switch, display the scores between rounds.

 

CC CopyrightPlease note that the spreadsheet is copyright (C) 2017-25, Small Charity Support
Charities and voluntary community organisations are welcome to use the spreadsheet royalty-free for their own internal quiz events, provided that the copyright notice (bottom left-hand cells) remains unchanged.   But it may NOT be used or adapted commercially, eg: by professional quiz masters or event managers charging for their services.