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 | درجة الفئة 2 | درجة الفئة 3 | درجة الفئة 4 | المجموع المرجّح | النسبة | التقدير | الحالة |
|---|---|---|---|---|---|---|---|---|---|
| 1 | أحمد سمير | 18 | 27 | 17 | 52 | 87.67 | 87.7% | ممتاز | آمن |
| 2 | سارة عادل | 15 | 24 | 16 | 45 | 77.00 | 77.0% | جيد جدًا | آمن |
| 3 | محمد حسن | 12 | 18 | 14 | 36 | 62.00 | 62.0% | مقبول | آمن |
| 4 | مريم خالد | 20 | 30 | 20 | 58 | 98.67 | 98.7% | ممتاز | آمن |
| 5 | خالد محمود | 8 | 12 | 10 | 24 | 42.00 | 42.0% | راسب | معرّض للرسوب |
| 6 | هدى علي | 14 | 21 | 12 | 30 | 60.00 | 60.0% | مقبول | آمن |
| 7 | يوسف نبيل | 10 | 15 | 12 | 31 | 52.67 | 52.7% | مقبول | على الحافة |
| 8 | نور الدين | 16 | 24 | 18 | 50.00 | 83.3% | جيد جدًا | آمن |
Example from the “الدرجات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الإعدادات: The subject and class, the four assessment categories with their weights and maximum marks (all editable), the total of the weights, the pass percentage and warning margin, and a table of grade boundaries. The grade boundaries shown are examples only that you edit to match your school.
- الدرجات: Each row is a student: number, name and mark in each of the four categories. The sheet calculates the categories recorded, the weighted total, the weight recorded, the percentage, the grade, the status, a note (missing marks or a mark out of range), the student's rank and the risk rank. It holds up to 200 students.
- المعرّضون: A list of students at risk of failing or borderline, sorted from the lowest percentage, with student number, name, percentage, grade, status and note. It holds the first 40 students.
- الإحصائيات: The number of students and how many have a percentage, the average, highest and lowest percentage, the number of students in each status, the average of each category and its percentage of the category maximum, the weakest category, and the number of students in each grade.
- ابدأ هنا: How to use the sheet, what the colors mean and notes on the calculation.
- لماذا ما زلت على إكسل؟: A short comparison between the sheet and a custom program 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
At the end of the term you do not need to work out each category's weight for each student on a calculator. You enter the marks as you recorded them and the sheet does the rest. Open the "المعرّضون" (At risk) tab to see who you need to talk to first, and the "الإحصائيات" (Statistics) tab to see which category had the weakest class average.
How to use it
- In the "الإعدادات" (Settings) tab, enter the subject and class, then the names of the four assessment categories, each category's weight and its maximum mark.
- Enter the pass percentage and the warning margin, and edit the grade boundaries if they differ from your school's (the boundaries shown are examples).
- In the "الدرجات" (Grades) tab, enter each student's number, name and mark in each category. Leave the cell empty if the mark has not been recorded yet.
- The sheet calculates the weighted total, percentage, grade, status and rank for each student, and the "ملاحظة" (note) cell warns you about a missing mark or one outside the allowed range.
- Open the "المعرّضون" (At risk) tab to find the students whose percentage is below the pass mark or close to it, sorted from the lowest.
- Check the "الإحصائيات" (Statistics) tab for the class average, highest and lowest percentage, the average of each category and the grade distribution.
Before you start:
- The recommended total of the weights is 100, but the sheet always calculates the percentage from the total weights of the categories that have recorded marks, so the calculation holds even if the total differs.
- Weighted total = for each category (mark / maximum x category weight), then the categories are added up. Percentage = weighted total / the total weights of the recorded categories.
- For a student without all categories recorded, the percentage is calculated from the recorded categories only and the note "درجات ناقصة" (missing marks) appears. If no category is recorded, no percentage is shown.
- Student status: "معرّض للرسوب" (at risk of failing) if the percentage is below the pass percentage, "على الحافة" (borderline) if it is below the pass percentage plus the warning margin, and otherwise "آمن" (safe).
- The grade boundaries and their names in Settings are an example only, not an official rule. Enter your school's boundaries, ordered from lowest to highest.
- The sheet holds up to 200 students, and the at-risk list shows the first 40. The names and marks in the example are fictional and for illustration.
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
How is the weighted total calculated?
For each category: the student's mark / the category's maximum mark x its weight, then the categories are added up. Percentage = weighted total / the total weights of the categories recorded for that student.
Can I change the weights and categories?
Yes. The four category names, their weights and their maximum marks are in the "الإعدادات" (Settings) tab, and all calculations change as soon as you edit them. You can set the weight of an unused category to zero.
Are the grade boundaries official?
No. The grade boundaries and their names in Settings are examples only, and you should enter those of your school or institution, ordered from lowest to highest.
What happens to a student who does not have all marks recorded?
Their percentage is calculated from the recorded categories only, and the note "درجات ناقصة" (missing marks) appears. If no category is recorded for them, no percentage or status is shown.
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 teachers: gradebook, lesson planning and follow-up
More free templates for: Teachers
More free templates
- Lesson plan and curriculum coverage tracker for teachers (Excel)
- Parent communication log for teachers (Excel)
- Remedial sessions tracker for teachers (Excel)
- Study groups management sheet for a private teacher
- Charity accounts by fund
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Swimming times and personal bests





