FCOPTS — Francisco Pontes
Download CV🇺🇸
01Home02About03Skills & Tools04Projects05Journey06Blog07Contact
Case Study

2nd CPM-CHMJ: Cloud-Based Academic Management for a Military Police School

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.

PHPPHP
LaravelLaravel
C#C#
.NET.NET
AngularAngular
PostgreSQLPostgreSQL
DockerDocker
GitGit
JiraJira
GrafanaGrafana
Portal de sistemas do 2º CPM-CHMJ (Com3 Brasil)
Project typeWeb+Admin System / PWA
RoleFull Stack Developer
AffiliationTime at Com3 Brasil
Idealized byCom3 Brasil
StatusIn production
Duration1.2 years in production

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.

Before and After: Home Screen Evolution

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.

Tela inicial original do sistema: menu azul sem nenhuma visão geral
Before — login drops straight into the menu, with no overview at all.
Protótipo da nova tela inicial: dashboard com indicadores, gráficos, ocorrências e agenda
After — a dashboard with KPIs, performance by grade, finance, occurrences and agenda.

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.

Variante do protótipo com menu de navegação lateral fixo
Explored variant with a fixed side menu, same indicators and quick access.

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.

Protótipo redesenhado da tela de Inserir/Atualizar Notas, com situação calculada em tempo real
Grade-entry prototype: status (passed/remediation/failed) calculated and color-highlighted live.

Context and Scope

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.

Modules on the systems portal

  • Main — central access to all of the school's systems
  • Online Report Card — grade tracking for parents and students
  • DAE — generating payment slips for tuition
  • Behavior — viewing disciplinary badges

Modules and Functional Domain

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.

Administration

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.

Finance

Payment amounts and status, and generating/printing DAE (State Revenue Collection Document) for school fees and enrollment.

Coordination

Confirm/reopen grades, lock or change answer keys, grade entry across multiple tracks (SAC, Elective, Trail) and curricular follow-up plans.

Behavior

Score-based discipline engine (CAD): occurrence type, justification, referral, closure and automatic recalculation of the behavior grade.

Agenda

Events, the school calendar, and logging class activities and content by subject.

Registry

Central entity repository: teacher, student, class, subject, guardian, monitor, psychologist, school coordinator, among others.

Library

Checkout and return cycle for the library collection, tied to the student's SIGE code and expected return dates.

Reports

Report cards, remediation, pre-enrollment and a grade-change log for auditing, plus pedagogical, financial and front-office cuts.

Behavior: discipline as measurable data

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.

Tela de Cadastro de Ocorrência do módulo Comportamento (CAD)
Occurrence registration: score, phase, and the "Date for Delivery to the Commander" field reflecting the school's military chain of command.
Tela de Consulta de Justificativa, com reincidência e situação por aluno
Justification Query: recurrence, responsible monitor and justification status per occurrence.

External integrations: SIGE and DAE

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.

Tela de Pré-Matrícula mostrando SIGE, situação de confirmação e de pagamento (dados pessoais removidos)
Pre-Enrollment: SIGE, confirmation and payment status side by side. Personal data redacted for this publication.

Grading, library and registry

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).

Tela de Inserir/Atualizar Notas mostrando colunas NA, VE, MVE e VC (nomes de alunos removidos)
Grade entry with the NA/VE/MVE/VC model. Student names redacted for this publication.
Tela de Boletim mostrando notas por bimestre, média final e resultado (nomes de alunos removidos)
Report card consolidated by bimester/semester, with final average and result. Student names redacted for this publication.
Tela de Retirada da Biblioteca (nomes de alunos removidos)
Library checkout cycle, tied to the student's SIGE code. Student names redacted for this publication.
Formulário de Cadastro de Professor (campos vazios)
Teacher Registration: full record with CPF, address and demographic data (blank form).

Agenda and configuration

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.

Formulário de Cadastro de Atividades por disciplina e turma (campos vazios)
Activity Registration: content, activities and homework by subject/class (blank form).
Tela de Textos/Mensagens do Sistema, configurada por bimestre
System Texts/Messages: report-card notices configured per bimester.

Audit and traceability

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.

Menu de Relatórios expandido, incluindo o submenu Pedagógico e o Log de Alteração de Notas
Reports menu: the Pedagogical submenu and the Grade Change Log used for auditing.

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.

Protótipo de boletim individual para impressão, com código de autenticidade
Individual print-ready report card prototype, with a document authenticity code.

Multiple Access Channels

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).

Report Card and Behavior

Sistemas CPMCE — Com3 Brasil platform, to check grades and disciplinary badges.

Student Portal

Shows the interaction between school, parents and students in one place.

Virtual Environment (EAD)

The institution's own EAD platform, accessible via the EAD 2nd CPM-CHMJ link.

Cloud Architecture and Security (AWS)

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.

Per-service isolated containers

COM3 (PHP/Laravel) and the academic API (C#/.NET) run in separate Docker containers, so one can be updated without affecting the other.

Role-based access control

The school, SEDUC, teachers, parents and students only see what's relevant to their role in the system.

Backups and continuity

Automated database backups protect critical report card and behavior data against loss.

Encrypted traffic

End-to-end TLS between clients (PWA/Web) and the load balancer, protecting sensitive data in transit.

Observability with Grafana

Dashboards track system health, with alerts firing before an issue affects school hours.

Delivery traceability

Versioning with Git and task management in Jira, giving traceability to every change shipped to production.

Parents and StudentsReport card, behavior, EADPWASchool (Admin)COM3 academic managementAWS CLOUDLoad Balancer (HTTPS/TLS)Routes by domain/serviceCOM3 — PHP/LaravelReport card, behavior, DAEDocker containersAPI — C# / .NETAcademic rules and integrationsDocker containersAdmin Panel — AngularRoles: school, SEDUC, teachersPostgreSQL (RDS)Automated backupsStorage — EAD/FilesEAD environment contentGrafanaSystem health monitoringAlerts ahead of school hoursSecurity and AccessRole-based access controlEnd-to-end TLS + isolated backupsEAD Environmentcpmce.com.br/ead2cpmIndependent school access

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.

Continuity with a Smaller Team

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.

Project Impact

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.

Affiliation and Rights

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.

Key Challenges Faced

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.

1Challenge

Keeping the system stable after the team shrank from 4 to 3 developers mid-project

2Challenge

Ensuring the security of sensitive academic data (grades, behavior, minors' data) in the cloud

3Challenge

Integrating multiple channels — the COM3 System, SEDUC's Aluno Online portal and the EAD environment — under a single identity

Structural Technical Indicators

  • 2,350+ active users among parents, students and school staff
  • 99.9% uptime during the school year
  • -40% weekly corrective maintenance after backend restructuring
  • MVP delivered 2 months ahead of schedule
  • AWS cloud backend, with observability via Grafana

Tech Stack

PHPLaravelC#.NETAngularPostgreSQLDockerGitJiraGrafana

Liked it? Get in touch!

Send me a messageSee other projects
© 2026 Francisco Pontes
Privacy·Check out my blog