RESOURCEGov 2 Project Team conducted the ODK/Qlik Systems Training and Installation for LGUs New Bataan and Maragusan, Compostela Valley at Mindanao P.O. Complex, Maa, Davao City on June 5-6, 2018. The training was participated by 24 participants (Male 23, Female 11) including the project team. The mock ODK-based business mapping/surveys were conducted in LGU New Bataan and LGU Maragusan on June 7 and 8, 2018, respectively.
LGU New Bataan and LGU Maragusan underwent workshop-training of the Open Data Kit (ODK) on June 5, 2018 were the participants learned how to do the 3-step process: Build, Collect and Aggregate. Project Manager Mr. Roel Ian P. Blanker guided the LGU representatives and discussed the features of creating forms while participants do hands-on in making the forms using different ‘questions’. The participants were allowed to go out the venue to “collect” data with GPS coordinates. After, they submitted the answered forms as “Aggregate”. At the end of the day, the participants were able to learn how to: register an account to Kobotoolbox, download and install the Kobotoolbox app, build forms, collect data, and aggregate the collected data. Mr. Blanker also added that they can share the forms and results to other departments who can either only view, modify, or add data, if they enable access to such data.
The next day, the participants were trained on Qlik, including registering to the Qlik Sense website and how to upload data to the Qlik system. Mr. Blanker showed samples of how Mahintana use such system for its projects particularly the Health Plus Project. In the afternoon, the participants were asked to present their LGUs’ Statement of Receipts and Expenditures (SREs) from years 2015 to 2017 using Qlik. After, Project Officer-AADC Ms. Cherrylyn Dapiton facilitated the 2-day training evaluation. Mr. Fernando Bautista, Municipal Treasurer of Maragusan, said “Though, we were not able to absorb everything in the training, we are sure that the ODK and Qlik systems are very useful in our LGUs. There must be periodic “clinic-ing” or checking of the systems to ensure that the data uploaded are updated and not lost. The project is very good.” LGU New Bataan Municipal Assessor Mr. Lyle Cubonoc said “As department heads, we can giveour support to the staff who will be assigned to man the systems. We are going to lobby for the gadgets and IT personnel to the mayor and will work hard for them to utilize the free tools.”
The project team traveled to LGU New Bataan on June 7, 2018 and to LGU Maragusan to do the mock surveys using their existing business tax, project monitoring and locational clearance forms. The participants were able to interview business owners, collect and aggregate the data, and presented the results in the post-survey sessions. Each LGU was able to agree on their next steps regarding the ODK and Qlik systems utilization.
