Monday, July 11, 2011

Mapping out Full-day Kindergarten

I finally get a great sense of accomplishment in being able to publish and embed this map. It's been somewhat of a labour of love since March. That was shortly after the year three school locations were announced by the Ontario Ministry of Education. Not knowing as much as I do now, I started, manually, mapping all the schools where FDK had been announced using Google Maps.That was a pain in my behind and several other body parts as it required a lot of cutting and pasting and manual correction as each address was searched. Google Maps also appears to have a limit of only a few hundred pins visible at a time for those entered manually.
Part of this frustration is a bigger conversation over open data-- specifically the lack thereof in the Ontario government. Instead of say, offering this information in an easily downloadable format, the ministry forces us to look up schools by municipality, school board or school name on the School Information Finder.
Things changed, and accelerated somewhat, when I participated in some social-media training at work and was introduced to Google Fusion Tables. Anyone with a Google account (and these can be setup for any email address) can use Fusion Tables, which is an incredibly powerful little website. So a few weeks ago, using the SIF, I started cutting and pasting all the information on the web into one large Excel spreadsheet (see its GoogleDocs version here). The bonus being that by this point in time, the ministry had announced implementation dates for all Ontario elementary schools, so the map went from including only the first three years of sites to all of them. Had I known about Google Refine at the time, this too would have been easier as I was manually moving cells around in Excel for over 3,500 schools and with the proper scripting I might have gotten Google Refine to do all that hard work for me.
Even once I uploaded the table to Google Fusion Tables there was still a lot of work to do. For example, it didn't like trying to map addresses with postal codes that weren't imported correctly-- which was all of them. Then, it insisted on plotting some schools in places such as California and the U.S. midwest, which required some manual dot-placing. The last challenge was to get them to show up in the five pretty colours they do now.
So other than that wild sense of accomplishment, what else?
As best I can tell, no one outside the Ministry of Education has ever plotted the location of the over 3,500 elementary schools in Ontario that would have kindergarten grades in them. As a result, the map does have caveats. First, it's only as good as the data provided. The ministry website doesn't include any address or FDK information for 19 schools, so they're not on the map (although they are on the spreadsheet). It also goes based on the address information provided therein, which may not be accurate in some cases where school addresses are not specific street or road numbers.
Perhaps most importantly, any information for a school that's recently been involved in a school-closure review or is currently in one is subject to some error. I checked schools I know for accuracy and in one case the location of the future schools was correct and the to-be-closed schools are not listed. In another, where trustees didn't vote on an outcome until late April, all three schools involved are listed and plotted, even though by 2013 when the program starts only one of the three will remain.
Please load it in your full browser, poke around, play and investigate. I will be doing some further analysis and mapping on the site (for this blog and hopefully my newspaper chain depending on what the data shows me), but for now here you go.


Anonymous said...

Hugo, the School Information Finder was essentially "unhooked" from its original format when the teachers' unions and People for Education did not want the comparison feature to work. So after defending it in the Legislature one day (April 6th), the then Minister of Ed. Kathleen Wynne was forced to make the changes. On April 7th, the website was changed. See:

"The concession from the ministry comes after Annie Kidder, executive director of People for Education, a parent group that lobbies for equality in education, issued a letter and petition to Premier Dalton McGuinty and Ms. Wynne deriding the new system, which it alleged allows parents to “rank” schools."

Read more:


From Hansard of April 6, 2009


Mr. Rosario Marchese: My question is to the Minister of Education. The Ministry of Education website school finder is set up to allow parents to compare schools in the province. Why would the government provide information that would facilitate the ranking of schools based on the number of lower-income households or the university education of their parents?

Hon. Kathleen O. Wynne: What the school information finder is set up to do is to allow parents to find information about schools. It’s about profiles of schools. It’s all public information; it’s information that’s available in various sources. What we’ve done is brought it together. We know that, up until now, some boards have had profiles of schools; other boards have not. What we’ve done is provided an opportunity for schools across the province to have a profile on this website. We’ve known for many years that parents don’t just want narrow information about test scores, they want a broader, contextualized set of information, and that’s what this website allows for.

The Speaker (Hon. Steve Peters): Supplementary?

Mr. Rosario Marchese: Minister, your school website includes the number of special education students, the number of children whose first language is not English and the number of recent immigrants. Why would parents want to know that kind of information?

Hon. Kathleen O. Wynne: I want to be clear that this information finder is not about ranking schools. I want to read a quote from the online survey from a newcomer. This person says, “I am so grateful for all this information—as a newcomer to Canada who came here to give my children a better future—this info was critical—I had to collect most of it myself three years ago. Please, please keep this information ... I represent at least 30% ... of parents in Ontario who came from a different country and home language—we need this information to make suitable choices for our children’s education....”

She goes on to say, “I’d like to know about extracurricular activities offered at each school.”

Further: “Everyone gains when statistical information is shared.”

I want to make the point that I have had a conversation with folks from People for Education and from the federations. It may be that we add more information to this school information finder, and I’ll be talking with folks at the partnership table this afternoon about just that."

Education Reporter said...

Anon 12 July 8:36 --

All of which is true, I blogged about the launch and opposition to the SIF website.

Still a powerful little website, even if the comparative properties were removed.