Three types of downloads are available in this portion of the site:
1. The original paper and the Power Point presentation given by the author.
2. All of the “data” dealing with Indiana schools was drawn from the public domain. Some readers may want to check this work while others may want to do their own analyses. For these reasons, the primary data sources are here for the taking.
3.In addition there are interesting articles that will help to shed light on the issues and solutions to some of the problems outlined on this web site.
Paper and Presentation
To download, simply click on the line of the document/database you wish to peruse.
Download the original paper that is the basis for this web site – it is a WORD.doc document
Download the Power Point presentation used by the author.
View the Power Point presentation used by the author.
Data Files Used in this Research
These are the Excel files that will provide the data needed to replicate the work on this web site. The first files are the original files from which data was extracted to obtain the current working files.
Original Data Files
This file is the source of all the free and reduced meal percent data. Since the author could not find a file that merged school grades and free and reduced meal percentages a great deal of manual effort was spent moving these 2100 meal percent data values to the grade file.
The 2013-2014 analysis the new 2014 data on free and reduced percents did not use the report similar to the one above. The author decided not to use this 125 page report because some of the data was no longer valid, for example the Indianapolis Public Schools, by policy, set all schools to 100% free and reduced. A seemingly better source of data is available at the web site: compass.doe.in.gov. Using this web site requires one to “look up” each individual school and enter the data into the Excel data base containing the school grades. This task too 25 hours of tedious work.
Working Data Files
What is needed to conduct the analysis is a file of all schools with the free and reduced meal percent and the associated school grade. Here are two such files, one for the school year 2013-2014 and another for the year 2012-2013. When opening either of these files they can be viewed using Google Sheets (Excel like viewing) or they can be downloaded then opened using Excel.
This file was the basis of the analysis that points out that 10 Indiana school districts account for 55% of the Ds and Fs for the whole state. If this were a business many resources and talent would be assigned to these to districts in order to get a “big bang for the buck”.
The following is the Hit Parade of Outstanding Schools. These are ‘A’ schools that have overcome the restrictions of poverty to better educate their children.