High Need; Per Pupil (Department of Education file name: MD-Maint-of-Equity-Final-7-30-2021-USDE-Request-8-4-2021.xlsx)

Summary

A spreadsheet file named MD-Maint-of-Equity-Final-7-30-2021-USDE-Request-8-4-2021.xlsx, described as a Department of Education spreadsheet. The sheet High Need has the columns NCES District ID, District Name, Total Population Relevant Ages 5 to 17, Population Relevant Ages 5 to 17 in Families in Poverty, Ratio and Y or N flags for High Need, with a row for each public school system beginning with Baltimore City Public Schools, Somerset County Public Schools and Dorchester County Public Schools. A second sheet, High Poverty, lists the districts with similar population and poverty figures.

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

“High Need; Per Pupil (Department of Education file name: MD-Maint-of-Equity-Final-7-30-2021-USDE-Request-8-4-2021.xlsx).” Original at www.ed.gov. Archived at Pandemic Darlings, https://pandemicdarlings.com/source-documents/md-maint-of-equity-final-7-30-2021-usde-request-8-4-2021-xlsx-departme-09d741d8c8/, SHA-256 1bcd55b7f18770248f1c71fc20e359f66f082ea6442a69570eb23d8d8e2a097d.

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: High Need
NCES District ID	District Name	Total Population	Relevant Ages 5 to 17 Population	Relevant Ages 5 to 17 in Families in Poverty	Relevant Ages 5 to 17 Ratio	High Need - Total Enroll	High Need - FTE	High Need - FTE w/ Prek	FY 2021 FTE w/ PreK 9-30-2019
2400090	Baltimore City Public Schools	593490	83117	25540	30.7	Y	Y	Y	77913.5
2400570	Somerset County Public Schools	25616	3165	885	28	Y	Y	Y	18083
2400300	Dorchester County Public Schools	31929	4937	1136	23	Y	Y	Y	4689.25
2400690	Wicomico County Public Schools	103609	16413	3464	21.1	Y	Y	Y	15172.25
2400030	Allegany County Public Schools	70416	8962	1549	17.3	Y	Y	Y	8410.25
2400180	Caroline County Public Schools	33406	5828	1003	17.2	Y	Y	Y	5872.5
2400360	Garrett County Public Schools	29014	3949	657	16.6	Y	Y	Y	3832.25
2400450	Kent County Public Schools	19422	2221	369	16.6	Y	Y	Y	1917.25
2400660	Washington County Public Schools	151049	24216	3662	15.1	Y	Y	Y	22958
2400720	Worcester County Public Schools	52276	6754	927	13.7	Y	Y	Y	6850
2400510	Prince George's County Public Schools	909327	142020	18730	13.2	Y	Y	Y	135857
2400630	Talbot County Public Schools	37181	5033	631	12.5	Y	Y	Y	4699.75
2400120	Baltimore County Public Schools	827370	130075	14216	10.9	Y	Y	Y	114590.75
2400240	Cecil County Public Schools	102855	17279	1866	10.8	Y	Y	Y	15256.25
2400600	St. Marys County Public Schools	113510	19959	1954	9.8	Y	Y	Y	2900
2400270	Charles County Public Schools	163257	29236	2640	9	Y	Y	Y	27517
2400480	Montgomery County Public Schools	1050688	177867	14835	8.3	N	N	N	165065.25
2400390	Harford County Public Schools	255441	42210	3307	7.8	N	N	N	38421
2400060	Anne Arundel County Public Schools	579234	93372	7095	7.6	N	N	N	84847.25
2400540	Queen Annes County Public Schools	50381	8199	556	6.8	N	N	N	7764
2400150	Calvert County Public Schools	92525	16375	1084	6.6	N	N	N	16002.25
2400330	Frederick County Public Schools	259547	44664	2494	5.6	N	N	N	43651
2400420	Howard County Public Schools	325690	59766	3157	5.3	N	N	N	58746
2400210	Carroll County Public Schools	168447	27133	1312	4.8	N	N	N	25339.25
									906355
								0.5	453177.5

Sheet: High Poverty
NCES District ID	District Name	Total Population	Relevant Ages 5 to 17 Population	Relevant Ages 5 to 17 in Families in Poverty	Relevant Ages 5 to 17 Ratio	High Poverty - Total Enroll	High Poverty - FTE	High Poverty - FTE w/PreK	FY 2021 FTE w/ Prek  9-30-2019
2400090	Baltimore City Public Schools	593490	83117	25540	30.7	Y	Y	Y	77913.5
2400570	Somerset County Public Schools	25616	3165	885	28	Y	Y	Y	18083
2400300	Dorchester County Public Schools	31929	4937	1136	23	Y	Y	Y	4689.25
2400690	Wicomico County Public Schools	103609	16413	3464	21.1	Y	Y	Y	15172.25
2400030	Allegany County Public Schools	70416	8962	1549	17.3	Y	Y	Y	8410.25
2400180	Caroline County Public Schools	33406	5828	1003	17.2	Y	Y	Y	5872.5
2400360	Garrett County Public Schools	29014	3949	657	16.6	Y	Y	Y	3832.25
2400450	Kent County Public Schools	19422	2221	369	16.6	Y	Y	Y	1917.25
2400660	Washington County Public Schools	151049	24216	3662	15.1	Y	Y	Y	22958
2400720	Worcester County Public Schools	52276	6754	927	13.7	Y	Y	Y	6850
2400510	Prince George's County Public Schools	909327	142020	18730	13.2	Y	Y	Y	135857
2400630	Talbot County Public Schools	37181	5033	631	12.5	N	N	N	4699.75
2400120	Baltimore County Public Schools	827370	130075	14216	10.9	N	N	N	114590.75
2400240	Cecil County Public Schools	102855	17279	1866	10.8	N	N	N	15256.25
2400600	St. Marys County Public Schools	113510	19959	1954	9.8	N	N	N	2900
2400270	Charles County Public Schools	163257	29236	2640	9	N	N	N	27517
2400480	Montgomery County Public Schools	1050688	177867	14835	8.3	N	N	N	165065.25
2400390	Harford County Public Schools	255441	42210	3307	7.8	N	N	N	38421
2400060	Anne Arundel County Public Schools	579234	93372	7095	7.6	N	N	N	84847.25
2400540	Queen Annes County Public Schools	50381	8199	556	6.8	N	N	N	7764
2400150	Calvert County Public Schools	92525	16375	1084	6.6	N	N	N	16002.25
2400330	Frederick County Public Schools	259547	44664	2494	5.6	N	N	N	43651
2400420	Howard County Public Schools	325690	59766	3157	5.3	N	N	N	58746
2400210	Carroll County Public Schools	168447	27133	1312	4.8	N	N	N	25339.25
									906355
								0.2	181271

Sheet: Per Pupil
NCES District ID	District Name	High Needs	High Poverty	FY 2019 Per Pupil	FY 2020 Per Pupil	FY 2021 Per Pupil	FY 2022 Per Pupil		Per Pupil Change FY 2022 - FY 2021	Meets High Needs MOEquity		Per Pupil Change - FY 2022 - FY 2019	Meets High Poverty MOEquity
2400030	Allegany County Public Schools	Y	Y	10483.7512857018	11144.9424356453	11095.2229155623	11901.8064626759		806.583547113605	Yes		1418.05517697407	Yes
2400060	Anne Arundel County Public Schools	N	N	5208.99312622287	5553.90004995026	5473.9801958964	5833.8431473694		359.862951473005	Yes		624.850021146534	Yes
2400090	Baltimore City Public Schools	Y	Y	11646.3435173267	12581.1118904155	12216.3713316752	13172.5201090623		956.148777387103	Yes		1526.17659173559	Yes
2400120	Baltimore County Public Schools	Y	N	6798.77984251411	7381.07809736004	7176.89492558498	7744.22161882304		567.326693238062	Yes		945.441776308926	Yes
2400150	Calvert County Public Schools	N	N	5992.60606060606	6615.91277845854	6416.80152985612	7012.58807121175		595.786541355628	Yes		1019.98201060569	Yes
2400180	Caroline County Public Schools	Y	Y	10617.0698478562	11766.0555150371	11584.4532292924	12635.1612495486		1050.70802025615	Yes		2018.09140169242	Yes
2400210	Carroll County Public Schools	N	N	6049.76424637352	6418.25192893956	6225.53603806341	6693.2214877382		467.68544967479	Yes		643.457241364682	Yes
2400240	Cecil County Public Schools	Y	N	7856.57328841804	8198.04346874438	7988.14096097367	8548.76159271281		560.620631739137	Yes		692.188304294774	Yes
2400270	Charles County Public Schools	Y	N	7634.57392533095	8173.83644178796	7891.363712898	8494.9631608943		603.599447996303	Yes		860.389235563351	Yes
2400300	Dorchester County Public Schools	Y	Y	10116.6067282654	11402.1915904322	11234.9689480424	12121.9678161907		886.998868148297	Yes		2005.36108792524	Yes
2400330	Frederick County Public Schools	N	N	6686.56792825368	7100.47217526064	6916.10458734625	7311.93973031753		395.835142971276	Yes		625.371802063848	Yes
2400360	Garrett County Public Schools	Y	Y	6682.48463022508	6923.80734183806	7112.70509175135	7510.27764447796		397.572552726614	Yes		827.793014252879	Yes
2400390	Harford County Public Schools	N	N	6324.24299609608	6782.30238397726	6607.50808823869	7094.5036764834		486.995588244712	Yes		770.260680387323	Yes
2400420	Howard County Public Schools	N	N	5565.08506988088	5967.86010122658	5801.04303966941	6223.02382053348		421.980780864072	Yes		657.938750652606	Yes
2400450	Kent County Public Schools	Y	Y	6765.36614343029	6274.51689401889	6185.71766933474	6864.62185338866		678.904184053917	Yes		99.2557099583673	Yes
2400480	Montgomery County Public Schools	N	N	5416.82153056989	5733.1670050699	5708.34725576093	6073.22324456565		364.875988804724	Yes		656.40171399576	Yes
2400510	Prince George's County Public Schools	Y	Y	9472.8107845491	10129.2438014043	9957.25974764713	10691.8448795503		734.585131903146	Yes		1219.03409500117	Yes
2400540	Queen Annes County Public Schools	N	N	5416.46585240422	5656.57111505567	5618.49757797179	6026.24962812711		407.752050155324	Yes		609.783775722896	Yes
2400570	St. Marys County Public Schools	Y	Y	6674.43629052136	7155.85307642082	6965.33886321355	7579.69608582198		614.35722260843	Yes		905.259795300617	Yes
2400600	Somerset County Public Schools	Y	N	12303.4239504473	13445.512995896	13482.923701768	14389.1557529987		906.232051230632	Yes		2085.73180255132	Yes
2400630	Talbot County Public Schools	Y	N	4017.87948745558	4306.3352588789	4356.72392482	4656.62716922737		299.903244407369	Yes		638.747681771786	Yes
2400660	Washington County Public Schools	Y	Y	8682.13092600798	9403.95534571769	9133.67059140606	9944.38495196097		810.714360554917	Yes		1262.254025953	Yes
2400690	Wicomico County Public Schools	Y	Y	10763.994326838	11760.8746141653	11573.2737718801	12687.8128978107		1114.53912593065	Yes		1923.81857097275	Yes
2400720	Worcester County Public Schools	Y	Y	4187.58514036931	4191.91971664699	4103.78868493337	4342.5412240012		238.752539067823	Yes		154.956083631883	Yes
	Statewide			7294.00317608123	7805.52416149348	7640.91501232961	8202.28121649952		561.366204169917			908.278040418294

Sheet: Student Count
	NCES District ID	District Name	FY 2019 FTE w/ Prek  9-30-2017		FY 2020 FTE w/ Prek 9-30-2018		FY 2021 FTE w/ Prek 9-30-2019		FY 2022 FTE w/ Prek 9-30-2021
	2400030	Allegany County Public Schools	8604.25		8517.25		8410.25		8047.75
	2400060	Anne Arundel County Public Schools	82669.25		83182.75		84847.25		82932.75
	2400090	Baltimore City Public Schools	79242		77894.25		77913.5		75828.25
	2400120	Baltimore County Public Schools	113089.5		113552.75		114590.75		110577.25
	2400150	Calvert County Public Schools	15889.5		15913.5		16002.25		15236.25
	2400180	Caroline County Public Schools	5784		5827.25		5872.5		5538
	2400210	Carroll County Public Schools	25282.75		25175.75		25339.25		24507
	2400240	Cecil County Public Schools	15362.25		15305.25		15256.25		14710.75
	2400270	Charles County Public Schools	26892		27103.5		27517		26758.25
	2400300	Dorchester County Public Schools	4762		4766		4689.25		4657
	2400330	Frederick County Public Schools	42037		42588		43651		43106.25
	2400360	Garrett County Public Schools	3809.75		3841		3832.25		3646.75
	2400390	Harford County Public Schools	37782.5		37821.25		38421		37308.75
	2400420	Howard County Public Schools	56685.75		57741.75		58746		56768.25
	2400450	Kent County Public Schools	1994		1906		1917.25		1807.5
	2400480	Montgomery County Public Schools	161417		162528		165065.25		160334.25
	2400510	Prince George's County Public Schools	132244.75		132485.25		135857		131413.75
	2400540	Queen Annes County Public Schools	7778		7746.25		7764		7395
	2400570	Somerset County Public Schools	18053.75		17995.75		18083		17245
	2400600	St. Marys County Public Schools	2906		2924		2900		2813.75
	2400630	Talbot County Public Schools	4643.5		4674		4699.75		4523.5
	2400660	Washington County Public Schools	22570		22663		22958		21883.25
	2400690	Wicomico County Public Schools	14972.25		14983.75		15172.25		14297
	2400720	Worcester County Public Schools	6661		6776		6850		6683
			891132.75		893912.25		906355		878019.25

Sheet: Exp Data
	NCES District ID	Jurisdiction	FY 2019 Actuals	FY 2020 Actuals	FY 2021 Appropriation	FY 2022 Appropriation
	2400030	Allegany	90204817	94924260.96	93313598.5256078	95782762.96
	2400060	Anne Arundel	430623555	461988679.38	464452166.176271	483816655.28
	2400090	Baltimore City	922879553	979996274.87	951820247.750472	998849147.96
	2400120	Baltimore Co.	768870613	838141715.92	822405772.193977	856334730
	2400150	Calvert	95219514	105282328	102683262.28114	106845545
	2400180	Caroline	61409132	68563747	68029701.5890197	69973523
	2400210	Carroll	152954677	161584306	157750414.052498	164030779
	2400240	Cecil	120694643	125473104.8	121869075.535855	125758694.6
	2400270	Charles	205308962	221539576	217146655.287814	227310348
	2400300	Dorchester	48175281.24	54342845.12	52683578.1396077	56452004.12
	2400330	Frederick	281083256	302394909	301894881.342251	315190302
	2400360	Garrett	25458595.82	26594344	27257664.0878641	27388105
	2400390	Harford	238945711	256515154.04	253867068.258219	264687064.04
	2400420	Howard	315461021	344594686	340788074.408419	353270172
	2400450	Kent	13490140.09	11959229.2	11859567.201532	12407804
	2400480	Montgomery	874367081	931800167	942249766.858991	973745694
	2400510	Prince George's	1252729494	1341975397.34	1352763437.5361	1405055430.04
	2400540	Queen Anne's	42129271.4	43817214	43622015.195373	44564116
	2400570	St. Mary's	120498604.18	128774943	125954222.663491	130711859
	2400600	Somerset	35753750	39314680	39100478.7351273	40487487
	2400630	Talbot	18657023.4	20127811	20475513.2656728	21064253
	2400660	Washington	195955695	213121840	209690809.4375	217615462
	2400690	Wicomico	161161214.06	176222005	175592602.985408	181397661
	2400720	Worcester	27893504.62	28404448	28110952.4917936	29021203
			6499925108.81	6977453665.63	6925381526	7201760802
		Unallocated/Statewide	30027645.19	46297107.37	148146476	106881452.000001
		SEED School	10450207	10715642	10844230	10930964
		Maryland School for the Deaf	31868465	33537080	35008280	34792016
		Maryland School for the Blind	23346757	23947915	24831335	24831335
		Total	6595618183	7091951410	7144211847	7379196569
	Note: Unallocated statewide represents education funds allocated for infants and toddlers, early childhood programs, and for special education students served in nonpublic special education schools. The SEED School, the Maryland School for the Blind, and the Maryland School for the Deaf are funded outside of the K-12 funding formulas in the State.

Sheet: SAIPE DATA
	2019 SAIPE Data
	Year	State	District ID	District Name	Grade range of responsibility	Total Population	Relevant Ages 5 to 17 Population	Relevant Ages 5 to 17 in Families in Poverty	Relevant Ages  5 to 17 Ratio
	2019	24	2400090	Baltimore City Public Schools	PK-12	593490	83117	25540	30.7
	2019	24	2400570	Somerset County Public Schools	PK-12	25616	3165	885	28
	2019	24	2400300	Dorchester County Public Schools	PK-12	31929	4937	1136	23
	2019	24	2400690	Wicomico County Public Schools	PK-12	103609	16413	3464	21.1
	2019	24	2400030	Allegany County Public Schools	PK-12	70416	8962	1549	17.3
	2019	24	2400180	Caroline County Public Schools	PK-12	33406	5828	1003	17.2
	2019	24	2400360	Garrett County Public Schools	PK-12	29014	3949	657	16.6
	2019	24	2400450	Kent County Public Schools	PK-12	19422	2221	369	16.6
	2019	24	2400660	Washington County Public Schools	PK-12	151049	24216	3662	15.1
	2019	24	2400720	Worcester County Public Schools	PK-12	52276	6754	927	13.7
	2019	24	2400510	Prince George's County Public Schools	PK-12	909327	142020	18730	13.2
	2019	24	2400630	Talbot County Public Schools	PK-12	37181	5033	631	12.5
	2019	24	2400120	Baltimore County Public Schools	PK-12	827370	130075	14216	10.9
	2019	24	2400240	Cecil County Public Schools	PK-12	102855	17279	1866	10.8
	2019	24	2400600	St. Marys County Public Schools	PK-12	113510	19959	1954	9.8
	2019	24	2400270	Charles County Public Schools	PK-12	163257	29236	2640	9
	2019	24	2400480	Montgomery County Public Schools	PK-12	1050688	177867	14835	8.3
	2019	24	2400390	Harford County Public Schools	PK-12	255441	42210	3307	7.8
	2019	24	2400060	Anne Arundel County Public Schools	PK-12	579234	93372	7095	7.6
	2019	24	2400540	Queen Annes County Public Schools	PK-12	50381	8199	556	6.8
	2019	24	2400150	Calvert County Public Schools	PK-12	92525	16375	1084	6.6
	2019	24	2400330	Frederick County Public Schools	PK-12	259547	44664	2494	5.6
	2019	24	2400420	Howard County Public Schools	PK-12	325690	59766	3157	5.3
	2019	24	2400210	Carroll County Public Schools	PK-12	168447	27133	1312	4.8

File and source

File: department-of-education-excel-www-ed-gov-a16fc9c6aa.xlsx
Size: 53,143 bytes
SHA-256: 1bcd55b7f18770248f1c71fc20e359f66f082ea6442a69570eb23d8d8e2a097d
Our copy: department-of-education-excel-www-ed-gov-a16fc9c6aa.xlsx
Original: www.ed.gov