Pandemic Darlings The pandemic economy, in original documents
Home Source documents District of Columbia, Maintenance of Equity Data Submission (7/30/21)

District of Columbia, Maintenance of Equity Data Submission (7/30/21)

Summary

The District of Columbia's maintenance of equity data submission, a spreadsheet whose overview sheet maps nine required items to tabs: a list of the State's high-need LEAs with NCES IDs (Tab 1), the statewide per-pupil amount of State funds provided to all LEAs in FY21 and FY22 (Tab 2), the per-pupil amount for each high-need LEA in FY 2021 and FY 2022 (Tab 3), a list of the highest-poverty LEAs (Tab 1) with their per-pupil State funding in FY 2019 and FY 2022 (Tab 4), and the high-poverty schools in each LEA for which equity must be maintained in FY 2022 (Tab 5). Table 1 on the next sheet gives SEA totals, with SY20-21 enrollment of 97467, and sets the high-need LEA line at 50% of cumulative enrollment and the highest-poverty line at 20%. A note says SNAP, TANF or foster-care participation was used to designate high-poverty schools.

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

“District of Columbia, Maintenance of Equity Data Submission (7/30/21).” Original at www.ed.gov. Archived at Pandemic Darlings, https://pandemicdarlings.com/source-documents/district-of-columbia-maintenance-of-equity-data-submission-7-30-21-2b4ccc0e1b/, SHA-256 a3d252d388a8aafc561c123c653f6534def48ff54e1680a176cb688ce7f1ceb6.

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: Overview of Submission
District of Columbia, Maintenance of Equity Data Submission (7/30/21)
1. A list of the State's high-need LEAs including NCES LEA/district ID	Tab 1
2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21	Tab 2
3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22	Tab 2
4. The per pupil-amount of State funds provided to each high-need LEA in the state in FY 2021	Tab 3
5. The per pupil-amount of State funds provided to each high-need LEA in the state in FY 2022	Tab 3
6. A list of the state's highest-poverty LEAs including NCES LEA/ district ID	Tab 1
7. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2019	Tab 4
8. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2022	Tab 4
9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.	Tab 5

Sheet: 1. High-Need High-Poverty LEAs
Table 1. SEA Data
SEA Totals	LEA Relative Poverty Share (same as Title I-A)	SY20-21 Enrollment Total	Cumulative Enrollment	High-Need LEA (50% of cumulative enrollment is 50k)	Highest Poverty LEA (20% of cumulative enrollment is 20k)		High-Need LEA Name	High-Need LEA NCES Code		Highest Poverty LEA Name	Highest Poverty LEA NCES Code
District of Columbia Totals	1	97467	n/a	46719	19493.4		DCPS	1100030		DCPS	1100030
Table 2. High-Need and Highest-Poverty LEAs
LEAs (from highest poverty percentage to lowest)*	LEA Relative Poverty Share (same as Title I-A)	SY20-21 Enrollment Total	Cumulative Enrollment	High-Need LEA (50% of cumulative enrollment is 50k)	Highest Poverty LEA (20% of cumulative enrollment is 20k)
District of Columbia Public Schools (DCPS)	0.5612	53610	53610	Yes	Yes
KIPP DC Public Charter School	0.0931	6963	60573	No	No
Friendship Public Charter School	0.0703	4519	65092	No	No
DC Preparatory Public Charter School	0.0302	2160	67252	No	No
Rocketship Academy Public Charter	0.0202	1524	68776	No	No
Center City Public Charter School	0.0173	1450	70226	No	No
Ingenuity Preparatory Public Charter School	0.0131	756	70982	No	No
Euphemia L. Haynes Public Charter School	0.0118	1190	72172	No	No
Paul Public Charter School	0.0113	716	72888	No	No
Capital City Public Charter School	0.0107	1007	73895	No	No
Eagle Academy Public Charter School	0.0092	705	74600	No	No
DC Scholars Public Charter School	0.0088	605	75205	No	No
Digital Pioneers Academy Public Charter School	0.008	337	75542	No	No
Two Rivers Public Charter School	0.0079	974	76516	No	No
Cesar Chavez Public Charter School	0.0078	374	76890	No	No
Hope Community Public Charter School	0.0077	559	77449	No	No
Meridian Public Charter School	0.0069	603	78052	No	No
Cedar Tree Academy Public Charter School	0.006	428	78480	No	No
Integrated Design Electronics Academy (IDEA) Public Charter School	0.0057	316	78796	No	No
Perry Street Preparatory Public Charter School	0.0057	446	79242	No	No
Thurgood Marshall Academy Public Charter School	0.0055	367	79609	No	No
The Children's Guild Public Charter School	0.0052	281	79890	No	No
Mary McLeod Bethune Public Charter School	0.005	370	80260	No	No
Kingsman Academy Public Charter School	0.0047	257	80517	No	No
Richard Wright Public Charter School	0.0047	299	80816	No	No
Howard University Middle School for Math & Science Public Charter School	0.0041	287	81103	No	No
Washington Global Public Charter School	0.0041	229	81332	No	No
Elsie Whitlow Stokes Public Charter School	0.0038	583	81915	No	No
SEED Public Charter School	0.0037	221	82136	No	No
Washington Leadership Academy Public Charter School	0.0037	409	82545	No	No
Creative Minds Public Charter School	0.0035	540	83085	No	No
DC Bilingual Public Charter School	0.0035	478	83563	No	No
Statesman College Prep Academy for Boys Public Charter School	0.0035	185	83748	No	No
Early Childhood Academy Public Charter School	0.0034	287	84035	No	No
Achievement Preparatory Academy Public Charter School	0.0033	261	84296	No	No
Maya Angelou Public Charter School	0.0032	370	84666	No	No
Bridges Public Charter School	0.0031	396	85062	No	No
St. Coletta Public Charter School	0.0031	243	85305	No	No
Social Justice Public Charter School	0.0022	48	85353	No	No
Harmony Public Charter School	0.002	113	85466	No	No
Capital Village Public Charter School	0.0018	51	85517	No	No
Monument Academy Public Charter School	0.0017	88	85605	No	No
LEARN DC Public Charter School	0.0016		85605	No	No
Girls Global Academy Public Charter School	0.0015	65	85670	No	No
Roots Public Charter School	0.0014	117	85787	No	No
Shining Stars Montessori Academy Public Charter School	0.0013	287	86074	No	No
Sela Public Charter School	0.0011	260	86334	No	No
I Dream Academy Public Charter School	0.0008	56	86390	No	No
Sojourner Truth Montessori Public Charter School	0.0006	91	86481	No	No
AppleTree Early Learning Public Charter School	0	492	86973	No	No
BASIS Public Charter School	0	663	87636	No	No
Breakthrough Academy Public Charter School	0	271	87907	No	No
Briya PCS	0	745	88652	No	No
DC International Public Charter School	0		88652	No	No
Global Citizens Public Charter School	0		88652	No	No
Inspired Teaching Demonstration Public Charter School	0	514	89166	No	No
Latin American Montessori Bilingual (LAMB) Public Charter School	0	519	89685	No	No
Lee Montessori Public Charter School	0	378	90063	No	No
Mundo Verde Bilingual Public Charter School	0	955	91018	No	No
Washington Latin Public Charter School	0	734	91752	No	No
Washington Yu Ying Public Charter School	0	577	92329	No	No
* Small Area Income and Poverty Estimates (SAIPE) was available and sed for District of Columbia Public Schools (DCPS) but not charter school LEAs which represent a significant portion of students in DC. Therefore, OSSE used the same methodology to determine percentage share of poverty represented by each LEA used to determine Title I-A eligibility and allocations

Sheet: 3. Data Requests
	Data Needed	Who Has	Available (Y/N)	Delivered (Y/N)	Deliverable Aligned with		Calculations to Show	Methodology
	Enrollment by LEA (FY21 & FY22)	Bonnie & Ryan	Y		1. A list of the State's high-need LEAs including NCES LEA/district ID		Overall State Per-pupil funding in FY21	total state local funding/ total enrollment
	SAIPE Poverty Percentage by LEA				1. A list of the State's high-need LEAs including NCES LEA/district ID		Overall State Per-pupil funding in FY22	total state local funding/ total enrollment
	Total number of LEAs in FY21				2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21		Reduction of Per-Pupil funding in FY22/FY21	overall state per-pupil funding in FY21 - overall state per-pupil funding in FY22
	Total number of LEAs in FY22				3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22		LEA per-pupil funding	LEA enrollment/ LEA projected funding for x year
	Total of State funds in FY21	Ryan	Y	2021-07-09	2. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY21
	Total of State funding FY22	Ryan	Y	2021-07-09	3. The statewide per-pupil amount of State funds provided to all LEAs in the state in FY22
	Total of State funding FY19	Ryan	Y	2021-07-09	7. The per-pupil amount of State funding provided for each highest-poverty LEA in FY 2019
	LEAs with more than 1000	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.
	LEAs with only 1 school	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.
	Schools that have all gradespans in one school	Bonnie	Y	2021-07-01	9. A list of the high-poverty schools in each LEA in the State (including the NCES school ID) for which it must maintain equity in FY 2022.

Sheet: 2. State-wide PP Calculation
	FY 2021 State Funding	FY 2021 Enrollment	FY 2021 Per Pupil Funding	FY 2022 State Funding	FY 2022 Enrollment	FY 2022 Per-Pupil State Funding
District of Columbia	1916204972	97467	19660.04	2015746495	98589	20445.96
				Note: All FY22 data is based on projections

Sheet: 3. High-Need LEA Table
	FY 2021 State Funding	FY 2021 Enrollment	FY 2021 Per Pupil Funding	FY 2022 State Funding	FY 2022 Enrollment	FY 2022 Per-Pupil State Funding
DCPS (1100030)	982008778	53610	18317.6418205559	1005650262	52575	19128
				Note: All FY22 data is based on projections

Sheet: 4. Highest-Poverty LEA Table
	FY 2019 State Funding	FY 2019 Enrollment	FY 2019 Per Pupil Funding	FY 2022 State Funding	FY 2022 Enrollment	FY 2022 Per-Pupil State Funding
DCPS (1100030)	847735517	50221	16880.1002966886	1005650262	52575	19128
				Note: All FY22 data is based on projections

Sheet: 5. LEA High Poverty School List
	FY22 Highest Poverty Schools for LEAs Required to Maintain Equity
	LEA Name	LEA Code	School Name	NCES School ID	Poverty Percentage (FY20)*
	Rocketship Academy Public Charter	1100106	Rise Academy	110010600509	0.82
	Friendship Public Charter School	1100008	Southeast Elementary	110000800382	0.79
		1100008	Blow Pierce Elementary	110000800479	0.74
		1100008	Ideal Elementary	110000800530	0.71
		1100008	Blow Pierce Middle	110000800478	0.69
	DC Preparatory Public Charter School	1100048	Anacostia Elementary	110004800501	0.68
		1100048	Benning Middle	110004800474	0.57
	Center City Public Charter School	1100073	Trinidad Elementary	110007300403	0.63
		1100073	Capitol Hill Elementary	110007300393	0.6
	KIPP DC Public Charter School	1100031	Honor Academy PCS	110003100522	0.73
		1100031	Somerset College Preparatory PCS	110003100523	0.71
		1100031	Discover Academy PCS	110003100427	0.7
		1100031	Heights Academy PCS	110003100452	0.63
		1100031	LEAP Academy PCS	110003100375	0.61
	District of Columbia Public Schools	1100030	Hendley Elementary School	110003000182	0.9
		1100030	Patterson Elementary School	110003000158	0.89
		1100030	Stanton Elementary School	110003000013	0.89
		1100030	Savoy Elementary School	110003000025	0.88
		1100030	Kramer Middle School	110003000143	0.88
		1100030	Malcolm X Elementary School @ Green	110003000036	0.85
		1100030	Turner Elementary School	110003000073	0.85
		1100030	Garfield Elementary School	110003000165	0.84
		1100030	Ketcham Elementary School	110003000176	0.84
		1100030	Kimball Elementary School	110003000173	0.84
		1100030	King Elementary School	110003000102	0.84
		1100030	C.W. Harris Elementary School	110003000185	0.83
		1100030	Moten Elementary School	110003000002	0.83
		1100030	Johnson Middle School	110003000144	0.83
		1100030	Aiton Elementary School	110003000122	0.82
		1100030	Lawrence E. Boone Elementary School	110003000161	0.81
		1100030	Walker-Jones Education Campus	110003000070	0.81
		1100030	Excel Academy	110003000519	0.8
		1100030	Thomas Elementary School	110003000049	0.8
		1100030	Hart Middle School	110003000135	0.8
		1100030	Ballou STAY High School	110003000207	0.79
		1100030	Plummer Elementary School	110003000126	0.76
		1100030	Drew Elementary School	110003000097	0.75
		1100030	Sousa Middle School	110003000019	0.75
		1100030	Anacostia High School	110003000085	0.75
		1100030	Simon Elementary School	110003000054	0.74
		1100030	Smothers Elementary School	110003000064	0.74
		1100030	Burrville Elementary School	110003000106	0.73
		1100030	Kelly Miller Middle School	110003000272	0.72
		1100030	Browne Education Campus	110003000152	0.71
	*Direct certification poverty percentages, which are  determined based on a count of students who qualify for Supplemental Nutrition Assistance Program (SNAP), Temporary Assistance for Needy Families (TANF), or are under the care of Child Foster Services Administration (CFSA), were used to designate high poverty schools for each LEA

File and source

File
department-of-education-excel-www-ed-gov-97431efb86.xlsx
Size
41,754 bytes
SHA-256
a3d252d388a8aafc561c123c653f6534def48ff54e1680a176cb688ce7f1ceb6
Our copy
department-of-education-excel-www-ed-gov-97431efb86.xlsx
Original
www.ed.gov
Back to top