Get unlimited access to 5000+ Templates for Google Docs, Slides and Sheets
Unlimited Access
ADVERTISEMENT
ADVERTISEMENT

Black and White Gradebook Template

Use this free template with Google Sheets and Microsoft Excel

4.47 (2 reviews)
Last updated Updated August 8, 2026
Created by Evelyn Stewart
ADVERTISEMENT

Template Specification

Format Google Sheets
Created November 5, 2021
Last Updated August 8, 2026
Community Added to collections by 2 Users
Usage Stats 3 downloads this month

Key Features of This Template

Suitable For Teachers

About this template

Use our simple and convenient Black and White Gradebook Template for free. This layout features a clean design divided into several clear sections. Built-in formulas automatically calculate final grades for the year based on the marks you enter for each assignment. Simply fill out this Excel and Google Sheets gradebook template to get accurate data for every student.

Download the Automated Gradebook

In the template header, you can enter the course name, instructor, room, and time. You can also give the table a specific title. The main section is designed to accommodate up to 30 students, with the option to expand it as needed. You can enter up to 15 midterm grades, which are then used to calculate each student's average.

Use this template’s convenient features:

  • Each assignment can be assigned a grade as a percentage of the total for the class.
  • The grading scale is fully customizable based on your school’s specific requirements.
  • Each student will receive a calculated total score, a percentage, and a final grade from A+ to F.

Save time with this easy-to-use template! Get your free copy and start filling it out today.

ADVERTISEMENT
Free Template

Download Free Template

Choose your platform and start editing right away
PLATFORM

Google Sheets

Opens in browser
PAPER SIZE
US Letter
Google Sheets – US Letter
Duplicate to Google Classroom
No account required • Attribution required

WHAT’S INCLUDED

Automatic grade calculations formula
Customizable grading scale section
Separate columns for assignments
Space for 30 students

Gradebook Tips

1
Update grades immediately after each assignment.
2
Customize the grading scale for specific needs.
3
Regularly check class averages for insights.
4
Use conditional formatting for grade visualization.

FAQ

Is this template compatible with my software? Yes, it works with Google Sheets and Microsoft Excel.
Is the template easy to use? Yes, it features a simple and intuitive layout.
Can I customize the template? Absolutely, you can adjust grading scales and more.
Is this template free to download? Yes, it is entirely free to use.
How do the automatic calculations work? Built-in formulas compute totals and averages automatically.
ADVERTISEMENT

How to Use and Edit This Template

Get Your Document
1

Get Your Document

Click the "Edit Template" button to create your own editable copy in Google Sheets or download for Microsoft Excel
Customize Everything
2

Customize Everything

Easily change colors, fonts, and layouts to match your unique style or brand identity
Add Your Content
3

Add Your Content

Fill in your data, upload images, and replace the placeholder text with your own information
Print, Export, or Share
4

Print, Export, or Share

Print, export as PDF, or share instantly

Related Templates

Recently Viewed