You teach one or more classes and want to know quickly who handed in the homework and who did not, which students are repeatedly late, and how the class behaves, without going through every notebook again. The free homework and behavior tracker does that in Excel, Google Sheets or online.
The problem it solves
You set homework today and a week later you are facing a pile of notebooks and papers. You jot down who did not hand in on a scrap of paper, forget what you wrote about the previous assignment, and when a parent asks about their child you have no numbers. Behavior notes mostly stay in your head, with no date and no count.
How the sheet solves it, step by step
- In Settings write your name, the school year, the delivery-rate limit under which you want a warning, the number of behavior alerts at which you review a student, and your class names.
- In Students write each student's code, name and class.
- In Homework log each assignment: code, date, class, subject, title and due date.
- In Submissions write one row per student and assignment with one of three statuses: handed in on time, handed in late, or not handed in. You pick it from a list, so there are no spelling slips.
- In Behavior add a short dated note: positive or alert.
- Open Follow-up and Summary for the calculated results.
What each sheet does
Students is the core: for each student, the number of assignments logged, what was handed in on time, late and not at all, the delivery rate, and the number of positive notes and alerts. At the end you get a delivery status ("on track" or "needs follow-up") and a behavior status, and rows that need follow-up turn red.
Homework shows, per assignment, how many students are in the class, how many rows you logged, how many handed in and how many did not, and the delivery rate. A "not yet logged" column shows how many students still have no row.
Submissions and Behavior are the input logs: one row is one event, and the student's name and class fill in automatically. If you type a code that does not exist, the sheet flags it.
Follow-up lists the students who need follow-up from the lowest delivery rate, with what they have not handed in and their behavior alerts, so you know whom to start with.
Summary gives the overall picture, then a table per class: students, delivery rate, how many need follow-up, positive notes and alerts.
Why it helps
- You follow up from a record, not an impression: every student has numbers you can go back to.
- You see early who is starting to slip, before a long list of assignments piles up.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not from real statistics. It has ten students in two classes, five assignments and 24 submission rows: 12 on time, 5 late and 7 not handed in, so the overall delivery rate is about 70.8%. With a 70% limit, four students need follow-up: Mariam Ashraf at 0%, then Omar Khaled and Youssef Sami at about 33.3% each, then Laila Mahmoud at about 66.7%. Class 1 is at 66.7% and Class 2 at about 77.8%.
On behavior there are six positive notes and seven alerts. Omar Khaled and Mariam Ashraf have three alerts each, so they show "behavior follow-up" because the limit in Settings is two alerts. In the last Class 2 assignment, "not yet logged" shows 1 because one student has no row yet.
An important note on behavior
Write short, general notes about conduct in class, such as "forgot supplies" or "helped a classmate". Do not write health, family or other sensitive personal details: the sheet is an ordinary file that can be copied or sent.
The online version
Open the page and the sheet loads on the example. Edit any cell and watch the results change, add a student, assignment or submission with a simple form instead of hunting for the last row, import your own .xlsx file or export your work. Your data stays in your browser on your device.
Who it suits
It suits a teacher with a limited number of classes who wants a simple record, and a class coordinator who collects delivery status from several teachers into one file. If you need marks, try the student grades sheet; for attendance, try the student attendance sheet. This one covers homework and behavior only.