How to make great Excel gradebooks
Posted on September 3rd, 2009 by benignim
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
Discussion Area - Leave a Comment