Case study · Offline attendance app for Android
Atmark
An offline Android app for class attendance and team work hours, live on Google Play. Records stay on the phone: no account, no server, no ads.
By Arpan Patra · Updated

The problem
Taking attendance is a small daily task, yet the apps I tried were slow, overloaded with features, or stored students’ details on someone else’s server.
Atmark opens fast, works without internet and keeps every record on the phone. It is built for teachers and anyone else who takes attendance, and, with the Work Hours addon, for small teams that track hours.
What it does
- Unlimited classes and students. Mark present or absent in one tap, for today or any past date.
- Roster import from CSV or Excel: map the columns, preview the students and fix rows before saving.
- Attendance percentage and calendar history for each student, plus insights that show patterns.
- Monthly PDF reports, shared straight from the phone.
- Search, class archiving and local backups.
- Work Hours addon (activated separately): several sessions per person, checks for missing times, daily to yearly summaries, and PDF or CSV exports. No location tracking.
Architecture and data
Screens are Expo Router routes and never query the database directly. All SQL sits behind typed repositories (classes, students, attendance, archives, insights, Work Hours), so the logic can be tested without a device.
Records live in SQLite (expo-sqlite) in the app’s private storage; AsyncStorage holds only preferences. A migration that runs once moved data from the earlier storage format, so existing installs kept their records. Data leaves the phone only when the user exports, shares or backs up a file.
Engineering decisions
- Offline only. The earlier version (React Native CLI, WatermelonDB, Supabase sync) shared records across devices; the 2026 rebuild drops accounts and cloud sync, so no server ever holds student data.
- Safe over the air updates. JavaScript fixes ship through EAS Update; native changes ship as a new store build. The runtime version follows the app version, which is bumped on every native change, so an update only reaches installs it is compatible with.
- Edge to edge display, which Android 16 makes mandatory. Version 1.5.1 sets the system bar style at runtime, so the status and navigation bars follow the theme chosen in the app, not the device theme.
Testing
TypeScript runs in strict mode. Jest suites cover the repositories, attendance logic, CSV and Excel import, PDF generation, backups, migrations and Work Hours calculations, plus a performance suite. Database tests run against SQLite in Node, with no emulator.
Privacy and permissions
No account and no ads. Atmark does not ask for location, camera, microphone or contacts access. It uses the internet for app updates and when the user shares a file, and reads files only when the user picks a roster to import.
Distribution and source code
Published on Google Play under my developer account, with atmark.app as the official site. EAS Build produces an APK for testing and an Android App Bundle for the store.
The current app lives in a private repository; the earlier version is public on GitHub (ARPANPATRA111/AtMark) and no longer maintained.