Three formulas you will use
| You want | Formula | Example |
|---|---|---|
| Your attendance % | attended ÷ total × 100 | 42 ÷ 56 × 100 = 75% |
| Absences you can still have | floor(total planned × (1 − minimum)) − absences so far | 60 planned classes, 75% minimum: floor(60 × 0.25) = 15; with 9 absences, 6 left |
| Classes in a row to get back to the minimum | (minimum × total − attended) ÷ (1 − minimum) | 30 of 45 attended (66.7%), goal 75%: (0.75 × 45 − 30) ÷ 0.25 = 15 classes |
Maximum absences by course length
| Total classes | Max. absences to keep 75% | Max. absences to keep 80% | Max. absences to keep 90% |
|---|---|---|---|
| 20 | 5 | 4 | 2 |
| 30 | 7 | 6 | 3 |
| 40 | 10 | 8 | 4 |
| 45 | 11 | 9 | 4 |
| 50 | 12 | 10 | 5 |
| 60 | 15 | 12 | 6 |
| 80 | 20 | 16 | 8 |
| 100 | 25 | 20 | 10 |
| 120 | 30 | 24 | 12 |
Round the maximum down: with 30 classes and a 75% minimum, 7.5 absences means 7, because the 8th would drop you to 73.3%.
Days, hours or classes?
Use whatever unit your school counts. A school that counts hours (common in colleges and technical courses) needs hours attended ÷ hours scheduled; see the hours version. In Excel or Google Sheets, the formula is in this sheet guide.
Keep your own count
College, Gambit Studio's attendance tracker app for iPhone, does the math per subject: you enter the minimum attendance your school requires and it shows how many classes you can still miss, next to a class calendar with reminders before classes and exams.