Enter the weight you want each assignment to carry, and then the score each student achieved as a percentage - everything else calculates for you. Statistics include class mean, median and standard deviation, as well as a cumulative numerical and letter grade. Excel 2003 or later.
With a sheet for each subject, you can manage grades for the whole class all year long with this spreadsheet. You can customize how much weight each assignment carries - grades, mean, standard deviation and class average calculate automatically. Excel 2003 or later.
If you accept the occasional late assignment from a student, this spreadsheet tracks who has turned in each assignment. It still serves as a full-function gradebook, calculating cumulative student GPAs as the semester progresses. Excel 2003 or later.
This spreadsheet allows you to customize each assignment with a title, due date and weight. Each student's cumulative course grade calculates for you in a clean, no-frills style. Excel 2007 or later.
If your class requires several scores to calculate a final grade, check out this sheet first. You can calculate averages for different areas such as class participation and labwork, and then have the final grade tallied before your eyes. Excel 2003 or later.
This spreadsheet looks as impressive as it works and includes clear instructions. Enter each student's grade, and it instantly calculates the students current letter and numerical grade in the course. Excel 2007 or later.
Perfect for a class that requires daily homework. This spreadsheet has both a homework and exam section for each student, allowing the teacher to calculate the course average daily. Excel 2003 or later.
