Best Free Excel Grade Tracking Workbooks For Teachers

Simple Excel Gradebook by Points

New, sleek, and simplified! Download here:
Excel 2007: Gradebook By Points | Gradebook By Percentage
Excel 2010: Gradebook By Points | Gradebook By Percentage

By Points sums all points earned and divides by total.
By Percentage is a weighted average across all assignments each out of 100%.

The newest Excel 2010 versions have premade sparkline distribution charts.
Gradebook Sparkline Histograms

What does it offer me?

*Warnings may show due to new Excel 2013 features. The workbooks are macro (code) free and are fully functional back to Excel 2007/2010.

Please like and share if this is helpful!

Excel Grade Tracker Distribution

On the left here is just one customizable graph. You can see distributions like this for any assignment. On the right is a sample grade printout. You are free to customize the printout how you would like.

Be Creative!

You can chart scores across gender, race, absences, or any other custom category.
  • Try a boys vs. girls challenge.
  • Use data to get $$ to help your low income minority students.
  • Show how showing up and doing work relates to outcomes.

Video Tutorial Help

Older Version with Mastery

Free Excel Grade Tracker

There is another older version (for Excel 2007+) that tracks both grades and mastery. Mastery is the percent of learning goals for which students have met standard. The links for the older version with mastery are at the bottom of this page.

What if I have some questions, concerns, or suggestions?

I love feedback and would be delighted to answer questions. Feel free to email me at jabbott(at)mit.edu.

Download:
Excel 2007: Gradebook By Points | Gradebook By Percentage
Excel 2010: Gradebook By Points | Gradebook By Percentage
Older Version with Mastery: Gradebook by Points



I value your privacy. You can read the story of this gradebook.

May 2013