Philippine E-Journals

CheckKoBayadKo: A Web Based Application for Tracking Student Financial Transaction with Scheduled SMS Notification Using Cron Job

Exander T. Barrios | Edzel Kim Lowie A Abliter | Sherrylle M Capiña | John Kevin D Murillo | Sheera Mae T Peñaranda

 

Abstract:

In any school business, financial transaction is vital because it is the fuel of the institution for giving quality education and services to their stakeholders. Unfortunately, the school has experienced delayed payments due to the discrepancies in their financial data. In this study, the researchers introduced a web-based application that could track students’ financial transactions and send a scheduled SMS notification for the students and parents of Jose Maria College. The researchers used the Constructive Method and Iterative Process Model as a research and software development methodology. The researchers also used fuel PHP framework for the web-based application and cron job that served as a time-based job scheduler for sending scheduled SMS notification. For the testing of the application, the researchers used white box to test the proper implementation of codes and black box to critique the functionalities of the application. Thirty-five students, seven parents, three program heads, two deans of colleges, a school administrator’s secretary, a principal, a vice president for academic affairs, a Cashier, and an accountant, a total of 52 respondents tested the web-based application and received scheduled SMS notifications. Unanimously, all observed that the application was useful in tracking the financial transactions of the students.