EdMgmt Assessment Tool

A Flutter application built for test centres and teachers to rapidly grade students in real-time. It completely bypasses traditional databases in favour of using Google Sheets as a headless CMS, powered by a custom Google Apps Script API.

Because test environments often have poor internet, the app is built completely offline-first. It caches the latest roster and rubric data locally, allowing examiners to score entire sessions offline and sync them when the connection is restored.

The backend features a highly optimized Apps Script instance using a Versioned Cache pattern for sub-100ms response times, and tracks changes using cryptographic device signatures so edits are attributable without requiring user accounts.

• Direct read/write integration with Google Sheets
• Robust offline-first support for uninterrupted classroom grading
• Instant loading speeds using Apps Script CacheService
• Cryptographic device signatures for edit accountability
• Dynamic scoring rubrics synchronized from the spreadsheet
• On-device generation of print-ready PDF reports

• Flutter (Web & Mobile) with BLoC state management
• Clean Architecture mapping strictly to spreadsheet schemas
• Google Apps Script (ES5 JavaScript) REST API backend
• Google Workspace Drive API for PDF report storage
• Local storage for aggressive read-caching