You have the marks for one class in one subject and you want to finish the paperwork: a total for each student, a grade, a rank, pass or fail, and a report card to hand to the parent, without a calculator and without re-checking every row. That is what this free sheet does. It takes minutes to set up and the grading rules are yours to change.
The problem it solves
Marks usually live in a notebook or a plain table. The totals are added by hand, the ranks are worked out by sorting, and one wrong mark (a 12 out of 10, or a missing final exam) quietly ends up in a report card. The sheet puts the rules in one place, so the same rules apply to every student.
What is inside
- Settings: school, teacher, class and subject; up to eight assessment components with the maximum mark of each; the pass percentage; and the grade table (minimum percentage and grade name), which you can edit.
- Marks: one row per student (up to 100) with a mark per component. The sheet calculates total, percentage, grade, rank and result, and a note column flags missing or invalid marks.
- Class statistics: number of students, class average, highest and lowest percentage, pass rate, how many students fall in each grade, and the average of each component as a share of its maximum.
- Student report card: pick a student number from the list and a report card appears, ready to print.
A worked example
The example is sample data, not real students: a fifth-grade science class of 15, with components of 10 (coursework), 10 (homework), 5 (participation), 15 (monthly test) and 60 (final exam), which add up to 100. The pass mark is 50%.
- Mariam Khaled scores 98 and ranks 1st (Excellent); Ahmed Samir scores 93 and ranks 2nd.
- Sara Adel and Hoda Ali both score 84, so both rank 4th. The next student, Omar Farouk with 82, ranks 6th: rank 5 is skipped because two students share rank 4.
- Khaled Mahmoud scores 37, which is 37%: grade Weak, result Fail.
- Nour El-Din has no final exam mark. His total is counted from the marks that exist (27), and the note says "missing marks" next to his name. He fails only because a mark is missing, which is exactly the signal to go and complete the entry before issuing a result.
- In all, 12 of the 15 students pass.
Why these features matter
- No manual totals. Change one mark and the total, grade and rank follow.
- Errors are visible. A missing mark is yellow; a mark above the maximum or below zero is red. You see the problem before the report card is printed.
- Fair ties. Equal totals share a rank, which avoids arguments about who is "above" whom.
- Your own scale. Change the components, the maximum marks and the grade boundaries to match your school.
- It works where you are. The formulas run in Excel 2016 and later, Google Sheets and LibreOffice. It is free and needs no sign-up.
Using the online version
The template page (the page is in Arabic) opens directly on this worked example, with numbers already in place. Edit the white input cells right in the page and the grey calculated cells update immediately. You can import your own .xlsx file made from this template, export your work to .xlsx, or download the original Excel file. Your data stays in your browser and is not sent to the server. The full template list is at /templates.
Common mistakes, and when a sheet stops being enough
- Giving two students the same number: the report card looks students up by number, so each needs a different one.
- Reusing the file for another class: save a new copy instead.
- Leaving a component's maximum blank by mistake: a blank maximum means the component is ignored everywhere.
The sheet holds the marks of one teacher for one subject. When you need grades, attendance and teacher notes for every student in one place, with reports that reach parents, that is the job of the student performance platform. For how such a platform is organised, see our guide for schools.
FAQ
Can I change the assessment components? Yes. Write up to eight components and their maximum marks in the Settings sheet. A component with a blank maximum is ignored.
What if a student has no mark for one component? The cell turns yellow, the total is calculated from the marks written, and the note says "missing marks".
Can I use my school's grade scale? Yes. Edit the minimum percentage and the name of each grade; the table does not need to be in order.