STRATEGEN NET LABS

FEATURED PROJECT

Early Trumpet Educational Foundational School System

School Management System • Software Engineering Project

IN PROGRESS

Project Overview

The Early Trumpet Educational Foundational School System is a school management platform being developed to help schools organize and manage their daily academic and administrative activities in one system.

The system is designed to manage students, teachers, parents, classes, subjects, attendance, assessments, grades, and academic records.

The Problem

Many school activities can become difficult to organize when student information, attendance, grades, assessments, and communication are handled through separate manual processes.

This project explores how a centralized school management system can bring these activities together in a structured digital environment.

The Solution

The Early Trumpet School Management System is designed as a centralized platform where authorized users can manage and access the information relevant to their responsibilities.

Administrators can manage school information, students, teachers, subjects, classes, and academic records, while teachers and parents can access the information provided to them through their respective accounts.

Why I Built It

The idea for this system comes from a real interest in improving how schools organize information and manage their daily academic activities.

The project also gives me an opportunity to apply software engineering, database design, programming, and system development concepts to a practical problem.

Key Features

• Student Registration & Management
• Automatic Student ID Generation
• Teacher Accounts & Subject Access
• Parent/Guardian Accounts
• Class & Subject Management
• Attendance Management
• Grades & Assessments
• Academic Records
• Student Status Management
• Role-Based Access

Technology Stack

• Java
• SQL Server
• SQL
• Database Design
• Object-Oriented Programming
• Software Engineering

Development Status

🟡 In Progress

The project is currently being developed and tested as a real-world software engineering project. Development is focused on building the database structure, application logic, user roles, and core school management features.

System Architecture

The system is being designed as a structured application with separate layers for the user interface, application logic, authentication and authorization, and database management.

• User Interface
• Application Logic
• Authentication & Authorization
• Database Layer

Security & Access Control

The system is being designed with role-based access so that administrators, teachers, and parents only access the information and functions relevant to their responsibilities.

• Administrator Access
• Teacher Access
• Parent/Guardian Access
• Protected Academic Records
• Controlled Grade Submission

User Roles

Academic Workflow

1. Administrator registers the student.
2. The student is assigned to a class and receives the appropriate subjects.
3. Teachers are assigned to their classes and subjects.
4. Teachers record attendance and academic assessments.
5. Grades are stored in the academic records.
6. Parents or guardians can view permitted student information.

Assessment & Grading

The system is designed to support the school's assessment structure and calculate the final subject result from the defined assessment components.

• Quiz — 10%
• Assignment — 10%
• Class Work — 20%
• Test — 60%
• Final Result — 100%

Academic Year Structure

The system is designed around a school year running from September through June.

• 1st Period
• 2nd Period
• 3rd Period & Exam
• 4th Period
• 5th Period
• 6th Period & Exam

Project Timeline

1. Planning & Requirements — Define the school's needs and system requirements.
2. Database Design — Design the database structure and relationships.
3. Core Development — Build the major school management modules.
4. Testing & Security — Test functionality, access control, and data handling.
5. Pilot Deployment — Test the system in a real school environment.
6. Production Deployment — Prepare the system for real-world use.

Future Vision

The long-term goal is to develop the Early Trumpet Educational Foundational School System into a reliable school management platform that can be deployed and adapted for real schools.

Future development may include notifications, reporting, parent communication, online assignments, dashboards, cloud deployment, and additional administrative tools.

Database Design

The system uses a relational database structure designed to organize school information and maintain relationships between students, teachers, parents, classes, subjects, attendance, assessments, and grades.

• Student Records
• Teacher Records
• Parent/Guardian Records
• Classes & Subjects
• Attendance
• Assessments & Grades
• User Accounts & Roles

Development Roadmap

1. Database Architecture
2. Core Student Management
3. Teacher & Parent Accounts
4. Attendance & Academic Records
5. Grades & Assessment Management
6. Testing & Security
7. Pilot Deployment
8. Production Deployment

Systems, experiments, and technology solutions developed through Strategen Net Labs.

Current Objective

The current objective is to complete the core database and application architecture, then progressively develop and test the major school management modules.