This is a spreadsheet-based program that helps you keep track of grades. The most important feature is the ability to print a student summary for each student in a class. The summary sheet includes current grade, a list of all assignment scores to-date (up to 35), with a description, and a list of all quiz scores also with a description. The spreadsheet calculates the average grade needed on all remaining tests to get a grade of A, B, C, and D and reports it. For this calculation, it uses one of the following policies (as determined by instructor): Drop lowest test score, Replace lowest test score with final exam score, or Every test counts.
This is a work-in-progress, but it is in good shape right now. Please contact me if you are considering using it. I would like to give some suggestions, and I'd like feedback on how it's working for you.
Download the Grade Template Spreadsheet here.