Back in the summer of 2024, I ranked Canadian provinces for educational outcomes using my very own custom Education Success Index (ESI). The thinking was that an effective school system would produce successful graduates, so provinces with better schools should be able to point to the most successful populations. The index consisted of these five metrics:
High school on-time graduation rates
Employment rates
Debt-to-income ratios
Net business formation rates
The OECD regional well-being measure
My Cost-Effectiveness Ratio (CER) was another product of that post. The CER was a measure of success rates when compared to education spending. Feel free to check out the full post for all the dirty details.
But as much fun as all that was, it had its limits. For one thing, the CER gave us a static, one-off snapshot that failed to account for the ongoing changes to spending policy. And just looking at total education spending diluted the effects of changing labour costs. In other words, what I’d really like to test for is an ongoing statistical relationship between labour costs and educational outcomes. Or in other other words, are graduates of school systems that employ more teachers and administrators better prepared for life.
To generate an ESI v.2.0, I’m going to assemble a slightly different set of data points :
Proportion of the non-immigrant population with high school diplomas or higher
Debt service ratio (a measure of overall financial health)
Net business formation rate (a measure of economic creativity)
The reason I’m focusing on non-immigrants wherever possible is because immigrants are far less likely to have been educated by Canadian public school teachers - so their success tells us nothing about the quality of Canadian schools.
The Statistics Canada tables that gave me my education attainment and employment status data aren’t time series numbers representing year-over-year results. Instead, they’re based on one-off research done in 2023 that reports individual status by age. The data tells us how many of today’s 20-24, 25-29, or 30-34 year-olds completed high school and were employed. To make that useful for us, I had to apply some transformations:
I pretended that, say, the 25-29 year-olds would all have been old enough to graduate high school in 2014 and that their cohort rates represented everyone who could have reached that age between 2012 and 2016.
I divided the high school graduation and employment numbers by the total population numbers of those age cohorts in 2023 to get a rate that’s comparable between provinces.
Obviously, individuals who were just 20-24 in 2023 would be less likely to be employed than 30-34 year-olds. So the raw ESI numbers did decline as we moved towards 2023. However, we’re really only interested in the relationships between ESI and K-12 employment, so such trends aren’t necessarily important to us.
Keep reading with a 7-day free trial
Subscribe to The Audit to keep reading this post and get 7 days of free access to the full post archives.