Home/Spreadsheets/Special Ed & Teachers/Digital Gradebook for Teachers
Digital Gradebook for Teachers
A digital gradebook for teachers: type each score once, and weighted averages, letter grades, missing work and standards mastery calculate for every student. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Weighted categories or total points, up to 6 grading periods and up to 8 weighted categories
- Type points, M for missing (counts as 0) or EX for excused (left out); low scores, M and EX are color coded
- Averages tab: category averages, the weighted overall average and letter for any grading period or the full year, with a grade distribution chart
- Missing Work tab lists every missing assignment by student, with dates
- Standards mastery by student and standard, in bands you set
- Opens in Excel and in Google Sheets
$8.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- Weighted categories or total points, up to 6 grading periods and up to 8 weighted categories
- Type points, M for missing (counts as 0) or EX for excused (left out); low scores, M and EX are color coded
- Averages tab: category averages, the weighted overall average and letter for any grading period or the full year, with a grade distribution chart
- Missing Work tab lists every missing assignment by student, with dates
- Standards mastery by student and standard, in bands you set
- A one-page printable progress report for any student; roster of up to 40 students and 600 assignment slots
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Averages
- Scores
- Missing Work
- Progress Report
Works in
- Microsoft Excel 2016 or later and Microsoft 365, on Windows or Mac
- Google Sheets, free, in any browser, including on a Chromebook (a ready-made Sheets copy link is included)
- No macros, no add-ons
Honest scope
This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district documentation system — those stay your professional judgement.
Others in Special Ed & Teachers
- MTSS and RTI Small Group SchedulerAn MTSS and RTI small group scheduler: place students into tiered intervention blocks…$9.99View →
- School Nurse Health ManagerA school nurse health manager that keeps immunisations, screenings, health plans and…$13.99View →
- IEP Due Date Compliance CalendarEvery statutory clock on your caseload in one place — consent, evaluation, annual…$16.00View →
- IEP Goal TrackerAn IEP goal tracker for special education data collection and progress monitoring: one…$19.99View →
