Fair, transparent, and efficient government procurement benefits the public. In this information age, where insight generation from big data has proven to be powerful, using the tools of Data Analytics can help ensure integrity and transparency in public procurement.
From years 2018 to 2020, Layertech has worked under the support and grant of Hivos’ Open Contracting programme on improving government procurement data use and disclosure. Layertech worked with the Local Government Unit (LGU) Legazpi city, academic institutions such as Bicol University and Southern Luzon Technological College, individual business owners and business organizations such as the Albay Chamber of Commerce and Industry, and Civil Society Organizations (CSO) such as Gayon Bicol LGBTQI organization and their regional network.
This compilation was produced to share experiences and methodologies of Layertech and partners, in mining government procurement data to answer advocacy-related questions of CSOs; to generate business insights; to help suppliers and procuring entities identify bottlenecks and inefficiencies in various procurement stages; and, to uncover trends and red flags in the procurement process.
Target readers of this handbook are assumed to have basic working competency in mathematics, statistics, and basic data manipulation. Working knowledge in coding such as in R and Python, would allow the reader to better appreciate the use-cases and replicate them.
Please NOTE that this handbook focuses on the data sources, filtering, and modelling methods used. Links to the papers (published AND manuscripts) are provided at the end of every use-case, and it is encouraged that the reader visit the links to view the full papers and studies. Some of the papers featured in this handbook may be updated, supplemented, and improved in the future.
You are free to use the contents of this document in any way permitted by the copyright and related legislation that applies to your use. No permission is required from the rights-holders for non-commercial use. Please credit and/or link to www.OCDEX.tech and Layertech Labs.
Attribution and USE of Handbook
Neither the publisher nor the authors or the editors give a warranty, express or implied, with respect to the material contained herein or for any errors or omissions that may have been made.
DOWNLOAD THE FIRST VOLUME of the Procurement Analytics Handbook for FREE HERE:
(This article and the manuscript were submitted by the research team and may be updated in the future)
Education has always been a “primary commodity” in the Philippines. With the implementation of the Universal Access to Quality Tertiary Education Act (Republic Act 10931), State Universities and Colleges (SUC) in the country are now mandated to provide free education to all tertiary students enrolled in their programs. Because of this, about 3.2 million college students were reported to enroll in the year 2018 alone [1] and this number is expected to double due to the implementation of the said law.
The Effect of COVID-19 Pandemic to Tertiary Education
The current COVID-19 has crippled the delivery of tertiary education in the country. Nationwide suspension of classes from all levels was hence declared as a mitigation measure to control and contain the spread of COVID-19 across all regions in the country. As a result, a temporary academic freeze has been widely observed from March 2020 until July 2020. This has been the case since various SUCs in the country are still addressing the unresolved dilemma of balancing safety and delivery of quality education to all SUC stakeholders upon resumption of classes in August 2020.
The COVID-19 Challenge to Resumption of Classes
With the sense of urgency to resume all classes despite the COVID-19 situation in the country, it has been widely suggested that face-to-face classes be shifted to online modes of learning this August 2020 [2]. This proposed transition, however, has been met with a huge resistance by various faculty, administrative staff, and college students. In the banner “#NoStudentLeftBehind”, online classes have been dubbed as “anti-poor” and “education solely for the privileged” [3].
As recent facts stated, only 17% of college students have been reported to have the capacity to connect to the internet wherein only 5% of such students have stable internet connectivity at home [3]. With these cited facts, it is expected that enrollment to SUCs this academic year would plunge to at least 70% [4]. Shifting then to purely online modes of learning this August 2020, hence, may not be feasible given the present situation of college students in the country.
Readiness of College Students for Online Learning – The Case of Bicol Region
Through the research grant given by Layertech Software Labs, Inc. and Hivos – People Unlimited, a group of faculty researchers from Bicol University College of Engineering (BUCENG) conducted a feasibility study solely focusing on this present dilemma. The capacity of SUCs and their students, hence, to undertake this proposed transition to online classes this August 2020 were thus reported to be comprehensively studied. In a pilot study conducted in the nine (9) SUCs in Region V, 160 (about 60%) of the 242 college students who willingly participated in a survey conducted from June-July 2020 were reported to have a monthly household income below PHP25,000. Even prior to the pandemic, about 60% of these students largely rely on cellular phones to accomplish academic tasks given to them and this represented a recurring monthly expense of PHP1,000 on cellular data alone. It was also reported that this observed expense is expected to at least double when online classes are implemented this August 2020. With these facts, it is without a doubt that these less privileged college students will have the most disadvantage if a purely online mode of learning is implemented upon the resumption of classes this August 2020.
Assessment of SUC EATing patterns – The Case of Bicol Region
With these described evidences, enabling college students to undertake the proposed online transition would then largely rely on the capacity of SUCs to deliver quality education through the said modes of learning this August 2020.
With the goal of assessing the nine (9) SUCs in the Bicol Region within the context of Education Access in Tenders (EAT), the same group of researchers from BUCENG looked closely into the information technology (IT) related procurement activities of such SUCs from the period 2016-2020. Upon a comprehensive evaluation of the collected contracts, these researchers reported two categories classifying the capacity of SUCs in Bicol Region to successfully implement the proposed online transition, namely “fully capable” and “partially capable”. “Fully capable” SUCs were reported to have largely invested on computer servers, internet coverage and bandwidth, library and learning managements systems, subscription to online databases, and acquisition of software for research and instructional use. These capabilities, as reported by these researchers, corresponded to an equivalent investment amounting to PHP241.19 million.
In contrast, while “partially capable” SUCs were reported to be to financially secure such investments, no relevant awarded IT tenders from 2016-2020 necessary to ensure effective implementation of the proposed online transition were found for such SUCs.
Collectively, seven (7) of the nine (9) SUCs in Bicol Region were seen to be “fully capable” of implementing online classes this August 2020. Though these reported findings implied that the Bicol Region as a whole is seen to effectively implement the proposed online transition, the EATing patterns of the remaining two (2) SUCs which cater to the majority of at least 3000 enrolled college students in the region indicated that much still needs to be done to ensure all college students, regardless of privilege, be given a fair and equal access to quality tertiary education. The researchers then strongly recommended that SUCs classified as “partially capable” benchmark on the IT related procurement strategies that of “fully capable” SUCs.
(This article is submitted by the research team and may be updated in the future.)
The COVID-19 pandemic has largely affected local government units (LGU) in the Philippines, guven the continuous rise of confirmed COVID-19 cases within their respective areas of jurisdiction. In mid-June 2020 alone for example, a spike in the COVID-19 cases was observed across all regions in the country.
As of July 22, 2020, a total of 72,269 confirmed COVID-19 cases has been reported, of which 46,803 cases are classified as active [1]. It is therefore imperative for the LGUs to immediately contain this spike in confirmed COVID-19 cases to prevent further spread of infection in their areas.
Possible Cause of Recent Spike in COVID-19 Cases
With the sudden implementation of a nationwide lockdown across all provinces in the Philippines, about 84,000 individuals remained stranded in Metro Manila for the duration of the imposed mitigation measures in the country [2]. In this case, a humanitarian effort to send these locally stranded individuals (LSI) to their respective home provinces was launched.
As the COVID-19 data published daily by the Department of Health indicated [1], the recent spike in confirmed COVID-19 cases mid-June 2020 could be linked to the return of LSIs to their respective home provinces.
Cross-examination of recently published COVID-19 data on regions (i.e. Region V) reporting a significant number of arriving LSIs further supplemented this observation [3]. As a result, there have been reported instances of mismanagement on the containment protocols of possible COVID-19 positive cases due to the onset of this described occurrence [4]. Hence, there is then a need to assess the capacity of LGUs to properly manage the arrivals of possible COVID-19 positive LSIs while ensuring that the arriving individuals are not discriminated and properly received according to the required medical protocols .
Capacity of LGUs to ACT on Arriving LSIs
Through a research grant given by Layertech Software Labs, Inc. and Hivos – People Unlimited, a group of faculty researchers from Bicol University College of Engineering looked closely into this present dilemma. Using COVID-19 related procurement data and officially press released COVID-19 data for the case of Region V, a system classifying the capacity of LGUs in the said region to accommodate, contain, and treat (ACT) arriving LSIs was formulated.
Under the developed system, three general LGU classifications were then derived namely, “low”, “moderate”, and “high”.
LGUs classified under the “high” category were reported to have at least three (3) hospitals and at least 10,000 PPEs readily available for ACTing on the arrival of possible COVID-19 positive LSIs. This then implied according to the researchers that LGUs categorized as “high” are the most equipped on ACTing on arriving LSIs. On the other hand, “moderate” LGUs were reported to have 1-2 hospitals readily available and a significantly low number of active COVID-19 cases within their respective areas of jurisdiction while “low” LGUs were also reported to have 1-2 hospitals within their vicinity but their active COVID-19 cases were relatively higher than that of “moderate” and “high” LGUs. In this perspective as cited by the researchers, LGUs (i.e. Oas, Albay) classified into “moderate” or “low” categories are highly advised to exercise due scrutiny and adhere to stringent health protocols while ensuring LSIs are not discriminated upon their arrival.
With the validation studies done on the case of Region V, this developed classification system is indeed seen to be helpful in providing data-driven insights that will specifically aid decision-makers on creating policies for proper management on the arrival of such individuals.
“TEAM DATA HOARDERS” Explored the Population Growth and its Effects to Philippines’ Carrying Capacity in Selected Indicators. They gave recommendations and insights both for data scientists to explore further on, and the government!
The presentation of Team Data Hoarders for the Datathon2020: Evidence-Based Lobby and Advocacy with Data Analytics, on February 22-23, 2020 held at Bicol University CSIT.
Please note that this presentation may be updated, modified, substantiated, in the following days. Please check this page for updates.
“TEAM DATA MINERS” Explores budget trend of HIV-related commodities, versus the number of newly diagnosed cases of HIV per month from 2017 to 2019, as well as insights, comments and recommendations!
This is Team Data Miners’ presentation at the Datathon2020: Evidence-Based Lobby and Advocacy competition and workshop, held at Bicol University College of Science, February 22-23, 2020.
low this page for more updates, as this study gets further substantiated. The contents of this page may be modified, updated, and further substantiated.
This report is made in support to the international open data movement, and to generate insights to help optimize the procurement process of procurement entities. For this report, State University Data is used, although the method is applicable to all procuring entities in general.
Please note that Layertech is not giving any conclusive statements about the agencies and organizations mentioned in this report. We highly encourage that additional research and validation be conducted when using the information stated in this report.
This report is a use-case created under the Open Contracting Grant of Hivos. The views and insights in this document do not necessarily reflect those of Hivos.
Kindly take time to read the notes, recommendations, scope and delimitation mentioned in this report.
This is document is under CC3 License. This is produced by Layertech. Please do not use the information without proper credit and/or Link to our website. For more information, comments and suggestions, please contact learning@layertechlab.com or visit www.OCDEX.tech
Open Contracting Portal
Test
Do you like our site?
Please consider making a kind donation to help us maintain and improve our work.
Cookie Consent
This website uses cookies or similar technologies, to enhance your browsing experience and provide personalized recommendations. By continuing to use our website, you agree to our Privacy Policy.
Cookies
This website uses cookies or similar technologies, to enhance your browsing experience and provide personalized recommendations. If you think that's ok, just click "Accept all". You can also choose what kind of cookies you want by clicking "Settings".
Read our Privacy Policy
Loading…
Reload document 
Open in new tab 
