Teacher Gradebook Spreadsheet, Weighted Grade Calculator, Class Tracker, Teacher Grade Book, Classroom Gradebook, Excel Google Sheets

Teacher Gradebook Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Grade faster and more accurately with this easy Teacher Gradebook. Enter points earned and it calculates category averages, weighted grades, letter grades and missing work for every student, with a class dashboard to spot who needs help. Perfect for middle and high school teachers. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • Clickable Start Here cover page with quick-start steps and a color key (yellow = you type, white = calculated) • Class Dashboard with a Show class drop-down (all classes or one period): students, class average with letter, class GPA, passing rate, at risk, excelling, missing work, late submissions, attendance rate, chronic absence, assignments graded and due in the next 7 days (12 KPI tiles) • 4 dashboard charts: grade distribution (A-F), category averages, last 10 assignment averages and attendance breakdown, plus Students Needing Attention, Top Performers, Coming Up and Alerts panels • Grades: one score grid for up to 200 students x 80 assignments. Type points, M for missing (counts as 0) or EX to excuse. Missing, excused, low scores and bonus points color themselves, and assignments that don't apply to a student's class turn grey • Report: every student's category %, weighted grade, letter, GPA, missing and late counts, attendance, rank in class and status (At risk, Missing work, Attendance, On track, Excelling) • Progress Report: pick a student for a printable report with grades by category vs class average (with chart), attendance, standards mastery, every assignment with score and status, teacher comment and a signature line • Students roster: class period, student ID, support plan, guardian name, email and phone, progress report comment, with grade, missing work, attendance and status filled in automatically • Assignments (80 rows): category, standard, applies to (all classes or one period), dates and points, with scored, missing, late and excused counts, high %, low %, average % and status (Upcoming, To grade, Partly graded, Graded) • Attendance: P / A / T / E for 90 school days, dates built from your term dates (skipping holidays), totals and attendance rate per student, today's column highlighted • Late Work log (200 rows): days late and late penalty worked out from your rules and taken off the grade automatically, with waive option and status • Class Stats: compare up to 8 periods side by side (average, high, low, A-F spread, at risk, missing, late, attendance, GPA), category average by class, assignment average by class and 2 charts • Standards: up to 16 standards or skills with class average, Mastered / Proficient / Developing / Beginning counts, % proficient and chart, filterable by class • Mastery grid: every student's % on every standard