{"id":949,"date":"2022-04-20T17:54:24","date_gmt":"2022-04-20T22:54:24","guid":{"rendered":"https:\/\/bennettforoffice.org\/?p=949"},"modified":"2022-04-20T17:54:24","modified_gmt":"2022-04-20T22:54:24","slug":"dpi-data-errors","status":"publish","type":"post","link":"https:\/\/bennettforoffice.cityofplayers.com\/?p=949","title":{"rendered":"DPI Data Errors"},"content":{"rendered":"\n<p>I&#8217;m currently writing a program that will let me take in all of the DPI&#8217;s spreadsheet data, aggregate it, and calculate the state average and ranking for the five main metrics &#8211; Overall Score, Student Achievement Score, Student Growth Score, Closing Gaps, and School On-Track and Postsecondary Readiness Score.<\/p>\n\n\n\n<p>However, during debugging the program and getting it ready for release, I&#8217;ve found some&#8230; issues with the data. Not only are the column headers inconsistent (sometimes it&#8217;s called &#8220;On-Track&#8221;, sometimes it&#8217;s called &#8220;On Track&#8221;), but I&#8217;ve also found something completely unexpected:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/bennettforoffice.org\/wp-content\/uploads\/2022\/04\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"130\" src=\"https:\/\/bennettforoffice.org\/wp-content\/uploads\/2022\/04\/image-7-1024x130.png\" alt=\"\" class=\"wp-image-961\" srcset=\"https:\/\/bennettforoffice.cityofplayers.com\/wp-content\/uploads\/2022\/04\/image-7-1024x130.png 1024w, https:\/\/bennettforoffice.cityofplayers.com\/wp-content\/uploads\/2022\/04\/image-7-300x38.png 300w, https:\/\/bennettforoffice.cityofplayers.com\/wp-content\/uploads\/2022\/04\/image-7-768x98.png 768w, https:\/\/bennettforoffice.cityofplayers.com\/wp-content\/uploads\/2022\/04\/image-7-1536x195.png 1536w, https:\/\/bennettforoffice.cityofplayers.com\/wp-content\/uploads\/2022\/04\/image-7.png 1691w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Apparently, in the 2017-18 school year, the school &#8220;Blessed Savior Catholic School&#8221; managed to obtain TWO separate rows of scoring data, including two completely different &#8220;Exceeds Expectations&#8221; Overall Accountability Scores.<\/p>\n\n\n\n<p>What a lucky school, to Exceed Expectations so well, that they get a double score!!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m currently writing a program that will let me take in all of the DPI&#8217;s spreadsheet data, aggregate it, and calculate the state average and ranking for the five main metrics &#8211; Overall Score, Student Achievement Score, Student Growth Score, Closing Gaps, and School On-Track and Postsecondary Readiness Score. However, during debugging the program and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-949","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=\/wp\/v2\/posts\/949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=949"}],"version-history":[{"count":0,"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=\/wp\/v2\/posts\/949\/revisions"}],"wp:attachment":[{"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bennettforoffice.cityofplayers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}