Teacher Gradebook & Attendance Tracker Spreadsheet – Weighted Grades, Attendance % (Excel + Google Sheets)
Marks, grades and attendance for one class in one simple spreadsheet.
What's inside:
Settings: up to 40 students, up to 20 assessments with max mark and weight, and editable grade boundaries
Marks log: student, assessment and mark; the % is worked out
Attendance log: Present, Late, Absent or Authorised absence
Dashboard: weighted average, grade, marks entered, attendance %, lates and absences for every student, plus class averages
What you get:
Teacher-Gradebook-and-Attendance-Tracker.xlsx – the blank gradebook
Teacher-Gradebook-and-Attendance-Tracker-EXAMPLE.xlsx – filled with made-up example data
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
This file will hold student data: keep it secure and follow your school's data policy.
This is a digital download. No physical item will be shipped. For use by one teacher.