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
| كود الطالب | الاسم | الفصل | نسبة التسليم | حالة التسليم | السلوك |
|---|---|---|---|---|---|
| S01 | أحمد علي | فصل 1 | 100.0% | منتظم | |
| S02 | سلمى حسن | فصل 1 | 100.0% | منتظم | |
| S03 | عمر خالد | فصل 1 | 33.3% | يحتاج متابعة | متابعة سلوك |
| S04 | ليلى محمود | فصل 1 | 66.7% | يحتاج متابعة | |
| S05 | يوسف سامي | فصل 1 | 33.3% | يحتاج متابعة | |
| S06 | منة الله طارق | فصل 2 | 100.0% | منتظم | |
| S07 | كريم هشام | فصل 2 | 100.0% | منتظم | |
| S08 | مريم أشرف | فصل 2 | 0.0% | يحتاج متابعة | متابعة سلوك |
| S09 | ياسين عادل | فصل 2 | 100.0% | منتظم |
Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الإعدادات (Settings): Teacher name and school year; the submission-rate threshold below which the "needs follow-up" alert appears (70% in the example); the number of behavior warnings at which a student is reviewed (2 in the example); and the list of classes (up to 20).
- الطلاب (Students): Student code, name and class. For each student the sheet calculates the number of assignments recorded, how many were handed in on time and late, how many were not handed in, the submission rate, the number of positive notes and warnings, submission status, behavior status and follow-up rank. It holds 300 students.
- الواجبات (Assignments): Assignment code, date, class, subject, title and due date. The sheet calculates the number of students in the class, the rows recorded, how many handed in and how many did not, the submission rate, and a "not recorded" column for students who do not yet have a row. It holds 300 assignments.
- التسليم (Submissions): One row per student and assignment: assignment code, student code, status (on time, late or not handed in) and an optional note. The student name and class appear automatically. It holds 2000 rows.
- السلوك (Behavior): Short, general behavior notes: date, student code, type (positive or warning) and the note. The student name and class appear automatically. It holds 1000 notes.
- للمتابعة (Follow-up): Students who need follow-up, sorted from the lowest submission rate, with their code, class, rate, number of assignments not handed in and behavior warnings. It shows the first 50 students.
- الملخص (Summary): The overall picture (students, assignments, on-time and late submissions, not handed in, the overall submission rate and how many need follow-up), the numbers of positive notes and warnings, and a table for each class with its rate and its students who need follow-up.
- ابدأ هنا (Start here): How to use the sheet, what the colors mean and notes on the calculations.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Instead of flipping through marking books to remember who did not hand in work, you open "للمتابعة" (Follow-up) and find their names in order with each one's rate, and from "الملخص" (Summary) you see which class is falling behind the most. Behavior notes stay together with their dates instead of getting lost in memory.
How to use it
- In the "الإعدادات" (Settings) tab, enter your name, the school year, the submission-rate threshold below which the alert appears and the number of behavior warnings at which you review a student, then enter your class names.
- In the "الطلاب" (Students) tab, enter each student's code, name and class.
- In the "الواجبات" (Assignments) tab, record each assignment you set: code, date, class, subject, title and due date.
- In the "التسليم" (Submissions) tab, write a row for each student and assignment: assignment code, student code and submission status (on time, late or not handed in).
- In the "السلوك" (Behavior) tab, record the general behavior note: date, student code, its type (positive or warning) and a short sentence.
- The Students tab calculates the submission rate, the number of notes and each student's status, the "للمتابعة" (Follow-up) tab ranks those who need follow-up, and the "الملخص" (Summary) tab shows the classes.
Before you start:
- A student's submission rate = (handed in on time + handed in late) ÷ the number of assignments recorded for them in the Submissions tab. An assignment with no row written does not count.
- A student shows "needs follow-up" if their rate is below the threshold written in Settings, and "behavior follow-up" if their warnings reach the number written there.
- In Behavior, write only short, general notes about conduct in class, and do not write health, family or sensitive personal information.
- The number of students in a class in the Assignments tab depends on each student's class being entered in the Students tab, so write the class name exactly as it appears in Settings.
- The "not recorded" column in Assignments counts the students in the class who do not yet have a submission row for that assignment.
- The sheet holds 300 students, 300 assignments, 2000 submission rows and 1000 behavior notes, and the Follow-up tab shows the first 50 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
How is the submission rate calculated?
A student's rate = (handed in on time + handed in late) ÷ the number of assignments recorded for them in the "التسليم" (Submissions) tab. An assignment you have not written a row for is not counted, and the "not recorded" column in the "الواجبات" (Assignments) tab alerts you to that.
When does a student appear in the follow-up list?
When their rate is below the threshold written in Settings. Change the threshold as you like and the list changes. In the example sheet, four of the ten students appear at a 70% threshold.
Can I write any note in Behavior?
Write only short, general notes about conduct in class. The sheet does not ask for health or family information, and it is best not to enter it.
Does it suit more than one class and subject?
Yes. You enter the classes in Settings and give each assignment its class and subject. A student's rate combines all the assignments recorded for them, and each class's rate appears in the Summary.
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: Schools and students
More free templates
- Gradebook Template for Excel (Weighted Categories, Letter Grades)
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)
- School bus subscriptions tracker (Excel)
- University applications tracker (Excel)
- Complete nursery management sheet
- Private school management sheet
- Lending library management sheet
- Graduation project manager sheet: tasks, team, phases and deliverables
- American diploma GPA calculator: unweighted, weighted and cumulative (Excel)
- IGCSE subject tracker with mock scores and target grades (Excel)
- IGCSE past papers log and error tracker (Excel)
- AP, SAT and ACT prep planner (Excel)
- Al-Azhar student grades sheet (Excel)
- Quran memorization and review tracker (Excel)
- Teacher weighted gradebook (Excel)
- Lesson plan and curriculum coverage tracker for teachers (Excel)