Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| الطالب (اسم أول أو كود) | الفصل | المجموع | النسبة | التقدير | مواد متعثرة | الحالة | الترتيب في الفصل |
|---|---|---|---|---|---|---|---|
| أحمد | فصل أ | 507 | 90.5% | ممتاز | 0 | ناجح | 1 |
| محمود | فصل أ | 407 | 72.7% | جيد | 0 | ناجح | 2 |
| يوسف | فصل أ | 293 | 52.3% | مقبول | 3 | دور ثانٍ | 3 |
| عمر | فصل أ | 267 | 47.7% | ضعيف | 4 | راسب | 4 |
| علي | فصل ب | 465 | 83.0% | جيد جدًا | 0 | ناجح | 1 |
| حسن | فصل ب | 368 | 65.7% | جيد | 0 | ناجح | 2 |
| إبراهيم | فصل ب | 354 | 0 | ناقص | |||
| مصطفى | فصل ب | 300 | 53.6% | مقبول | 1 | دور ثانٍ | 3 |
Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الإعدادات: The pass percentage for a subject (50% in the example), the four grade boundaries (85%, 75%, 65% and 50% in the example), the maximum number of failed subjects that still allows a second round (3 in the example), and the subject table: name, group (religious, Arabic or general), maximum year work, maximum final exam and weight. It also holds the class list. All of this is editable example data, and the subject table holds up to 15 subjects.
- الطلاب: The student's first name or a code, and the class. For each student the sheet calculates complete and incomplete subjects, year work, final exam, the weighted total, the maximum, the percentage, the grade, the number of failed subjects, the status and the rank within the class. It holds up to 300 students.
- الدرجات: One row per student and subject: the student, the subject (from a list), the year work mark and the final exam mark. The sheet automatically shows the maximum marks, the subject total, its percentage and its status (pass, failed or incomplete), and a warning if a mark exceeds the maximum. It holds up to 1000 rows.
- الدور الثاني: A list of failed subjects: the student, class, subject, its mark, its maximum, its percentage and the student's status, with the number of failed subjects and the number of second-round and failing students. It holds the first 100 failed subjects.
- ترتيب الفصل: You pick a class from a list and it shows the students ranked from the highest percentage, with their percentage, grade, total, number of failed subjects and status. An incomplete student is not ranked until all their marks are entered.
- الملخص: The number of students, subjects and mark rows, the student results (pass, second round, fail and incomplete), the average, highest and lowest percentage, the number of students in each grade, a table for each class, a table for the percentage of each subject group, and a table for each subject with its number of failures and failure rate.
- ابدأ هنا: How to use the sheet, what the colors mean and notes on the calculation.
- لماذا ما زلت على إكسل؟: What could change if more than one person needs to work on the marks at the same time, and how a custom program can be built around the way you work.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Instead of adding marks on a calculator and searching through papers to see who failed which subject, you enter each mark once. The total, percentage and grade appear in the student's row, the second-round list is ready with subjects and marks, and the class ranking is sorted. If the number of subjects or their maximum marks change, you edit them in Settings and everything recalculates.
How to use it
- In the "الإعدادات" (Settings) tab, edit the subject list, the maximum year work and final exam marks and each subject's weight to match your class regulations. The subjects shown are only an example.
- Also in Settings, enter the subject pass percentage, the grade boundaries, the maximum number of failed subjects that still allows a second round, and the class names.
- In the "الطلاب" (Students) tab, enter the student's first name or a code, and choose their class.
- In the "الدرجات" (Grades) tab, write one row for each student and subject: choose the student and the subject, then enter the year work mark and the final exam mark.
- The Students tab calculates the total, percentage, grade, number of failed subjects and status, and ranks the student within the class.
- Open "الدور الثاني" (Second round) for the list of failed subjects, "ترتيب الفصل" (Class ranking) after choosing a class, and "الملخص" (Summary) for the overall picture.
Before you start:
- The subject list, weights, maximum marks, and pass and grade boundaries in Settings are examples that you set according to the class regulations. The sheet includes no official regulation.
- Subject mark = year work + final exam. Weighted total = the sum of (each subject's mark x its weight). Set all weights to 1 if you want the raw total.
- A failed subject is one whose percentage is below the pass percentage in Settings. A student is "ناجح" (pass) if they failed no subject, "دور ثانٍ" (second round) if they failed no more than the limit set, and "راسب" (fail) if more.
- If a student has a subject with no year work or final exam mark, or no row at all, the status is "ناقص" (incomplete) and the percentage and rank are not calculated until it is complete.
- Enter only the student's first name or a code, and do not enter sensitive personal data.
- The sheet holds up to 300 students, 1000 mark rows and 15 subjects, and the second-round list shows the first 100 failed subjects.
Free cheat sheet for this field
Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Does the sheet follow an official Al-Azhar regulation?
No. The subject list, maximum marks, weights, pass mark and grade boundaries in Settings are examples only, and you set them according to the regulations of your class or school. The sheet is a calculation tool and claims no regulation.
How are the total and percentage calculated?
Subject mark = year work + final exam. Total = the sum of (each subject's mark x its weight), and percentage = total / the weighted maximum. Only complete subjects are counted, and a student missing a subject has the status "ناقص" (incomplete) and no percentage until it is complete.
How does the sheet know who goes to the second round?
A failed subject is one whose percentage is below the pass percentage in Settings. A student with no failed subject is "ناجح" (pass). A student who failed no more than the number set is "دور ثانٍ" (second round), and one who failed more is "راسب" (fail). Change the percentage and the limit as you like. In the example, two students are in the second round and one fails.
Can I change the subjects and how many there are?
Yes, up to 15 subjects. Change the names, group, maximum marks and weight in Settings, then choose the subject from the list in the "الدرجات" (Grades) tab.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for Al-Azhar students and teachers
More free templates for: Al-Azhar students
More free templates
- Quran memorization and review tracker (Excel)
- University applications tracker (Excel)
- Teacher weighted gradebook (Excel)
- Lesson plan and curriculum coverage tracker for teachers (Excel)
- Parent communication log for teachers (Excel)
- Remedial sessions tracker for teachers (Excel)
- Charity accounts by fund
- Strength workout log
- Running, cycling and swimming log





