DESKTOP-BASED SCHOOL CLINIC ADMINISTRATIVE INFORMATION SYSTEM (D-SCAIS) FOR IMMACULADA CONCEPCION COLLEGE

Abstract

The existing manual recording system for student health records at Immaculada Concepcion College (ICC) faced challenges such as space limitations, storage issues, time-consuming organization, and the risk of mishandling. These inefficiencies highlighted the need for a digital solution to enhance record management, improve accessibility, and ensure data security within the school clinic. In response, the "Desktop-Based School Clinic Administrative Information System (D-SCAIS) for Immaculada Concepcion College" was introduced to enhance the efficiency of managing student health records. This system includes functions such as User Authentication, Student Management Profile, Search and Filter options, Print Record, and Calendar Notes Module. A descriptive-developmental approach was used, involving interviews and direct observation for data collection. The agile methodology was employed in the software development life cycle (SDLC), which contained six phases: requirements, design, development, testing, deployment, and review. Front-end development tools included Visual Studio IDE, Visual Basic.NET (VB.NET), MySQL database, phpMyAdmin server, Adobe Photoshop CS6, and Canva for GUI design. In the descriptive approach, the System Usability Questionnaire (SUQ) was administered to three clinic staff using Total Population Sampling. Permission to use the standardized questionnaire was granted by its authors, Urera and Balahadia. Data analysis employed the weighted mean, with responses analyzed and interpreted under the guidance of Mr. Efren Joshua Adamos, ensuring accuracy and reliability in the study’s findings. Based on the assessment results, the system obtained an "Excellent" rating. In the SUQ, the overall weighted mean was 4.5 across functional suitability, reliability, portability, usability, performance, security, compatibility, and maintainability of the system. It is recommended that implementing the system in the Health Service Office of Immaculada Concepcion College will enhance performance in managing student health records. This is to ensure secure and easy access to records, and providing reliable health records for students in each department. Thus, the objectives defined for the system were achieved.