In my local city I took on a project for a private school. To help them digitize their school management and bring everything to one system.

Scope & tech stack

The project scope is a bit bigger and it can not be finished in a few weeks. It took me 2 months to get into the end result.

I used Node.JS, MySQL and Angular. These stacks help me to speed up the development. Using Angular Material helps simplify the forms designs. MySQL database is best suited for this situation. We want a relational database as the architecture requires a lot of joining tables and querying using SQL. Overall I design in a simple and scalable way.

User roles & permissions

School has different user authorization with different account types. It works like Agent and Admin. But this one has more than two account types. Registrar, Teacher, Director and some other.

Teachers have only the ability to add students' marks and take attendance. You can not insert a mark if the class is not assigned to you. Directors have the higher access over the application. They are the one who will give account to employees and plan the academic semester.

Reports

Building reports is much easier. We have everything we need. We have grade results. We have attendance. We can build a roster. Calculate RANK for each semester. These and other few things become possible as we collect the raw data, which makes it easier to drive any necessary information from it.