Learning Technology Services (formerly Faculty Support Centre)

Gradebooks with Excel Resources

Gradebook Template (Excel)
Gradebook Tutorial: step-by-step instructions on how to use the gradebook template.

Microsoft Template Gallery for Teachers
Contains the following Access & Excel templates (free download):
Gradebook & instructional database (requires Access 2000 or later)
Gradebook for a class based on averages (Excel)
Gradebook for a class based on percentages (Excel)
Gradebook for a class based on points (Excel)
CollegeOffice Gradebook Program (works with Office 97 & 2000)
Developed by college teachers for college teachers, "College Office is a gradebook program that will help you record scores, calculate grades, and print reports. It uses a Microsoft Excel workbook to let you enter scores and comments in a familiar manner. It stores all data that you enter in a Microsoft Access database. This backend database engine keeps all data well organized and generates the reports. From the typical user's viewpoint, the database remains completely hidden and everything appears as if it is stored in a well-formatted spreadsheet workbook."

Excel for Grade Management Part One and Part Two (Tor Gross, UC Davis)
A comprehensive, step-by-step tutorial with lots of illustrations.
Excel Tutorials from Microsoft in Education
Select "Excel" from the Product menu to search for Excel tutorials, or go directly to the following pages:
- Managing Grades with Excel 2002
- Analyzing Data Using Excel 2002 Tutorial

Excel Gradebook: Other Helpful Calculations (U. of Wisconsin-Eau Claire)
Includes calculating average, medium, maximum, and minimum; dropping the lowest score; finding averages.