EMID Data Analysis

We’ve heard a lot about the way EMID schools compare to member district schools. On this page we try to gather and analyze some data. Please let me know if you have ideas for other data that we should wrestle into shape to share on this page.

Member district expense growth and “per ADM” expenses


{“dataSourceUrl”:”//docs.google.com/spreadsheet/tq?key=0AoCOtaN2UAXDdDZUaDgyeFh3Z3BacFpyOThIdnBXSkE&transpose=1&headers=1&range=A1%3AJ12&gid=2&pub=1″,”options”:{“reverseCategories”:false,”series”:{“3”:{“color”:”#cccccc”},”2″:{“color”:”#cccccc”},”10″:{“color”:”#000000″},”1″:{“color”:”#cccccc”},”0″:{“color”:”#cccccc”},”7″:{“color”:”#cccccc”},”6″:{“color”:”#cccccc”},”5″:{“color”:”#cccccc”},”4″:{“color”:”#cccccc”},”9″:{“color”:”#cccccc”},”8″:{“color”:”#cccccc”}},”backgroundColor”:”#FFFFFF”,”pointSize”:0,”lineWidth”:2,”logScale”:false,”hAxis”:{“maxAlternations”:1},”hasLabelsColumn”:true,”vAxes”:[{“title”:”Multiple of 2005-level Expenditures”,”minValue”:1,”viewWindowMode”:”explicit”,”viewWindow”:{“min”:1,”max”:1.8},”maxValue”:1.8},{“viewWindowMode”:”pretty”,”viewWindow”:{}}],”title”:”EMID Member District Expenditure Growth since 2005″,”interpolateNulls”:false,”legend”:”right”,”reverseAxis”:false,”width”:600,”height”:450},”state”:{},”view”:”{\”columns\”:[0,1,2,3,4,5,6,7,8,9,10,11]}”,”chartType”:”LineChart”,”chartName”:”Chart 2″}

Expenditure Growth Chart PDF


{“dataSourceUrl”:”//docs.google.com/spreadsheet/tq?key=0AoCOtaN2UAXDdDZUaDgyeFh3Z3BacFpyOThIdnBXSkE&transpose=1&headers=1&range=A1%3AJ12&gid=0&pub=1″,”options”:{“series”:{“3”:{“color”:”#cccccc”},”2″:{“color”:”#cccccc”},”1″:{“color”:”#cccccc”},”10″:{“color”:”#000000″},”0″:{“color”:”#cccccc”},”7″:{“color”:”#cccccc”},”6″:{“color”:”#cccccc”},”5″:{“color”:”#cccccc”},”4″:{“color”:”#cccccc”},”9″:{“color”:”#cccccc”},”8″:{“color”:”#cccccc”}},”reverseCategories”:false,”curveType”:””,”titleX”:”Fiscal Year”,”backgroundColor”:”#FFFFFF”,”pointSize”:0,”width”:600,”lineWidth”:2,”logScale”:false,”hasLabelsColumn”:true,”hAxis”:{“maxAlternations”:1},”vAxes”:[{“title”:”Per ADM Expenditure”,”minValue”:5000,”viewWindowMode”:”explicit”,”viewWindow”:{“min”:5000,”max”:15000},”maxValue”:15000},{“viewWindowMode”:”pretty”,”viewWindow”:{}}],”title”:”EMID Member Per ADM Expenditures since 2005″,”height”:450,”interpolateNulls”:false,”legend”:”right”,”reverseAxis”:false},”state”:{},”view”:”{\”columns\”:[0,1,2,3,4,5,6,7,8,9,10,11]}”,”chartType”:”LineChart”,”chartName”:”ADMexp”}

Expenditure per ADM Chart PDF

Sources:

  • The data for these charts can be found in our EMID Families Member District Data Analysis spreadsheet.
  • The sources of 2005-2010 data include the Minnesota Department of Education (see the 2010 Total Expenditures spreadsheet) and the EMID Business Office (Shari Thompson provided EMID ADM counts and EMID data for 2005-2010). The expenditure amount for each district is the “Subtotal: General Fund Operating Expenditures” column less the amount in the “Student Transportation” column. This subtraction was made to more accurately compare with EMID expenses, which do not include transportation. The EMID amounts do not include OEI and administration of shared services since these are costs unrelated to the magnet schools and thier ADMs.
  • The 2011 and 2012 data were pulled from each district’s 2011-2012 budgets as found on each district web site. This means that 2011 data was unaudited and 2012 data was projected. Since there were no 2011 or 2012 transportation or ADM data, these were carried over from 2010.
  • Projected 2013 EMID data taken from the 10% reduction budget proposal presented in the January 2012 EMID board meeting packet.