“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.

I am on the Road in Tanzania and Ghana to spread the datalove. Last week Tanzania’s first data journalism event happened: The Data Bootcamp, organized by the World Bank Institute and the African Media Initiative, brought together international experts, journalists, civil society organizations and technologists to work on data related projects.

In 2010 Tanzania comitted to release open government data as part of the open government partnership. Nevertheless, the Tanzanian government has only released two datasets so far. One goal of the data bootcamp was to spur demand by implementing small data projects. The format was tested before in South Africa, Kenya and Moldovia and helped to raise awareness of Open Data. In preparation and during the workshop 4 more datasets were scraped and liberated. Further data was collected by the participants to work on their specific projects.

Of the 40 participants only 7 were able to code – the majority was journalists and activists who never handled data before. Through the three days they received an intensive training in how to use spreadsheets and tools like Google Refine or Fusion Tables to tell stories with data.

The data bootcamps not only consist of intense hands-on learning experience, they also are a small competition, where 2000$ are awarded to the winner. Since the Tanzania bootcamp did not result in a clear winning project, three finalists were chosen. Each of them received a small starting sum to produce a working prototype within three weeks. After this the winning project will be chosen. Final projects were 1.) A platform tracking promises made by politicians and whether they were fulfilled. 2.) Tracking and monitoring foreign direct investments and 3.) a project illustrating the problem with Land-Grabbing and land ownership in Tanzania.