{"id":10585,"date":"2012-03-15T15:48:34","date_gmt":"2012-03-15T19:48:34","guid":{"rendered":"http:\/\/www.raleighpublicrecord.org\/?p=10585"},"modified":"2012-03-15T15:52:04","modified_gmt":"2012-03-15T19:52:04","slug":"correlation-between-wake-county-schools-poverty-level-and-test-grades","status":"publish","type":"post","link":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/news\/2012\/03\/15\/correlation-between-wake-county-schools-poverty-level-and-test-grades\/","title":{"rendered":"Mapping Poverty Level and Test Grades in Wake Schools"},"content":{"rendered":"<p>New mapping by the Record shows that as schools become more high-poverty from West to East across Wake County, they are also more likely to score poorly on End of Grade tests.<\/p>\n<p>After the Record <a href=\"http:\/\/www.raleighpublicrecord.org\/news\/2012\/03\/08\/data-show-deep-economic-divide-in-schools-from-east-to-west\/\" target=\"_blank\">released a map<\/a> showing the trend of wealthy schools in the Western part of the county and poorer schools in the East last week, we received requests to produce more data maps from advocacy organizations as well as the school system. We heeded the call and produced additional testing and free-and reduced-lunch demographic maps.<\/p>\n<p>Here\u2019s what we came up with:<\/p>\n<p><strong>2012-13 F&#038;R<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3161247+&#038;h=false&#038;lat=35.75431391021905&#038;lng=-78.51769109375006&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h6>2012-13 F&#038;R projections show a well-defined trend of schools becoming more high-poverty moving from West to East.<\/h6>\n<p><strong>Over and Under-Chosen Schools<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3179419+&#038;h=false&#038;lat=35.76994100070472&#038;lng=-78.60993465000001&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h5>Percentage by which schools were under or over-chosen in the first proximity round does not show a clear trend that correlates to the other maps. Percentages more than 100 indicate by how much schools were over-chosen and vice-versa.<\/h5>\n<div style=\"float: right; width: 180px; padding: 10px; margin-left: 10px; margin-bottom: 10px; margin-top: 10px; font-size: 12px; font-family: arial,serif; background-color: lightgrey;\"><span style=\"font-size: 16px; font-weight: bold; color: #191970;\">LEGEND<\/span><br \/>\nF&#038;R Maps<br \/>\n0-25% = green<br \/>\n25-50% = yellow<br \/>\n50-75% = red<br \/>\n75-100% = purple<\/p>\n<p>Report Card Maps<br \/>\n50-60% at grade level = purple<br \/>\n60-100% at grade level = blue<br \/>\n60-80% = red<br \/>\n80-90% = yellow<br \/>\n90-100% = green<\/p><\/div>\n<p>To rate a school\u2019s EOG performance, we used report card grades issued by the <a href=\"http:\/\/www.ncpublicschools.org\/\">NC Department of Public Instruction<\/a>. As we mapped schools\u2019 performance, a trend emerged that correlated strongly with free-and-reduced-lunch data.<\/p>\n<p>The data shows that the poorer a school is, the more likely it will have worse overall scores on EOG tests and the wealthier it is, the more likely it is to have better scores. While it doesn\u2019t prove a cause, it\u2019s a strong correlation.<\/p>\n<p>Moreover, we produced maps, which show F&amp;R percentages and DPI ratings from 2003-04. That data bears out a similar correlation.<\/p>\n<p>In 2003-04, when the diversity policy was in effect, the same trend existed of schools becoming increasingly high-poverty from West to East across the county, but it was noticeably less pronounced. (As seen in the mixing of the yellow and red dots.)<\/p>\n<p>Directly East of Raleigh, in fact, there were slightly more schools in the 25 to 50 percent range than in the 50 percent and up range.<\/p>\n<p>Next year, according to school system data, that part of the county will consist almost exclusively of schools at which more than 50 percent of the student body will receive free-and-reduced lunch.<\/p>\n<p>Fifty percent F&amp;R and higher is often a demarcation line cited by officials and advocates as the point at which a schools\u2019 ability to perform well is compromised.<\/p>\n<p>It should also be noted that in 2003-04 the overall percentage of students receiving F&amp;R in the district was 24.3 percent. Last year, it was 32.4 percent.<\/p>\n<p>In 2003-04 we also see a correlation with F&amp;R and test scores. As the schools were more mixed socioeconomically, test results were also more mixed.<\/p>\n<p><strong>2003-04 F&#038;R<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3208691+&#038;h=false&#038;lat=35.74794912051025&#038;lng=-78.5974408359375&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h5>2003-04 F&#038;R trends show a much less well-defined movement of schools becoming poorer from West to East.<\/h5>\n<p><strong>2003-04 EOG Results<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3208929+&#038;h=false&#038;lat=35.788063020779134&#038;lng=-78.602934&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h5>2003-04 DPI Report Card Grades show test scores decreasing from West to East in a less well defined trend than 2010-11. It correlates with the F&#038;R map for 2003-04.<\/h5>\n<p>Additionally, we mapped F&amp;R distribution just before the school board\u2019s assignment policy was changed to represent proximity as the most important factor in student assignment. The change was made by the former Republican majority in 2010.<\/p>\n<p>The map of F&amp;R in December 2009 shows a definite trend of schools becoming increasingly high-poverty from West to East that is far more pronounced than in 2003-04, despite the diversity policy still being in effect.<\/p>\n<p><strong>Dec. 2009 F&#038;R<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3179339+&#038;h=false&#038;lat=35.788063020779134&#038;lng=-78.60431740000001&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h5>Dec. 2009 F&#038;R percentages show a snapshot of F&#038;R trends before the assignment policy was changed by the former Republican majority to reflect proximity in assignment. The main difference between then and now is the absence of schools with more than 75 percent F&#038;R.<\/h5>\n<p>The most noticeable difference in the maps is the absence of extremely high-poverty schools, as defined by more than 75 percent of the student body receiving free-and-reduced lunch.<\/p>\n<p>In 2009-10, no schools were above the 75 percent mark. In 2010-11, there were two. Next year, there is set to be seven such schools.<\/p>\n<p><strong>F&#038;R 2010<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3166302+&#038;h=false&#038;lat=35.769071876222284&#038;lng=-78.68041249999999&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<h5>2010-11 F&#038;R percentages show a well-defined trend of schools becoming more high-poverty moving from West to East, but there are less schools above the 75 percent mark.<\/h5>\n<p><strong>2010-11 EOG Results<\/strong><\/p>\n<p><iframe width=\"600\" height=\"300\" scrolling=\"no\"  src=\"https:\/\/www.google.com\/fusiontables\/embedviz?viz=MAP&#038;q=select+col1+from+3190184+&#038;h=false&#038;lat=35.717004942886504&#038;lng=-78.47649236328131&#038;z=9&#038;t=1&#038;l=col1\"><\/iframe><\/p>\n<\/h5>\n<p>2010-11 DPI Report Card grades show test scores decreasing from West to East that correlates with F&#038;R percentages.<\/h5>\n<p>The highest concentration of F&amp;R at any one school in 2009-10 was 62 percent (i.e. the last year of the diversity policy.) Next year, 18 schools will be above that mark.<\/p>\n<p>We also created a map indicating how much schools were under or over-chosen in the most recent selection round at the kindergarten level. Figures of more than 100 percent indicate by how much the school was over-chosen and vice-versa.<\/p>\n<p>We didn\u2019t find any correlation between this data and the other maps we compiled.<\/p>\n<p><em>Ideas for other maps or data visualization? Send them our way and we\u2019ll let you know if we can make it happen.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>New mapping by the Record shows that not only do schools get poorer moving from West to East across the county, test scores go down also. We also provided maps of additional years and saw a similar trend.<\/p>\n","protected":false},"author":24024,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[15,55],"tags":[119,511,512,513,210,385],"_links":{"self":[{"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/posts\/10585"}],"collection":[{"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/users\/24024"}],"replies":[{"embeddable":true,"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/comments?post=10585"}],"version-history":[{"count":0,"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/posts\/10585\/revisions"}],"wp:attachment":[{"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/media?parent=10585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/categories?post=10585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/theraleighcommons.org\/raleighpublicrecord\/wp-json\/wp\/v2\/tags?post=10585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}