Google Sheets Editable Gradebook

Be sure that you have an application to open
this file type before downloading and/or purchasing.

63 KB|1 page

Share

Product Description

There are sections for reading, writing, science, social studies, and math. You can add, rename, or delete tabs at the bottom. All except writing contain the same formulas. To use these tabs:

Enter first and last names of students (manually or copy/paste)
Manually type in and change names of quizzes/tests to fit your needs
Below where it says “quiz name” in the yellow row, is where you will enter the total possible points for a quiz/assignment. This will automatically tabulate into the total points and average for each student.
Enter students points earned for each quiz/assignment. This will automatically tabulate into a total for each student column, as well as a current average grade.
The nice thing about this is that it averages as you go, so at any given time, you can see each student’s average, based on the assignments you have entered.
Be careful not to type in the red columns, as this is where all of the formulas are.