Chicago Public Schools - Progress Report Cards (2011-2012)
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_progress_report_42c3b622
City of Chicago
@usgov.city_of_chicago_chicago_public_schools_progress_report_42c3b622
This dataset shows all school level performance data used to create CPS School Report Cards for the 2011-2012 school year. Metrics are described as follows (also available for download at http://bit.ly/uhbzah): NDA indicates "No Data Available." SAFETY ICON: Student Perception/Safety category from 5 Essentials survey // SAFETY SCORE: Student Perception/Safety score from 5 Essentials survey // FAMILY INVOLVEMENT ICON: Involved Families category from 5 Essentials survey // FAMILY INVOLVEMENT SCORE: Involved Families score from 5 Essentials survey // ENVIRONMENT ICON: Supportive Environment category from 5 Essentials survey // ENVIRONMENT SCORE: Supportive Environment score from 5 Essentials survey // INSTRUCTION ICON: Ambitious Instruction category from 5 Essentials survey // INSTRUCTION SCORE: Ambitious Instruction score from 5 Essentials survey // LEADERS ICON: Effective Leaders category from 5 Essentials survey // LEADERS SCORE: Effective Leaders score from 5 Essentials survey // TEACHERS ICON: Collaborative Teachers category from 5 Essentials survey // TEACHERS SCORE: Collaborative Teachers score from 5 Essentials survey // PARENT ENGAGEMENT ICON: Parent Perception/Engagement category from parent survey // PARENT ENGAGEMENT SCORE: Parent Perception/Engagement score from parent survey // AVERAGE STUDENT ATTENDANCE: Average daily student attendance // RATE OF MISCONDUCTS (PER 100 STUDENTS): # of misconducts per 100 students//AVERAGE TEACHER ATTENDANCE: Average daily teacher attendance // INDIVIDUALIZED EDUCATION PROGRAM COMPLIANCE RATE: % of IEPs and 504 plans completed by due date // PK-2 LITERACY: % of students at benchmark on DIBELS or IDEL // PK-2 MATH: % of students at benchmark on mClass // GR3-5 GRADE LEVEL MATH: % of students at grade level, math, grades 3-5 // GR3-5 GRADE LEVEL READ: % of students at grade level, reading, grades 3-5 // GR3-5 KEEP PACE READ: % of students meeting growth targets, reading, grades 3-5 // GR3-5 KEEP PACE MATH: % of students meeting growth targets, math, grades 3-5 // GR6-8 GRADE LEVEL MATH: % of students at grade level, math, grades 6-8 // GR6-8 GRADE LEVEL READ: % of students at grade level, reading, grades 6-8 // GR6-8 KEEP PACE MATH: % of students meeting growth targets, math, grades 6-8 // GR6-8 KEEP PACE READ: % of students meeting growth targets, reading, grades 6-8 // GR-8 EXPLORE MATH: % of students at college readiness benchmark, math // GR-8 EXPLORE READ: % of students at college readiness benchmark, reading // ISAT EXCEEDING MATH: % of students exceeding on ISAT, math // ISAT EXCEEDING READ: % of students exceeding on ISAT, reading // ISAT VALUE ADD MATH: ISAT value-add value, math // ISAT VALUE ADD READ: ISAT value-add value, reading // ISAT VALUE ADD COLOR MATH: ISAT value-add color, math // ISAT VALUE ADD COLOR READ: ISAT value-add color, reading // STUDENTS TAKING ALGEBRA: % of students taking algebra // STUDENTS PASSING ALGEBRA: % of students passing algebra // 9TH GRADE EXPLORE (2009): Average EXPLORE score, 9th graders who tested in fall 2009 // 9TH GRADE EXPLORE (2010): Average EXPLORE score, 9th graders who tested in fall 2010 // 10TH GRADE PLAN (2009): Average PLAN score, 10th graders who tested in fall 2009 // 10TH GRADE PLAN (2010): Average PLAN score, 10th graders who tested in fall 2010 // NET CHANGE EXPLORE AND PLAN: Difference between Grade 9 Explore (2009) and Grade 10 Plan (2010) // 11TH GRADE AVERAGE ACT (2011): Average ACT score, 11th graders who tested in fall 2011 // NET CHANGE PLAN AND ACT: Difference between Grade 10 Plan (2009) and Grade 11 ACT (2011) // COLLEGE ELIGIBILITY: % of graduates eligible for a selective four-year college // GRADUATION RATE: % of students who have graduated within five years // COLLEGE/ ENROLLMENT RATE: % of students enrolled in college // COLLEGE ENROLLMENT (NUMBER OF STUDENTS): Total school enrollment // FRESHMAN ON TRACK RATE: Freshmen On-Track rate // RCDTS: Region County District Type Schools Code
Organization: City of Chicago
Last updated: 2020-11-10T16:54:35.812986
Tags: cps, report-cards
CREATE TABLE table_1 (
"school_id" BIGINT,
"name_of_school" VARCHAR,
"elementary_middle_or_high_school" VARCHAR -- Elementary, Middle, Or High School,
"street_address" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"phone_number" VARCHAR,
"link" VARCHAR,
"network_manager" VARCHAR,
"collaborative_name" VARCHAR,
"adequate_yearly_progress_made" VARCHAR -- Adequate Yearly Progress Made?,
"track_schedule" VARCHAR,
"cps_performance_policy_status" VARCHAR,
"cps_performance_policy_level" VARCHAR,
"healthy_schools_certified" VARCHAR -- Healthy Schools Certified?,
"safety_icon" VARCHAR,
"safety_score" DOUBLE,
"family_involvement_icon" VARCHAR,
"family_involvement_score" VARCHAR,
"environment_icon" VARCHAR,
"environment_score" DOUBLE,
"instruction_icon" VARCHAR,
"instruction_score" DOUBLE,
"leaders_icon" VARCHAR,
"leaders_score" VARCHAR,
"teachers_icon" VARCHAR,
"teachers_score" VARCHAR,
"parent_engagement_icon" VARCHAR,
"parent_engagement_score" VARCHAR,
"parent_environment_icon" VARCHAR,
"parent_environment_score" VARCHAR,
"average_student_attendance" DOUBLE,
"rate_of_misconducts_per_100_students" DOUBLE -- Rate Of Misconducts (per 100 Students),
"average_teacher_attendance" DOUBLE,
"individualized_education_program_compliance_rate" DOUBLE,
"pk_2_literacy" VARCHAR -- Pk-2 Literacy %,
"pk_2_math" VARCHAR -- Pk-2 Math %,
"gr3_5_grade_level_math" VARCHAR -- Gr3-5 Grade Level Math %,
"gr3_5_grade_level_read" VARCHAR -- Gr3-5 Grade Level Read %,
"gr3_5_keep_pace_read" VARCHAR -- Gr3-5 Keep Pace Read %,
"gr3_5_keep_pace_math" VARCHAR -- Gr3-5 Keep Pace Math %,
"gr6_8_grade_level_math" VARCHAR -- Gr6-8 Grade Level Math %,
"gr6_8_grade_level_read" VARCHAR -- Gr6-8 Grade Level Read %,
"gr6_8_keep_pace_math" VARCHAR -- Gr6-8 Keep Pace Math%,
"gr6_8_keep_pace_read" VARCHAR -- Gr6-8 Keep Pace Read %,
"gr_8_explore_math" VARCHAR -- Gr-8 Explore Math %,
"gr_8_explore_read" VARCHAR -- Gr-8 Explore Read %,
"isat_exceeding_math" DOUBLE -- ISAT Exceeding Math %,
"isat_exceeding_reading" DOUBLE -- ISAT Exceeding Reading %,
"isat_value_add_math" DOUBLE,
"isat_value_add_read" DOUBLE,
"isat_value_add_color_math" VARCHAR,
"isat_value_add_color_read" VARCHAR,
"students_taking_algebra" VARCHAR -- Students Taking Algebra %,
"students_passing_algebra" VARCHAR -- Students Passing Algebra %,
"n_9th_grade_explore_2009" VARCHAR -- 9th Grade EXPLORE (2009),
"n_9th_grade_explore_2010" VARCHAR -- 9th Grade EXPLORE (2010),
"n_10th_grade_plan_2009" VARCHAR -- 10th Grade PLAN (2009),
"n_10th_grade_plan_2010" VARCHAR -- 10th Grade PLAN (2010),
"net_change_explore_and_plan" VARCHAR,
"n_11th_grade_average_act_2011" VARCHAR -- 11th Grade Average ACT (2011),
"net_change_plan_and_act" VARCHAR,
"college_eligibility" VARCHAR -- College Eligibility %,
"graduation_rate" VARCHAR -- Graduation Rate %,
"college_enrollment_rate" VARCHAR -- College Enrollment Rate %,
"college_enrollment_number_of_students" BIGINT -- College Enrollment (number Of Students),
"general_services_route" BIGINT,
"freshman_on_track_rate" VARCHAR -- Freshman On Track Rate %,
"rcdts_code" BIGINT,
"x_coordinate" DOUBLE,
"y_coordinate" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_area_number" BIGINT,
"community_area_name" VARCHAR,
"ward" BIGINT,
"police_district" BIGINT,
"location" VARCHAR
);Anyone who has the link will be able to view this.