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