Best Free Excel Grade Tracking Workbooks For Teachers

Simple Excel Gradebook by Points

Recently redesigned for extra simplicity and ease of use. Get the gradebook:
Assessment Types - Points Directly - Points
Assessment Types - Percents Directly - Percents

Assessment Types has fixed percentages for all the homeworks, classworks, tests, etc
Directly has all assignments directly go towards the running average
By Points assignments each out of so many points; more points = bigger weight
By Percents assignments each out of 100%; you can still weight assignments

With the gradebook you can:

For Windows Excel 2007+ or Mac Excel 2011+. The pretty sparkline charts show in Excel 2010+.

If using Excel online: colors may appear off till Microsoft supports conditional formatting with formulas. You can disable colors on the options sheet. -Noted March 2020

Please like and share if this is helpful!

The workbooks are macro (code) free. You can safely ignore "formula references blank cells" warnings.

Charts and Grade Distributions

Easily graph distributions and chart scores. There's a prebuilt distribution for the overall running average:

Grade Distribution in Excel

The Printouts

The gradebooks have an easy-to-customize printout you can print for everyone or just one student. See video directions. Simple, Customizable, Gradebook Printouts in Excel

Be Creative!

You can chart scores across gender, race, absences, or any other custom category.

Video Tutorial Help

See older versions

I value your privacy. You can read the story of this gradebook. License. Last updated: July 2015.