Seth Anderson just turned me on to this great link from Penn State. This page gives you all the formulas you would need to make a great and effective gradebook using Excel. Some of the examples it covers are:
- Summing Up Scores
- Calculating a Numeric Percentage
- Convert Numeric Percentage to Letter Grades
- Weighting Assignments by Points
- Weighting Assignments by Percentage
- Dropping Lowest Score
- Dropping the Lowest Two (or More) Scores
- Keeping the Highest Score
- Keeping the Highest Two (or More) Scores
- Maintaining a Running Grade