The goal of this capstone project is to streamline the process of manual data entry in household profiling, generating forms, data visualization through descriptive analytics, and the creation of an official website for the posting of announcements to the residents of Barangay 385 in Manila It will reduce errors, provide precise information and reports, and make data accurate, consistent, and accessible to residents with the use of this web application as well as aid in policy and decision making, and provision of social services.

For the discussion, it must be noted that the system is seeded with 2500 residents and 850 households , simulating the actual production load when it goes live. As per the census provided by the barangay, there are 2300 residents and 800 households.

The first module of the system is Authentication. It is where system users’ credentials and level of access or permission is assigned. In this module, the master account can manage the roles and permissions of every authorized system user. With the assigned roles, e.g., “Profiling”, it can limit the accessible module to a specific user.

Lists all the verified users of the system

Allows the creation of new users

For editing the existing system users

The second module is Household Profiling. This is where the system user can manage household and resident information.

To display all streets in Barangay 385

To show all households in a street

For displaying all residents in a household

Form for adding a household

Form for adding a resident

The third module is the descriptive analytics. This is where aggregated information from the database is visualized using graphs, charts, bars, pies, and pyramids

Displays the households count, population, number of families, bona fide residents, registered voters, senior citizens, household, families, and residents density per street

Distinct age groups. Women and children, pregnant women, and PWDs are also displayed in the dashboard. Its aim is to aid in disaster management

Displays the educational attainment of the residents. This is to identify where education services should be improved

Show the income classes. By being able to identify the socioeconomic profile of the residents, the local government can plan or manage how financial aid and opportunities will be distributed to the residents

Visualizes the civil status of the residents as well as the number of Filipinos and Non-Filipinos are displayed in this tab. Individuals can access necessary services including healthcare, education, and banking services by registering as citizens, which gives them formal legal standing

The percentage of residents' religion is indicated on the Religion tab

Summarizes household information such as waste management, toilet facility, type of dwelling, and type of ownership.

Shows a bar graph about the number of generated forms each month

User activity logging to record all database transactions committed by a system user

The Form Generation module eases up the generation of forms and certificates. In this module, the name and address of a resident will be automatically filled and displayed. The day’s current date will also be filled automatically.

It must be noted that residents that are registered in the profiling module are the only entities that will be displayed in the datalist.

The menu for generating forms

The form field that will be answered to generate a form

The generated form in a pdf format after clicking the Print button

This is the Announcements module. This allows the e-journalist to publish an announcement that will be displayed in the official website

Rich text editor for creating/updating an announcement

The official website of Barangay 385 following the Government Website Design Template by D.O.S.T.