Class Attendance Sheet
Sheets + Excel4 slides
Free
- Type
- Spreadsheet
- Price
- Free
- Slides
- 4
- Style
- Friendly
- Difficulty
- Beginner
- Updated
- November 6, 2026
Every slide (4)
Overview
This template tracks marks across several courses. The Assignments tab has one row for each piece of work, with its course, weight, score and maximum mark. The percent and weighted columns are worked out for you. The Grade scale tab holds the grade bands used for the GPA.
The Dashboard shows the overall average, the GPA, the number of assignments graded and the lowest result, with a chart of the weighted average by course. It comes with sample data. Make a copy, then replace the sample rows. Formulas and charts update on their own.
Useful for
- Keeping track of marks across a school term
- Working out what score is needed on the final assignment
- Checking the weighted average for each course before a report
What's included
- 4 tabs: Dashboard, Assignments, Grade scale, How to use
- Dashboard: a dashboard with 4 summary figures
- Assignments: a table
- Grade scale: a table
- 1 chart that update as you type
- Formulas, dropdowns and colour rules already set up
- Sample rows that show how to fill it in
How to use it
- 1
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
- 2
Start on the Assignments tab: replace the sample rows with your own.
- 3
Keep the formula columns as they are; they fill in as you type.
- 4
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
What you need
Requirements
- A Google account, or Microsoft Excel for the download
Works with
- Google Sheets
- Microsoft Excel (download the .xlsx)
Questions
Is this Grade Tracker template free?
Yes. Download the template and use it in Google Sheets or Excel at no cost.
Does it work in Excel?
Yes. Download the .xlsx file to open it in Excel. The formulas and charts work in both Excel and Google Sheets.
Is the GPA my school's official grade?
No. It is a simple guide based on the grade bands you set on the Grade scale tab. Use your school's own rules for official results.
- #grade-tracker
- #grade-tracker
- #google-sheets
- #excel
- #spreadsheet-template
- #free-template
Related templates
Job Application Tracker
Sheets + Excel4 slides
Free
Study Planner
Sheets + Excel5 slides
Free
