In early December 2014, aWhere Data Analyst, Hannah Reed, conducted a follow up training in Kenya for stakeholders involved with the SNV Home-Grown School Feeding Programme(HGSF).
This was a follow-up trip from her previous training in late September 2014, which focused on data collection and management best practices in preparation for a large round of surveys tracking programme success in participating schools within the district.
After Hannah’s first training, school district officers successfully distributed surveys among Laikipia County schools, and received a 100% response rate. This ensured a strong foundation for further reporting and analysis, providing a great lead up for Hannah’s follow-up visit with programme stakeholders in December. This December training included eight ICT officers from Laikipia County, four ministry of education representatives, and two SNV representatives.
Hannah focused the first half of the training on capacity building around data cleaning from the survey data, such as identifying outliers, verifying information, and null versus zero. Trainees learned data cleaning techniques through hands-on exercises, and data quality was emphasized throughout all segments of the training.
Hannah demonstrating data cleaning in the aWhere platform. A school feeding officer making a phone call to verify a questionable data point exposed in the cleaning process.
The need for data quality was further supported by Laikipia County’s Chief Economist for Education, Isaac Kamande, OGW, who wrote a formal MOU underscoring the importance of data accuracy so the public can trust that results of this research are true and can be trusted for future decision making.
The second half of Hannah’s training focused on loading data into the aWhere data management platform. From here, trainees learned how to analyze their data, generate reports, and identify trends for future decision making for the school feeding programme and beyond.
Trainee, Faith Wambui (ICT Officer at Laikipia County Government) learning how to load data into the aWhere platform.
The project is a powerful example of the benefits of multi-stakeholder collaboration, as the County of Laikipia, Ministry of Education, SNV, and aWhere work together to see success and sustainability well beyond the Home-Grown School Feeding Programme. The County seeks to continue in its data collection and management practices to increase public visibility and planning for resource and funding distribution to district schools. Some of the key indicators the county will be able to track include:
- Student-toilet ratio
- Student-teacher ratio
- Planned feeding days per actual
- Price variation among schools for commodities within the HGSF
- Attendance and performance in HGSF schools vs. non HGSF schools
Once the complete dataset is loaded and cleaned in the aWhere platform, the Laikipia team plans to take 100% ownership of future data collection, management and analysis. In March 2015, the team will present programme results to the county board of education. The team plans to continually update their database with new survey results every term, and will make all of the information publically accessible on the Laikipia County website. If successful, the Ministry of Education plans to scale out the programme across all counties in Kenya.
Trainees and Hannah Reed, Data Analyst at aWhere, Inc.