Web-Based Welfare Monitoring Information System with Predictive Analytics for Social Assistance and Scholarship Management

Abstract

The Welfare Bureau (KESRA) of North Sumatra Province is responsible for managing social welfare programs, such as social assistance and scholarships, aimed at improving the quality of life of the community. Manual data management often results in inefficiencies, errors, and limited information accessibility. This study aims to develop a web-based Welfare Monitoring Information System to facilitate the management of social assistance and scholarship data. The system was developed using PHP programming language and MySQL database and is equipped with secure user authentication and a user-friendly interface. Predictive analytics methods were integrated to analyze trends and predict welfare patterns using historical data. The system implementation results demonstrate its capability to centrally manage data, generate comprehensive reports, and predict trends in the distribution of social assistance and scholarships over time. Furthermore, the system enables the evaluation of program effectiveness by comparing actual data with predictions, thereby supporting more accurate planning and decision-making in the implementation of social welfare programs in North Sumatra Province.