In my previous post, I mentioned that I spend a lot of time during the summer prepping for academic year. This fall requires extra work because I’m changing textbooks, and re-organizing a lot of material. I’m not doing this just to improve the content or my teaching, but I do this to “exercise” my other skills – things like playing with Google Fusion Tables, Photoshop, HTML, etc.
This fall I’ll be teaching urban sociology again and I’m currently updating material for the course. New on the syllabus for this year is Robert Sampson’s book on Great American City: Chicago and the Enduring Neighborhood Effect. Reading the book the past few weeks inspired me to think of examples to help students make comparisons/connections between Chicago and Philadelphia.
Perhaps the most obvious example is that were both hit bad with school closures in 2013 affected whole communities.
|School Closings 2013||47||23|
|Charter Schools opened||15||9|
The Chicago Tribune has an excellent map that illustrates some of social and economic dimensions of neighborhoods affected by the closures. Since, I’m very much in favor of visualizing data for my statistics-adverse students, I’ve decided to make my own map in Google Fusion Tables to help me with my lesson plan in the fall. I can always use Social Explorer, but it’s also useful and fun for me go through the effort of downloading U.S. Census data and making my own map.
The below is a color coded map of census tracts based on the percent of those with high school diplomas or higher based. The purple flags are where the schools closed in 2013 are located.
[Click for Map w/ Race & Income]
I’ll continue to work on this throughout the summer, but I wanted to blog on how summer “prep” work isn’t just revising lectures and reading. It can be an opportunity to develop other skills.