This dataset contains the school performance indices (SPIs) for 2009-10 (2010), 2010-11 (2011), and 2011-12 (2012) for all schools that administered the Connecticut Academic Performance Test (CAPT). These data were published in the School Performance Reports released by the CT State Department of Education (CSDE) in December 2013 (see http://www.csde.state.ct.us/public/performancereports/20122013reports.asp) Note: Cells are left blank if there is no SPI, which happens when there are small N sizes for a particular subgroup or subject.
This dataset has the following 36 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Facility Code | facility_code | text | Seven-digit numeric code for school | 2106112 0646111 0936411 0496111 0866111 view top 100 |
| District Name | district_name | text | Seven-digit numeric code for district | Connecticut Technical High School System Hartford School District New Haven School District Capitol Region Education Council Waterbury School District view top 100 |
| School Name | school_name | text | School Name | Capital Preparatory Magnet School Norwalk High School Cheshire High School Lyman Hall High School Rocky Hill High School view top 100 |
| Overall SPI OVERALL 2010 | overall_spi_overall_2010 | number | Overall School Performance Index 2010 | 81.2 76.900000000000006 79 89.6 83.9 view top 100 |
| Overall SPI OVERALL 2011 | overall_spi_overall_2011 | number | Overall School Performance Index 2011 | 83.2 70.599999999999994 83.4 69.400000000000006 78.3 view top 100 |
| Overall SPI OVERALL 2012 | overall_spi_overall_2012 | number | Overall School Performance Index 2012 | 80.5 87.7 83.3 88.8 45 view top 100 |
| Black SPI OVERALL 2010 | black_spi_overall_2010 | number | Black or African American School Performance Index 2010 | 64.6 52.7 50.1 66.2 56.7 view top 100 |
| Black SPI OVERALL 2011 | black_spi_overall_2011 | number | Black or African American School Performance Index 2011 | 52.2 50 68.9 63.6 60.1 view top 100 |
| Black SPI OVERALL 2012 | black_spi_overall_2012 | number | Black or African American School Performance Index 2012 | 46.6 38.9 49.8 56.1 38.6 view top 100 |
| Hispanic SPI OVERALL 2010 | hispanic_spi_overall_2010 | number | Hispanic/Latino of Any Race School Performance Index 2010 | 59 58.2 59.3 69.9 73 view top 100 |
| Hispanic SPI OVERALL 2011 | hispanic_spi_overall_2011 | number | Hispanic/Latino of Any Race School Performance Index 2011 | 59.7 62.7 51.3 69.8 56.3 view top 100 |
| Hispanic SPI OVERALL 2012 | hispanic_spi_overall_2012 | number | Hispanic/Latino of Any Race School Performance Index 2012 | 68.9 61.1 32.9 67.2 64 view top 100 |
| ELL SPI OVERALL 2010 | ell_spi_overall_2010 | number | English Learner School Performance Index 2010 | 24.4 23.4 33.3 11 19.3 view top 100 |
| ELL SPI OVERALL 2011 | ell_spi_overall_2011 | number | English Learner School Performance Index 2011 | 31.9 30.9 32.2 43.6 28.1 view top 100 |
| ELL SPI OVERALL 2012 | ell_spi_overall_2012 | number | English Learner School Performance Index 2012 | 25.9 16.2 23.9 19.3 30.4 view top 100 |
| FRL SPI OVERALL 2010 | frl_spi_overall_2010 | number | Students Eligible for Free/Reduced-Price Meals School Performance Index 2010 | 51.5 51.3 68.599999999999994 52.5 59.9 view top 100 |
| FRL SPI OVERALL 2011 | frl_spi_overall_2011 | number | Students Eligible for Free/Reduced-Price Meals School Performance Index 2011 | 67.7 45.6 75.7 72.400000000000006 65 view top 100 |
| FRL SPI OVERALL 2012 | frl_spi_overall_2012 | number | Students Eligible for Free/Reduced-Price Meals School Performance Index 2012 | 66.7 68.099999999999994 59.7 64.5 38.4 view top 100 |
| SWD SPI OVERALL 2010 | swd_spi_overall_2010 | number | Students with Disabilities School Performance Index 2010 | 55.8 33.700000000000003 26.8 70.900000000000006 17 view top 100 |
| SWD SPI OVERALL 2011 | swd_spi_overall_2011 | number | Students with Disabilities School Performance Index 2011 | 46.7 61.6 25 53.4 28.2 view top 100 |
| SWD SPI OVERALL 2012 | swd_spi_overall_2012 | number | Students with Disabilities School Performance Index 2012 | 47.2 56.5 60.6 25.2 27.4 view top 100 |
| High Needs SPI OVERALL 2010 | high_needs_spi_overall_2010 | number | High Needs Students (FRL, EL, or SWD) School Performance Index 2010 | 65.099999999999994 66.2 56.9 56 75.099999999999994 view top 100 |
| High Needs SPI OVERALL 2011 | high_needs_spi_overall_2011 | number | High Needs Students (FRL, EL, or SWD) School Performance Index 2011 | 61.3 55 62 63.3 65.599999999999994 view top 100 |
| High Needs SPI OVERALL 2012 | high_needs_spi_overall_2012 | number | High Needs Students (FRL, EL, or SWD) School Performance Index 2012 | 65.7 63.9 61 48.2 61.3 view top 100 |
| Overall SPI MATH 2010 | overall_spi_math_2010 | number | Overall School Performance Index Math 2010 | 83.9 70.099999999999994 93.8 75.400000000000006 74.5 view top 100 |
| Overall SPI MATH 2011 | overall_spi_math_2011 | number | Overall School Performance Index Math 2011 | 86.7 71.099999999999994 82.7 75.099999999999994 75.8 view top 100 |
| Overall SPI MATH 2012 | overall_spi_math_2012 | number | Overall School Performance Index Math 2012 | 70.2 82.1 72.599999999999994 53.6 33.6 view top 100 |
| Overall SPI READ 2010 | overall_spi_read_2010 | number | Overall School Performance Index Reading 2010 | 88.6 93.2 68.8 86 73.8 view top 100 |
| Overall SPI READ 2011 | overall_spi_read_2011 | number | Overall School Performance Index Reading 2011 | 70.599999999999994 67.400000000000006 86.1 63.6 53.8 view top 100 |
| Overall SPI READ 2012 | overall_spi_read_2012 | number | Overall School Performance Index Reading 2012 | 50.6 68.3 77 65.599999999999994 79.5 view top 100 |
| Overall SPI WRITE 2010 | overall_spi_write_2010 | number | Overall School Performance Index Writing 2010 | 78.5 84.6 80 87.8 86.4 view top 100 |
| Overall SPI WRITE 2011 | overall_spi_write_2011 | number | Overall School Performance Index Writing 2011 | 80.099999999999994 93 90.2 91 79.099999999999994 view top 100 |
| Overall SPI WRITE 2012 | overall_spi_write_2012 | number | Overall School Performance Index Writing 2012 | 93.6 88.1 96.4 92.5 83 view top 100 |
| Overall SPI SCIENCE 2010 | overall_spi_science_2010 | number | Overall School Performance Index Science 2010 | 80.5 86 81.7 87.8 88.5 view top 100 |
| Overall SPI SCIENCE 2011 | overall_spi_science_2011 | number | Overall School Performance Index Science 2011 | 85.3 83.8 81.900000000000006 83.2 69.3 view top 100 |
| Overall SPI SCIENCE 2012 | overall_spi_science_2012 | number | Overall School Performance Index Science 2012 | 65.099999999999994 78.099999999999994 81.8 84.2 88.5 view top 100 |