About the site
The Exploring Kenyan Education site investigates the education sector in Kenya and visualizes location data for all primary and secondary schools across the country. By mapping school locations with education outcomes and investment data, the site provides insight into the state of education within Kenya.
Methodology
Data work was carried out using OpenOffice and SQLite to join attribute data with spatial data for the purpose of visualization. Data was obtained and collected from the Kenya OpenData portal and official Government of Kenya data. In cases of pre-2010 data, district names were updated to the 47 2010-designated counties. Data was aggregated and formatted into county-level tables and joined to county-level geographic data. Averages, minimums, and maximums were calculated to be included in the visualization.
School location data was downloaded from the Kenya OpenData portal. Latitude and longitude data for 37,725 primary and secondary schools were reformatted for proper use in mapping applications. All points were plotted on the map, including schools that are listed with zero enrollment. It is unknown to whether these locations have invalid data, missing data, or are closed.
Kenya Certificate of Primary Education (KCPE) and Kenya Certificate of Secondary Education (KCSE) exam results were obtained from the Kenyan National Examination Council. Exam results were listed by school with gender and score categorizations. Percentages of students passing (C+ or higher for secondary, or a score higher than 250 for primary) were calculated for both the KCPE and the KCSE exam results. Results were aggregated to county-level averages. The exam results only contained county location identifiers and did not include a national school identifier code so only county-level aggregations were able to be visualized.
Other contextual data was obtained from the Kenya OpenData portal. Data was matched to county administrative geographic data by county name. There is no official source of county administrative boundary geographic data. This site used county geographic data made publicly available on ArcGIS.com.
All maps were created with TileMill and hosted with MapBox. Color scales were determined based on natural breaks within each of the visualized indicators.
Close