Your Cart
Loading

Teacher Gradebook & Attendance Tracker Spreadsheet – Weighted Grades, Attendance % (Excel + Google Sheets)

On Sale
£2.99
£2.99
Added to cart

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.

You will get a ZIP (71KB) file