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

Black and White Gradebook Template

Use this free template with Google Sheets and Microsoft Excel

4.47 (2 reviews)
Last updated Updated May 16, 2026
Created by Evelyn Stewart
ADVERTISEMENT
ADVERTISEMENT

Template Specification

Format Google Sheets
Created November 5, 2021
Last Updated May 16, 2026
Community Added to collections by 2 Users
Usage Stats 0 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
Edit in Google Sheets
Add to Google Classroom
No account required • Attribution required
Customize text, images, and colors
Print-ready for home or office
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