We designed and built Catalog2 — a comprehensive digital gradebook platform spanning Android tablets for teachers, a web application for parents, and an admin dashboard, all powered by a Java backend with offline-first architecture for unreliable school network environments.
The challenge
The traditional paper gradebook was holding schools back. Teachers needed a digital solution that worked reliably in classrooms where Wi-Fi coverage was spotty at best — dropping mid-lesson was not an option. The platform had to serve three distinct user groups with fundamentally different needs: teachers entering grades, absences, and observations on tablets in real time; parents checking their children's academic progress from any device; and school administrators managing classes, subjects, and generating statistical reports. The offline challenge was paramount — tablets had to function flawlessly without an internet connection and synchronize seamlessly when connectivity returned, without data loss or conflicts.
Our solution
We architected the entire platform from the ground up. The teacher-facing Android tablet application was built with native Android and featured a local SQLite database that stored all gradebook data on-device, enabling teachers to enter grades, record absences, and add observations with zero dependency on network connectivity. A sophisticated sync engine handled bidirectional data synchronization when the device reconnected, resolving conflicts automatically using timestamp-based resolution strategies. The parent-facing web application was built with JavaScript and jQuery, providing a clean, responsive interface for viewing grades, absences, attendance statistics, and teacher observations. The admin dashboard delivered comprehensive statistical reporting, class management, and user administration. The entire backend ran on Java with Apache Tomcat, backed by MySQL, with a RESTful API layer serving all three client applications.
Results
- Delivered complete multi-platform education ecosystem spanning tablet, web, and admin interfaces
- Engineered offline-first Android application with automatic conflict-free data synchronization
- Built comprehensive gradebook covering grades, absences, observations, and statistical reporting
- Served three distinct user groups — teachers, parents, and administrators — from a unified backend
- Designed local SQLite storage enabling uninterrupted classroom use without network dependency