Attendance Register and Percentage Calculator

This attendance register keeps a monthly class register and does the attendance maths. Pick the month and school days, add holidays and your class list, and click each cell to mark present, absent, late or excused. Each student's attendance percentage updates as you go, with a warning when it falls below the minimum (75% by default), how many days in a row they must attend to recover, or how many they can still miss. Marks are saved in your browser and export to CSV; registers from other systems can be imported in batch.

Reaching 75% from 20 days

Present so farAttendanceStatus
1260%Attend next 12
1470%Attend next 4
1575%Can miss 0
1890%Can miss 4

When to use it

  1. Take daily attendance without a paid system.
  2. Find students below the 75% exam eligibility rule.
  3. Tell a student how many classes they must attend.
  4. Export a monthly register for the office.
  5. Check a student's own attendance shortfall.

How to Use

  1. Pick the month, school days and holidays.
  2. Paste the class list.
  3. Click cells to mark attendance.
  4. Read percentages and export the CSV.

Features

  1. Monthly register grid
  2. Present, absent, late, excused
  3. Shortfall and recovery days
  4. Saved in the browser
  5. CSV export and batch import
  6. 100% client-side

FAQs

How is attendance percentage calculated?

Days present ÷ total days × 100. 14 present out of 20 is 70%.

How many classes do I need to reach 75%?

At 14 of 20, attending the next 4 gives 18 of 24 = 75%.

How many can I miss and stay at 75%?

At 18 of 19, you can miss 5: 18 ÷ 24 = 75%.

Where are the marks saved?

Only in this browser. Export the CSV to keep a copy.

Is anything uploaded?

No. Everything runs in your browser; class lists and scores never leave your device.

Technical Details

School days are the chosen weekdays of the month minus holidays. Each cell cycles Present, Absent, Late and Excused; late can count as present and excused days can be left out. Attendance % = days present ÷ days counted × 100. Below the target, the days needed in a row to recover is the smallest n with (present + n) ÷ (total + n) ≥ target; above it, the days a student can still miss is the largest n with present ÷ (total + n) ≥ target. Registers export to CSV, and imported registers or present/total figures are calculated in batch.

Education Tools

Education Tools

  • Math Worksheet Generator
  • Flashcard Maker
  • OMR Answer Sheet Maker and Grader
  • Chemical Equation Balancer
  • Centrifuge RPM to RCF Calculator
  • Hemocytometer Cell Counter
  • PCR Master Mix Calculator
  • DNA Sequence Toolkit