CONFERENCE 2012 DATA files

Files for September 2012 SSFC workshops

Here are file names and descriptions:
File Name:  SSFC Possible Extrapolation 1314 Aid 091812
Description:  This is a “possible “extrapolation of 2013-14 state aid based on how 2012=13 worked, but with no change to Foundation Aid, Increased reduction in the GEA cuts, but less state aid due to the Personal Income Tax (PIT) cap on total state aid- the amount is diminished from 2012-13 to 2013-14.

File Name:  One Page 101574575 Fy 2013 July Update Fiscal Update From DOB
Description:  This is just one page from the DOB budget update from July of 2013.  The chart shows the estimated state budget deficits for the next three years.

File Name: Percent Foundation Aid Fully Funded 091812
Description:  This is a portion of the state aid files for 2012-13.  Additionally, the spreadsheet calculates the percent each district that compares its current Foundation Aid amount (2012-13) with the “Fully Funded” amount found on the SED spreadsheets for 2012-13.

File Name:  How Much IWI No Floor 1213 09 18 12
Description:  This is our approximation of the amount of aid due to each school district as a result of the lowering of the IWI floor from .65 to ZERO.  The SSFC has held that the IWI is a significant part of the Foundation Aid formula that makes it more inequitable.  We recommend the movement of the IWI Floor from .65 to Zero.

File Name:  IWI All Figured Out June 2012 Basis
Description: This is the file we used with and tested on other state aid wonks.  It appears to be as correct as we can get it.  It is here mostly for policymakers and state executive and legislative staff to examine how we came up with our data and recommendation for the change in IWI floor from .65 to Zero.  Every time we work on this issue the data reveal the advantages to the districts with the less fiscal capacities based on income because they have been shortchanged every year since 2007-08.

File Name:  Bullet Aid 1213 FRPL 091812
Description:  This is a spreadsheet based on our reading of the Bullet aid legislation passed over the last few months.  It is sorted by FRPL.  Note there is not relationship between the distribution of Bullet Aid and the FRPL as just one measure of school district poverty.  Absent that indicator, it would suggest that the distribution of Bullet Aid was not only political but indiscriminate and the antithesis of any equitable solution to the ills of the Foundation Aid Formula.

File Name:  Bullet Aid 1213 CWR 091812
Description:  This is a spreadsheet based on our reading of the Bullet aid legislation passed over the last few months.  It is sorted by CWR.  Note there is not relationship between the distribution of Bullet Aid and the CWR as just one measure of school district fiscal capacity.  Absent that indicator, it would suggest that the distribution of Bullet Aid was not only political but indiscriminate and the antithesis of any equitable solution to the ills of the Foundation Aid Formula.

File Name:  Bullet Aid 1213 Low Per Student 091812
Description:  This is a spreadsheet based on our reading of the Bullet aid legislation passed over the last few months.  It is sorted by per student amounts of Bullet Aid.  Note there is not relationship between the distribution of Bullet Aid and per student amounts of Bullet Aid (sorted from the lowest to highest) as just one measure a rational approach to the distribution of such funds.  Absent that indicator, it would suggest that the distribution of Bullet Aid was not only political but indiscriminate and the antithesis of any equitable solution to the ills of the Foundation Aid Formula.

File Name:  Compare Contrast GEA Cuts Equity 12-13 Enrollment 091812
Description:  This file, sorted by Enrollment, enables school districts to compare and contrast school districts in all of New York State.  Subsets include Budget and Levy (from Property Tax Report Card), CWR, FRPL, Enrollment, County and current GEA (from current state aid files), the GEA per student and Amount Above or Below the Average GEA cut (as calculated from the spreadsheet data).

File Name:  Compare Contrast GEA Cuts Equity 12-13 091812
Description:  This file, sorted by County, enables school districts to compare and contrast school districts in all of New York State.  Subsets include Budget and Levy (from Property Tax Report Card), CWR, FRPL, Enrollment, County and current GEA (from current state aid files), the GEA per student and Amount Above or Below the Average GEA cut (as calculated from the spreadsheet data).

File Name:  State Aid Replenish EJF Worst FRPL 2012-13 09/18/12-13
Description:  This file represents the lowest the percents (under 50%) of the total amount (value) of Educational Job Funds ( “EJF” 2010-11 Federal program) replenished by the recent state aid increases for 2012-13.  These data reveal the obvious inequities in the state aid increases because they appear by the measures indicated to be uncorrelated in any way.  Those with the least amount of replenishment are a mixture of the very wealthy and many considerably poorer school districts across the state.  Clearly, the amount of state aid increases for 2012-13 were insufficient for all of these districts to make up the loss of EJF.  Inequity exists when the districts in this subset have large amounts of poverty as indicated by FRPL as one measure, and CWR as the fiscal capacity measure are not replenished at a greater rate than their school district counterparts that have little or no poverty or have greater fiscal capacity due to their significant income and property wealth.

File Name:  State Aid Replenish EJF 2012-13 091812
Description:  This file represents all school districts and the percent of the total the amount (value) of Educational Job Funds ( “EJF” 2010-11 Federal program) replenished by the recent state aid increases for 2012-13.  These data reveal the obvious inequities in the state aid increases because they appear by the measures indicated to be uncorrelated in any way.  Those with the least amount of replenishment are a mixture of the very wealthy and many considerably poorer school districts across the state.  Clearly, the amount of state aid increases for 2012-13 were insufficient for significant numbers of districts to make up the loss of EJF.  Inequity exists when the districts have large amounts of poverty as indicated by FRPL as one measure, and CWR as the fiscal capacity measure are not replenished at a greater rate than their school district counterparts that have little or no poverty or have greater fiscal capacity due to their significant income and property wealth.

File Name:  Summary Aid with Loses 2010-13 Impact 091812
Description:  This file shows the overall amounts of different state aid categories, state aid diminishments and changes in those amounts for 2010-11, 2011-12, and 2012-13.  Additionally, it also notes the projected cost of Full implementation of Foundation Aid, the current amount needed to eliminate the GEA and an estimated amount for other aids to determine the amount of funds need immediately to fulfill fill the “promise “ of full funding in 2007-08 by the state to school districts.  Further, it shows how long it would take to fully fund Foundation Aid and eliminate the GEA as extrapolated from the progress on both fronts made in the 2012-13 state aid to school budget.

File Name:  Time To Eliminate GEA
Description:  This file shows how long it would take to just eliminate the GEA for each school district in the state as extrapolated from the progress on the reduction of the GEA made in the 2012-13 state aid to school budget.  Many school districts, particularly those with higher levels of poverty or lower fiscal capacity and marginal fund balances, do not have the resources to sustain their educational or fiscal programs as long as the spreadsheet indicates.

File Name:  2012-13 PTRC5 Full Data Post Reserves Only
Description:  This file shows how long it would take to exhaust all reserves, cash reserves only, restricted reserves only as a method of annual replenishment of a school district Appropriated Fund Balance used to offset taxes.  All school district are represented with all of their reserves as indicated by the Property Tax Report Card for 2012-13. Small Print!

File Name:  2012-13 PTRC5 Full Data Post Abbreviated Reserves Only
Description: This file is an abbreviated version of the data that shows how long it would take to exhaust all reserves, cash reserves only, restricted reserves only as a method of annual replenishment of a school district Appropriated Fund Balance used to offset taxes.  All school district are represented with all of their reserves as indicated by the Property Tax Report Card for 2012-13.

File Name:  State Aid Formulas & NY Senate Not Making the Grade for Our Schools, Children & Communities 120111.pdf
Description: State Aid Formulas & NY Senate Not Making the Grade for Our Schools, Children & Communities 120111 was written by SSFC in December of 2011 to provide the history of state aid from 2006 through 2010-11.  It includes a description and origin of the strategy and term know as the “shares agreement”.  It also demonstrates the distribution of state aid to SSFC school districts when compared to their wealthier counterparts based on senatorial districts and 2011-12 state aid.

File Name:  Problems with and Recommendations for the Foundation Aid Formula 092012.pdf
Description:  These are the seven major changes recommended by the SSFC that are needed to make the Foundation Aid formula more equitable.

File Name:  A Tale of Two School Districts: The Original 2007-8 Version.pdf
Description:  This was the first SSFC “compare and contrast lesson” by Rick Timbs given in testimony to the Suozzi Commission and subsequently to legislators.  It drew a stark comparison of the finances and program offerings between a fairly wealthy school districts and a lower wealth SSFC district.  These data are compelling and clearly point to the inequities in the Foundation Aid formula since its inception.  It is just one way to show what happens to SSFC school districts when compared to wealthier counterparts and can be updated to reflect current times and issues.

File Name:  Tale of Two Districts: VVS v N-EN the 2010 Norm Reed Improvement.pdf
Description:  This was a presentation by SSFC founding father Norm Reed (then superintendent of the Vernon-Verona-Sherrill (City of Sherrill SD) school district in Central New York.  This excellent improvement on the original Tale of Two School Districts (noted above) “compare and contrast lesson” was used with members of the CNY legislature and the head of the Senate Education Committee.  This concrete and easy to understand comparison of the finances and program offerings between a fairly wealthy school district and VVS CSD.  These data are clear and unambiguous.  The inequities in the Foundation Aid formula and the GEA cuts are terribly destructive.  Your legislators and citizens deserve to know the results of inequitable and neglected state policy. Such a presentation can be updated with your district data to reflect current times and issues.