Today’s post is a first look at a project that I’m developing at work. Work is ED Platform, a Johannesburg-based consulting company. Our website is here. We’re creating a database for the South African public education system, and the next couple of blog posts will be a taste of what’s possible with our analysis.
I’ve analysed data from the Department of Basic Education (DBE). The data sets include a list of state and independent schools in South Africa, and a detailed breakdown of the matric results for 2014.
A reader asked if we could look at the results for mathematics in Diepsloot, a township in the City of Johannesburg metro. In this post we’ll identify the high schools in Diepsloot and discuss what analysis is possible.
The map below shows the Gauteng province with the location of all high schools:
The map shows the province, its metro / district municipalities, and the wards of the metros / districts. The City of Johannesburg metro is in the centre, in pink. To the north is the City of Tshwane metro (in blue), to the east is the Ekurhuleni metro (in green), to the south is the Sedibeng district (in brown), and to the west is the West Rand district (in yellow).
The map also shows all the high schools in the DBE’s database. which includes all schools designated as ‘secondary’, ‘intermediate’, and ‘combined’. This includes both state schools and independent schools.
Diepsloot covers two wards (Wards 95 and 113) in the City of Johannesburg metro. The next map shows the metro and the two wards (highlighted in red). Diepsloot is in the north of the metro, on the border of the City of Tshwane metro:
The next map shows a close-up of Diepsloot. There are eight high schools in the township:
In the next post we’re going to look at the maths results of these schools in the 2014 matric finals. We’ll be able to identify how many students wrote maths in Diepsloot, how many received an official pass (i.e. 30 per cent or more), and how many did well enough to qualify for tertiary education.
We’ll also be able to compare maths results across the eight schools and identify which schools are producing the highest number of graduates (and the highest percentage of graduates).