Unit 2 of 7

Attendance & Punctuality

Replace the 7-minute morning roll call with a 30-second digital check-in. Spot late-coming patterns before they become habits. Send a same-day text to any parent whose child is absent — automatically.

⏱ 50 minutes 📊 Beginner 🎯 4 learning objectives

Learning objectives

  1. Run digital attendance in under one minute per period.
  2. Spot punctuality patterns using a simple spreadsheet.
  3. Build a same-day "your child is absent" parent workflow.
  4. Handle the most common attendance edge cases (sickness, school events, exam days).

Why attendance is a management problem, not a paperwork problem

Every minute of roll call is a minute pupils are unsupervised. Most behaviour incidents in primary and JSS classrooms happen in the first 10 minutes — exactly when teachers are still calling names. Cut roll-call to 30 seconds and you reclaim 4 hours per week.

More importantly: late-coming and absenteeism are leading indicators of disengagement. A pupil who comes late 3 days in one week needs a conversation. A pupil who comes late 8 days in one term may need a home visit.

The Google Form method — 30 seconds, every period

  1. Create one Google Form titled "JSS1A Attendance".
  2. Question 1: Date (auto-fill with today).
  3. Question 2: Period (dropdown — Morning, After Break, Afternoon).
  4. Question 3: Multiple choice grid — rows = pupil names, columns = Present, Absent, Late.
  5. Link the Form to a Google Sheet — every submission becomes a row automatically.
  6. Pin the Form link on your phone home screen. Tap, fill, submit — 30 seconds.

💡 Pro tip

Get your class prefect to fill it during morning prayer. They love the responsibility, and you keep the master record on Drive.

Reading the patterns

Once a week, open the linked Google Sheet. Use a pivot table (Insert → Pivot table) to ask one question:

"How many times has each pupil been Late or Absent in the last 7 days?"

Three numbers to act on:

  • 0–1 late/absent days: No action.
  • 2–3 late/absent days: Quick chat with pupil. Note the reason.
  • 4+ late/absent days: Phone the parent. Document the call in your incident log (Unit 4).

Same-day "your child is absent" workflow

Parents should know the same day, not at the next PTA. Two ways:

  1. Manual (5 minutes): Filter the sheet for "Absent" rows today. Copy each parent's name into a WhatsApp Business template: "Good morning Mrs Adeyemi — Tunde was absent from school today. Please let us know if he is well. — JSS1A teacher."
  2. Automated (advanced): Use a free Google Sheets script (or Zapier free tier) that sends an SMS via Termii or BulkSMSNigeria whenever an "Absent" row is added. We cover the setup in Unit 5.

Edge cases you'll meet every term

SituationHow to mark it
Pupil sick (parent informed)"Absent — Excused". Note reason in a second column.
School-approved event (sports, debate)"Present — Off-site". Counts towards attendance.
Late by 5–10 minutes"Late". Counts as present, but tracked for pattern detection.
Late after 30 minutes"Absent — Late entry". Pupil signs into the late book; parent notified.
Exam day, pupil absentStandard "Absent" plus a flag in your incident log — exam absences are formal.

🎬 Demo — 5-minute setup

Step 1: Open forms.google.com, create a new form. Title it "JSS1A Attendance". 30 seconds.

Step 2: Add a "Multiple choice grid" with pupil names as rows and Present/Absent/Late as columns. 2 minutes.

Step 3: Click Responses tab → green Sheets icon → "Create new spreadsheet". 30 seconds.

Step 4: Copy the form link → save as a bookmark on your phone home screen. 1 minute.

Total: 4 minutes. From tomorrow morning, attendance takes 30 seconds.

✍ Exercise 2.1 — Build your attendance system

Before next Monday:

  1. Build the attendance Form for one class.
  2. Link it to a Sheet.
  3. Run it for one full week.
  4. On Friday, open the Sheet and identify any pupil with 2+ late/absent days. Plan your follow-up.

Deliverable: A screenshot of your Friday pivot summary saved to your "Term 1 — culture pack" folder.

Knowledge check

⚡ Knowledge check

Unit 2 — Attendance & Punctuality

4 questions. Choose the best answer for each.

Question 1 of 4

According to this unit, attendance is primarily:

Question 2 of 4

Which Google Form question type works best for marking a whole class at once?

Question 3 of 4

A pupil has been late 4 times in one week. The right action is:

Question 4 of 4

A pupil who arrives 40 minutes after school start is best marked as:

Unit summary

  • Roll call should take 30 seconds, not 7 minutes.
  • A Google Form + linked Sheet does the job for free.
  • Weekly pivot table = pattern detection in under a minute.
  • Same-day parent notification turns attendance into prevention.