We have created an Excel spreadsheet which allows users to create an easier to read School Aid run for any district passed on the state budget passed by the Legislature last week.
In addition to presenting the same information as the state-produced runs in an easier to analyze format, we provide more detail on federal aid and where districts stand in relation to full funding of the Foundation Aid formula.
Here is the link to access and use the spreadsheet .
It may take a while to load. Once it does, enter a district’s six digit BEDS Code to create a report. To look up a code for any district, click on the tab named “CODE LIST” at the bottom of the screen.
There are tabs for REPORT 1 and REPORT 2 on the bottom of the screen.
The upper section of REPORT 1 replicates what appears on the state-produced aid runs but with the two years of aid for each category presented side-by-side, along with the change and percentage change by category. This makes it easier to identify which aid categories are most influencing the change in total aid.
The lower section provides more detail.
First, in the state-produced runs, the Pandemic Adjustment is included in 2020-21 aids, but not the offsetting allocations from the federal CARES Act. While this is an accurate representation of state funding, it arguably has the effect of making the change in total funding appear greater than it “feels” for each district. We include a row showing the change in total funding excluding the 2020-21 Pandemic Adjustment.
Second, for some districts, 2021-22 Universal Prekindergarten Aid includes a new full-day prekindergarten expansion grant. We include a row with this sum for affected districts.
Third, at the bottom of the state-produced runs, estimates appear for district allocations from the December Coronavirus Relief and Recovery Supplemental Appropriations Act (CRRSAA) and March American Rescue Plan Act (ARPA)—“CRRSA 90% ESSER + BASE ALLOC” and “AMERICAN RESCUE PLAN,” respectively. We include rows for these sums.
For some districts, the American Rescue Plan allocations are comprised of two parts—an allocation based on shares of Title 1 funding as required by federal law, plus a “Learning Loss Grant.” We show the total ARPA allocation and separate lines for these two components.
Under ARPA, states are allowed or required to reserve parts of their federal education funding for specified purposes, including at least 5% to address learning loss, at least 1% for summer enrichment programs, and at least 1% for after-school programs. The enacted budget aims to satisfy these federally required set-asides through the Learning Loss Grants program.
All districts are required to use at least 20% of their allocations based on Title 1 shares to address learning loss. The Learning Loss Grants are in addition to those local set-asides. We provide more information about the learning loss funding here.
Finally, we include a row showing required community schools set-asides for affected districts—although not included on state-produced runs, that requirement has been continued.
REPORT 2 presents changes in aid estimates over time: from March 2020 to November 2020 to April 2021 for 2020-21 aid and from November 2020 to April 2021-22 aid. The March 2020 estimates reflect what districts were projected to receive at the time the 2020-21 state budget was enacted. The November 2020 database was used for the Governor’s budget proposal. The April 2021 figures reflect what is projected for the 2021-22 enacted state budget.
Please call or write to firstname.lastname@example.org with any questions or suggestions.
Here are some other resources:
- State Education Department Memorandum on American Rescue Plan Funding
- Compilation of Education-Related Funding Provisions of the American Rescue Plan
- U.S. Department of Education FACT SHEET American Rescue Plan Act of 2021 Elementary and Secondary School Emergency Relief Fund (ARP ESSER)