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
| الطالب (اسم أول أو كود) | الحلقة | إجمالي المحفوظ (أوجه) | إجمالي المراجعة (أوجه) | آخر حفظ | آخر مراجعة | أيام منذ آخر مراجعة | التنبيه |
|---|---|---|---|---|---|---|---|
| أحمد | حلقة 1 | 9 | 8 | 46320 | 46324 | 3 | |
| محمد | حلقة 1 | 5 | 6 | 46321 | 46307 | 20 | تأخر مراجعة |
| يوسف | حلقة 1 | 2 | 2 | 46314 | 46296 | 31 | تأخر مراجعة |
| عمر | حلقة 2 | 8 | 3 | 46317 | 46312 | 15 | تأخر مراجعة |
| علي | حلقة 2 | 2 | 4 | 46308 | 46313 | 14 | |
| زياد | حلقة 2 | 2 | 0 | 46325 | لم تُسجَّل مراجعة |
Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الإعدادات: Today's date (entered as the example date, and you can replace it with =TODAY()), the number of days after which a review counts as late (14 in the example), the number of faces per page used to show the equivalent memorized pages (2 in the example, set by the teacher according to their copy of the Quran), and the list of circles or groups (up to 10).
- الطلاب: The student's first name or a code, and their circle. For each student the sheet calculates total memorized and reviewed in faces, number of sessions, date of last memorization and last review, days overdue, the alert, the number of times marked "يعاد" (repeat), the last memorization position and the follow-up rank. It holds up to 200 students.
- التسميع: One row per session: date, student, type (new memorization or review), the "from" and "to" positions as text, number of faces, rating (excellent, very good, good, acceptable or repeat) and a note. A "check" cell appears if the student is not found or the date or number of faces is missing. It holds up to 2000 sessions.
- للمتابعة: The students whose review is overdue, sorted from the most overdue, with their circle, date of last review, days overdue, last memorization position and total memorized. It holds the first 50 students.
- الملخص: The number of students and sessions, total memorized in faces and the equivalent in pages, total reviewed and sessions in the last 7 days, the alert counts, the number of sessions at each rating, and a table for each circle with its students, faces memorized, faces reviewed and overdue students.
- ابدأ هنا: How to use the sheet, what the colors mean and notes on the calculation.
- لماذا ما زلت على إكسل؟: What could change if more than one person needs to log sessions 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 trying to remember who has reviewed and who has stopped, you open the "للمتابعة" (Follow-up) tab and find the overdue students sorted by days late, with each one's last memorization position. Your sessions stay recorded with their dates and ratings, so you know each student's total memorized and reviewed without counting from a notebook.
How to use it
- In the "الإعدادات" (Settings) tab, enter today's date (or =TODAY() so it updates by itself), the number of days after which a review counts as late, and the names of the circles or groups.
- In the "الطلاب" (Students) tab, enter the student's first name or a code, and choose their circle.
- In the "التسميع" (Recitation) tab, write one row for each session: the date, the student and the session type (new memorization or review).
- Write the position as text in the "من" (from) and "إلى" (to) cells, for example "البقرة 1" and "البقرة 10" (Al-Baqarah 1 and 10), then enter the number of faces as a number you work out yourself, and choose the rating.
- The Students tab calculates total memorized and reviewed, the last position, the dates of the last memorization and last review, days overdue and the alert.
- Open "للمتابعة" (Follow-up) to see whose review is overdue, sorted from the most overdue, and "الملخص" (Summary) for the totals by circle and rating.
Before you start:
- The number of faces is a number you enter for each session. The sheet has no Quran page table and does not calculate faces from verses; it adds up what you enter.
- Total memorized = the sum of faces in a student's "حفظ جديد" (new memorization) sessions. Total reviewed = the sum of faces in their "مراجعة" (review) sessions.
- "تأخر مراجعة" (review overdue) appears when the days between today's date and the last review exceed the number set in Settings. A student with no review logged shows "لم تُسجَّل مراجعة" (no review recorded).
- The position is free text, so write it the way your circle is used to. The sheet shows the "to" position of the last memorization session as the student's last position.
- Enter only the student's first name or a code, and no sensitive personal data.
- The sheet holds up to 200 students and 2000 recitation sessions, and the follow-up list shows the first 50 overdue students.
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 calculate the number of faces from the surah and verse?
No. The position is text you write however you like, and the number of faces is a number you enter for each session. The sheet has no Quran page table, so it only adds up what you enter.
When does the "تأخر مراجعة" (review overdue) alert appear?
When the days between today's date and the student's last review date exceed the number set in Settings. A student with no review logged shows "لم تُسجَّل مراجعة" (no review recorded). Change the number of days as you like. In the example, with a 14-day limit, three students show as overdue.
How is total memorized calculated?
A student's total memorized = the sum of the faces in their "حفظ جديد" (new memorization) sessions, and total reviewed = the sum of the faces in their "مراجعة" (review) sessions.
Should I enter students' full details?
No. Enter a first name or a code only, and no sensitive personal data, because the sheet is an ordinary file that may be copied or sent.
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
- Al-Azhar student grades sheet (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