January 20, 2000 by School FAQ Research Committee FIRST: Definitions of COLUMN codes used to search State EMIS(98-99 school year) DataBase in all of Cuyahoga County Variable Description -------- ----------- DNAME District Name CNAME County Name CDPP04PS Dist. Avg. Citizenship Pass Pct. 4th Grade MDPP04PS Dist. Avg. Math Pass Pct. 4th Grade RDPP04PS Dist. Avg. Read Pass Pct. 4th Grade WDPP04PS Dist. Avg. Write Pass Pct. 4th Grade SDPP04PS Dist. Avg. Science Pass Pct. 4th Grade CDPP06PS Dist. Avg. Citizenship Pass Pct. 6th Grade MDPP06PS Dist. Avg. Math Pass Pct. 6th Grade RDPP06PS Dist. Avg. Read Pass Pct. 6th Grade WDPP06PS Dist. Avg. Write Pass Pct. 6th Grade SDPP06PS Dist. Avg. Science Pass Pct. 6th Grade STDCT27 Number of Performance Standards met out of 27 DENRL99 Enrollment (1999) DSDLH99 District Stability Rate (1999) DPECD99 Student Disadvantaged in Percent (1999) DMEDI99 Family Median Income (1997) D578 Pupil/Teacher Ratio (1999) D582 Administrative Expenditure/Pupil (1999) D587 Total Expenditure/Pupil (1999)
NEXT: SQL search command followed by tabular results The tables below are sorted by 4th grade reading Proficiency scores. select DNAME,RDPP04PS,DPECD99,DSDLH99,STDCT27,DMEDI99,D587,D582,D578,DENRL99 from rc_db where CNAME='Cuyahoga' order by RDPP04PS; +-------------------------------+----------+---------+---------+---------+---------+---------+---------+-------+---------+ | DNAME | RDPP04PS | DPECD99 | DSDLH99 | STDCT27 | DMEDI99 | D587 | D582 | D578 | DENRL99 | +-------------------------------+----------+---------+---------+---------+---------+---------+---------+-------+---------+ | East Cleveland City | 32.6 | 51.5 | 20.8 | 2 | $18,936 | $9,471 | $1,441 | 18.3 | 6,299 | | Cleveland City | 37.0 | 60.3 | 0.3 | 0 | $20,529 | $7,718 | $762 | 17.0 | 76,239 | | Bedford City | 41.4 | 12.2 | 8.8 | 9 | $27,680 | $9,084 | $1,110 | 16.3 | 4,108 | | Euclid City | 41.6 | 16.0 | 12.5 | 8 | $26,977 | $8,122 | $1,091 | 17.7 | 5,917 | | Warrensville Heights City | 41.6 | 25.1 | 12.7 | 7 | $25,369 | $8,074 | $1,194 | 15.5 | 3,069 | | Maple Heights City | 46.0 | 10.9 | 12.0 | 7 | $27,219 | $6,225 | $856 | 19.5 | 3,931 | | Garfield Heights City | 55.1 | 10.3 | 7.1 | 9 | $27,111 | $6,678 | $854 | 20.2 | 3,444 | | Richmond Heights Local | 60.3 | 2.9 | 6.2 | 16 | $31,556 | $7,849 | $1,027 | 16.3 | 1,000 | | Cleveland Hts-Univ Hts City | 63.4 | 15.2 | 8.4 | 9 | $33,556 | $9,979 | $1,156 | 15.4 | 7,322 | | Parma City | 64.3 | 5.3 | 6.5 | 17 | $28,830 | $7,719 | $1,041 | 18.5 | 13,158 | | Brooklyn City | 65.5 | 4.9 | 4.7 | 12 | $26,460 | $9,534 | $1,815 | 16.6 | 1,349 | | South Euclid-Lyndhurst City | 66.0 | 2.3 | 5.0 | 16 | $32,788 | $8,947 | $889 | 16.7 | 4,442 | | Berea City | 67.4 | 3.8 | 6.1 | 18 | $29,549 | $8,180 | $938 | 18.2 | 7,919 | | Lakewood City | 68.8 | 11.9 | 8.4 | 15 | $28,384 | $7,117 | $754 | 20.4 | 7,459 | | Shaker Heights City | 72.2 | 7.5 | 5.3 | 17 | $41,387 | $10,891 | $1,294 | 14.9 | 5,637 | | Strongsville City | 75.9 | 1.3 | 4.9 | 22 | $39,623 | $7,717 | $1,017 | 19.4 | 6,820 | | North Olmsted City | 76.3 | 3.1 | 9.4 | 22 | $32,658 | $7,143 | $830 | 19.5 | 5,009 | | North Royalton City | 80.7 | 1.5 | 4.2 | 25 | $35,428 | $6,789 | $776 | 20.9 | 4,245 | | Brecksville-Broadview Heights | 82.4 | 1.3 | 3.0 | 27 | $39,067 | $7,484 | $795 | 21.3 | 4,053 | | Fairview Park City | 82.5 | 2.9 | 8.2 | 22 | $32,562 | $7,582 | $764 | 17.6 | 2,077 | | Independence Local | 82.8 | 0.4 | 2.6 | 26 | $33,653 | $9,847 | $1,144 | 15.9 | 979 | | Rocky River City | 83.3 | 1.4 | 3.2 | 23 | $36,732 | $8,288 | $1,048 | 18.5 | 2,341 | | Mayfield City | 83.4 | 4.0 | 4.9 | 25 | $31,433 | $8,237 | $866 | 15.4 | 4,229 | | Westlake City | 84.0 | 1.8 | 8.7 | 26 | $38,665 | $8,656 | $885 | 18.0 | 3,663 | | Beachwood City | 84.3 | 1.2 | 2.4 | 26 | $41,285 | $13,151 | $2,106 | 12.1 | 1,629 | | Bay Village City | 84.8 | 0.9 | 1.7 | 27 | $43,284 | $7,581 | $977 | 17.8 | 2,417 | | Cuyahoga Heights Local | 86.0 | 1.0 | 1.5 | 26 | $31,097 | $13,401 | $1,821 | 11.6 | 792 | | Olmsted Falls City | 86.0 | 1.9 | 9.7 | 27 | $32,875 | $6,933 | $840 | 20.6 | 2,989 | | Orange City | 86.6 | 0.5 | 8.6 | 26 | $53,096 | $11,608 | $1,327 | 14.8 | 2,261 | | Solon City | 88.4 | 0.5 | 5.0 | 26 | $38,679 | $8,530 | $866 | 17.6 | 4,885 | | Chagrin Falls Ex Village | 89.8 | 0.2 | 1.1 | 27 | $44,792 | $7,911 | $922 | 18.6 | 1,875 | +-------------------------------+----------+---------+---------+---------+---------+---------+---------+-------+---------+ 31 rows in set (0.03 sec)
ALL THE 4TH AND 6TH GRADE PROFICIENCY RESULTS IN CUYAHOGA COUNTY: select DNAME,CDPP04PS,MDPP04PS,RDPP04PS,WDPP04PS,SDPP04PS,CDPP06PS,MDPP06PS,RDPP06PS,WDPP06PS,SDPP06PS from rc_db where CNAME='Cuyahoga' order by RDPP04PS; +-------------------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+ | DNAME | CDPP04PS | MDPP04PS | RDPP04PS | WDPP04PS | SDPP04PS | CDPP06PS | MDPP06PS | RDPP06PS | WDPP06PS | SDPP06PS | +-------------------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+ | East Cleveland City | 33.9 | 18.0 | 32.6 | 29.7 | 19.9 | 41.0 | 14.8 | 25.6 | 69.5 | 11.0 | | Cleveland City | 47.0 | 36.1 | 37.0 | 49.2 | 34.2 | 31.6 | 13.9 | 17.7 | 50.2 | 9.9 | | Bedford City | 55.5 | 34.4 | 41.4 | 59.4 | 33.2 | 69.7 | 42.1 | 42.1 | 78.6 | 48.5 | | Euclid City | 55.1 | 31.3 | 41.6 | 54.3 | 33.2 | 54.0 | 26.0 | 31.6 | 79.2 | 27.0 | | Warrensville Heights City | 47.1 | 24.0 | 41.6 | 48.6 | 21.7 | 63.0 | 32.2 | 37.9 | 84.4 | 27.0 | | Maple Heights City | 53.0 | 30.0 | 46.0 | 51.6 | 27.9 | 61.4 | 36.0 | 34.2 | 77.2 | 25.0 | | Garfield Heights City | 67.1 | 43.8 | 55.1 | 62.3 | 46.1 | 64.4 | 43.9 | 47.3 | 82.0 | 38.3 | | Richmond Heights Local | 72.5 | 48.5 | 60.3 | 65.2 | 40.6 | 80.6 | 55.6 | 62.5 | 94.4 | 48.6 | | Cleveland Hts-Univ Hts City | 68.8 | 48.8 | 63.4 | 74.2 | 54.6 | 68.4 | 42.7 | 50.0 | 79.8 | 39.4 | | Parma City | 80.5 | 50.0 | 64.3 | 75.3 | 61.4 | 83.7 | 57.2 | 62.1 | 87.3 | 54.0 | | Brooklyn City | 75.0 | 46.4 | 65.5 | 85.7 | 54.8 | 83.0 | 54.3 | 53.2 | 89.4 | 38.3 | | South Euclid-Lyndhurst City | 80.0 | 56.9 | 66.0 | 63.3 | 53.1 | 82.2 | 64.7 | 68.6 | 90.8 | 51.2 | | Berea City | 82.5 | 64.0 | 67.4 | 76.1 | 62.3 | 79.3 | 60.1 | 57.1 | 83.7 | 51.7 | | Lakewood City | 77.9 | 61.8 | 68.8 | 75.8 | 64.0 | 79.4 | 56.2 | 54.0 | 78.3 | 55.3 | | Shaker Heights City | 82.6 | 72.7 | 72.2 | 74.1 | 69.3 | 73.2 | 64.7 | 68.6 | 83.8 | 53.4 | | Strongsville City | 88.8 | 71.8 | 75.9 | 84.7 | 73.5 | 89.9 | 73.6 | 69.4 | 92.8 | 59.8 | | North Olmsted City | 86.4 | 69.5 | 76.3 | 84.6 | 73.7 | 88.1 | 68.1 | 74.6 | 90.6 | 65.6 | | North Royalton City | 90.3 | 80.0 | 80.7 | 85.9 | 77.6 | 86.6 | 78.7 | 70.4 | 92.4 | 65.9 | | Brecksville-Broadview Heights | 91.3 | 79.2 | 82.4 | 88.6 | 77.9 | 92.6 | 83.9 | 81.9 | 94.0 | 77.9 | | Fairview Park City | 94.1 | 80.9 | 82.5 | 82.4 | 73.5 | 87.6 | 64.1 | 63.6 | 85.0 | 56.2 | | Independence Local | 89.7 | 79.3 | 82.8 | 89.7 | 82.8 | 90.2 | 84.1 | 79.3 | 96.3 | 68.3 | | Rocky River City | 89.7 | 73.0 | 83.3 | 87.4 | 78.7 | 89.9 | 71.6 | 67.5 | 88.2 | 68.6 | | Mayfield City | 88.8 | 74.8 | 83.4 | 79.3 | 75.2 | 91.3 | 81.7 | 75.2 | 93.5 | 69.5 | | Westlake City | 93.4 | 75.6 | 84.0 | 90.9 | 82.0 | 91.1 | 80.9 | 77.4 | 93.0 | 71.6 | | Beachwood City | 96.1 | 84.5 | 84.3 | 76.5 | 83.5 | 93.6 | 83.2 | 81.9 | 95.8 | 72.3 | | Bay Village City | 91.1 | 81.0 | 84.8 | 86.7 | 75.3 | 97.1 | 86.0 | 82.4 | 95.9 | 84.3 | | Cuyahoga Heights Local | 92.0 | 84.0 | 86.0 | 86.0 | 80.0 | 93.0 | 79.1 | 79.1 | 93.0 | 74.4 | | Olmsted Falls City | 92.7 | 82.0 | 86.0 | 94.6 | 79.5 | 94.5 | 80.4 | 75.8 | 91.8 | 75.8 | | Orange City | 91.6 | 83.7 | 86.6 | 82.9 | 77.0 | 90.1 | 78.9 | 78.9 | 95.3 | 69.6 | | Solon City | 95.1 | 86.2 | 88.4 | 92.7 | 84.2 | 88.2 | 79.1 | 78.1 | 93.6 | 66.3 | | Chagrin Falls Ex Village | 96.6 | 81.6 | 89.8 | 88.4 | 78.2 | 94.4 | 87.6 | 88.8 | 97.5 | 82.0 | +-------------------------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+ 31 rows in set (0.03 sec)