🎓 BSIT Capstone Project · 2024

Enrollment & Records
Management System

A desktop system built for Sagsagat Elementary School to replace their manual enrollment process. Handles student enrollment, profiling, grade management, and book monitoring — all in one place.

View Features
4.69
ISO 25010 Rating
RAD
Methodology
v1.0
Version
UNP
Capstone 2024

Everything the school needed

Each feature maps directly to a real workflow in Sagsagat Elementary School — from the first day of enrollment to handing out books.

🔒

Secure Login

Role-based access control separates admin and teacher accounts. Only authorized personnel can view or modify student records.

📋

Student Enrollment

Register new, returning, and transferee students digitally. Supports DepEd's Enhanced BEEF form requirements and maps to standard DepEd Order No. 35, s. 2022.

👤

Student Profiling

Store complete student records including personal information, enrollment year, grade level, section, and contact details in a searchable database.

📊

Grade Management

Enter subject grades and compute general averages automatically. Saves teachers from manual calculation and reduces errors on report cards.

📚

Book Monitoring

Track book releases and returns per student. Logs the condition of returned books and flags unreturned ones — replacing the school's manual Brigada Eskwela records.

📂

Record Retrieval

Search and pull any student's file in seconds. Authorized staff can retrieve, copy, and hand over records without digging through physical cabinets.

📤

Transfer Records

Handles the student record retrieval and handover process for transferees. Tracks who requested records and when, with a log for unauthorized attempts.

💾

Data Backup

Admin-controlled database backups stored locally. All data stays on school hardware — no cloud dependency, no third-party servers.

See how it works
without sign-up

Sample data only. Nothing is saved and it resets every session.

Demo uses read-only in-memory data

Browse the enrollment and student profile modules
Check grades, averages, and book status
Search and filter student records
No login needed — just click Launch Demo
SES-ERMS  ·  Dashboard
Total Students
84
Enrolled This Year
17
Books Released
312
Books Unreturned
8
Recent Enrollees
Maria Santos   Grade 1New
Jose Reyes   Grade 3Old
Ana dela Cruz   Grade 5Transfer
Enrollment progress
68%

Rated Excellent across all criteria

The system was evaluated by teachers and school administrators at Sagsagat Elementary School using the ISO 25010 quality standard. Grand mean was 4.69 out of 5.

Functional Suitability
4.73
Excellent
Performance Efficiency
4.57
Excellent
Compatibility
4.78
Excellent
Usability
4.68
Excellent
Security
4.71
Excellent
Grand Mean
4.69
Excellent

Built for low-spec Windows machines

The school runs on modest hardware with limited internet. The system was designed to match that.

C# / .NET
The primary language used for the Windows desktop application. Provides native performance and integrates cleanly with SQL Server for data operations.
SQL Server
Handles all student records, enrollment data, grades, and book logs. Chosen for its reliability and compatibility with Windows school environments.
Windows Forms
The UI framework for building the desktop interface. Fast to develop, familiar to users, and runs well on older Windows hardware without extra dependencies.
RAD Methodology
Rapid Application Development allowed the team to get working prototypes in front of the school early. Feedback from teachers shaped each iteration before the final build.
Crystal Reports
Generates printable student record reports, enrollment summaries, and grade sheets. Documents come out formatted and ready for official school use.
Windows Desktop App
Runs entirely offline on any Windows PC. No internet, no browser, no external service — the school can use it even during connectivity issues.
Get in Touch

Want to know more about this project?

Reach out to Yaksharo for questions about the system or similar capstone work.

✉️
Email
support@yaksharo.xyz
🌐
Website
yaksharo.xyz
🇵🇭
Location
Ilocos Region, Philippines
Back to Portfolio
Demo Mode — Sample data only. Nothing is saved. Resets on refresh.

Dashboard

Total Students
84
Enrolled This Year
17
Books Released
312
Unreturned Books
8
Grade 1 Students
22
Grade 2 Students
19
Grade 3 Students
21
Grade 4 Students
14
Grade 5 Students
8
New Transferees
3

Recent Enrollees — SY 2023-2024

17 students
#Student NameGrade LevelTypeDate EnrolledStatus
1Maria SantosGrade 1New2023-07-25Active
2Jose ReyesGrade 3Old2023-07-25Active
3Ana dela CruzGrade 5Transfer2023-07-26Active
4Juan BautistaGrade 2Old2023-07-26Active
5Liza DomingoGrade 4New2023-07-27Active
6Carlo AbadGrade 1New2023-07-28Active

Student Enrollment

New Enrollment Form — Enhanced BEEF

Enrollment List — SY 2023-2024

LRNNameGradeSectionTypeActions

Student Records

LRNNameGradeSectionTypeAverageActions

Grade Management

Select Student

Subject Grades

Select a student to load grades

Grade Summary — SY 2023-2024 Q1

StudentGrade LevelFilipinoEnglishMathScienceMAPEHAverageStatus
Maria SantosGrade 1889185909289.2Passed
Jose ReyesGrade 3798375808480.2Passed
Ana dela CruzGrade 5929088949191.0Passed
Juan BautistaGrade 2747068727672.0Failed
Liza DomingoGrade 4858782868885.6Passed

Book Monitoring

Total Books
320
Released
312
Returned (Good)
280
Unreturned / Damaged
8

⚠️ Unreturned Books

8 items
StudentGradeBook TitleDate ReleasedStatusActions
Juan BautistaGrade 2Science 2 Textbook2023-07-28Unreturned
Carlo AbadGrade 1Filipino 1 Textbook2023-07-28Damaged
Maria SantosGrade 1Math 1 Textbook2023-08-01Unreturned

Available Books — SY 2023-2024

Filipino 1
Grade 1 · 22 copies
Available: 20
Math 2
Grade 2 · 19 copies
Available: 17
Science 3
Grade 3 · 21 copies
Available: 21
English 4
Grade 4 · 14 copies
Available: 14
Araling Panlipunan 5
Grade 5 · 8 copies
Available: 8
MAPEH 2
Grade 2 · 19 copies
Available: 3
Science 2
Grade 2 · 19 copies
Available: 1
Filipino 4
Grade 4 · 14 copies
Available: 13

User Management

Full NameUsernameRoleStatusLast LoginActions
Demo AdmindemoAdminActive2024-07-25 08:00
Mrs. Corazon ArranzcarranzTeacherActive2024-07-24 14:00
Mrs. Luzviminda UllerolulleroTeacherActive2024-07-23 09:30
Mrs. Rosegene CortesrcortesTeacherInactive2024-06-10 08:00