Teacher Gradebook preview
Gradebook class matrix sheet with student rows, assessment columns for homework, quiz, project, midterm, and final, plus auto-calculated weighted percentage, letter grade, rank, and attendance fields. 1/4

About this teacher gradebook spreadsheet template

This teacher gradebook spreadsheet template provides a complete class tracking system with four interconnected sheets: a Gradebook class matrix for recording raw scores, an At-Risk Students review queue for intervention planning, a Class Dashboard for performance overview, and a Setup & Rubric sheet for configuring weights and grade thresholds.

The Gradebook sheet auto-calculates weighted percentages, letter grades, and class rank from raw assessment scores, while the attendance multiplier adjusts final results. The At-Risk sheet flags students needing support with reason, intervention, owner, and status fields for actionable follow-up.

Every cell, label, and threshold is fully editable in WPS Office, Microsoft Excel, or Google Sheets. Adjust assessment names, weight percentages, and grade cutoffs on the Setup sheet to match your course syllabus.

4 interconnected sheets

Gradebook, at-risk queue, dashboard, and rubric setup work together for complete class management.

Auto-calculated grades

Weighted percentages, letter grades, ranks, and attendance-adjusted scores update automatically.

At-risk student tracking

Built-in review queue with intervention planning, owner assignment, and status tracking.

Standard XLSX

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Teacher Gradebook template is designed for tracking student scores, calculating weighted grades, monitoring at-risk students, and viewing class performance dashboards. Customize the sample data, assessment columns, weight percentages, and grade thresholds in WPS Office for your own courses.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data and structure in a Notion database; for branded visual reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample student names, assessment labels, raw scores, weight percentages, and grade thresholds with your own course data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for corporate training scorecards, workshop assessments, team performance tracking, and educational data reporting. It is available for personal and commercial projects, subject to the applicable template license.