COM3 System + Aluno Online Portal (SEDUC) + EAD Environment
School management system for the 2nd Military Police School Coronel Hervano Macêdo Júnior, built while I worked at Com3 Brasil. The COM3 System handles academic and administrative management (report cards, behavior, DAE), integrated with SEDUC's Aluno Online portal and a dedicated EAD environment, with a backend hosted on AWS cloud infrastructure.

The 2nd CPM-CHMJ school system integrates academic, behavioral and financial management into a single ecosystem — the COM3 System, SEDUC's Aluno Online portal and an EAD environment — backed by a robust, secure AWS cloud backend.
On login, the user landed directly on a blank blue menu bar — no overview at all, just module tabs and an empty screen until you picked something to open. As a prototype for the product's next evolution, I designed a data-first home screen: key indicators (active students, delinquency, overall average, occurrences this week), a performance-by-grade chart, the month's financial status, latest occurrences, upcoming events and quick access to every module — all visible without navigating anywhere.


I also explored a variant with a fixed side navigation, keeping the same indicators and the same quick access to modules — useful for taller screens and for shortening the distance between menu and content during long work sessions.

The same redesign care extended to grade entry: class, subject and bimester stay visible at the top, and each student's status (passed, in remediation, failed) is calculated and color-highlighted as soon as grades are typed in — no need to save and open another screen just to check the result.

The school system of the 2nd Military Police School Coronel Hervano Macêdo Júnior (2nd CPM-CHMJ) is the COM3 system (v9) used by the school for academic and administrative management: report card tracking, behavior badges, and DAE issuance for tuition payments. The system is complemented by SEDUC's Aluno Online portal, which gives visibility into student progress, and by the school's own EAD environment.
Behind the public portal, the COM3 core used by the school's front office and coordination team organizes its workspace into nine functional groups — Administration, Finance, Coordination, Behavior, Agenda, Registry, Library, Grades and Reports — with a tabbed navigation pattern that keeps several screens open at once (e.g. Occurrence, Teacher, Activities, Checkout and Report Card simultaneously), avoiding reloads during front-office work.
Users, importing prior-year grades, answer keys, the full grading cycle (enter, calculate, replicate, lock/unlock report card), automatic behavior and performance badges, and class migration.
Payment amounts and status, and generating/printing DAE (State Revenue Collection Document) for school fees and enrollment.
Confirm/reopen grades, lock or change answer keys, grade entry across multiple tracks (SAC, Elective, Trail) and curricular follow-up plans.
Score-based discipline engine (CAD): occurrence type, justification, referral, closure and automatic recalculation of the behavior grade.
Events, the school calendar, and logging class activities and content by subject.
Central entity repository: teacher, student, class, subject, guardian, monitor, psychologist, school coordinator, among others.
Checkout and return cycle for the library collection, tied to the student's SIGE code and expected return dates.
Report cards, remediation, pre-enrollment and a grade-change log for auditing, plus pedagogical, financial and front-office cuts.
Being a militarized school, the Behavior module treats discipline as a grade: each occurrence has a type, classification, referring teacher, score, phase and status — plus a "Date for Delivery to the Commander" field, which embeds the military chain of command directly into the approval flow. A monitor tracks recurrence and justifications per student, and the cycle is closed by automatic behavior-grade (CAD) generation and recalculation routines.


Every student carries an external SIGE code (with its own correction routine), most likely tied to the state network's integrated school management system — pointing to direct interoperability with Ceará state government databases. The Finance module closes that loop by issuing DAE for school fees and enrollment — the same document used for state revenue collection — with pre-enrollment status tracking confirmation and payment side by side.

Grading follows a four-bimester model consolidated into two semester grades, with its own nomenclature (NA, VE, MVE, VC) feeding into the final average and result (e.g. 8.78 → "PASSED"). The Library runs a conventional loan cycle integrated with the student base, and the Registry backs full records — the teacher record, for instance, includes CPF, education level, marital status, race/ethnicity, religion and a detailed address (state, municipality, district, ZIP code).




The Agenda module logs class content and activities — including homework — by subject and class, while the system lets staff configure report-card texts and messages per bimester (e.g. appeal deadlines, grade-adjustment guidance), avoiding recurring manual edits at each closing period.


The Reports module reinforces the system's accountability posture: beyond report cards and pedagogical, financial and front-office cuts, it keeps a dedicated Grade Change Log for auditing — important for a system handling academic and disciplinary data of minors.

As a prototype evolution of this module, I also designed an individual report-card template ready for print/PDF — with enrollment and guardian data, per-subject/per-bimester grades, consolidated attendance and behavior, and an authenticity code to validate the electronically issued document.

The 2nd CPM-CHMJ ecosystem is made up of three fronts that need to talk to each other without confusing the end user: the Systems portal (Com3 Brasil), the Student portal — which shows the interaction between school, parents and students — and the Virtual Learning Environment (EAD).
Since it handles academic and disciplinary data of minors, the system's backend was hosted on AWS infrastructure, prioritizing robustness and security: containerized services behind a TLS-terminated load balancer, a managed PostgreSQL database with automated backups, and isolated storage for the EAD environment's content.
COM3 (PHP/Laravel) and the academic API (C#/.NET) run in separate Docker containers, so one can be updated without affecting the other.
The school, SEDUC, teachers, parents and students only see what's relevant to their role in the system.
Automated database backups protect critical report card and behavior data against loss.
End-to-end TLS between clients (PWA/Web) and the load balancer, protecting sensitive data in transit.
Dashboards track system health, with alerts firing before an issue affects school hours.
Versioning with Git and task management in Jira, giving traceability to every change shipped to production.
The result is a backend built for robustness and security: containerized services isolated by domain, a managed database with automated backup, always-encrypted traffic, and continuous observability over a system used daily by parents, students and the school's administration.
During the project, the team shrank from 4 to 3 developers without interrupting the system's operation for the school. Restructuring processes and standardizing delivery through Jira and Git helped cut weekly corrective maintenance by 40%, freeing up room to keep evolving the product even with fewer people on the team.
The systems portal MVP was delivered 2 months ahead of schedule, which gave room to stabilize the report card and DAE modules before the school's critical grade-closing periods.
The 2nd CPM-CHMJ school system now sustains over 2,350 active users among parents, students and school staff, with 99.9% uptime during the school year. AWS cloud infrastructure and the integration between COM3, Aluno Online (SEDUC) and the EAD environment gave the school a single digital ecosystem for academic, behavioral and financial management.
This system was built during the period I worked as a developer at Com3 Brasil, the company that conceived and owns the product. All rights to the project, including brand, source code and other materials, are reserved to Com3 Brasil and the 2nd Military Police School Coronel Hervano Macêdo Júnior. This case study is presented solely to demonstrate the technical work performed.
A school system used daily by parents, students, teachers and the school's administration cannot fail on critical dates like report card closing. That brought concrete challenges around stability, security and team continuity.
Keeping the system stable after the team shrank from 4 to 3 developers mid-project
Ensuring the security of sensitive academic data (grades, behavior, minors' data) in the cloud
Integrating multiple channels — the COM3 System, SEDUC's Aluno Online portal and the EAD environment — under a single identity