Softwiro
Free Excel template

Al-Azhar student grades sheet (Excel)

A free Excel sheet for recording the grades of Al-Azhar students (Egypt's Azhar school system). You enter the list of subjects (religious, Arabic and general), the maximum mark for year work and for the final exam, and the weight of each subject, then record each student's mark in each subject. The sheet calculates the total, percentage, grade, number of failed subjects and student status (pass, second round, fail or incomplete), pulls out the list of failed subjects for the second round, and ranks the students in each class. The subjects, weights, pass mark and grade boundaries in the sheet are examples that the teacher sets according to the class regulations, and the sheet claims no official regulation.

Excel file (.xlsx) · 279 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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

Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.
الطالب (اسم أول أو كود)الفصلالمجموعالنسبةالتقديرمواد متعثرةالحالةالترتيب في الفصل
أحمدفصل أ50790.5%ممتاز0ناجح1
محمودفصل أ40772.7%جيد0ناجح2
يوسففصل أ29352.3%مقبول3دور ثانٍ3
عمرفصل أ26747.7%ضعيف4راسب4
عليفصل ب46583.0%جيد جدًا0ناجح1
حسنفصل ب36865.7%جيد0ناجح2
إبراهيمفصل ب3540ناقص
مصطفىفصل ب30053.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

  1. 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.
  2. 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.
  3. In the "الطلاب" (Students) tab, enter the student's first name or a code, and choose their class.
  4. 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.
  5. The Students tab calculates the total, percentage, grade, number of failed subjects and status, and ranks the student within the class.
  6. 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.

Excel file (.xlsx) · 279 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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.

Cheat sheet: Azhar student grades (1/3)Cheat sheet: Azhar student grades (2/3)Cheat sheet: Azhar student grades (3/3)
0 downloads · 3 pages

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 sheetIn 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.

See Custom Software from Softwiro · Ask for a demo

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

All templates · Free tools