Can I choose the rounding rule for the average grade?

Yes. On the "Class" sheet you set the round-up threshold: 0.5 gives standard mathematical rounding and 0.6 is stricter. The spreadsheet only suggests a grade; the final decision stays with the teacher.

How do I mark absences?

In the student's cell under the lesson date, choose the letter "A" from the list. It is not included in the average grade but is counted in absences and in the attendance percentage.

How many students and lessons fit?

Up to 35 students and up to 40 lesson dates in one file. If there are more lessons, enter only the dates with grades and absences, or keep a separate file for each half-year.

How do I keep several subjects?

One file is one subject in one class. For another subject, save a copy of the file, change the subject and enter the new grades.

← All templates

Teacher's Class Grade Book — Excel Template

A teacher's personal grade book in Excel: grades 2–5 and absences, average grade, suggested term and year grades, attendance, knowledge quality and class pass rate.

≈ $3.59

290 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Calculating average grades and working out term grades by hand takes time, and rounding mistakes then have to be explained. Here you enter grades in a "student × lesson date" matrix, and the spreadsheet calculates the average grade, the number of 5s, 4s, 3s and 2s and the absences, and suggests a grade for the term and for the year. You set the rounding rule as a parameter, and the summary shows the class's knowledge quality, pass rate and attendance.

What is inside

"Class": class name, subject, teacher, term start dates and end of year, a list of up to 35 students, up to 40 lesson dates, rounding and attendance threshold settings.
"Grades": a matrix of students and lesson dates, grades 2–5 and "A" (absent) with a drop-down list, color highlighting, average grade, number of grades of each kind, absences and the suggested grade for the selected period.
"Results": average grade and suggested grade for each of the four terms and for the year, with the categories "top student", "good student", "has 3s" and "failing".
"Attendance": absences by term, attendance percentage, highlighting of students below the threshold.
"Summary": class average grade, knowledge quality, pass rate, attendance, a table by term and year, two charts.

Who it is for

Subject teachers and class tutors at schools, colleges and clubs, tutors with a group, and anyone who keeps personal progress records alongside the official register and wants to get averages and summaries quickly.

What you get

The package contains a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not accounting software. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Thresholds and rounding values are kept in the settings: check them against your local rules before use. The calculation is approximate.

📘 How to Make a Teacher's Grade Book in Excel with Averages and Attendance

Questions and answers

Can I choose the rounding rule for the average grade?: Yes. On the "Class" sheet you set the round-up threshold: 0.5 gives standard mathematical rounding and 0.6 is stricter. The spreadsheet only suggests a grade; the final decision stays with the teacher.
How do I mark absences?: In the student's cell under the lesson date, choose the letter "A" from the list. It is not included in the average grade but is counted in absences and in the attendance percentage.
How many students and lessons fit?: Up to 35 students and up to 40 lesson dates in one file. If there are more lessons, enter only the dates with grades and absences, or keep a separate file for each half-year.
How do I keep several subjects?: One file is one subject in one class. For another subject, save a copy of the file, change the subject and enter the new grades.