This free Editable Gradebook Template for Excel started out as a very basic grade book spreadsheet. It has evolved into something that is very useful, flexible, and powerful (and still free). We now have a few different types of grade books that can handle most of the major grading systems used in high school and colleges.
For new teachers: I’ve included a lot of information on this page about how to use the grade book. There are some details that I wish I would have known my first time.
Some of the features that make this template particularly useful are the ability to mark excused assignments, hide/show names or IDs, apply different weighting to homework and exams, apply a simple curve to the final grades, and make adjustments to the grading scale. In addition, because the gradebook is in Excel rather than an online gradebook system, you can add cell comments and format cells to highlight specific grades.
Different types of student Grading System or Grading Program?
Percentage System – also a university grading system or grading in colleges
This system is commonly use in high schools and for courses that involve more subjective grading like art and literature. On each assignment, the grade records as a percentage. The percentage might be a calculation, such as earning 25 out of 30 points. Or, the percentage might record based on performance or a subjective letter grade. The nice thing about this system is that you can use whatever method makes sense for a particular assignment. If you are unsure what template to use, I would suggest using the percentage-based version.
Weighting Factors vs. Points: If you use total points for the weighting factors, then the percentage system is almost exactly the same as the point-based system, except that you are recording grades as percentages, and doing the calculations for each assignment by hand.
Converting Letter Grades to Percentages: The grading scale is used to define the minimums for each grade. However, when recording an “A-” you would reference a different conversion chart. For example, instead of recording an A- as a 90% (the minimum), you might record it as a 92%.
Extra Credit – Giving extra credit using this system requires assigning the extra credit to specific assignments.
Gradebook Template : Point System for Schools
In this version, the grading scale is percentage-based (A>=90%, B>=80%, etc.), but in the Gradebook worksheet you enter the number of points earned on each assignment or exam.
Extra Credit: The values listed in the Points row in the Gradebook worksheet do not necessarily represent “maximum possible” points. For an extra credit assignment, you would enter a “0” in the Points row. Or, if you allow extra credit on a specific assignment, the student might earn a higher score than the one listed in the Points row.
