Madrasah Master Attendance & Quran Log
Clean, pre-formatted spreadsheet template engineered for Islamic schools and Maktabs. Features automated attendance calculations, separate weekend/weekday schedules, Sabaq/Sabqi Quran tracking, and parent emergency rosters.
Explore What's Inside the Workbook
Click across the 5 worksheets below to preview the formatting, formulas, and layouts included in your download.
Madrasah Master Attendance & Quran Log
Includes 5 pre-built worksheets with automated COUNTIF attendance calculations, Hifz logs & emergency rosters.
| Roll # | Student Name | 1 Th | 2 Fr | 3 Sa | 4 Su | 5 Mo | 6 Tu | 7 We | ... | Present | Absent | Late | Excused | Att. % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| M26-001 | Zayd Abdullah | P | P | - | - | P | P | L | ... | 21 | 0 | 1 | 0 | 97.7% | ⭐️ Excellent |
| M26-002 | Ibrahim Hassan | P | P | - | - | A | P | P | ... | 19 | 2 | 1 | 0 | 88.6% | ✅ Good |
| M26-003 | Maryam Al-Mansoor | P | P | - | - | E | E | P | ... | 20 | 0 | 0 | 2 | 90.9% | ⭐️ Excellent |
| M26-004 | Umar Farooq | A | P | - | - | A | L | A | ... | 15 | 5 | 2 | 0 | 72.7% | ⚠️ Follow-up |
Automated Monthly Formulas
Pre-configured =COUNTIF() formulas automatically total Present, Absent, Late, and Excused days with instant percentage rates and low-attendance alerts.
Weekday & Weekend Tabs
Includes separate dedicated layouts for both 5-day full-time weekday Maktabs (Mon–Fri) and 2-day Saturday/Sunday weekend Islamic schools.
Sabaq & Sabqi Recitation Columns
Built specifically for Quran & Hifz classes with dedicated columns for Sabaq (new lesson), Sabqi (recent revision), Manzil (distant revision), and standard Mumtaz/Jayyid grading.
Parent Emergency Directories
Immediate emergency contacts with Father/Mother mobile numbers, WhatsApp availability indicators, medical and allergy alerts, and authorized pickup notes.
This .xlsx file is 100% natively compatible with Google Sheets without any formatting loss or broken formulas:
- Download the file above to your computer or phone.
- Go to drive.google.com or sheets.google.com, click + New → File Upload, and select the downloaded file.
- Click the uploaded file to open it in Google Sheets. All sheets, freeze panes, and COUNTIF formulas will work immediately!
Tired of manual cell editing, broken formulas & texting parents one-by-one?
Spreadsheets are a good starting point, but as your Madrasah grows, manually tracking 30+ students across months becomes exhausting. MadrasahSync replaces spreadsheets with 1-tap roll calls on mobile, automated WhatsApp attendance alerts to parents, and automated student progress report cards—free for up to 30 students.