Table quiz score-tracking spreadsheet

Right-click to
download this file

This is an Excel file that you can use to keep record each team's marks and the overall scores during a table-quiz. It shows:

• 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

Find quiz topic and question ideas, using Google Trends

A great way to choose topics for a table quiz is to look at what people are interested in. And in the internet-age, you can work this out from what people are searching for.

Google Trends monthly popularity charts show you what people have been searching for - and so probably what wil be good quiz topics.

Their charts are broken down into categories eg scientists, cars, movies, songs, people, animals, chemical elements and more.  They are updated monthly and go back to 2004.

To see the monthly popularity charts Google Trends by clicking here and choosing the 'Top Charts' link on the left-hand side.

Look at the categories to get ideas for quiz-round themes, and the things that are searched for for individual questions.

Note: At the moment, these charts are based on what people in the United States are searching for. If the people taking part in your quiz are not from the United States, then you should check whether the suggested topics really do work for your country: many of them will, but some may not make sense.