Project | SEGi SMS

Project Overview

System Name: Student Management System (SMS)

Aims: To allow the lecturer to manage students, courses, and semesters while monitoring the student grade reports.

Technologies Used: Java, Local File Storage, Apache NetBeans

Development Time: April 2024 (Assignment of Advanced Programming)

Features: -

Provided a dashboard displaying key system metrics and student performance insights
Allowed lecturers to add, edit, and delete students and courses (can set predefined courses).
Enabled lecturers to manage semesters, including student enrollment and grade entry.
Generated student grade reports with graphical GPA trends.

Relevant System Demonstrations (8 Main Features)

Dashboard Page
Manage Students
Manage Courses

Manage Semesters
Grade Report

(1) Dashboard Page

The system currently supports a single lecturer login for demo purposes. After logging in, the lecturer sees a dashboard with key metrics like total students, courses, and semesters, along with charts for gender distribution, program distribution, and semester GPA trends.

(2) Manage Students

Lecturers can add, edit, and delete student records, with all student data stored in a dedicated file.

(3) Manage Courses

This feature allows lecturers to create, edit, and delete courses while setting prerequisite course(s). The course data are stored in another separate file for management.

(4) Manage Semesters

Lecturers can enroll students in courses within a semester. Once grades are entered, the system automatically calculates the student's GPA, ensuring accurate academic tracking. The semester data are stored in another separate file for management.

Prerequisite Course Validation: If a lecturer attempts to enroll a student in a course without completing its prerequisite, the system will alert the lecturer.
Semester Enrollment Restriction: Each student can only be assigned to a specific semester (e.g., Y1S1 for Year 1 Semester 1) once. If the lecturer attempts to re-enroll a student in the same semester, an error dialog will be displayed.

(5) Grade Report

A student's GPA and CGPA history can be viewed across multiple semesters. The system also provides visualizations through bar charts, making it easier to analyze academic performance trends.

Problem Solved by SMS

1. Course Prerequisites

Enables lecturers to set course prerequisites during course creation, automatically ensuring that student enrollment in a semester will follow the correct course progression.

2. Visual Representation of Student Performance

Uses charts to illustrate GPA trends, improving academic tracking.

Future Improvements

1. Multi-User Authentication

The current system is hardcoded for lecturers to log in. In future, a database (transition from file-based storage to MySQL) can be implemented to support multiple user roles, such as admins for managing lecturer accounts.

2. Export Functionality

Currently, the system only allows users to view reports. In future, it can incorporate an export feature, enabling users to download reports in PDF, CSV, or other file formats.