# Loading the SQL extension so I can run SQL queries in this notebook
%load_ext sql

# Enter the connection string for your Db2 on Cloud database instance below
# %sql ibm_db_sa://my-username:my-password@my-hostname:my-port/my-db-name
# Replace with your actual connection string for the database
%sql ibm_db_sa://

'Connected: bsx51096@BLUDB'

# Checking which tables exist in my schema
%sql select TABSCHEMA,TABNAME,CREATE_TIME from SYSCAT.TABLES WHERE TABSCHEMA = 'BSX51096'

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

# Counting the number of columns in the SCHOOLS table
%sql select count(*) from SYSCAT.COLUMNS where tabname='SCHOOLS';

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

# Listing all columns, their types, and lengths in the SCHOOLS table
%sql select COLNAME, TYPENAME, LENGTH from SYSCAT.COLUMNS where TABNAME = 'SCHOOLS'

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

### Problem 1: Counting Elementary Schools

How many elementary schools are in the dataset? I want to see how many schools are classified as 'ES' (Elementary School).

%sql SELECT COUNT(*) FROM SCHOOLS WHERE "Elementary, Middle, or High School" = 'ES'

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql SELECT MAX(safety_score) FROM SCHOOLS;

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql SELECT NAME_OF_SCHOOL FROM SCHOOLS WHERE safety_score=99;

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql select Name_of_School, Average_Student_Attendance from SCHOOLS \
    order by Average_Student_Attendance desc nulls last limit 10

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql SELECT Name_of_School, Average_Student_Attendance  \
     from SCHOOLS \
     order by Average_Student_Attendance \
     fetch first 5 rows only

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql SELECT Name_of_School, REPLACE(Average_Student_Attendance,'%','')\
     from SCHOOLS \
     order by Average_Student_Attendance \
     fetch first 5 rows only

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql SELECT Name_of_School, Average_Student_Attendance  \
     from SCHOOLS \
     where DECIMAL ( REPLACE(Average_Student_Attendance, '%', '') ) < 70 \
     order by Average_Student_Attendance

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql select Community_Area_Name, sum(College_Enrollment) AS TOTAL_ENROLLMENT \
   from SCHOOLS \
   group by Community_Area_Name

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql select Community_Area_Name, sum(College_Enrollment) AS TOTAL_ENROLLMENT \
   from SCHOOLS \
   group by Community_Area_Name \
order by total_enrollment asc\
fetch first 5 rows only

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%%sql 
select hardship_index 
   from chicago_socioeconomic_data CD, schools CPS 
   where CD.ca = CPS.community_area_number 
      and college_enrollment = 4368

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
Done.

%sql select ca, community_area_name, hardship_index from chicago_socioeconomic_data \
   where ca in \
   ( select community_area_number from schools order by college_enrollment desc limit 1 )

 * ibm_db_sa://bsx51096:***@dashdb-txn-sbox-yp-dal09-14.services.dal.bluemix.net:50000/BLUDB
(ibm_db_dbi.ProgrammingError) ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N  An unexpected token ")" was found following ".college_enrollment)".  Expected tokens may include:  "<table_expr>".  SQLSTATE=42601 SQLCODE=-104
[SQL: select hardship_index 
   from chicago_socioeconomic_data CD, schools CPS 
   where CD.ca = CPS.community_area_number 
      and (select max(cps.college_enrollment))]
(Background on this error at: http://sqlalche.me/e/13/f405)

tabschema	tabname	create_time
BSX51096	EMPLOYEES	2020-09-17 13:54:41.872907
BSX51096	JOB_HISTORY	2020-09-17 13:54:42.069071
BSX51096	JOBS	2020-09-17 13:54:42.245220
BSX51096	DEPARTMENTS	2020-09-17 13:54:42.421544
BSX51096	LOCATIONS	2020-09-17 13:54:42.602533
BSX51096	PETSALE	2020-09-18 16:35:43.587033
BSX51096	INSTRUCTOR	2020-09-27 16:26:09.549225
BSX51096	INTERNATIONAL_STUDENT_TEST_SCORES	2020-09-27 19:35:13.162190
BSX51096	CHICAGO_SOCIOECONOMIC_DATA	2020-09-27 21:15:33.491487
BSX51096	SCHOOLS	2020-09-28 16:10:11.019423

name_of_school	average_student_attendance
John Charles Haines Elementary School	98.40%
James Ward Elementary School	97.80%
Edgar Allan Poe Elementary Classical School	97.60%
Orozco Fine Arts & Sciences Elementary School	97.60%
Rachel Carson Elementary School	97.60%
Annie Keller Elementary Gifted Magnet School	97.50%
Andrew Jackson Elementary Language Academy	97.40%
Lenart Elementary Regional Gifted Center	97.40%
Disney II Magnet School	97.30%
John H Vanderpoel Elementary Magnet School	97.20%

name_of_school	average_student_attendance
Richard T Crane Technical Preparatory High School	57.90%
Barbara Vick Early Childhood & Family Center	60.90%
Dyett High School	62.50%
Wendell Phillips Academy High School	63.00%
Orr Academy High School	66.30%

name_of_school	2
Richard T Crane Technical Preparatory High School	57.90
Barbara Vick Early Childhood & Family Center	60.90
Dyett High School	62.50
Wendell Phillips Academy High School	63.00
Orr Academy High School	66.30

name_of_school	average_student_attendance
Richard T Crane Technical Preparatory High School	57.90%
Barbara Vick Early Childhood & Family Center	60.90%
Dyett High School	62.50%
Wendell Phillips Academy High School	63.00%
Orr Academy High School	66.30%
Manley Career Academy High School	66.80%
Chicago Vocational Career Academy High School	68.80%
Roberto Clemente Community Academy High School	69.60%

Exploring Chicago Public School Data with SQL and Python¶

My Objectives¶

Chicago Public Schools - Progress Report Cards (2011-2012)¶

About the Dataset¶

Loading the Data¶

Connecting to My Database¶

Checking My Table¶

Exploring Table Columns¶

Some Quick Questions¶

My Problem-Solving Section¶

Problem 1¶

How many Elementary Schools are in the dataset?¶

Problem 2: Highest Safety Score¶

Problem 3: Schools with the Highest Safety Score¶

Problem 4: Top 10 Schools by Student Attendance¶

Problem 5: Lowest Student Attendance¶

Problem 6: Cleaning Up Attendance Data¶

Problem 7: Schools with Low Attendance¶

Problem 8: College Enrollment by Community Area¶

Problem 9: Least College Enrollment¶

Problem 10: Hardship Index for a Specific Community Area¶

Problem 11: Hardship Index for the Top College Enrollment Area¶

My Reflections¶

Author¶

community_area_name	total_enrollment
ALBANY PARK	6864
ARCHER HEIGHTS	4823
ARMOUR SQUARE	1458
ASHBURN	6483
AUBURN GRESHAM	4175
AUSTIN	10933
AVALON PARK	1522
AVONDALE	3640
BELMONT CRAGIN	14386
BEVERLY	1636
BRIDGEPORT	3167
BRIGHTON PARK	9647
BURNSIDE	549
CALUMET HEIGHTS	1568
CHATHAM	5042
CHICAGO LAWN	7086
CLEARING	2085
DOUGLAS	4670
DUNNING	4568
EAST GARFIELD PARK	5337
EAST SIDE	5305
EDGEWATER	4600
EDISON PARK	910
ENGLEWOOD	6832
FOREST GLEN	1431
FULLER PARK	531
GAGE PARK	9915
GARFIELD RIDGE	4552
GRAND BOULEVARD	2809
GREATER GRAND CROSSING	4051
HEGEWISCH	963
HERMOSA	3975
HUMBOLDT PARK	8620
HYDE PARK	1930
IRVING PARK	7764
JEFFERSON PARK	1755
KENWOOD	4287
LAKE VIEW	7055
LINCOLN PARK	5615
LINCOLN SQUARE	4132
LOGAN SQUARE	7351
LOOP	871
LOWER WEST SIDE	7257
MCKINLEY PARK	1552
MONTCLARE	1317
MORGAN PARK	3271
MOUNT GREENWOOD	2091
NEAR NORTH SIDE	3362
NEAR SOUTH SIDE	1378
NEAR WEST SIDE	7975
NEW CITY	7922
NORTH CENTER	7541
NORTH LAWNDALE	5146
NORTH PARK	4210
NORWOOD PARK	6469
OAKLAND	140
OHARE	786
PORTAGE PARK	6954
PULLMAN	1620
RIVERDALE	1547
ROGERS PARK	4068
ROSELAND	7020
SOUTH CHICAGO	4043
SOUTH DEERING	1859
SOUTH LAWNDALE	14793
SOUTH SHORE	4543
UPTOWN	4388
WASHINGTON HEIGHTS	4006
WASHINGTON PARK	2648
WEST ELSDON	3700
WEST ENGLEWOOD	5946
WEST GARFIELD PARK	2622
WEST LAWN	4207
WEST PULLMAN	3240
WEST RIDGE	8197
WEST TOWN	9429
WOODLAWN	4206

School_ID	name_of_school	Elementary, Middle, or High School	Street_Address	City	State	ZIP_Code	Phone_Number	Link	Network_Manager	Collaborative_Name	Adequate_Yearly_Progress_Made_	Track_Schedule	CPS_Performance_Policy_Status	CPS_Performance_Policy_Level	healthy_school_certified	Safety_Icon	safety_score	Family_Involvement_Icon	Family_Involvement_Score	Environment_Icon	Environment_Score	Instruction_Icon	Instruction_Score	Leaders_Icon	Leaders_Score	Teachers_Icon	Teachers_Score	Parent_Engagement_Icon	Parent_Engagement_Score	Parent_Environment_Icon	Parent_Environment_Score	average_student_attendance	Rate_of_Misconducts__per_100_students_	Average_Teacher_Attendance	Individualized_Education_Program_Compliance_Rate	Pk_2_Literacy__	Pk_2_Math__	Gr3_5_Grade_Level_Math__	Gr3_5_Grade_Level_Read__	Gr3_5_Keep_Pace_Read__	Gr3_5_Keep_Pace_Math__	Gr6_8_Grade_Level_Math__	Gr6_8_Grade_Level_Read__	Gr6_8_Keep_Pace_Math_	Gr6_8_Keep_Pace_Read__	Gr_8_Explore_Math__	Gr_8_Explore_Read__	ISAT_Exceeding_Math__	ISAT_Exceeding_Reading__	ISAT_Value_Add_Math	ISAT_Value_Add_Read	ISAT_Value_Add_Color_Math	ISAT_Value_Add_Color_Read	Students_Taking__Algebra__	Students_Passing__Algebra__	9th Grade EXPLORE (2009)	9th Grade EXPLORE (2010)	10th Grade PLAN (2009)	10th Grade PLAN (2010)	Net_Change_EXPLORE_and_PLAN	11th Grade Average ACT (2011)	Net_Change_PLAN_and_ACT	College_Eligibility__	Graduation_Rate__	College_Enrollment_Rate__	college_enrollment	General_Services_Route	Freshman_on_Track_Rate__	x_coordinate	y_coordinate	Latitude	Longitude	community_area_number	community_area_name	Ward	Police_District	Location
610038	Abraham Lincoln Elementary School	ES	615 W Kemper Pl	Chicago	IL	60614	(773) 534-5720	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610038.pdf	Fullerton Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 1	Yes	Very Strong	99	Very Strong	99	Strong	74	Strong	66	Strong	65	Strong	70	Strong	56	Average	47	96.00%	2.0	96.40%	95.80%	80.1	43.3	89.6	84.9	60.7	62.6	81.9	85.2	52	62.4	66.3	77.9	69.7	64.4	0.2	0.9	Yellow	Green	67.1	54.5	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	813	33	NDA	1171699.458	1915829.428	41.92449696	-87.64452163	7	LINCOLN PARK	43	18	(41.92449696, -87.64452163)
610281	Adam Clayton Powell Paideia Community Academy Elementary School	ES	7511 S South Shore Dr	Chicago	IL	60649	(773) 535-6650	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610281.pdf	Skyway Elementary Network	SOUTH SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 1	No	Average	54	Strong	66	Strong	74	Very Strong	84	Strong	63	Strong	76	Weak	46	Average	50	95.60%	15.7	95.30%	100.00%	62.4	51.7	21.9	15.1	29	42.8	38.5	27.4	44.8	42.7	14.1	34.4	16.8	16.5	0.7	1.4	Green	Green	17.2	27.3	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	521	46	NDA	1196129.985	1856209.466	41.76032435	-87.55673627	43	SOUTH SHORE	7	4	(41.76032435, -87.55673627)
610185	Adlai E Stevenson Elementary School	ES	8010 S Kostner Ave	Chicago	IL	60652	(773) 535-2280	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610185.pdf	Midway Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	Strong	61	NDA	NDA	Average	50	Weak	36	NDA	NDA	NDA	NDA	Average	47	Weak	41	95.70%	2.3	94.70%	98.30%	53.7	26.6	38.3	34.7	43.7	57.3	48.8	39.2	46.8	44	7.5	21.9	18.3	15.5	-0.9	-1.0	Red	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	1324	44	NDA	1148427.165	1851012.215	41.74711093	-87.73170248	70	ASHBURN	13	8	(41.74711093, -87.73170248)
609993	Agustin Lara Elementary Academy	ES	4619 S Wolcott Ave	Chicago	IL	60609	(773) 535-4389	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609993.pdf	Pershing Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 1	No	Average	56	Average	44	Average	45	Weak	37	Strong	65	Average	48	Average	53	Strong	58	95.50%	10.4	95.80%	100.00%	76.9	NDA	26	24.7	61.8	49.7	39.2	27.2	69.7	60.6	9.1	18.2	11.1	9.6	0.9	2.4	Green	Green	42.9	25	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	556	42	NDA	1164504.290	1873959.199	41.80975690	-87.67214460	61	NEW CITY	20	9	(41.8097569, -87.6721446)
610513	Air Force Academy High School	HS	3630 S Wells St	Chicago	IL	60609	(773) 535-1590	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610513.pdf	Southwest Side High School Network	SOUTHWEST SIDE COLLABORATIVE	NDA	Standard	Not on Probation	Not Enough Data	Yes	Average	49	Strong	60	Strong	60	Average	55	Average	45	Average	54	Average	53	Average	49	93.30%	15.6	96.90%	100.00%	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	None	None	None	None	NDA	NDA	NDA	NDA	14.6	14.8	NDA	16	1.4	NDA	NDA	NDA	NDA	NDA	302	40	91.8	1175177.622	1880745.126	41.82814609	-87.63279369	34	ARMOUR SQUARE	11	9	(41.82814609, -87.63279369)
610212	Albany Park Multicultural Academy	MS	4929 N Sawyer Ave	Chicago	IL	60625	(773) 534-5108	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610212.pdf	O'Hare Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Strong	66	Weak	37	Strong	66	Strong	71	Average	43	Average	50	Weak	46	Average	51	97.00%	2.3	96.90%	100.00%	NDA	NDA	NDA	NDA	NDA	NDA	60.7	39.8	53.7	59.8	17.5	20.8	34.5	15.6	0.2	0.3	Yellow	Yellow	29.2	50	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	266	31	NDA	1153858.196	1932691.891	41.97114330	-87.70962725	14	ALBANY PARK	39	17	(41.9711433, -87.70962725)
609720	Albert G Lane Technical High School	HS	2501 W Addison St	Chicago	IL	60618	(773) 534-5400	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609720.pdf	North-Northwest Side High School Network	NORTH-NORTHWEST SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Very Strong	88	NDA	NDA	Strong	62	Average	52	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	96.30%	2.1	96.20%	99.40%	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	None	None	None	None	NDA	NDA	NDA	NDA	19.1	19.5	19.9	20.1	1	23.4	3.5	67.9	92.2	79.8	4368	35	90.7	1158975.392	1923791.705	41.94661693	-87.69105603	5	NORTH CENTER	47	19	(41.94661693, -87.69105603)
610342	Albert R Sabin Elementary Magnet School	ES	2216 W Hirsch St	Chicago	IL	60622	(773) 534-4491	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610342.pdf	Fulton Elementary Network	WEST SIDE COLLABORATIVE	No	Standard	Probation	Level 3	No	Strong	67	NDA	NDA	Weak	30	Very Weak	18	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	94.70%	28.1	95.00%	100.00%	56.3	NDA	33.5	33.5	49.5	49.5	27.4	39.3	35.5	44.4	25	23.4	18.0	12.8	-1.8	0.1	Red	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	620	35	NDA	1161265.299	1909314.592	41.90684338	-87.68304259	24	WEST TOWN	1	14	(41.90684338, -87.68304259)
610524	Alcott High School for the Humanities	HS	2957 N Hoyne Ave	Chicago	IL	60618	(773) 534-5979	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610524.pdf	North-Northwest Side High School Network	NORTH-NORTHWEST SIDE COLLABORATIVE	NDA	Standard	Not on Probation	Not Enough Data	No	Strong	70	NDA	NDA	Strong	67	Average	51	NDA	NDA	NDA	NDA	Strong	57	Weak	43	92.70%	7.1	96.90%	100.00%	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	None	None	None	None	NDA	NDA	NDA	NDA	14.7	13.7	NDA	16	1.3	NDA	NDA	NDA	NDA	NDA	232	33	87.6	1161870.556	1919857.440	41.93576106	-87.68052441	5	NORTH CENTER	1	19	(41.93576106, -87.68052441)
610209	Alessandro Volta Elementary School	ES	4950 N Avers Ave	Chicago	IL	60625	(773) 534-5080	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610209.pdf	O'Hare Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 2	No	Average	43	Strong	61	Weak	28	Weak	37	Strong	62	Average	56	Average	51	Average	53	96.40%	22.5	95.90%	100.00%	63.9	43.2	51.3	32.9	50.7	70	52.5	31.3	59.8	57.6	16.5	24.7	19.9	14.2	0.3	-0.4	Yellow	Yellow	31.6	65.2	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	1023	31	NDA	1149774.095	1932831.151	41.97160605	-87.72464139	14	ALBANY PARK	39	17	(41.97160605, -87.72464139)
609799	Alexander Graham Bell Elementary School	ES	3730 N Oakley Ave	Chicago	IL	60618	(773) 534-5150	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609799.pdf	Ravenswood-Ridge Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 1	No	Very Strong	99	Very Strong	88	Strong	64	Average	46	Average	51	Average	51	NDA	NDA	NDA	NDA	96.30%	6.3	95.90%	99.30%	91.9	67.3	79.2	77.4	53.3	54.7	84.2	83	49.8	53.6	62.6	71.7	64.0	57.9	0.0	0.3	Yellow	Yellow	58.1	65.6	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	998	35	NDA	1160327.881	1924862.722	41.94952795	-87.68605496	5	NORTH CENTER	47	19	(41.94952795, -87.68605496)
609947	Alexander Graham Elementary School	ES	4436 S Union Ave	Chicago	IL	60609	(773) 535-1308	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609947.pdf	Pershing Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	Average	49	Weak	30	Weak	31	Weak	33	Weak	30	Average	41	Average	48	Average	51	92.50%	27.4	95.00%	92.10%	76.7	47.4	59.4	38.8	51.6	76.2	44.4	31.3	66.7	49.3	5.9	35.3	20.8	11.1	1.7	-0.5	Green	Yellow	45.3	31.8	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	476	42	NDA	1172335.702	1875308.997	41.81329195	-87.64338051	61	NEW CITY	11	9	(41.81329195, -87.64338051)
609963	Alexander Hamilton Elementary School	ES	1650 W Cornelia Ave	Chicago	IL	60657	(773) 534-5484	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609963.pdf	Ravenswood-Ridge Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	Strong	73	Strong	64	Strong	60	Average	59	Average	59	Average	48	Strong	57	Strong	54	95.30%	12.5	97.40%	97.40%	70.3	47.2	34.4	48.4	56.5	62.9	31.9	46.8	48.9	51.1	14.3	35.7	13.8	21.3	0.6	0.6	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	307	33	NDA	1164474.274	1923334.414	41.94524725	-87.67085683	6	LAKE VIEW	32	19	(41.94524725, -87.67085683)
610210	Alexander von Humboldt Elementary School	ES	2620 W Hirsch St	Chicago	IL	60622	(773) 534-4480	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610210.pdf	Fulton Elementary Network	WEST SIDE COLLABORATIVE	No	Standard	Probation	Level 3	No	Weak	31	NDA	NDA	Weak	32	Average	45	NDA	NDA	NDA	NDA	Weak	43	Weak	44	92.50%	185.5	96.00%	100.00%	NDA	32.6	23.6	24	56.3	54	31.8	19.7	60.7	39.7	9.1	20.5	8.6	5.7	-0.4	-1.2	Yellow	Red	14.6	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	398	34	NDA	1158554.232	1909250.021	41.90672216	-87.69300325	24	WEST TOWN	26	14	(41.90672216, -87.69300325)
609808	Alex Haley Elementary Academy	ES	11411 S Eggleston Ave	Chicago	IL	60628	(773) 535-5340	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609808.pdf	Rock Island Elementary Network	FAR SOUTH SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	Weak	28	NDA	NDA	Average	58	Strong	60	NDA	NDA	NDA	NDA	Average	47	Average	49	94.90%	2.9	94.70%	94.70%	51.6	31.4	17.3	13.6	43.7	41.4	36.3	24.5	64.8	53.9	1.8	16.1	11.6	1.9	0.5	-1.5	Yellow	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	525	48	NDA	1175378.714	1829178.573	41.68663682	-87.63359476	49	ROSELAND	34	22	(41.68663682, -87.63359476)
610028	Alfred David Kohn Elementary School	ES	10414 S State St	Chicago	IL	60628	(773) 535-5489	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610028.pdf	Rock Island Elementary Network	FAR SOUTH SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Very Weak	19	Weak	26	Weak	22	Very Weak	13	Weak	21	Very Weak	19	Average	47	Weak	45	90.10%	31.2	94.20%	96.40%	41.3	31.9	34	22.2	42.8	56.2	29.6	22.8	80	61.7	4.3	19.6	5.0	5.6	0.5	-0.1	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	428	48	NDA	1178053.498	1835837.822	41.70485072	-87.62360199	49	ROSELAND	34	5	(41.70485072, -87.62360199)
610098	Alfred Nobel Elementary School	ES	4127 W Hirsch St	Chicago	IL	60651	(773) 534-4365	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610098.pdf	Garfield-Humboldt Elementary Network	WEST SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 2	No	Weak	37	Weak	34	Weak	37	Weak	35	Average	48	Weak	36	Average	48	Average	51	94.60%	24.8	95.20%	100.00%	55.4	33.2	26.7	23.2	47.3	50	39.2	28.1	59.5	51	15.2	16.7	9.7	7.1	-0.3	0.7	Yellow	Yellow	23.4	44.4	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	801	34	NDA	1148503.002	1908960.619	41.90612797	-87.72993324	23	HUMBOLDT PARK	37	25	(41.90612797, -87.72993324)
609788	Alice L Barnard Computer Math & Science Center Elementary School	ES	10354 S Charles St	Chicago	IL	60643	(773) 535-2625	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609788.pdf	Rock Island Elementary Network	FAR SOUTH SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 1	No	Average	46	NDA	NDA	Weak	39	Average	58	NDA	NDA	NDA	NDA	Strong	69	Average	51	95.60%	28.5	95.00%	100.00%	62.1	38.5	43	38.8	47.4	61.8	45.6	40.4	49.4	61.4	18.5	29.6	18.0	15.7	1.9	1.9	Green	Green	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	274	49	NDA	1168627.899	1835867.534	41.70514024	-87.65811642	72	BEVERLY	19	22	(41.70514024, -87.65811642)
610334	Al Raby High School	HS	3545 W Fulton Blvd	Chicago	IL	60624	(773) 534-6755	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610334.pdf	West Side High School Network	WEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Average	52	NDA	NDA	Average	51	Average	53	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	80.30%	14.0	95.10%	100.00%	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	None	None	None	None	NDA	NDA	NDA	NDA	12.8	13	14.1	14	1.2	15.2	1.1	13.5	72.2	64.2	551	34	74.3	1152512.295	1901720.850	41.88618300	-87.71539705	27	EAST GARFIELD PARK	28	11	(41.886183, -87.71539705)
610131	Ambrose Plamondon Elementary School	ES	2642 W 15th Pl	Chicago	IL	60608	(773) 534-1789	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610131.pdf	Austin-North Lawndale Elementary Network	WEST SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 2	No	Average	45	NDA	NDA	Weak	32	Weak	28	NDA	NDA	NDA	NDA	Weak	45	Weak	41	96.90%	0.6	96.60%	100.00%	61.9	14.3	27.3	37.9	35	54.8	43.5	25	74.4	40	16.7	25	12.3	11.4	-1.5	-1.3	Red	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	171	39	NDA	1158816.302	1892329.996	41.86028668	-87.69250468	29	NORTH LAWNDALE	28	10	(41.86028668, -87.69250468)
610316	Amelia Earhart Options for Knowledge Elementary School	ES	1710 E 93rd St	Chicago	IL	60617	(773) 535-6416	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610316.pdf	Skyway Elementary Network	SOUTH SIDE COLLABORATIVE	Yes	Track_E	Not on Probation	Level 2	No	Very Strong	81	Strong	63	Strong	60	Strong	73	Weak	34	Average	54	NDA	NDA	NDA	NDA	96.30%	33.4	95.40%	100.00%	76.7	NDA	58.1	59.1	66.7	58.1	48.8	67.5	51.3	62.5	NDA	NDA	27.5	26.4	0.1	1.0	Yellow	Green	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	264	47	NDA	1189297.589	1843689.527	41.72613498	-87.58217727	48	CALUMET HEIGHTS	8	4	(41.72613498, -87.58217727)
609780	Ames Middle School	MS	1920 N Hamlin Ave	Chicago	IL	60647	(773) 534-4970	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609780.pdf	Fullerton Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	No	Standard	Probation	Level 2	No	Weak	38	Very Weak	17	Weak	27	Weak	35	Weak	26	Weak	26	Average	50	Average	50	94.30%	5.3	96.00%	100.00%	NDA	NDA	NDA	NDA	NDA	NDA	35.1	27.9	76.8	51.1	9.2	18.4	14.5	3.0	-1.9	-1.5	Red	Red	28.8	55	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	586	34	NDA	1150696.779	1912593.823	41.91605519	-87.72177945	22	LOGAN SQUARE	26	25	(41.91605519, -87.72177945)
610339	Amos Alonzo Stagg Elementary School	ES	7424 S Morgan St	Chicago	IL	60621	(773) 535-3565	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610339.pdf	Englewood-Gresham Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Weak	23	Weak	35	Weak	35	Average	42	Weak	25	Average	42	Weak	44	Average	50	91.40%	34.3	95.50%	100.00%	NDA	NDA	35.3	22.4	47.6	58.2	20.1	26.8	49.2	43.9	8	23.5	7.7	7.8	-0.4	-0.1	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	539	45	NDA	1170892.320	1855485.867	41.75892669	-87.64925340	68	ENGLEWOOD	17	7	(41.75892669, -87.6492534)
610320	Ana Roque de Duprey Elementary School	ES	2620 W Hirsch St	Chicago	IL	60622	(773) 534-4230	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610320.pdf	Fulton Elementary Network	WEST SIDE COLLABORATIVE	No	Standard	Probation	Level 2	Yes	Average	57	NDA	NDA	Very Weak	12	Very Weak	14	NDA	NDA	NDA	NDA	Average	53	Strong	57	95.40%	77.5	95.60%	100.00%	32.1	23.3	56.8	32.4	75.8	75.8	34.9	34.1	53.8	52.5	7.1	28.6	11.1	6.2	0.7	0.1	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	114	34	NDA	1158554.232	1909250.021	41.90672216	-87.69300325	24	WEST TOWN	26	14	(41.90672216, -87.69300325)
609837	Andrew Carnegie Elementary School	ES	1414 E 61st Pl	Chicago	IL	60637	(773) 535-0530	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609837.pdf	Burnham Park Elementary Network	SOUTH SIDE COLLABORATIVE	No	Standard	Probation	Level 3	No	Average	48	Average	51	Weak	37	Strong	63	Average	42	Weak	31	Average	49	Average	49	94.60%	6.2	94.40%	100.00%	NDA	NDA	40.2	48.3	40.8	52.3	29.8	44.7	32.6	36.2	18.4	38.8	21.4	20.4	-1.2	0.1	Red	Yellow	48.1	8.3	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	730	46	NDA	1186764.646	1864534.473	41.78339577	-87.59079649	42	WOODLAWN	20	3	(41.78339577, -87.59079649)
610060	Andrew Jackson Elementary Language Academy	ES	1340 W Harrison St	Chicago	IL	60607	(773) 534-7000	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610060.pdf	Fulton Elementary Network	WEST SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Very Strong	86	NDA	NDA	Average	57	Average	46	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	97.40%	0.7	96.10%	100.00%	88.7	NDA	90.3	90.9	70.6	81.2	85.7	90.7	64.8	62.1	72.6	87.1	70.4	62.7	0.6	0.8	Green	Green	48.4	80	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	556	38	NDA	1167364.912	1897512.032	41.87432724	-87.66097599	28	NEAR WEST SIDE	2	12	(41.87432724, -87.66097599)
609869	Anna R. Langford Community Academy	ES	6010 S Throop St	Chicago	IL	60636	(773) 535-9180	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609869.pdf	Englewood-Gresham Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 2	No	Weak	31	Weak	31	Average	54	Weak	32	Average	49	Average	50	Average	53	Average	52	91.80%	29.0	95.40%	100.00%	58.8	NDA	40	14	52.8	59.8	31.9	17	51.3	44.9	7.7	11.5	12.6	7.5	0.5	0.2	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	339	43	NDA	1168649.029	1864844.463	41.78465652	-87.65720530	67	WEST ENGLEWOOD	16	7	(41.78465652, -87.6572053)
610084	Annie Keller Elementary Gifted Magnet School	ES	3020 W 108th St	Chicago	IL	60655	(773) 535-2636	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610084.pdf	Rock Island Elementary Network	FAR SOUTH SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Very Strong	99	Very Strong	97	Very Strong	85	Very Strong	82	Very Strong	94	Very Strong	82	Strong	68	Strong	60	97.50%	4.9	96.50%	100.00%	100	NDA	100	100	63.4	74.7	96.5	97.7	61.2	76.7	89.3	100	92.8	92.3	1.6	2.3	Green	Green	51.5	70.6	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	245	49	NDA	1157959.455	1832892.067	41.69719792	-87.69726380	74	MOUNT GREENWOOD	19	22	(41.69719792, -87.6972638)
610229	A.N. Pritzker School	ES	2009 W Schiller St	Chicago	IL	60622	(773) 534-4415	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610229.pdf	Fulton Elementary Network	WEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 1	No	Average	59	NDA	NDA	Average	58	Strong	61	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	94.60%	36.5	95.60%	98.50%	56.8	11.8	58.2	58.5	55	55.6	62.9	54.9	57.6	55.1	38.7	50	37.2	34.5	-0.2	0.3	Yellow	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	669	35	NDA	1162693.096	1909391.648	41.90702500	-87.67779555	24	WEST TOWN	1	14	(41.907025, -87.67779555)
610277	Anthony Overton Elementary School	ES	221 E 49th St	Chicago	IL	60615	(773) 535-1430	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610277.pdf	Burnham Park Elementary Network	SOUTH SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Weak	32	NDA	NDA	Strong	64	Strong	76	NDA	NDA	NDA	NDA	Average	52	Strong	55	90.50%	24.9	94.90%	100.00%	52	54.8	19.6	16.2	41.1	40	20.4	25	45.1	46.2	0	8.3	8.2	4.3	1.2	0.7	Green	Yellow	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	436	42	NDA	1178699.353	1872549.026	41.80557578	-87.62012252	38	GRAND BOULEVARD	3	2	(41.80557578, -87.62012252)
609951	Ariel Elementary Community Academy	ES	1119 E 46th St	Chicago	IL	60653	(773) 535-1996	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609951.pdf	Burnham Park Elementary Network	SOUTH SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	NDA	None	NDA	NDA	NDA	None	NDA	None	NDA	NDA	NDA	NDA	Average	51	Average	50	95.50%	5.4	96.00%	100.00%	70.8	34.3	48.4	43	62	58.6	40	47.1	58.6	49.3	14.6	36.6	24.8	14.4	0.0	-1.6	Yellow	Red	35	28.6	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	550	42	NDA	1184576.517	1874697.119	41.81133445	-87.59850030	39	KENWOOD	4	2	(41.81133445, -87.5985003)
610161	Arna Wendell Bontemps Elementary School	ES	1241 W 58th St	Chicago	IL	60636	(773) 535-9175	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610161.pdf	Englewood-Gresham Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Weak	33	NDA	NDA	Average	48	Average	59	NDA	NDA	NDA	NDA	Average	53	Average	52	94.20%	31.2	95.80%	100.00%	36.4	26.9	25.7	20.8	64.3	64.8	28.7	22.1	54.3	51.9	0	18.8	7.5	4.2	-1.1	-2.5	Red	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	345	43	NDA	1168872.421	1866273.444	41.78857298	-87.65634499	67	WEST ENGLEWOOD	16	7	(41.78857298, -87.65634499)
610171	Arnold Mireles Elementary Academy	ES	9000 S Exchange Ave	Chicago	IL	60617	(773) 535-6360	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610171.pdf	Skyway Elementary Network	SOUTH SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Weak	27	NDA	NDA	Average	43	Average	54	NDA	NDA	NDA	NDA	Average	48	Average	51	92.80%	11.8	95.20%	98.90%	44	27.5	21.9	15.2	45.4	45.7	23	19.4	46.9	51	6.4	18.2	7.6	5.4	-1.1	-0.7	Red	Red	9.8	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	905	47	NDA	1197292.129	1845782.158	41.73168217	-87.55282373	46	SOUTH CHICAGO	10	4	(41.73168217, -87.55282373)
610037	Arthur A Libby Elementary School	ES	5300 S Loomis Blvd	Chicago	IL	60609	(773) 535-9050	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610037.pdf	Pershing Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Weak	36	NDA	NDA	Strong	60	Strong	60	NDA	NDA	NDA	NDA	Average	48	Average	52	90.80%	21.6	95.10%	100.00%	31.1	37.3	24.7	12	43.2	48.3	32	17.7	55.3	48.3	4.2	14.6	4.8	3.9	-0.4	-2.8	Yellow	Red	18	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	539	43	NDA	1167858.322	1869572.502	41.79764784	-87.65996858	61	NEW CITY	16	9	(41.79764784, -87.65996858)
609887	Arthur Dixon Elementary School	ES	8306 S Saint Lawrence Ave	Chicago	IL	60619	(773) 535-3834	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609887.pdf	Skyway Elementary Network	SOUTH SIDE COLLABORATIVE	No	Track_E	Not on Probation	Level 2	No	Average	47	NDA	NDA	Average	47	Average	52	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	94.80%	32.2	95.60%	100.00%	69.7	35.5	42.8	37.8	51.8	70.8	43.5	44.5	51.3	49.4	22.1	31.6	22.0	15.7	-0.3	0.7	Yellow	Green	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	652	45	NDA	1181644.805	1850009.577	41.74365776	-87.61001515	44	CHATHAM	6	6	(41.74365776, -87.61001515)
609836	Arthur E Canty Elementary School	ES	3740 N Panama Ave	Chicago	IL	60634	(773) 534-1238	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609836.pdf	O'Hare Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Very Strong	87	Strong	64	Strong	70	Strong	64	Average	49	Average	47	Strong	66	Average	53	96.10%	2.3	96.10%	99.10%	75.3	60.6	77.2	58.3	52.9	62	81.3	71.3	61.4	59.7	41.3	60	47.4	34.2	0.3	0.1	Yellow	Yellow	29.8	100	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	784	30	NDA	1121355.698	1924041.412	41.94799245	-87.82933190	17	DUNNING	36	16	(41.94799245, -87.8293319)
610268	Arthur R Ashe Elementary School	ES	8505 S Ingleside Ave	Chicago	IL	60619	(773) 535-3550	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610268.pdf	Skyway Elementary Network	SOUTH SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	NDA	None	NDA	NDA	NDA	None	NDA	None	NDA	NDA	NDA	NDA	Weak	39	Weak	46	87.90%	41.6	93.40%	100.00%	30.1	25.5	20.3	14.3	47.4	54.8	43.4	23.6	61	58.7	7.9	15.8	9.2	2.8	1.1	-0.9	Green	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	459	45	NDA	1184078.661	1848752.991	41.74015307	-87.60113659	44	CHATHAM	8	6	(41.74015307, -87.60113659)
609941	Asa Philip Randolph Elementary School	ES	7316 S Hoyne Ave	Chicago	IL	60636	(773) 535-9015	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609941.pdf	Englewood-Gresham Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Track_E	Probation	Level 3	No	Very Weak	15	NDA	NDA	Average	41	Average	48	NDA	NDA	NDA	NDA	Weak	45	Average	49	92.10%	43.5	95.30%	95.60%	52.9	52.6	20.2	11.3	40.1	48.1	44.2	21.3	63	50.8	12.1	12.1	13.8	4.5	0.3	-1.3	Yellow	Red	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	573	43	NDA	1163589.689	1856037.765	41.76059741	-87.67600175	67	WEST ENGLEWOOD	17	7	(41.76059741, -87.67600175)
610287	Ashburn Community Elementary School	ES	8300 S Saint Louis Ave	Chicago	IL	60652	(773) 535-7860	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_610287.pdf	Midway Elementary Network	SOUTHWEST SIDE COLLABORATIVE	No	Standard	Not on Probation	Level 2	No	Average	48	Strong	76	Average	52	Average	40	Strong	68	Strong	70	Average	51	Average	50	95.50%	28.5	97.10%	100.00%	70.6	61.7	40.4	33.3	55.5	56.2	45.8	36.8	69.9	45.5	22.4	30.6	15.1	9.5	0.4	-0.6	Yellow	Yellow	40.8	40	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	490	44	NDA	1154458.760	1849313.602	41.74233179	-87.70964592	70	ASHBURN	18	8	(41.74233179, -87.70964592)
609820	Augustus H Burley Elementary School	ES	1630 W Barry Ave	Chicago	IL	60657	(773) 534-5475	http://schoolreports.cps.edu/SchoolProgressReport_Eng/Spring2011Eng_609820.pdf	Ravenswood-Ridge Elementary Network	NORTH-NORTHWEST SIDE COLLABORATIVE	Yes	Standard	Not on Probation	Level 1	No	Very Strong	99	NDA	NDA	Strong	78	Strong	65	NDA	NDA	NDA	NDA	Strong	59	Average	49	96.50%	0.7	95.00%	97.90%	69.4	47	64.5	70.2	51.2	66.7	69.4	75	62.9	67.3	50	69.6	54.2	53.3	1.3	2.1	Green	Green	35.7	80	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	NDA	572	33	NDA	1164768.164	1920682.831	41.93796493	-87.66985204	6	LAKE VIEW	32	19	(41.93796493, -87.66985204)