You teach remedial sessions to a group of students who are struggling, and after a few weeks you want to know whether they worked. Who improved, who did not, and is the reason absence or a method that does not suit the student? The free remedial sessions tracker answers this from two things you type: the students and the sessions, plus a score before and after.
The problem it solves
Remedial sessions usually live on scattered paper: a list of names, a notebook of dates, and scores in another file. To compare, you count sessions by hand and subtract scores on a calculator, and you forget who attended three sessions and who missed two. You end up unsure who needs more follow-up and which subject takes more time without a clear effect.
How the sheet solves it, step by step
- In the Settings sheet, write the smallest score difference you count as improvement and the lowest attendance rate you want flagged.
- In the Students sheet, write one row per student per subject: a code and first name, and pick the subject and a short reason from a list (weak basics, earlier absence, difficulty with the lesson, slow solving, exam preparation).
- Type the score before when support starts and the score after when you test the student. Both scores are yours, on your own scale.
- In the Sessions sheet, log each session: date, student code, minutes, and attended or absent.
- The sheet calculates for each student the sessions logged, attended and missed, minutes attended, attendance rate, improvement and status.
- The follow-up sheet lists those who did not improve, and the summary shows the totals and each subject.
What each sheet does
Students is the core: one row per student per subject, with grey cells that calculate on their own. Rows of students who did not improve turn red, and "weak attendance" appears when the rate falls under your limit.
Sessions is a simple log where you add a line per session. The student's name and subject appear beside the code, and a mistyped code shows "code not found".
Follow-up is sorted from least improvement, so the first name is the student whose score fell the most.
Summary gives the big picture: how many improved, did not improve or await a score, total sessions and attendance, average score before and after, and a table for each subject.
Why it matters
Judging remedial work by impression can be unfair to you or to the student. When you see a student who attended every session and still did not improve, you know a different way of explaining is needed. When another missed more than half of the sessions, you know regularity comes before the curriculum. That decision is what saves your time and theirs.
A walk-through with the sample data
These numbers come from the example data in the sheet, not from real students. It has 11 students in five subjects and 29 sessions logged in October: 20 attended and 9 missed. Nine students have both scores; their average was 47 before and about 54.4 after, an average gain of about 7.4 points.
With a threshold of 5 points, five students improved, including "Ahmed", whose score rose from 45 to 62 after attending three of four sessions. Four did not improve, the first being "Mostafa", whose score fell from 38 to 30 after missing two of three sessions. Two students await a score because one or both values are not typed yet. In the subject table, Physics has two students who did not improve, so you know where to look first.
The online version
You can open the sheet on the site on the same example, edit cells and see results immediately, add students and sessions with a simple form instead of hunting for the empty row, and import or export an .xlsx file. Your data stays in your browser on your device.
Who it suits
It suits private teachers, school teachers who give sessions to struggling students, and a support coordinator in a small school. If you run groups and collect fees, use the tutoring center sheet; if you track a whole class's attendance, use the student attendance sheet. If your work grows and several people need the data at once, you can ask Softwiro for a custom program.
In short
Type the students, sessions and the two scores, and let the sheet do the rest. After two weeks of use you will know who needs follow-up, which subject needs effort, and whether the sessions are paying off.