Public School Data Analyzed

Find the Best Elementary Schools for Every Home Price Range (Los Angeles County) Instructions: 1. Rank in Home Price Range: Select how many schools you would like to see for each median home price range. The default shows the top 20 schools in the selected home price range 2. Select a house price range.  3. Schools that show up in:  Red are low performing schools when compared to other Los Angeles Country Elementary Schools  Green are high performing schools when compared to other Los Angeles Country Elementary Schools.  Why I Built This Tool:                            Often times I am asked the question "Which is the best elementary school if I have $X to spend on a house?" I created this dashboard to inform parents and home buyers to find schools that are the highest performing in every price range. The ranking systems is something that I calculated that ranks sc...

There Are Great Schools in Affordable Neighborhoods in Los Angeles, California The chart above shows how elementary schools rank in each median home price range. As expected, as home price increases so does the performance of the school. There are however schools in each home price range that perform just as well as schools in expensive neighborhoods. The Best Schools for Home Prices Ranging from $300,000 to $400,000 School Charter District City Rank Percentile KIPP Raices Academy Y Los Angeles Unified Los Angeles 98% KIPP Comienza Community Prep Y Los Angeles Unified Huntington Park 97% Gregg Anderson Academy N Westside Union Elementary Palmdale 95% Wilder's Preparatory Academy Charter Y Inglewood Unified Inglewood 94% Vena Avenue Elementary N Los Angeles Unified Arleta 88% Synergy Charter Academy Y Los Angeles Unified Los Angeles 87% Ranch Hills Elementary N Pomona Unified Pomona 83% KIPP Los Angeles College Preparatory Y Los Angeles Unified Los Angel...

In my previous post I displayed the best high school in California based on their 2013 Academic Performance Index but I was curious to see if there were schools that were high performing and the housing price was affordable. In the map above: Green: High API to Average Home Price Ratio Red: Low API to Average Home Price Ratio

Learn About Tableau

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. ...