The ICT GIG has created an Excel file to allow you and your co-teachers to keep track of students’ grades quickly and easily. There are two potential versions for you to use: a simple sheet that simply totals up all of your students’ scores on everything, and a more complex version that allows you to put different weight on homework, quizzes or tests. This guide is meant to help you understand how to use either version.

For your online reading ease, we have broken up the guide into three sections:

• Simple Gradesheet explains our most basic spreadsheet, for folks looking just to track total points earned.
• Advanced Gradesheet explains the version of our spreadsheet designed to let you weight different kinds of grades (e.g. homework, quizzes, and tests) as different percentages of the overall grade.
• Gradesheet Tips offers further advice on how to modify your sheets, including formatting ideas and an explanation of how to keep track of the grades from multiple classes in one file.

In case you would like to read the guide offline, it is bundled with the actual spreadsheets in the .zip file attached to this page.