Wan Salleh, Wan Muhamad Salahudin and Abd. Rahim, Nour El Huda and Abdullah, Aszrin and Pakeer, Aniza (2026) SmartTasjeel: a GPS-based automated attendance tracking system for medical education built on microsoft powerApps. International Journal of Allied Health Sciences, 10 (2). pp. 3454-3460. E-ISSN 2600-8491
|
PDF
- Published Version
Download (1MB) | Preview |
Abstract
Background: Attendance in medical undergraduate programmes is consistently associated with academic performance, which makes accurate per-session tracking essential for early identification of at-risk students. At the Department of Basic Medical Sciences, Kulliyyah of Medicine, International Islamic University Malaysia, the previous biometric thumbprint system captured only twice-daily entries and excluded students with dermatological conditions affecting fingerprint recognition. This made per-session attendance percentage calculations impossible to automate. Methods: We developed SmartTasjeel, a GPS-based attendance system built entirely on free Microsoft 365 Education licences using PowerApps, SharePoint Online, and Excel with Power Query. The system uses geofencing validation with a 0.001-degree tolerance (approximately 110 metres at the campus latitude) and matches each time-in to a session pulled from track-specific timetables. It was deployed for 285 students across three curriculum tracks. Results: Per-session attendance processing dropped from 30 minutes (paper) or 10 minutes (biometric queues) to under 15 seconds. Weekly percentage calculations dropped from around 2 hours of manual computation to under 30 minutes of automated dashboard review. Data granularity increased from a maximum of 10 weekly capture points (biometric) to 20–25 per student (per-session). No calculation errors were reported by coordinators over two academic semesters. Hardware cost dropped from RM3,500–7,000 (biometric machines) to zero. Students previously excluded by fingerprint recognition issues were able to participate. Conclusion: SmartTasjeel demonstrates that GPS-based automated attendance tracking can be implemented using only free Microsoft 365 Education licences, with no premium connectors, no custom code, and no additional hardware purchase. The architecture is transferable to other institutions and the per-session data structure supports policy enforcement, warning-letter workflows, and student self-monitoring. Future work should formally evaluate whether real-time attendance feedback influences student attendance behaviour and academic performance.
| Item Type: | Article (Journal) |
|---|---|
| Uncontrolled Keywords: | Attendance tracking; GPS geofencing; medical education; PowerApps; digital transformation |
| Subjects: | A General Works > AI Indexes (General) L Education > L Education (General) R Medicine > R Medicine (General) T Technology > T Technology (General) |
| Kulliyyahs/Centres/Divisions/Institutes (Can select more than one option. Press CONTROL button): | Kulliyyah of Medicine Kulliyyah of Medicine > Department of Basic Medical |
| Depositing User: | dr wan muhamad salahudin wan salleh |
| Date Deposited: | 06 Aug 2026 00:34 |
| Last Update: | 06 Aug 2026 00:34 |
| Queue Number: | 2026-08-Q4530 |
| URI: | http://irep.iium.edu.my/id/eprint/128563 |
Actions (login required)
 |
View Item |