Key Facts
Fridaskolorna was looking for a smart school management system. However, the market could offer either school management ERP systems packed with excess features or small components automating just a few processes. Thus, the Client decided to encapsulate those smaller components into a comprehensive system addressing all their needs in full.
Apart from the web services integration and UI development, we identified several areas that the external components could not cover and developed custom modules to fill those gaps.
- Requirements & external components investigation, solution architecture design
- UI concept and screens development
- Third-party services integration (Visma, Vklass, Gsuite by Google Cloud, and Skolon)
- Custom modules development
- Security Testing on OWASP TOP 10 most critical tasks
- Ongoing support & maintenance of the school management app adding new functionality on the regular basis
Data Migration
One of the essential tasks of this project was to safeguard data consistency and security through the migration process as the old database had multiple interrelations and a lot of personal info. We created a new well-structured database, migrated all the data, and ran data cleaning to ensure data integrity.
Our sound strategy, well-defined migration plan, and great teamwork from both our engineers and the Client allowed to perform fast and accurate data migration.
- Elaborated and documented data structuring approach (together with the Product Owner)
- Migrated 10 000+ users to the new database preserving all the rules and interrelations between the entities
- Created corresponding SQL scripts and cleansed all the data (excluded duplicates & inconsistencies, added missing points, etc.) in only 2 weeks
- Data cleansing went in close collaboration with Fridaskolorna representatives to safeguard data integrity and consistency
Developed from Scratch
We developed an intuitive Web Interface enabling users access all the system functionality through a single gateway. Our major focus in the UI development was to make it simple and clear so that school personnel could reach all the necessary functions in as little clicks as possible.
Since there were demands that couldn’t be covered by integrations, it was decided to develop a set of additional modules from scratch, including:
- User Administration module allows to manage user profiles and their access rights as well as group students into classes and link head teachers
- Budget module collects financial data from the external systems and returns into a dashboard outlining planned vs spent budget for each school per year
- Dashboard module performs regular system checkups and displays emerging issues concerning e.g. duplicate invoice or pupil
