Softwiro
Free Excel template

Homework and behavior tracker for teachers (Excel)

A free Excel sheet for a teacher to track homework and behavior. You record your classes' students and the homework you assign, then mark for each student whether they handed it in on time, late or not at all, and add short, general behavior notes (positive or a warning). The sheet calculates the submission rate for each student, each assignment and each class, and shows a list of who needs follow-up.

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

Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.
كود الطالبالاسمالفصلنسبة التسليمحالة التسليمالسلوك
S01أحمد عليفصل 1100.0%منتظم
S02سلمى حسنفصل 1100.0%منتظم
S03عمر خالدفصل 133.3%يحتاج متابعةمتابعة سلوك
S04ليلى محمودفصل 166.7%يحتاج متابعة
S05يوسف ساميفصل 133.3%يحتاج متابعة
S06منة الله طارقفصل 2100.0%منتظم
S07كريم هشامفصل 2100.0%منتظم
S08مريم أشرففصل 20.0%يحتاج متابعةمتابعة سلوك
S09ياسين عادلفصل 2100.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

  1. 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.
  2. In the "الطلاب" (Students) tab, enter each student's code, name and class.
  3. In the "الواجبات" (Assignments) tab, record each assignment you set: code, date, class, subject, title and due date.
  4. 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).
  5. In the "السلوك" (Behavior) tab, record the general behavior note: date, student code, its type (positive or warning) and a short sentence.
  6. 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.

Excel file (.xlsx) · 163 KB · 9 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: homework and behaviour tracker (1/3)Cheat sheet: homework and behaviour tracker (2/3)Cheat sheet: homework and behaviour tracker (3/3)
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 sheetIn 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 · Ask for a demo

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

All templates · Free tools