“Open Data Training: Education Data Dive” workshop was held on 6-10 October 2014, in Dar Es Salaam, with representatives from Ministry of Education and Vocational Training (MoEVT), Prime Minister’s Office- Regional Administration and Local Government, National Examination Council of Tanzania (NECTA), E-Government Agency (EGA), National Bureau of Statistics (NBS) and National Council of Technical Education (NACTE), Tanzania Education Authority and other institutions.

Group photo for training in Dar es Salaam

This was my first time co-facilitating a workshop of this kind as a School of Data Fellow in Tanzania. And it was a fantastic opportunity for me to sharpen my facilitation skills and also to learn from other facilitators, including the main facilitator and a more experienced among us all, Michael Bauer from the School of Data. It was a wonderful thing seeing all these government agencies responsible for education, in one room, learning and sharing from one another, which even by their own admission is very rare situation. When we were preparing for this workshop we knew that there is an existing expertise and knowledge about specific education datasets, but the challenge is mainly in letting other agencies know this so that they can be able to collaborate between themselves. It was fitting then that we had several datasets from some of the agencies that we used during our workshop to bring participants to a common understanding of open data concepts, teach and practice data wrangling skills and clean and join key datasets that some of them were already familiar with.

We started the workshop by focusing on developing a common understanding of open data and data management with concepts such as improving usability of already available public data providing better metadata and improving data workflows, to open licensing of data. Then we proceeded to introduction of various tools for data cleaning, analysis and visualization, including Open Refine, QGIS, Fusion Tables and Pivot Tables. This was the first time that most of the participants were using these tools, and they were excited to see how these tools opened up a world of possibilities that they did not know that existed with the datasets that they are working with often. An example was clearly illustrated by one participant from the PMO-RALG who was glad to have discovered Pivot Tables, as most of the tasks that he is working on most datasets would be simplified a lot using Pivot Tables skills. These practical hands on sessions were met with enthusiasm by all participants, and despite dedicating two full days, they were still up to spending more time cleaning, merging, analyzing and visualizing their datasets using these tools.

Brainstorming during the workshop

One major discussion that resonated throughout the workshop and how these agencies through working together might be able to come up with solutions about this , was the lack of unique codes that can be used to identify schools by different education stakeholders when dealing with education datasets containing schools. Most participants were of the agreement that merging data sets and coming up with analysis and visualizations during the workshop, would have been much easier, if we had unique codes used by every agency whose data sets were used during the workshop.

The latter part of the workshop was mainly spent, collecting feedback about the workshop and jointly plan the way forward for the implementation of what participants learned in their daily workflows. The follow up plan was drafted in which we will have a bi–weekly sessions with some of the participants to work together to implement what they learned during the workshop and also to revise various techniques about the tools learned and to dive deep into techniques we could not cover during the workshop.

Post-it notes from the workshops

The highlight for me of this workshop was the informal discussions that participants were having during breaks in which most of them were of the agreement that Open Data initiatives need not be seen as a foreign based concept imposed on Tanzania, but rather Tanzanians themselves need to see the benefits and take ownership of this concept.