You teach, or run the grading desk for, a class in an Al-Azhar school and want to record marks for religious, Arabic and general subjects, then see each student's total, percentage and grade, who failed which subject (for the second round), and who is top of the class. The free Al-Azhar student grades sheet does that in Excel, Google Sheets or online.
The problem it solves
Marks usually sit in paper lists and separate files, one per subject. At the end of term you add year work to the final exam for every student with a calculator, then search the papers for who fell below the pass mark and where. One addition slip changes a grade, and adding a subject or changing a maximum mark means starting again.
How the sheet solves it, step by step
- In Settings write your subject list: name, group (religious, Arabic or general), maximum year work, maximum final exam and weight. The subjects in the file are only an example.
- Also in Settings: the pass percentage per subject, the grade limits, the most failed subjects allowed for a second round, and your class names.
- In Students write a first name or a code and pick the class.
- In Marks write one row per student and subject: pick both from lists, then type the year-work mark and the final-exam mark.
- The sheet calculates the rest. Open Second round, Class ranking and Summary for the results.
What each sheet does
Settings is the control panel; every value is an example you set. With all weights at 1 the total is the sum of raw marks.
Marks is the entry log. Beside each row it shows the maximums, the subject total, percentage and status: passed, failed, or incomplete when a mark is missing. A mark above the maximum, or a student who is not listed, produces a warning note.
Students is the report itself: year work, final, total, maximum, percentage, grade, failed subjects, status (passed, second round, failed or incomplete) and class rank.
Second round lists every failed subject with student, class, mark, maximum and percentage. Class ranking shows a chosen class from the highest percentage down, and a student with a missing mark is not ranked until the marks are complete. Summary gives the counts, the average, students per grade, and tables per class, subject group and subject, so you can see which subjects students struggle with most.
Why it matters
- Each mark is entered once and the totals and grades calculate themselves.
- You know who goes to the second round and in which subjects.
- One changed cell (a maximum, a weight, the pass mark) updates every result.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not from real statistics, and the names are made-up first names. It has eight students in two classes, ten subjects and 80 mark rows. "Quran" has weight 2 and every other subject weight 1, so the weighted maximum per student is 560.
"Ahmed" scored 507 of 560, about 90.5%, "excellent", first in class A. "Yousef" failed three subjects (Fiqh, grammar and English), so he is in the "second round" even though his percentage is about 52.3%. "Omar" failed four subjects, more than the limit of 3, so he is "failed" with about 47.7%. In class B, "Mostafa" failed Quran alone with 24 of 50, so he is in the second round, and "Ibrahim" has no Science final mark yet, so he shows "incomplete" with no percentage or rank. The Summary shows four passed, two in the second round, one failed and one incomplete, and the second-round list holds eight failed subjects.
An important note
The subjects, weights, maximum marks, pass mark and grade limits in the file are examples to try the sheet with. They are not an official regulation for any year or stage, so set them to what your school uses. Write only a first name or a code for each student, with no sensitive personal details.
The online version
Open the page and the sheet is already filled with the example. Edit any cell and watch the results change, add records with a simple form, and import or export .xlsx. Your data stays in your browser on your device.
Who it suits
It suits a teacher recording a class's marks or a coordinator collecting marks in one file. For general school marks try the student grades sheet, for attendance the student attendance sheet, and for Quran memorization the Quran memorization tracker.
Bottom line
Let the report calculate itself: weighted subjects, a mark per student per subject, and a second-round list and class ranking ready to use. Open the sheet on the example, then edit the subjects and type in your own class's marks.