A Proposed Web-based Monitoring System of Student’s Statement of Account and Balance for the Aklan State University Banga

Abstract

Aklan State University (ASU) was located in the province of Aklan that consists of five campuses: Banga, Kalibo, New Washington, Ibajay, and Makato. Among the five campuses, Banga had the only existing student information database since 2004 and it was currently used by the registrar’s office. This database was not connected with the databases in the accounting and cashier’s office that also maintained student’s information for the statement of account, balance, and assessment of fees.

The proposed ASU Web-Based Monitoring of Student’s Statement of Account and Balance envisioned the extended services offered by the office of the registrar, accounting and cashier to address the student’s need in viewing statement of account, balance, and student’s assessment online. The objective of the project was to bring all the existing databases of Aklan State University Banga into one centralized student information system viewable online.

Lack of centralization caused the repetition of task in encoding the student record from the registrar and accounting offices. The web content management system, MySQL and Microsoft Access technology served as the portal of all the information needed by the users. The project sponsor was the administration of the Aklan State University Banga. Iterative development model was followed in this proposed project where tasks were divided into small parts.