Grade Book (Color-Coded) | Excel Sheet | Automatic Tally with Grades and %

A completely editable and color-coded Excel spreadsheet where you can keep track of all your students assignments and assessments. It automatically tallies all of the scores and it gives you the final points, the percentage (%) they achieved, as well as the grade.

You get:

6 sheets inside of the excel book. Each sheet is divided into quarters, terms (semesters) and one final table for the entire year. In each quarter the points are automatically summed up for each of the major categories; as well as the total score for that quarter. These categories are:

--Assignments (class work and homework)

--Assessments (projects)

--Quizzes

--Tests

--Journal

--PBL

You can change the names of the categories to whatever suits your needs the best.

You can track the scores of up to 35 students per section; up to 6 sections at a time. With enough space to tally over 100 assignments through the academic year.

In addition, at the bottom of each column you get a breakdown of that assignment's mean, median, mode, and range.

If you have any questions feel free to contact me and I will do my best to get back to you as soon as I can.

Copyright 2018, MiraBer's Corner. All rights reserved by the author.