📋Assessment Tracker
Track all assessments — quizzes, activities, projects, exams — with type, date, total points, weight, status, average score, and pass rate.
Why Teachers Need It
Teachers lose track of what they've assessed and when. This tracker gives you a complete inventory of every assessment given, with results summarized.
Key Benefits
- Assessment ID, Subject, Name, Type, Date, Total Points, Weight columns
- Assessment Type dropdown: Quiz, Activity, Project, Exam, Performance Task
- Status dropdown: Planned, Completed, Graded
- Average Score and Pass Rate columns for post-assessment analysis
How It Works
- 1Log each assessment when you give it.
- 2After grading, enter Average Score and Pass Rate.
- 3Use the Weight column to track how much each assessment contributes to the final grade.
Example Workflow
“You give Quiz 2 (20 points, 5% weight). After grading, you log it: Average Score = 14.2, Pass Rate = 75%. You notice the pass rate is lower than Quiz 1 (85%). You plan to review the most-missed questions in the next class.”
Pro Tips for Teachers
- •Log assessments right after grading while data is fresh
- •Compare pass rates across assessments to spot patterns
Frequently Asked Questions
Is this connected to the Gradebook?
The Assessment Tracker is a planning tool. The Gradebook is where actual scores live. Both can reference each other for a complete picture.
Related Navigation
Explore the full parent spreadsheet system or browse other teaching resources and interactive tools.