Baselight

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

City of Chicago

@usgov.city_of_chicago_chicago_public_schools_progress_report_42c3b622

Loading...
Loading...

About this Dataset

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

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

Tables

Table 1

@usgov.city_of_chicago_chicago_public_schools_progress_report_42c3b622.table_1
  • 171.75 KB
  • 566 rows
  • 79 columns
Loading...

CREATE TABLE table_1 (
  "school_id" BIGINT,
  "name_of_school" VARCHAR,
  "elementary_middle_or_high_school" VARCHAR,
  "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,
  "track_schedule" VARCHAR,
  "cps_performance_policy_status" VARCHAR,
  "cps_performance_policy_level" VARCHAR,
  "healthy_schools_certified" VARCHAR,
  "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,
  "average_teacher_attendance" DOUBLE,
  "individualized_education_program_compliance_rate" DOUBLE,
  "pk_2_literacy" VARCHAR,
  "pk_2_math" VARCHAR,
  "gr3_5_grade_level_math" VARCHAR,
  "gr3_5_grade_level_read" VARCHAR,
  "gr3_5_keep_pace_read" VARCHAR,
  "gr3_5_keep_pace_math" VARCHAR,
  "gr6_8_grade_level_math" VARCHAR,
  "gr6_8_grade_level_read" VARCHAR,
  "gr6_8_keep_pace_math" VARCHAR,
  "gr6_8_keep_pace_read" VARCHAR,
  "gr_8_explore_math" VARCHAR,
  "gr_8_explore_read" VARCHAR,
  "isat_exceeding_math" DOUBLE,
  "isat_exceeding_reading" DOUBLE,
  "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_passing_algebra" VARCHAR,
  "n_9th_grade_explore_2009" VARCHAR,
  "n_9th_grade_explore_2010" VARCHAR,
  "n_10th_grade_plan_2009" VARCHAR,
  "n_10th_grade_plan_2010" VARCHAR,
  "net_change_explore_and_plan" VARCHAR,
  "n_11th_grade_average_act_2011" VARCHAR,
  "net_change_plan_and_act" VARCHAR,
  "college_eligibility" VARCHAR,
  "graduation_rate" VARCHAR,
  "college_enrollment_rate" VARCHAR,
  "college_enrollment_number_of_students" BIGINT,
  "general_services_route" BIGINT,
  "freshman_on_track_rate" VARCHAR,
  "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
);

Share link

Anyone who has the link will be able to view this.