HighNeedsLEAs; HighPovLEAs (Department of Education file name: VT-Moequity-Data.xlsx)

Summary

Vermont maintenance of equity workbook from the Department of Education with sheets for high-need and highest-poverty local educational agencies. The HighNeedsLEAs sheet lists supervisory unions and districts by SAIPE poverty rate with enrollment, cumulative enrollment against a high-need threshold of 39,464, total state funds and average daily membership for FY21 and FY22, state funds per ADM and the per pupil change, with exemptions noted. Orleans Central SU, with a poverty rate of 0.2477, shows a change of -157 explained by an FY22 surplus of 1.52 M against 1.05 M in FY21, and Missisquoi Valley School District a change of -406 explained by a surplus of 2.31 M against 0.89 M. A note records that Battenkill Valley SU dissolved into Southwest Vermont SU as of July 1, 2021. The HighPovLEAs sheet applies a threshold of 15,785 and compares FY19 with FY22.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Cite this document

“HighNeedsLEAs; HighPovLEAs (Department of Education file name: VT-Moequity-Data.xlsx).” Original at www.ed.gov. Archived at Pandemic Darlings, https://pandemicdarlings.com/source-documents/vt-moequity-data-xlsx-department-of-education-spreadsheet-f7cf4249f9/, SHA-256 c2f89bfdcf2c32ef4248d617a0662dc72435ccb65c13f5178b9f880721c339a0.

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: HighNeedsLEAs
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate	SU_ENROLLMENT	Cumulative Enr_CS	High-Need LEA (Cumulative Sum above 39,464)	Total FY21	ADM for FY21	State funds per ADM FY21	Total FY22	ADM for FY22	State funds per ADM FY22	Per Pupil change FY21 to FY22	Exemptions
5099934	SU034	Orleans Central SU	0.2477	1063	1063	Y	20102926.72	1079.05	18630	19996737.23	1082.46	18473	-157	See note below	FY22 surplus of 1.52 M vs FY21 of 1.05 M translates to a decrease in FY22 funding of 434 per ADM
5099917	SU017	Winooski SD	0.2418	795	1858	Y	18362697.93	838.76	21893	19185428.75	835.24	22970	1077	less than 1,000
5099911	SU011	St Johnsbury SD	0.2056	661	2519	Y	21896043.62	1120.85	19535	22439506.2	1118.4	20064	529
5099919	SU019	Essex North SU	0.1586	190	2709	Y	7513272.33	404.45	18577	8591516.56	403.5	21292	2715	less than 1,000
5099947	SU047	Windham Northeast SU	0.1572	1055	3764	Y	28266072.17	1197.42	23606	30733652.29	1202.03	25568	1962
5099956	SU056	Springfield SD	0.1452	1141	4905	Y	27987734.4	1245.44	22472	29302508.92	1253.71	23373	901	One school per grade span
5099940	SU040	Rutland City SU	0.1448	2019	6924	Y	38331532.16	1840.33	20829	41536662.39	1840.46	22569	1740
5099905	SU005	Southwest Vermont SU  * see note below	0.1418	2829	9753	Y	66898672.13	3508.78	19066	69327820.7	3511.94	19741	675
5099915	SU015	Burlington SD	0.1379	3552	13305	Y	77620804.4	3823.46	20301	78289745.86	3824.11	20473	172
5099931	SU031	North Country SU	0.1325	2554	15859	Y	52714792.36	2701.9	19510	55628848.96	2719.89	20453	943
5000407	SU067	Kingdom East Supervisory District	0.1297	1106	16965	Y	34038865.43	1807.16	18836	34609251.5	1807.23	19150	314
5099920	SU020	Franklin Northeast SU	0.1282	1789	18754	Y	33967183.6	1979.17	17162	35607962.29	1982.08	17965	803
5099904	SU004	Slate Valley Unified Union School District	0.1274	1212	19966	Y	24443954.49	1259	19415	24426439.89	1257.15	19430	15
5099948	SU048	Windham Southeast SU	0.1199	2489	22455	Y	55562219.09	2571.37	21608	58351509.97	2571.76	22689	1081
5099927	SU027	Orange East SU	0.1195	1482	23937	Y	38202806.61	1836.67	20800	39189881.08	1840.25	21296	496
5099928	SU028	Orange Southwest SU	0.1176	836	24773	Y	18466294.66	879.11	21006	18414813.99	869.15	21187	181	less than 1,000
5099936	SU036	Rutland Northeast SU	0.1151	1460	26233	Y	28430460.53	1580.84	17984	29361771.06	1579.25	18592	608
5099935	SU035	Orleans Southwest SU	0.1107	940	27173	Y	23359224.74	1071.66	21797	24476646.02	1085.59	22547	750
5099921	SU021	Missisquoi Valley School District	0.1089	1762	28935	Y	33756899.99	1835.14	18395	32999500.77	1834.41	17989	-406	See note below	FY22 surplus of 2.31 M vs FY21 of 0.89 M translates to a decrease in FY22 funding of 774 per ADM
5000007	SU061	Barre SU	0.1064	2138	31073	Y	43530540.1	2359.31	18451	44920933.36	2348.82	19125	674
5099926	SU026	Lamoille South SU	0.1055	1575	32648	Y	29594228.48	1622.95	18235	30739067.86	1617.05	19009	774
5099923	SU023	Maple Run SD	0.1049	2576	35224	Y	49615773.77	2532.12	19595	51569841.43	2525.49	20420	825
5099924	SU024	Grand Isle SU	0.1013	562	35786	Y	20218818.64	944.93	21397	20917952.34	944.69	22143	746	less than 1,000
5000385	SU063	Two Rivers SU	0.0964	856	36642	Y	21960634.51	1011.19	21718	22699016.63	1011.54	22440	722
5099949	SU049	Windham Southwest SU	0.0948	548	37190	Y	15783385.92	703.12	22448	15783900.31	707.3	22316	-132	less than 1,000
5099909	SU009	Caledonia Central SU	0.0935	1275	38465	Y	33184195.27	1495.08	22196	34137566.62	1509.01	22622	426
5099951	SU051	Windsor Central SU	0.0932	1057	39522	Y	20117422.91	987.64	20369	20721105.18	1007.45	20568	199
Note:
5099934	SU034	Orleans Central SU	FY22 surplus of 1.52 M vs FY21 of 1.05 M translates to a decrease in FY22 funding of 434 per ADM
5099921	SU021	Missisquoi Valley School District	FY22 surplus of 2.31 M vs FY21 of 0.89 M translates to a decrease in FY22 funding of 774 per ADM
Battenkill Valley SU (S060) dissolved and became a part of Southwest Vermont SU (S005) as of July 1, 2021, FY2022.
5000004	SU060	Battenkill Valley SU	0.0919881305637982	418	41604	N	8238645.28	407.64	20211							SU060 Battenkill Valley is part of SU005 Southwest Vermont beginning in FY2022

Sheet: HighPovLEAs
NCES District ID	State District ID	SU_Name	SAIPE_pov_rate	SU_ENROLLMENT	Cumulative Enr_CS	Highes-Poverty LEA (Cumulative Sum above 15,785)	Total FY19 State Funds	ADM for FY19	State funds per ADM FY19	Total FY22 State Funds	ADM for FY22	State funds per ADM FY22	Per Pupil change FY19 to FY22	Exemptions
5099934	SU034	Orleans Central SU	0.2477	1063	1063	Y	18841070.54	1086.84	17336	19996737.23	1082.46	18473	1137
5099917	SU017	Winooski SD	0.2418	795	1858	Y	16491369.98	886.08	18612	19185428.75	835.24	22970	4358	less than 1,000
5099911	SU011	St Johnsbury SD	0.2056	661	2519	Y	18630706.23	1130.95	16474	22439506.2	1118.4	20064	3590
5099919	SU019	Essex North SU	0.1586	190	2709	Y	8643863.49	406.15	21282	8591516.56	403.5	21292	10	less than 1,000
5099947	SU047	Windham Northeast SU	0.1572	1055	3764	Y	26161649.75	1282.09	20405	30733652.29	1202.03	25568	5163
5099956	SU056	Springfield SD	0.1452	1141	4905	Y	26109754.32	1253.61	20828	29302508.92	1253.71	23373	2545	One school per grade span
5099940	SU040	Rutland City SU	0.1448	2019	6924	Y	37107334.17	1968.4	18852	41536662.39	1840.46	22569	3717
5099905	SU005	Southwest Vermont SU  * see note below	0.1418	2829	9753	Y	63052538.09	3563.45	17694	69327820.7	3511.94	19741	2047
5099915	SU015	Burlington SD	0.1379	3552	13305	Y	71318062.9	3922.34	18183	78289745.86	3824.11	20473	2290
5099931	SU031	North Country SU	0.1325	2554	15859	Y	47277921.82	2639.51	17912	55628848.96	2719.89	20453	2541
Note:
Battenkill Valley SU (S060) dissolved and became a part of Southwest Vermont SU (S005) as of July 1, 2021 - FY2022.
5000004	SU060	Battenkill Valley SU

Sheet: Sheet3

File and source

File: department-of-education-excel-www-ed-gov-7ecc39417e.xlsx
Size: 18,882 bytes
SHA-256: c2f89bfdcf2c32ef4248d617a0662dc72435ccb65c13f5178b9f880721c339a0
Our copy: department-of-education-excel-www-ed-gov-7ecc39417e.xlsx
Original: www.ed.gov