# Remedial sessions tracker for teachers (Excel)

> Track students needing support by subject, log sessions with minutes and attendance, enter scores before and after, and see who did not improve.

Source: https://softwiro.com/templates/remedial-sessions-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for remedial (extra support) sessions. You enter the students who need support by first name or code, choose the subject and the reason for support from a short list, then log each session with its date, length and whether the student attended or was absent. You type the score before and after the support, and the sheet calculates the improvement, the number of sessions attended and the attendance rate, picks out students who did not improve, and summarizes each subject. The sheet asks for no sensitive data.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-remedial-sessions-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-remedial-sessions-tracker-blank.xlsx)

Excel file (.xlsx) · 144 KB · 7 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

| كود الطالب | الاسم الأول | المادة | الدرجة قبل | الدرجة بعد | الحصص المحضورة | فرق التحسن | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- |
| R01 | أحمد | الرياضيات | 45 | 62 | 3 | 17 | تحسّن |
| R02 | منى | الرياضيات | 50 | 53 | 1 | 3 | لم يتحسن |
| R03 | كريم | اللغة العربية | 40 | 58 | 4 | 18 | تحسّن |
| R04 | سلمى | اللغة الإنجليزية | 55 | 54 | 2 | -1 | لم يتحسن |
| R05 | يوسف | العلوم | 60 | 72 | 2 | 12 | تحسّن |
| R06 | هدى | الفيزياء | 35 | 35 | 1 | 0 | لم يتحسن |
| R07 | عمر | الرياضيات | 48 | 66 | 3 | 18 | تحسّن |
| R08 | نور | اللغة الإنجليزية | 42 |  | 1 |  | بانتظار الدرجة |
| R09 | ياسمين | اللغة العربية | 52 | 60 | 2 | 8 | تحسّن |
| R10 | مصطفى | الفيزياء | 38 | 30 | 1 | -8 | لم يتحسن |

Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): The smallest score difference that counts as improvement (5 in the example) and the lowest attendance rate before an alert (50% in the example).
- "الطلاب" (Students): One row per student per subject: code, first name, subject, reason for support from a list, score before and score after. The sheet then calculates sessions logged, attended and missed, minutes attended, attendance rate, improvement, status (improved, did not improve, or waiting for score), follow-up rank and an attendance alert.
- "الحصص" (Sessions): The session log: date, student code, length in minutes, attended or absent, and a note. The student's name and subject appear next to each row.
- "للمتابعة" (To follow up): A list of students who did not improve, ordered from least improved (or most declined), with their subject, reason, sessions attended, difference and attendance rate. It holds the first 50 students.
- "الملخص" (Summary): Number of students, how many improved, did not improve or are waiting for a score; sessions logged, attended and missed; attendance rate and minutes attended; average score before and after and the improvement; then a table for each subject.
- "ابدأ هنا" (Start here): The steps, what the cell colors mean and important notes on how the calculations work.
- "لماذا ما زلت على إكسل؟" (Why am I still on Excel?): What a custom program from Softwiro adds if your work grows.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

The sheet answers the questions a teacher has after weeks of remedial sessions. Did the sessions actually help? Which student attended and improved, which did not improve despite attending, and who missed too many? Which subject needs more effort? You type both scores on your own scale, so the sheet invents no numbers, and everything it shows is a calculation from what you recorded. It differs from the [tutoring center management sheet](https://softwiro.com/templates/tutoring-center), which tracks groups and subscriptions, and from the [student attendance sheet](https://softwiro.com/templates/student-attendance), which tracks attendance for a whole class. This one is for a small group that needs support, and the effect on their scores.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter the smallest score difference that counts as improvement and the lowest attendance rate at which you want an alert.
2. In the "الطلاب" (Students) sheet, add a row for each student in each subject: a code (such as R01) and first name, then choose the subject and the reason for support from the list.
3. Enter the "score before" (الدرجة قبل) when the support starts, and the "score after" (الدرجة بعد) when you test the student after the sessions.
4. In the "الحصص" (Sessions) sheet, log each session: the date, the student code and its length in minutes, and choose attended or absent.
5. The "الطلاب" (Students) sheet calculates sessions attended, attendance rate, improvement and each student's status.
6. Open "للمتابعة" (To follow up) to see who did not improve, from least improved, and "الملخص" (Summary) for the figures of each subject.

**Before you start:**

- Each row in the "الطلاب" (Students) sheet is one student in one subject. A student you support in two subjects is entered in two rows with two different codes.
- Improvement = score after - score before. You type both scores, on the same scale (for example out of 100).
- A student counts as "improved" if the difference reaches the threshold in the settings or more; otherwise the status is "did not improve", even if the difference is zero or negative.
- A student without both scores has the status "waiting for score", and is left out of the score averages and the count of those who did not improve.
- Attendance rate = sessions attended / (attended + absent). The sheet asks for no sensitive data: a first name or a code is enough.
- The sheet holds 200 students and 3000 sessions, and the "للمتابعة" (To follow up) list shows the first 50 students who did not improve.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-remedial-sessions-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-remedial-sessions-tracker-blank.xlsx)

Excel file (.xlsx) · 144 KB · 7 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: remedial sessions tracker (1/3)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-1.jpg)[![Cheat sheet: remedial sessions tracker (2/3)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-2.jpg)[![Cheat sheet: remedial sessions tracker (3/3)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/remedial-sessions-tracker/en-3.jpg)

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

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How is the improvement calculated?

Improvement = score after - score before, and you type both scores. If either is missing, the student's status is "waiting for score" and they are left out of the averages.

### Who counts as "did not improve"?

Anyone whose difference is below the threshold in the settings sheet, whether the difference is small, zero or negative. You can change the threshold at any time and the statuses update automatically.

### Should I enter full student names and parent details?

There is no need. The sheet is designed for a first name or a code only, and has no phone number, address or any sensitive detail.

### How do I track a student who needs support in two subjects?

Give the student two rows in the students sheet with two different codes, one row per subject, and log the sessions of each subject under its own code.

### 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](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](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](https://softwiro.com/templates/for-teachers)

More free templates for: Teachers

## More free templates

- Teacher weighted gradebook (Excel)
- Lesson plan and curriculum coverage tracker for teachers (Excel)
- Parent communication log 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

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
