Tag Archives: legazpi

Public Data Analytics: Community Problem Solving

VOLUME 2 of the OCDex Public Data Analytics Series

Data science and analytics has demonstrated its power in informing decision-making and problem-solving. Data can reveal trends and insights that would have otherwise been obscured. It can give decision-makers key information needed to craft effective and optimal solutions to organizational problems. It can help predict potential bottlenecks and challenges, so that organizations may come prepared when it happens. Data science and analytics is a sought out
skill in the digital age.

The Covid-19 pandemic and its resulting limitations on mobility has forced many transactions and communications to migrate from the physical space to the digital space. This sudden global digitalization resulted in an increase in data produced and a subsequent increase in the potential game-changing insights that these data may be hiding.


While many in the private sector have been seen leveraging the power of data for business insights and maximization of revenue, the public sector is yet to catch up in terms of digitalization and data utilization, especially in developing countries. The power of data would especially help communities and local governments in coming up with efficient, effective, and inclusive policies and solutions to problems.


The aim of the 2022 OCDex project run is to bring data scientists and analysts together, and demonstrate how analysis of government data can be used to help solve problems in local communities. The project aims to demonstrate how it can help inform local policymaking and project planning, and how citizens and researchers can participate and help their respective local government units in overcoming community challenges hand-in-hand. This handbook hopes to convince local governments and authorities to invest in good data housekeeping and integrate data science and analytics into their decision-making.


This handbook features how academics and data enthusiasts used public data to help inform solutions to various community problems such as healthcare, inclusivity, and accessibility for persons with disabilities, fairness, and transparency in public procurement, and ensuring enough supply of utilities. Lastly, this handbook presents a replicable model of cooperation between local governments and their local researchers and data enthusiasts toward the effective use of data science and analytics for community building.

Loader Loading…
EAD Logo Taking too long?

Reload Reload document
| Open Open in new tab

For more information, questions, suggestions, and submissions, please e-mail learning@layertechlab.com

Reflections: Using Data Analytics to Validate Philippines’ occupational gender segregation

Author: Christian Sy (Bicol University)

The World Economic Forum’s Global Gender Gap Report of 2021 recognized the Philippines as the best-performing country in Asia in terms of gender equality. It ranked 1st in Asia and 17th out of the 156 countries. The Global Gender Gap Index (GGGI) is a significant indicator of gender disparity worldwide. It is useful for tracking the extent of access to resources and opportunities and differences between men and women. It adopts four key dimensions that include 1. Economic Participation and Opportunity, 2. Educational Attainment, 3. Health and Survival, and 4. Political Empowerment.

The Philippines have almost closed the gender gap for educational attainment and health and survival gaps with an index score of 0.999 and 0.979, respectively out of the perfect score of 1. On the other hand, economic participation and opportunity, and political empowerment are trailing with 0.792 and 0.353 index scores. This is primarily because of the gender gap in employment opportunities for women, and statistically, there are too few seats in government-held for women.

With this, we can explore a textual analysis of multi-domain, multi-source, and multi-year articles through big data analytics to validate the Philippines’ occupational gender segregation along with the economic participation and opportunity dimension of the Global Gender Gap Index (GGGI). The result of this textual analysis may be utilized to improve institutional transformation and policy formulation for equalizing economic participation and opportunity for women.

References

[1]        M A R C H 2 0 2 1 Global Gender Gap Report The analysis presented in the Global Gender Gap Report 2021. 2021. [Online]. Available: http://reports.weforum.org/global-

[2]        R. R. Sharma, S. Chawla, C. M. Karam, “Chapter 10: Global Gender Gap Index: World Economic Forum Perspective”, 2021, DOI:88975728.00017.

[3]        T. Mehdi, “Global Gender Gap Index: A Stochastic Dominance Approach,” SSRN Electronic Journal, Sep. 2020, doi: 10.2139/ssrn.3663281.

[4]        R. E. Matland, “Women’s Representation in National Legislatures: Developed and Developing Countries,” Legislative Studies Quarterly, vol. 23, no. 1, p. 109, Feb. 1998, doi: 10.2307/440217.

[5]        C. L. Hoyt, “Women, Men, and Leadership: Exploring the Gender Gap at the Top,” Social and Personality Psychology Compass, vol. 4, no. 7, pp. 484–498, Jul. 2010, doi: 10.1111/j.1751-9004.2010.00274.x.

This article is a reflection on the OCDex 2022 Fellowship Programme for Researchers

For more information about the article, please reach out to the author: cysy@bicol-u.edu.ph or layertech labs support at learning@layertechlab.com

Students Analyzing Procurement Data: 2019 Datathon for Transparency, Efficiency and Good Governance

25 students from Bicol University College of Science – Computer Science and IT Department, and students from Southern Luzon Technological College Foundation, Inc., joined the two-day Datathon on September 4-5, 2019 at Bicol University College of Science Laboratory. The event is facilitated by Layertech Labs, with the help of Bicol University CS- CSIT and SLTCFI, supported by Hivos.

In 10 hours, students learned basics of the R Environment, Basic Data Scraping and Data Analytics techniques. The students were made to form teams of 3 or 4, with a procuring entity of their choice. Using R, the students were able to scrape official Philippine procurement data from Philippine Government E-Procurement System (PhilGEPS), clean and standardize the datasets, before visualizing them into graphs.

At the end of theDatathon, the teams presented their findings before a panel of judges from: Department of ICT Luzon Cluster 3, Bicol University CS-CSIT, SLTCFI, and Gayon Bicol Civil Society Organization.

The judges declared the final winner, team “Paste Copy”, for analyzing Department of Education Region 5’s procurement efficiency, focusing on procurement of school supplies in the region’s public schools.

Check out the VIDEO:

Layertech Leads Data Scraping Session using R and R Studio

Supported by Hivos, Layertech lead a data scraping session using R and R Studio, using official Philippine Procurement Datasets found in Philgeps.gov.ph’s Open Data Portal.

The session attendees were faculty members of Bicol University College of Science IT Department, and faculty and graduating students of Southern Luzon Technological College Foundation, Inc.

While procurement datasets are available in open data formats, the large PhilGEPS datasets still need to be pre-processed, filtered, visualized and analyzed. Only then can researchers, advocates, and concerned citizens draw useful insights to aid them in their advocacy and decision making.

What’s the objective?

Layertech and partners advocate for #DataDrivenGovernance. We aim to encourage researchers to study and innovate on government procurement. For them to do that, they must be equipped with the necessary skills and tools to draw insights from procurement information that is available.

For this first session, the academe was specifically invited because the team also needs to get their insights, comments and suggestions about the training design, in order to improve the next tech training sessions to come.

The team and partners will soon be deploying training sessions for young researchers, students, innovators, and faculty, on various topics such as:

Data Science
Data Analytics
Data Visualization
Python Programming
Machine Learning
Cybersecurity
Data Privacy

What are the results?

For the first training session with R, the participants were able to publish a total of 13 datasets (downloadable HERE, in our Open Data Portal) under various categories such as Health, Local Government, and Education.

The participants also actively presented their outputs and how these cleaned datasets can help increase transparency and efficiency in public procurement in the Philippines.

Want to know more about HOW to filter Philgeps datasets? Here’s a quick, general guide HERE.

Keep on visiting our “References” section for more procurement and data scraping, visualization, and analytics guides!

First Stakeholder Meeting – Open Contracting Data Standards Stakeholder Meeting 2018

Held at The Oriental Hotel on May 22, 2018, Layertech Software Labs and Hivos conducted the first stakeholder meeting to officially kickstart the Open Contracting and OCDex project in Legazpi city, Albay.

The objective of the meeting is to present the Open Contracting project objectives, proposed activities, and solicit stakeholder feedback and support in order to understand the current issues and difficulties they encounter in public procurement.

Furthermore, in order to create a user-friendly, functional, and relevant procurement portal, stakeholders need to be a constant part of the development process, making them co-creators of the OCDex portal.

Meeting attendees include civil society organizations, local businessmen, members of the academe, and representatives of the Local Government Unit (LGU) of Legazpi.

OCDex team presenting OCDS and potential benefits to stakeholders

The meeting aims to ensure that the OCDex portal, its features, and contents will benefit target stakeholders and assist them in their future procurement planning and decision making activities.