Tabulation and Awards

Tabulation: You can download the tab template by clicking the file called Debate tab template in the attachment area below. You need a computer with a printer and the program Excel. Ideally you want at least two people in the tab room, one to read scores and the other to enter. They must be reliable, careful and trustworthy. They should not discuss the scores with anyone other than the organizer. After the scoresheets are entered, they are photocopied and sorted so that one copy can be given to each school at the conclusion of the tournament after the awards. If you do not have time to photocopy the results during the tournament, you can mail them out later but it saves work and is more popular to give the scoresheets out on the night of the tournament. A template for the tabulation can be downloaded below. On this template the Tab room workers enter whether the team is novice/open in column A, the school name in column C, the team code in column D, and the student names in column E. They then enter the scores from each judge in each round scores from the scoresheets are entered into the appropriate columns (L to P for round 1, Q to U for round 2, etc.). If you have only 1 judge you only need to enter 1 score for that round; the computer will ignore the blank cells. The 0's in the first cell are just there to avoid getting an error message and they will be replaced as you enter the scores. The total team scores, total individual scores and averages for each round are calculated automatically. Save the results after each round under a different file name. After you have entered all of the data you can sort the spreadsheet by the appropriate columns to determine the top individuals, the top teams and the top person from each school. Be certain to save before doing this, and then afterwards.

Awards: In Manitoba we provide 1 medal to the top person from each school that participates as well as medals for the top several speakers and the top several teams -- how many depends on your budget for medals but the more the better as a general rule. In order to spread out the medals, we normally don't award more than 1 medal per student at any one tournament; we usually just announce their position if they earn any award after their first medal, although that can take longer to calculate. If the tournament has both open and novice categories, novice and open are ranked separately. If a school enters both novice and open debaters, the award for the top student from that school is always presented to the top open student from that school even if a novice student has a higher score.