BarangayConnect: A Web-Based Information Portal for Resident Data, Administrative Services, and Community Records Using Data Analytics and Linear Regression Algorithms

The study developed a web-based application called BarangayConnect, specifically designed to streamline barangay operations through digital transformation. The system provides a centralized platform that allows residents to request services-such as barangay clearances, certificates of residency, and identification cards-without physically visiting the barangay hall. This innovation benefits residents by reducing the time and effort required for document processing and assists barangay staff by minimizing manual paperwork and improving service efficiency. BarangayConnect was developed following the System Development Life Cycle (SDLC) Waterfall Model, ensuring a structured and systematic process across the stages of planning, analysis, design, development, testing, and deployment. The system is built using PHP, MySQL, HTML, CSS, and JavaScript, resulting in a responsive and user-friendly interface accessible on both computers and mobile devices. It features automated request handling, record management, and report generation, all accessible through an intuitive dashboard for barangay staff. To support data-driven governance, the system integrates a Linear Regression Algorithm to analyze demographic and community data, allowing barangay officials to forecast population trends and predict service demands. This predictive component assists in strategic planning and resource allocation based on real-time data insights. The study utilized a developmental research design focused on system creation, testing, and evaluation. The Waterfall Model guided the project's flow-starting with user requirement analysis, followed by system design using data flow and entity-relationship diagrams. The development phase involved coding and integration of both the front-end and back-end components using the chosen web technologies. During the testing phase, functionality and usability were verified through simulation of real barangay operations. The system's quality and performance were evaluated using the ISO 25010 Software Quality Model, which assessed functionality, reliability, efficiency, usability, and portability. Data were gathered from fifty (50) respondents, equally divided between barangay staff/residents and technical experts. Their feedback provided quantitative and qualitative insights into the system's effectiveness and areas for improvement. The results revealed an overall mean rating of 3.0 (Agree), indicating that the system is effective, accessible, and reliable. Respondents strongly agreed on its efficiency, usability, and portability, though enhancements were recommended to further improve system functionality and reliability. In conclusion, BarangayConnect successfully modernizes barangay operations through automation and analytics, fostering transparency, accessibility, and citizen engagement.