Public School Data Analyzed

Learn About Tableau (data from 2012) Y-axis: District Graduation Rate (number of graduates/ number of 12th graders) X-axis: Percentage of Students scoring 1500 or above on the SATs (number of students scoring 1500 or above/ number of 12th graders) Size of Circle: Represents the number of 12th graders in the school district According to the CollegeBoard: "The SAT Benchmark score of 1550 is associated with a 65 percent probability of obtaining a first year GPA (FYGPA) of a B or higher, which in turn is associated with a high likelihood of college success." Bottom Line: Many students are graduating from high school but are not ready for college

Learn About Tableau The cost to keep high schools open: In my previous post I noted that none of Chicago’s high school were on the list of schools being closed while they are the most expensive to update or maintain.   There were schools that were proposed to be colocation, and I left those out of my analysis. The ideal enrollment for Chicago high schools, excluding the high schools proposed for colocation, is 151,451 students and the current enrollment is 116,551 students.   The current enrollment is only 76.9% of the ideal capacity with an excess of 34,900 seats.   Something to think about:   Hypothetically closing Tilden High School and Chicago Vocational High School, both which are underutilized and underperforming would save the Chicago Public Schools $161,417,000 and displace 1,365 students. The money saved can save 21 elementary schools from the chopping block and prevent 5,957 elementary aged students from being displaced. There are probably rea...

Learn About Tableau Chicago Public School Performance (% Possible Points) vs. 2012-2013 School Utilization Rate Y-Axis : - Performance Level  X-Axis : School Utilization Rate Color of Circle:   Orange = School closing Green = School will be co-located with another school Red = School will be receiving students from closing schools Blue = School unaffected Size of Circle:   Larger = more expensive to maintain/update Smaller = less expensive to maintain/update Are the right schools being closed in Chicago? When I first learned that the Chicago Public Schools were closing 54 schools  I was curious to see if it was closing the right schools. My thoughts: In my mind schools that are underutilized and under-performing ( bottom left on chart above)  should be the ones that should be closed and schools that are underutilized but performing above average (top left on chart above) should be the ones receiving new students. ...