 |
| Right-click to download this file |
- Each team's total marks based on the rounds so far
- The current top score
- Based on colour-coding, the teams with the top and bottom total scores:
Red cells are the highest scores
Green ones are the lowest
The colour coding is updated automatically each time you enter more marks form a quiz-round.
What does the table-quiz scoreboard spreadsheet look like?
 |
An empty quiz-marking score tracker spreadsheet |
How to use the file
- Download the Excel file from the top of this page (right click on the picture, and choose save-link-as, or similar)
- Save it to your computer
- Add more columns (see below), if you have more than ten rounds in your quiz.
- When the teams have registered, enter them into the Table Name column.
- Add more rows (see below), if you have more than 15 teams entered.
- After each round, the markers or marking-co-ordinator enters the score for each team - and the formulas will calculate automatically.
How to add more teams to the spreadsheet
If your table-quiz has more than 10 teams taking part, then:- Select the number of rows that you need to add, somewhere in between the current rows 2 and 14.
- Right-click with your mouse on the selected area
- Choose Insert from the pop-up menu
- Type the names of the extra teams into column B
How to add more question-rounds to the spreadsheet
If your table-quiz has more than 10 rounds of questions then:- Select the number of columns that you need to add (one per extra round), somewhere in between the current columns D and K.
- Right-click with your mouse on the selected area
- Choose Insert from the pop-up menu
- Type the numbers of the extra rounds into row 2
