{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Fiscal Assurance","Directions Allocation Worksheet","Allocation Worksheet ","Removed Title I Schools","Tables 7-1 and 7-2","Table 7-3, 7-4, 7-5","Table 7-6.1-7-6.3","Table 7-7 Skipped Schools","Skipped School WS Directions","Skipped School Allocation WS","Table 7-8 ","Table 7-9.1","Table 7-9.2","Table 7-9.3","Table 7-9.4","CSI Schools 7% Set Aside","TSI District level set aside","Table 7-10","Table 7-11","Update C 125","Template Budget Narrative","Category and Object Codes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Fiscal Assurance","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,1,14],[2,1,6,14],[0,1,0,14],[8,1,13,14]]}
[null,"Fiscal Assurances "]
[null,"OVER ARCHING ASSURANCE? \"By agreeing to these Assurances, the LEA affirms that it is assembling and will assemble and present for review all written documentation that MSDE requires as evidence of implementation of the Assurances during MSDE oversight activities (e.g., monitoring).  meeting sign-ins, agenda, notes, evaluations, communication media including PowerPoint presentations, webinar presentations, web pages, telephone logs , etc.\""]
[null,"The LEA assures fiscal transparency and oversight of Title I federal funds distributed to schools.  Expenditures are maintained at the LEA.  Expenditures are 1) necessary, reasonable, allowable and allocable; 2)  conform with Federal law and grant terms; 3) consistent with State and local policies; 4) consistently treated as either direct cost or an indirect cost; 5) in accordance with generally accepted accounting practices (GAAP) , and 6) are properly documented.  ESSA Sections 1003, 1112, 1118(b), 2103, 2301, 3116.  Uniform Guidance 2 CFR Part 200, Subpart E."]
[]
[]
[]
[]
[]
[null,"Initial ___________________   Date___________________________________"]

{"sheet":"Directions Allocation Worksheet","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Allocation Worksheet ","index":2,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,1,2,2]]}
[null,null,null,null,"Local School System",null,"Submission Date",null,"               ","Note: 1/2 day Pre-K equals .5 FTE"]
[null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,0.5]
[null,"Notations:",null,"D","E","F","G","H","I","J","K","L ","M","N","O","P","Q"]
[null,"N, S, C, CSI or TSI","SW or TAS","MSDE Sch ID #","Public School Name                               (Must rank order by Percent  of Poverty highest to lowest, include Skipped Schools)\n","Specific Numeric Grade Span (public)","CEP* School (Y or N)","Public School Enrollment  (as of 9/30/21)/  waiver","Public School Enrollment  (as of 9/30/21)/  waiver","Number of  Direct Certification Children for NSLP in  CEP Schools    (10/31/21)/waiver","CEP Direct Certification count multiplied by the 1.6 multiplier 1","FTE\nLow Income Public School Children used to Allocate Title I Funds2","Percent of Poverty for Title I Allocations     (I/H=M)     ","Number of Low- Income Private School Children  Residing in this School's Attendance Area. ","FTE\nLow Income Private School Children Residing in this School's Attendance Area.","Per Pupil Allocation (PPA)","Public School Allocation              (L xP  =Q)"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"(J5*1.6)","v":0},null,{"$f":"SUM(I5/H5)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUND(P5*L5,2)","v":0}]
[2,null,null,null,null,null,null,null,null,null,{"$f":"(J6*1.6)","v":0},null,{"$f":"SUM(I6/H6)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUND(P6*L6,2)","v":0},null,null," b"]
[3,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(I7/H7)","v":{"$error":"#DIV/0!"}},null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(I8/H8)","v":{"$error":"#DIV/0!"}},null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},null,null,null,{"$f":"ROUND(P12*L12,2)","v":0}]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I5:I12)","v":0},{"$f":"SUM(J5:J12)","v":0},{"$f":"SUM(K5:K12)","v":0},{"$f":"SUM(L5:L12)","v":0},null,{"$f":"SUM(N5:N12)","v":0},{"$f":"SUM(O5:O12)","v":0},null,{"$f":"SUM(Q5:Q12)","v":0}]
[null,null,null,null,null,null,null,null,"Table 7-9",null,null,null,null,"Table 7-8",null,null,"Table 7-10"]
[null,null,null,"*Community Eligibility Provision"]
[1,"1The 1.6 multiplier applies to a Community Eligibility school."]
[2,"For a CEP school, the Column I figure is equal to the lesser of (a) column K  or (b) column H.  In other words, the count cannot exceed the school's total enrollment."]

{"sheet":"Removed Title I Schools","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Title I Schools in SY 2021-2022 removed from Title I in SY 2022-2023"]
[]
["MSDE School ID #","Official Public School Name","Status Last Year SW or TAS","Reason for Removal from the Title I List"]

{"sheet":"Tables 7-1 and 7-2","index":4,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[[26,2,26,9],[43,0,43,11],[45,1,45,17],[52,0,52,11],[53,0,53,17],[19,2,19,9],[20,2,20,9],[22,2,22,9],[25,2,25,9],[23,2,23,9],[44,0,44,11],[33,2,33,9],[37,0,37,9],[39,1,39,9],[40,1,40,9],[41,1,41,9],[34,2,34,9],[28,2,28,9],[29,2,29,9],[27,0,27,9],[31,2,31,9],[42,1,42,9],[32,2,32,9],[9,0,9,11],[17,2,17,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9],[15,2,15,9],[16,2,16,9],[54,0,54,17],[46,1,46,17],[47,1,47,17],[48,1,48,17],[49,1,49,17],[50,1,50,17],[51,1,51,17]]}
["Table 7-1              SOURCE(S) OF DOCUMENTED LOW-INCOME DATA FOR DETERMINING"]
["                             THE NUMBER OF CHILDREN FROM LOW-INCOME FAMILIES    "]
[]
["A Local Education Agency must use the same measure of poverty for:"]
["1.       Identifying eligible Title I schools."]
["2.       Determining the ranking of each school."]
["3.       Determining the Title I allocation for each school."]
[]
["PUBLIC SCHOOLS:"]
["CHECK the data source(s) listed below that the school system is using to determine eligible Title I schools.  The data source(s) must be applied uniformly to all schools across the school system.  A child who might be included in more than one data source may be counted only once in arriving at a total count.  The data source(s) must be maintained in the applicant's Title I records for a period of three years after the end of the grant period and/or 3 years after the resolution of an audit – if there was one.   The LEA must only check one method unless an LEA is using Community Eligibility Provision (CEP) or Explicit Authority (see G below).  "]
[]
["☐ ____    ","A.","Free Lunch"]
["☐ ____    ","B.","Free and Reduced Lunch"]
["☐ ____   ","C.","Temporary Assistance for Needy Families (TANF)"]
["☐ ____   ","D.","Ages 5-17 in poverty as counted in the most recent LEA-level census poverty data\napproved by the Department; or\nNote: Because census data are generally not available at the school level, if an LEA\nuses this measure, it would most likely be part of a composite with one or more of the\nabove measures."]
["☐ ____    ","E.","Children eligible to receive medical assistance under the Medicaid program"]
["☐ ____ ","F.","Community Eligibility Provision(CEP)"]
["☐ ____  ","G","NEW as of 17-18: Explicit Authority to Use Feeder Patterns to Determine the Poverty Percentages of Secondary Schools (ESEA sections 1113(a)(5)(B) and (C)"]
["☐ ____ ","H.","Counted by the LEA using a composite of any of the above measures."]
["☐ ____ ","I.","Allowable Waiver, Waiver option used ( from list below) ________________________________"]
[null,null,"> Medicaid or TANF data or a composite of data from these two sources from SY 2020-\n2021 for SY 2021-2022 within-LEA allocations or from SY 2021-2022 for SY 2022-\n2023 within-LEA allocations;\nMedicaid data, Temporary Assistance for Needy Families (TANF) data, or a composite of data of these two sources from SY 2020-2021 "]
[null,null,">Best available NSLP data (might be from SY 2019-2020; "]
[null,null,"> NSLP data from SY 2020-2021 or SY 2021-2022 that may be accessible (e.g., counts of \nchildren identified through direct certification, which may be adjusted by 1.6 for within LEA allocations to account for the lack of household applications);"]
[null,null,"> A combination of the best available NSLP data from SYs 2019-2020, 2020-2021, and \n2021-2022;A composite of NSLP, Medicaid, and TANF data, which might include Medicaid or TANF counts from SY 2020- 2021 and the best available FRPL data, which may be from SY 2019-2020;\n\n"]
[null,null,"> A composite of the NSLP, Medicaid, and TANF data listed in the previous bullets; or"]
[null,null,"> Data from a poverty survey conducted by the SEA or LEA that replicate NSLP, \nMedicaid, or TANF data.\n"]
["PRIVATE SCHOOLS: "]
["A local educational agency shall have the final authority to calculate the number of children who are from low-income families and attend private schools.  According to Title I Guidance B-4, if available, an LEA should use the same measure of poverty used to count public school children, e.g., free and reduced price lunch data.  CHECK (all that apply) the data source(s) listed below that the school system is using to identify private school participants: (Reg. Sec. 200.78) "]
["☐ ____    ","A.","The same measure used to count public school children, if available to count private school students, (e.g.,  FaRMS data or direct certification data) "]
["☐ ____  ","B. ","Use comparable poverty data from a survey of families of private school students that, to the extent possible, protects the families’ identify. The LEA must extrapolate data from the survey based on a representative sample if complete actual data are unavailable."]
["☐ ____    ","C.","Use comparable poverty data from a different source, such as scholarship applications"]
["☐ ____    ","D. ","Apply the low-income percentage of each participating public school attendance area to the number of private school children who reside in that school attendance area to derive the number of private school children from low-income families (proportionality). "]
["☐ ____    ","E. ","An equated measure of low income correlated with the measure of low income used to count public school children. By correlating \nsources of data—that is, determining the proportional relationship between two sources of \ndata on public school children and applying that ratio to a known source of data on private \nschool children."]
["☐ ____   ","F.","Community Eligibility Provision (CEP)- check this/Remove?"]
[null,null,"Waiver Notes: , the ESEA permits an LEA to decide, in consultation with appropriate private school\nofficials, whether to determine the number of children from low-income families who attend \nprivate schools each year or every two years. (See ESEA section 1117(a)(4)(D).) Thus, for an \nLEA that used NSLP data from SY 2019-2020 to make this determination for SY 2020-2021 and \nSY 2021-2022, the potential lack of NSLP data from SY 2020-2021 will not affect the \nproportional share determination for SY 2021-2022 because the LEA had not planned to use data \nfrom SY 2020-2021. For SY 2022-2023, such an LEA, in consultation with appropriate private \nschool officials and consistent with the measures described above, must redetermine the number \nof children from low-income families who attend private schools, rather than using NSLP data \nfrom SY 2019-2020 for a third consecutive year because, as noted above, ESEA section \n1117(a)(4)(D) requires an LEA to determine the number of children from low-income families \nwho attend private schools every year or every two years.\nAn LEA may also have planned to use NSLP data from SY 2020-2021 to determine the \nproportional share for SY 2021-2022 or SY 2022-2023. To the extent that NSLP data from \nSY 2020-2021 or SY 2021-2022 are not available, to determine the number of children from \nlow-income families who attend private schools, the LEA, in consultation with appropriate \nprivate school officials, would need to use another source of data, consistent with the other \nmeasures described above. For the reason described in the previous paragraph, an LEA may not \nuse the same data (e.g., NSLP data from SY 2019-2020) for more than two consecutive years."]
[]
["Table 7-2           METHOD OF QUALIFYING ELIGIBLE ATTENDANCE AREAS (TITLE I SCHOOLS) "]
["Section 1113 of Title I contains the requirements for identifying and selecting eligible schools that will participate in the Title I, Part A.  The following points summarize these requirements:"]
[]
["1.      "," The school system must first rank all of its schools by poverty based on the percentage of low-income children.  "]
["2.      "," After schools have been ranked by poverty, the school system must serve schools above 75% poverty in rank order of poverty, including middle and high schools."]
["3.      "," Only after the school system has served all schools above 75% poverty, may lower-ranked schools be served.  The school system has the option to serve high schools with 50 % or more poverty before it serves any elementary or middle schools with a poverty percent at or below 75 %. (ESEA section 1113 (a)(3)(B))  Then continue on with the district-wide ranking or rank remaining schools by grade span groupings. "]
["4.      "," If the school system has no schools above 75% poverty, the system may rank district-wide or by grade span groupings.  For ranking by grade span groupings, the school system may use (a) the district-wide grade span poverty average or (b) the district-wide grade span poverty averages for the respective grade span groupings. "]
[]
["CHECK below to indicate which method the school system is using to qualify attendance areas.  The school system must qualify Title I schools by using percentages or other listed eligible methods. "]
["☐ ____    ","Percentages -- schools at or above the district-wide average must be served in rank order of poverty.  Title I, Part A funds may run out before serving all schools above the district-wide average.  Schools below the district-wide average cannot be served. Complete Table 7-3."]
["☐ ____   "," Grade span grouping/district-wide percentage -- schools with similar grade spans grouped together, and any school at or above the district-wide percentage in each group is eligible for services.  Schools must be served in rank order of poverty within each grade-span grouping.  Complete Tables 7-3 and 7-4."]
["☐ ____  ","35% rule -- all schools at or above 35% are eligible for services.  Schools must be served in rank order of poverty.  Title I, Part A funds may run out before serving all schools above 35%. Complete Tables 7-3."]
["☐ ____  "," Grade-span grouping/35% rule -- schools with similar grade spans grouped together, and any school at or above 35% in each group is eligible for services.  Schools must be served in rank order of poverty within each grade-span grouping.  Complete Tables 7-3 and 7-4."]
["☐ ____  "," Special Rule:  Feeder pattern for secondary schools.  Using this method, a school system may project the number of low-income children in a secondary school based on the average poverty rate of the elementary school attendance areas that feed into the school.   (ESEA section 1113 (a)(5)(B)).  Complete Tables 7-3 and 7-4."]
["☐ ____   ","New Exception as of 2017-2018:  An LEA may serve high schools with 50 % or more poverty before it serves any elementary or middle schools with a poverty percent at or below 75 %.  (ESEA section 1113 (a)(3)(B)).   Complete Tables 7-6.2."]
["☐ ____   "," District-wide and school percentage below 35% rule – District-wide percentage is below 35% then any school above 35% are eligible for services.  Schools must be served in rank order of poverty, but not below district-wide percentage.  Title I, Part A funds may run out before serving all schools above 35%.   (ESEA section 1113 (c)(2)(A)).  Complete Tables 7-3 and 7-5."]
[]
["NOTE REGARDING GRADE-SPAN GROUPING:  The same rule must be used for all groups if grade-span grouping is selected.  If there are three grade-span groups, the school system must use the 35% rule for all three or the district-wide average for all three.  The district may not have three groups with one group using the 35% rule and one group using the district-wide average.  Schools above 75% poverty must be served before lower ranked schools.                                                                                                                                                                                                             Note also re: Feeder Patterns in Maryland:                                                                                                                                                                                                                                                                              In COMAR, Secondary School is defined as the following COMAR 13a.09.10.02B(34): \n(34) \"Secondary school\" means an educational program that:\n(a)    Is provided by a teacher to students in any one or consecutive sequence of grades 9—12;\n(b)    Consists of instruction in English language arts, mathematics, science, social studies, and other curricular areas required for earning a secondary school diploma.\n"]
["NOTE REGARDING GRADE-SPAN GROUPING:  The same rule must be used for all groups if grade-span grouping is selected.  If there are three grade-span groups, the school system must use the 35% rule for all three or the district-wide average for all three.  The district may not have three groups with one group using the 35% rule and one group using the district-wide average.  Schools above 75% poverty must be served before lower ranked schools.                                                                                                                                                                                                             Note also re: Feeder Patterns in Maryland:                                                                                                                                                                                                                                                                              In COMAR, Secondary School is defined as the following COMAR 13a.09.10.02B(34): \n(34) \"Secondary school\" means an educational program that:\n(a)    Is provided by a teacher to students in any one or consecutive sequence of grades 9—12;\n(b)    Consists of instruction in English language arts, mathematics, science, social studies, and other curricular areas required for earning a secondary school diploma.\n"]

{"sheet":"Table 7-3, 7-4, 7-5","index":5,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[13,0,17,1],[13,3,17,4],[13,6,17,7],[2,0,6,8],[0,1,0,8],[12,0,12,1],[12,6,12,7],[12,3,12,4],[19,1,19,8],[20,1,20,8],[21,0,27,8],[28,0,29,8],[30,0,30,1],[30,2,32,3],[30,4,32,4],[30,5,32,6],[30,7,32,8],[31,0,32,1],[33,0,33,1],[33,2,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,1],[34,2,34,3],[34,5,34,6],[34,7,34,8],[35,0,35,1],[35,2,35,3],[35,5,35,6],[35,7,35,8],[38,1,38,8],[39,1,39,8],[42,0,42,2],[42,3,46,3],[42,4,42,5],[42,6,46,6],[42,7,42,8],[43,0,46,2],[43,4,46,5],[43,7,46,8],[40,1,41,8]]}
["Table 7-3","DISTRICT-WIDE PERCENTAGE OF LOW-INCOME CHILDREN (PreK*-12)"]
[]
["The LEA may rank schools using the district wide poverty average or the district-wide grade span poverty averages for the respective grade span groupings. Based on the data source(s) noted in Table 7-1, CALCULATE the district-wide average of low-income children below. Use the official number of students approved for FARM as of October 31, 2021 to complete this table along with the September 30, 2021 enrollment data (or allowable waiver poverty measure). "]
[]
[]
[]
[]
[]
[null,null,"Points of Clarification:"]
[null,null,"*Pre-K Students are counted as ONE child "]
[]
[]
[null,null,"/",null,null,"=",{"$f":"+A13/D13","v":{"$error":"#DIV/0!"}}]
["Total Number of Low-Income Children Attending ALL Public Schools (October 31, 2021) or allowable waiver measure of poverty",null,null,"Total LEA Student Enrollment (September 30, 2021) or allowable waiver measure of poverty",null,null,"District Wide Average (percentage) of Low-Income Children"]
[]
[]
[]
[]
[]
["Table 7-4","DISTRICT-WIDE GRADE SPAN POVERTY AVERAGES OF LOW INCOME CHILDREN"]
[null,"BY GRADE SPAN GROUPONGS (Complete only if using grade span averaging) "]
["Grade span groupings are determined by how the school system organizes its schools. For example, if the district has elementary schools serving grades PreK-5, middle schools serving grades 6-8, and high schools serving grades 9-12, the grade span groupings would be the same. To the extent a school system has schools that overlap grade spans (e.g. Prek-6, K-8, 6-9) the school system may include a school in the grade span in which it is most appropriate. Based on the data source(s) noted in Table 7-1 and the district wide average in Table 7-3 INDICATE below the district-wide grade span poverty averages for each grade span groupings."]
[]
[]
[]
[]
[]
[]
["DISTRICT-WIDE GRADE SPAN POVERTY AVERAGE CALCULATIONS"]
[]
["Grade Span",null,"Total Grade Span Enrollment of Low Income Students",null,"/","Total Grade Span Enrollment",null,"District-wide grade span poverty average"]
["Write Grade Span in Spaces Below"]
[]
["Elementary (PreK-5)",null,null,null,"/",null,null,{"$f":"+C34/F34","v":{"$error":"#DIV/0!"}}]
["Middle (6-8)",null,null,null,"/",null,null,{"$f":"+C35/F35","v":{"$error":"#DIV/0!"}}]
["High (9-12)",null,null,null,"/",null,null,{"$error":"#DIV/0!"}]
[]
[]
["Table 7-5","CALCULATING THE MINIMUM ALLOCATION-- FOR SCHOOL SYSTEMS THAT"]
[null,"SERVE SCHOOLS BELOW 35% DISTRICT -WIDE POVERTY (125% RULE) "]
[null,"“125 percent rule”: If an LEA serves any school below 35 percent poverty, section\n1113(c)(2)(A) of the ESEA requires the LEA to allocate an amount for each low-income\nchild in each participating Title I school that is at least 125 percent of the LEA’s\nallocation per low-income child, except that the per-pupil amount for the served school\nwith the lowest poverty rate may be less due to the amount of funds remaining."]
[]
[null,null,null,"/",null,null,"=",{"$f":"SUM(A43/E43)*1.25","v":{"$error":"#DIV/0!"}}]
["Local Educational Agency Title I, Part A Allocation (Taken from Table 7-9.1).  This should match # on C-1-25",null,null,null," The number of low-income children in the LEA as determined using the poverty measure selected by the LEA to identify eligible school attendance areas. ",null,null,"Per Pupil Amount"]

{"sheet":"Table 7-6.1-7-6.3","index":6,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,3,2],[5,0,5,3],[4,0,4,3],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[34,1,34,2],[35,1,35,2],[36,1,36,2],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,1,33,2]]}
[]
[]
["Table 7-6.1              CONTINUED ELIGIBILITY (aka grandfather)                                                  "]
[]
["Section 1113(b)(1)(C) includes a provision that permits the school system to designate and serve for one additional year a school that is not eligible, but was eligible and served during the preceding fiscal year.   This provision applies to a newly ineligible school and not to an eligible school that has\nfallen in the poverty ranking compared to the previous year’s ranking and does not receive a Title I allocation from its LEA because the LEA allocates its Title I funds to other eligible schools with higher poverty percentages.  LIST below any school(s) that the school system will serve for one additional year. "]
["To qualify for continued eligibility, a school must have a lower poverty level than the district-wide poverty average or fall below 35% poverty as qualification is based upon the LEA's selection in Table 7-2.  "]
[]
["Name of School(s)","MSDE School ID","Preceding Fiscal Year ","Current Fiscal Year"]
[null,null,"Percent Poverty  ","Percent Poverty"]
[]
[]
[]
[]
[]
[]
[]
["Table 7-6.2                HIGH SCHOOL SERVED BETWEEN 50-75% POVERTY"]
["                                     "]
["Ranking High Schools -  ESEA Exceptions to the Ranking Requirement "]
["Exception:  A local educational agency may lower the threshold in subparagraph (A)(i) to 50 percent for high schools served by such agency. (Section 1113(a)(3)(B).  "]
["List the high schools that the LEA is choosing to serve under this exception."]
["Name of School(s)","MSDE School ID Number",null,"Poverty Percent"]
[]
[]
[]
[]
[]
["Table 7-6.3   Year of data exception:  Newly opened and significantly expanded charter schools"]
[]
[]
[]
["Newly Expanded Charter Schools-  ESEA Exceptions to the Year of Data Requirement "]
["If applicable, list the Charter Schools that the LEA is choosing to serve under this exception.  The LEA must determine such a school’s Title I allocation based on current year data and provide the school its allocation within five months of the school’s opening or expansion.                                     (ESEA section 4306(a); 34 C.F.R. 76.792(a)).  "]
["Name of Charter School(s)","MSDE School ID Number",null,"Poverty Percent"]

{"sheet":"Table 7-7 Skipped Schools","index":7,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[9,1,10,1],[9,0,10,0],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2]]}
[]
[]
["Table 7-7              TITLE I SKIPPED SCHOOLS    "]
["LEAs must have prior approval from the State Title I Director to skip schools.  Request must be in writing prior to the first submission of Title I Application.  "]
["Follow the directions in the Skipped School Addendum."]
["Section 1113(b)(1)(D) of ESEA includes a \"skipping provision\" that permits the school system not to serve an eligible Title I school that has a higher percentage of low-income students if the school meets all three of the following conditions:"]
["1.        The school meets the comparability requirements of section 1118 (c); "]
["2.        The school is receiving supplemental funds from other State and local sources that are spent according the requirements of section 1114 and 1115;"]
["3.        The funds expended from such other sources equal or exceed the amount that would be provided by Title I, Part A."]
["Number of Skipped Schools:",null,"Note: The completed 2022-2023  Skipped School(s) Allocation Worksheet must be submitted with the Title I Application."]
[null,null,"LEA must submit a copy of the approved request letter.  "]
[]
[]
["LEAs are reminded they must notify MSDE and receive written approval before planning to skip Title I eligible schools within a district’s ranking scheme. "]
[]
["Proof of comparability must be submitted to MSDE with the Comparability Report and the LEA must ensure the schools will be comparable on this addendum. (The skipped schools must be treated as Title I schools when running comparability report)."]
[]
["The Title I Skipped Schools Excel worksheet must be completed and submitted to MSDE with this addendum. These are part of the Title l Excel Fiscal Tables.  The allocation worksheet requires the LEA to identify each skipped school’s code. See table below:"]
["Code","School Type","Description"]
[1,"Regular School  (State school codes 12, 13, 15, 16)","A public elementary/secondary school that does NOT focus primarily on vocational, special or alternative education, although it may provide these programs in addition to a regular curriculum."]
[20,"Vocational Education School","A school that focuses primarily on providing secondary students with an occupationally relevant or career–related curriculum, including formal preparation for vocational, technical or professional occupations."]
[30,"Special Education School","A public elementary/secondary school that focuses primarily on serving the needs of students with disabilities."]
[40,"Alternative Education School","A public elementary/secondary school that addresses the needs of students that typically cannot be met in a regular school program. The school provides nontraditional education; serves as an adjunct to a regular school; and falls outside the categories of regular, special education, or vocational education."]
[]
["Section A: Code 1 (12, 13, 15, and 16 Schools) - Regular Schools"]
[]
["1.       Provide a full description (in narrative form) of the Title I- like services in each Code 1 school. The descriptions must be submitted to MSDE with this addendum. These services must be targeted to specific students or used to provide instructional reform throughout the school. (Note: Title I- like means the schools must meet the requirements of Section 1114 or 1115)."]
[]
["2.       Attach documentation in which additional State or local funding was approved for Code 1 schools. (Note: Additional funding for these schools that are skipped must appear as separate fund codes that can be tracked to each skipped school)."]
[]
["Section B: Code 20, Code 30, and Code 40 Schools"]
[]
["1.       Describe the process used to calculate the additional State and local funds to derive the PPA reported on the Skipped School Allocation Worksheet for schools identified as Code 20, Code 30 and Code 40."]

{"sheet":"Skipped School WS Directions","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Skipped School Allocation WS","index":9,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,3,11]]}
["Skipped School  FY22 Allocation Worksheet (Compensatory Funds only--No Federal Funds)"]
[]
[]
[]
[]
[null,null,null,null,"Local School System",null,null,"               ","Note: 1/2 day Pre-K equals .5 FTE"]
[]
[null,null,"Notations:","D","E","F","G","H","I","J","K","L"]
[null,null,"Code as 1,2,3, or 4","MSDE Sch ID #","Skipped Public School Name                              (Must rank order by Percent of Poverty highest to lowest)\n\n","Specific Numeric Grade Span (public)","Percent of Poverty      (I/H=G)     ","Public School Enrollment  (as of 9/30/21)/waiver","Number of Low Income- Public School Children             (as of 10/31/21)/waiver","FTE\nLow Income Public School Children (10/31/21)/ waiver","Per Pupil Allocation (PPA)","Local/State  Allocation to Skipped Public Schools          (J x K =L)"]
[null,1,null,null,null,null,{"$f":"SUM(I10/H10)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(J10*K10)","v":0}]
[null,2,null,null,null,null,{"$f":"SUM(I11/H11)","v":{"$error":"#DIV/0!"}},null,null,null,null,0]
[null,3,null,null,null,null,{"$f":"SUM(I12/H12)","v":{"$error":"#DIV/0!"}},null,null,null,null,0]
[null,4,null,null,null,null,{"$f":"SUM(I13/H13)","v":{"$error":"#DIV/0!"}},null,null,null,null,0]
[null,5,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,6,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,7,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,8,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,9,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,10,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,11,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,12,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,13,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,14,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,15,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,16,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,17,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,18,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,19,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,20,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,0]
[null,null,null,null,"Total",null,null,null,{"$f":"SUM(I10:I29)","v":0},{"$f":"SUM(J10:J29)","v":0},null,{"$f":"SUM(L10:L29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Table 7-7 Skipped"]

{"sheet":"Table 7-8 ","index":10,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[16,0,16,7],[2,0,4,7],[5,0,5,7],[6,0,6,1],[6,3,6,4],[6,6,6,7],[7,0,12,1],[7,3,12,4],[13,0,13,1],[13,3,13,4],[13,6,13,7],[14,3,15,4],[14,6,15,7],[7,6,12,7],[14,0,15,1],[17,0,17,1],[17,3,17,4],[17,6,17,7],[18,6,20,7],[18,3,20,4],[18,0,20,1],[21,0,21,7],[22,0,22,1],[22,3,22,4],[22,6,22,7],[23,6,26,7],[23,0,26,1],[23,3,26,4],[27,0,27,7],[29,0,31,1],[28,0,28,1],[28,3,28,4],[29,3,31,4],[28,6,28,7],[29,6,31,7],[32,0,32,7],[33,0,33,1],[33,3,33,4],[33,6,33,7],[34,3,36,4],[34,6,36,7],[34,0,36,1],[38,0,39,7],[40,1,40,6],[41,1,42,6],[45,0,45,1],[45,3,45,4],[45,6,45,7],[52,4,52,6],[52,1,52,3],[46,3,47,4],[48,3,50,4],[46,0,50,1],[46,6,50,7],[58,1,58,3],[58,4,58,6],[59,1,59,3],[59,4,59,6],[57,4,57,6],[55,1,55,3],[55,4,55,6],[56,1,56,3],[56,4,56,6],[57,1,57,3],[63,1,63,3],[63,4,63,6],[53,0,55,0],[56,0,58,0],[59,0,61,0],[62,0,63,0],[60,1,60,3],[60,4,60,6],[61,1,61,3],[61,4,61,6],[62,1,62,3],[62,4,62,6],[53,1,53,3],[53,4,53,6],[54,1,54,3],[54,4,54,6]]}
[]
["Table 7-8 EQUITABLE SERVICES"]
["COMPLETE the following formulas to identify monies allocated for equitable services to priavate school participants, their families, and their teachers (see Section 1117(a) of ESSA and Sec 200.64 & 200.65 in 34CFR)"]
[]
[]
["1.a: Determining Proportional Share for Equitable Services"]
[null,null,"/",null,null,"=",{"$f":"ROUND(A7/D7,3)","v":{"$error":"#DIV/0!"}}]
["Total # of private school children from low income families including those going to schools in other LEAs residing in Title I School attendance area. (Use the total number report in Title I Allocation Worksheet Column N)",null,null,"Total # of public school children from low-income familities in Title I public School plus private school children from low-income famlies. (Use the total numbers reported in the Title I Allocation Worksheet Column I + N)",null,null,"Proportion of reservation"]
[]
[]
[]
[]
[]
[{"$f":"+G7","v":{"$error":"#DIV/0!"}},null,"x ",null,null,"=",{"$f":"ROUND(A14*D14,0)","v":{"$error":"#DIV/0!"}}]
["Proportion of reservation",null,null,"Total Title I Allocation                       (Use # from C 125)",null,null,"Proportional Share for Equitable Services"]
[]
["1.b: Determining Parental and Family Engagement Reservation"]
[{"$f":"+G14","v":{"$error":"#DIV/0!"}},null,"x ",0.01,null,"=",{"$f":"ROUND(A18*D18,0)","v":{"$error":"#DIV/0!"}}]
["Total Proportional Share for Equitable Services (Table 7-8, line 1a)",null,null,"For Parent Involvement",null,null,"Proportional share available to parents of private school participants"]
[]
[]
["1.c: Remaining for Instruction, Professional Development and Administration"]
[{"$f":"+G14","v":{"$error":"#DIV/0!"}},null,"-",{"$f":"+G18","v":{"$error":"#DIV/0!"}},null,"=",{"$f":"+A23-D23","v":{"$error":"#DIV/0!"}}]
["Total Proportional Share for Equitable Services (Table 7-8, line 1a)",null,null,"Proportional share available to parents of private school participants",null,null,"Proportional share for instruction, Professional Development, administration and/or other allowable services"]
[]
[]
[]
["1.d: If using funds for PD, subtract amount for agreed upon PD"]
[{"$f":"+G23","v":{"$error":"#DIV/0!"}},null,"-",null,null,"=",{"$f":"+A29-D29","v":{"$error":"#DIV/0!"}}]
["Remaining for instruction, Professional Development and Administration (Table 7-8, line 1c)",null,null,"Agreed amount of Professional Development (determined during consultation)",null,null,"Proportional share remaining for instruction and administration"]
[]
[]
["1.e: If using funds for administration, subtract amount for agreed upon administration"]
[{"$f":"+G29","v":{"$error":"#DIV/0!"}},null,"-",null,null,"=",{"$f":"+A34-D34","v":{"$error":"#DIV/0!"}}]
["Remaining for instruction and administration",null,null,"Agreed amount of Administration (determined during consultation)",null,null,"Proportional share remaining for equitable services instruction"]
[]
[]
[]
["1.f: Determine Final PPA amount for all Private Schools (This includes all services, e.g. instructional, counseling, mentoring, etc.)"]
[]
[null,"Points of Clarification"]
[null,"This information is needed to provide exchange of funds for students who may be attending private schools in neighboring districts"]
[]
[]
[]
[{"$f":"+G34","v":{"$error":"#DIV/0!"}},null,"/",{"$f":"+A7","v":0},null,"=",{"$f":"ROUND(A46/D46,2)","v":{"$error":"#DIV/0!"}}]
["Remaining proportional share for instruction (Table 7-8, line 1e)",null,null,"Number of private school studnets.",null,null,"PPA Allocation for eligible private school students"]
[]
[null,null,null,"(Use the total number reported in the Title I Allocation Worksheet, Column N)"]
[]
[]
[]
[null,"DETAILED BUDGET DESCRIPTION",null,null,"Calculation",null,null,"Total"]
["Parent & Family Engagement"]
[]
[]
["Professional Development"]
[]
[]
["Administration"]
[]
[]
["Instructional"]
[]
["Total Equitable Share",null,null,null,null,null,null,{"$f":"SUM(H54:H64)","v":0}]

{"sheet":"Table 7-9.1","index":11,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,0,3,6],[19,2,23,2],[24,1,25,1],[26,1,27,1],[24,2,25,2],[26,2,27,2],[15,1,18,1],[20,1,21,1],[22,1,23,1],[13,2,18,2],[5,0,5,1],[7,0,7,1],[8,1,12,1],[8,0,12,0],[8,2,12,2],[13,0,18,0],[19,0,23,0],[26,0,27,0],[24,0,25,0],[28,2,32,2],[29,1,30,1],[31,1,32,1],[28,0,32,0]]}
["Table 7-9 LEA RESERVATIONS FROM TITLE I ALLOCATION"]
["Before allocating funds to schools, a school system MUST reserve funds for certain services."]
[]
["LIST (calculate) the amount of funds the district will reserve from the Title I allocation for required (mandatory) and authorized activities.  Provide a brief, budget description that explains how the mandatory and reserved Title I funds will be used to support each activity. All fixed charges and fringe benefits must accompany the salaries and wages on whatever line they might appear in Table 7-9."]
[null,null,"Allocation - Proportioal Share"]
["Total Title I 2022-2023 Allocation taken from the C-1-25 minus the Proportional Share in Table 7-8",null,{"$f":"'Table 7-8 '!D14-'Table 7-8 '!G14","v":{"$error":"#DIV/0!"}},"Parent and Family Engagement Minimum Calculation at 1%.  This is the minimum reservation and can be higher.",{"$f":"SUM(C6)*0.01","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Minimum of 90% of 1% that must go to Schools",{"$f":"SUM(E6)*0.9","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Reservations","Detailed Budget Description","Calculation","Total"]
[2,"Parent and Family Engagement- not less than 1% of its allocation (Sec. 1116 (a)(3)(A)) of ESEA. \nNot less than 90% of the 1% shall be distributed to schools with priority given to high-needs schools (Sec. 1116(a)(3)(C) of ESEA.  Parent input is required for expenditure Title I Parent and Family Engagement Spending Plan",{"$f":"SUM(F9:F13)","v":0}]
[]
[]
[]
[]
[3,"Services to Neglected Children Sec. 1113(c)(3) (B)(C) of ESEA",{"$f":"SUM(F14:F19)","v":0}]
[null,"Must reserve funds if N & D programs exist."]
[null,"Note:  Required Attachment- Include a description of how Title I funds support a coordiinated effort  in the LEA, to address the needs of Neglected, Delinquent or At-Risk students in accordance with the Title I, Part D Prevention and Intervention Programs for Children and Youth who are  Neglected, Delinquent or At-Risk.  Also list each Institution, the amount of funding provided."]
[]
[]
[]
["4a","Required: Education for Homeless Children and Youth  ",{"$f":"SUM(F20:F24)","v":0}]
[null,"Sec. 1113(c)(3)(A) of ESEA and Non-Regulatory Guidance, Education for Homeless Children and Youth Program, March 2017, M1-M10."]
[]
[null,"Note: Required Attachment-  Please include a description of how Title I funds provide educationally related support services as a coordinated effort in the LEA, to address the needs of homeless students, in accordance with the McKinney-Vento Homeless Education Act. "]
[]
["4b","Optional: Cost associated with Homeless Liaison position (funded portion of the position can only be for duties related to homeless education as outlined in McKinney-Vento).  Required Attachment if Applicable- Include a job description.",{"$f":"SUM(F25:F26)","v":0}]
[]
["4c","Optional:  Transportation Cost to and from school of origin (above what the LEA would have otherwise provided to transport the student to his or her assigned school).   Required Attachment if Applicable- Include 1) description of how the LEA calculated the excess cost of providing transportation to homeless students; 2) the calculation that the LEA used to arrive at the amount in this section..",{"$f":"SUM(F27:F28)","v":0}]
[]
[5,"Optional: Education for Foster Children  ",{"$f":"SUM(E29:E33)","v":0}]
[null,"Sec. 1113(c)(3)(A)(i) of ESEA and Non-Regulatory Guidance: Ensuring Educational Stability for\nChildren in Foster CareProgram, June 2018, Question 30, page 19   An LEA MAY use Title I funds to pay for ADDITIONAL COSTS needed to transport children in foster care to their schools of origin. Please note, however, that funds reserved for comparable services for homeless children and youth under section 1113(c)(3)(A)(i) of the ESEA may not be used to provide transportation needed to maintain children in foster care in their schools of origin. "]
[]
[null,"Required Attachment if Applicable- Include 1) description of how the LEA calculated the excess cost of providing transportation for Foster Care students; 2) the calculation that the LEA used to arrive at the amount in this section.Note: As part of developing and implementing its transportation procedures, an LEA must address any\nadditional costs incurred in providing transportation to maintain children in foster care in their schools of\norigin.   Additional costs incurred in providing transportation to the school of origin should reflect the difference between what an LEA otherwise would spend to transport a student to his or her assigned school and the cost of transporting a child in foster care to his or her school of origin. "]
[]
["Total Mandatory Set Asides",null,{"$f":"SUM(C9:C28)","v":0}]

{"sheet":"Table 7-9.2","index":12,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,2,7],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,0,17,0],[12,1,17,1],[12,2,17,2],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[7,0,11,0],[7,1,11,1],[7,2,11,2],[7,3,7,5],[8,3,8,5],[3,0,3,7],[5,0,5,1],[5,3,5,7],[6,0,6,1],[6,3,6,5]]}
["Table 7-9 LEA RESERVATIONS FROM TITLE I ALLOCATION"]
["Before allocating funds to schools, a school system MUST reserve funds for certain services."]
["LEAs may reserve funds for district-wide instructional and professional development programs. "]
["LIST (calculate) the amount of reservations the district will set-aside from the Title I allocation for activities authorized by ESEA. Provide a brief budget description that explains how the reserved Title I funds will be used to support each activity. All fixed charges and fringe benefits must accompany the salaries and wages on whatever line they might appear in Table 7-9.  "]
[]
["Total Reservation",null,0,"Taken from the C-1-25"]
[null,null,"Total Reservations","DETAILED BUDGET DESCRIPTION",null,null,"Calculation","Total"]
[5,"District-wide Title I Instructional Program(s) ",{"$f":"SUM(H8:H12)","v":0}]
[]
[]
[]
[]
[6,"District-wide Professional Development    34 CFR Sec. 200.60 Sec. 9101 (34) of ESEA    ",{"$f":"SUM(H13:H18)","v":0}]
[]
[]
[]
[]
[]
["Total Districtwide Set Asides",null,{"$f":"SUM(C8:C18)","v":0},null,null,null,null,{"$f":"SUM(H8:H18)","v":0}]

{"sheet":"Table 7-9.3","index":13,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,2,28,2],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,2,32,2],[29,3,29,5],[30,3,30,5],[31,3,31,5],[32,3,32,5],[23,3,23,5],[24,3,24,5],[13,2,18,2],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,2,24,2],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[2,0,2,7],[4,0,4,1],[4,3,4,7],[5,0,5,1],[5,3,5,5],[6,2,12,2],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[19,1,24,1],[25,1,28,1],[29,1,32,1],[6,0,12,0],[6,1,12,1],[13,0,18,0],[13,1,18,1],[25,0,28,0],[29,0,32,0]]}
["Table 7-9 LEA RESERVATIONS FROM TITLE I ALLOCATION"]
["Before allocating funds to schools, a school system MUST reserve funds for certain services."]
["LIST (calculate) the amount of reservations the district will set-aside from the Title I allocation for activities authorized by ESEA. Provide a brief budget description that explains how the reserved Title I funds will be used to support each activity. All fixed charges and fringe benefits must accompany the salaries and wages on whatever line they might appear in Table 7-9."]
[]
["Administration (including mid-level) for services to public school 34CFR Sec. 200.77 (f) .",null,null,"Only costs for administering and oversight of the Title I Program may be charged to this reservation (e.g. technical assistance around Title I program requirements and fiscal compliance). LEAs may not include costs for delivery of direct services to students or instructional professional development for school level staff in this reservation.  District-level Administration: Include a job description for all centrally-funded district-level administration positions "]
[null,null,"Total Reservations","DETAILED BUDGET DESCRIPTION",null,null,"Calculation","Total"]
[7,"Management",{"$f":"SUM(H7:H13)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Staff",{"$f":"SUM(H14:H19)","v":0}]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(H20:H25)","v":0}]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(H26:H29)","v":0}]
[]
[]
[]
[null,null,{"$f":"SUM(H30:H33)","v":0}]
[]
[]
[]
["Total Administrative Reservations",null,{"$f":"SUM(C7:C33)","v":0},null,null,null,null,{"$f":"SUM(H7:H33)","v":0}]

{"sheet":"Table 7-9.4","index":14,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,3,11,5],[1,0,1,6],[3,3,3,5],[4,0,6,0],[4,2,6,2],[4,3,4,5],[5,3,5,5],[6,3,6,5],[8,0,10,0],[8,2,10,2],[8,3,8,5],[9,3,9,5],[10,3,10,5],[7,3,7,5],[11,7,11,9],[9,7,9,9],[10,7,10,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[8,7,8,9],[7,7,7,9]]}
["Table 7-9 LEA RESERVATIONS FOR CSI AND Title I TSI SCHOOLS FROM TITLE I ALLOCATION"]
["LIST the amount of reservations set-aside from the Title I allocation for activities authorized by ESEA. Provide a brief budget description that explains how the reserved Title I funds will be used to support each school as a Required Attachment, if applicable,. All fixed charges and fringe benefits must accompany the salaries and wages on whatever line they might appear in Table 7-9."]
[]
[null,"LIST of Comprehensive Support and Improvement (CSI) Schools","Total Reservations","CSI School                                                               (List each school on a separate line)",null,null,"Total Amount of Allocation ","DETAILED BUDGET DESCRIPTION",null,null,"Calculation","Total"]
[8,"Does the LEA provide additional Title I Part A funds to support CSI Schools?",{"$f":"SUM(G5:G7)","v":0}]
[null,"YES ____    NO______"]
[]
[null,"LIST of Targeted Support and Improvement (TSI) Schools","Total Reservations","TSI School                                                               (List each school on a separate line)",null,null,"Total Amount of Allocation ","DETAILED BUDGET DESCRIPTION",null,null,"Calculation","Total"]
[9,"Does the LEA provide additional Title I Part A funds to support Title I TSI Schools?",{"$f":"SUM(G9:G11)","v":0}]
[null,"YES ____    NO______"]
[]
["Total LEA Reservation",null,{"$f":"SUM(C5:C11)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L11)","v":0}]

{"sheet":"CSI Schools 7% Set Aside","index":15,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,2,8,4],[10,2,10,4],[0,0,1,5],[2,2,2,4],[3,0,9,0],[3,2,3,4],[4,2,4,4],[9,2,9,4],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
[" List the 2021-2022 CSI school(s) and the total amount each school received from  the 7% set aside from Title l, Part A Funds (1003)."]
[]
[null,"LIST of Comprehensive Support and Improvement (CSI) Schools","CSI School                                                               (List each school on a separate line)",null,null,"  Total Amount of Allocation "]
[null,"The LEA has CSI Schools"]
[null,"YES ____    NO______"]
[]
[]
[]
[]
[]
[null,null,"Total",null,null,{"$f":"SUM(F4:F10)","v":0}]
[]
[]
[]
[null,"Link for School Improvement Resource Hub"]
[null,"https://www.marylandresourcehub.com/"]
[null,"https://www.marylandresourcehub.com/csi-tsi-schools"]
[null,"Note: Accountability Waivers May Apply"]

{"sheet":"TSI District level set aside","index":16,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,2,9,4],[0,0,1,5],[2,2,2,4],[3,0,8,0],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[7,6,7,8],[8,6,8,8],[9,6,9,8],[2,6,2,8],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8]]}
["List the 2021-2022 TSI school(s) and the total amount each school received from the LEA District Level set aside (not federal funds)"]
[]
[null,"LIST of Targeted Support and Improvement (TSI) Schools ","TSI School                                                        (List each school on a separate line)",null,null,"Total LEA district level set aside","DETAILED BUDGET DESCRIPTION",null,null,"Calculation","Total"]
[null,"The LEA has TSI Schools:"]
[null,"YES ____    NO______"]
[]
[]
[]
[]
[null,null,"Total",null,null,{"$f":"SUM(F4:F9)","v":0},null,null,null,null,{"$f":"SUM(K4:K9)","v":0}]
[]
[]
[]
[null,"Link for School Improvement Resource Hub"]
[null,"https://www.marylandresourcehub.com/"]
[null,"https://www.marylandresourcehub.com/csi-tsi-schools"]
[null,"Note: Accountability Waivers may apply."]

{"sheet":"Table 7-10","index":17,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,1,10,1],[11,1,12,1],[8,0,12,0],[8,3,12,3],[8,2,12,2]]}
["Table 7-10"]
["BUDGET SUMMARY -- CALCULATION OF PER PUPIL ALLOCATION (PPA)"]
[1,"Total Title I Allocation (Use amount shown on C-1-25)","----",{"$f":"+'Table 7-8 '!D14","v":0}]
[2,"Equitable share total reported in Table 7-8","minus",{"$f":"+'Table 7-8 '!G14","v":{"$error":"#DIV/0!"}}]
[3,"Mandated set-asides total reported in Table 7-9.1","minus",{"$f":"+'Table 7-9.1'!C34","v":0}]
[4,"District-wide Reservations total reported in Table 7-9.2","minus",{"$f":"+'Table 7-9.2'!C19","v":0}]
[5,"Administration total reported in Table 7-9.3","minus",{"$f":"+'Table 7-9.3'!C34","v":0}]
[6,"Additional Support for CSI /TSI schools total reported in Table 7-9.4","minus",{"$f":"+'Table 7-9.4'!C12","v":0}]
[7,"Total PPA - This amount is available for PPA calculation. The total of the funds in the Title I Allocation Worksheet for public school students must equal this amount.","equals",{"$f":"D3-D4-D5-D6-D7-D8","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"(LEAs serving schools below the 35% poverty line must first complete Table 7-5 to determine minimum PPA) "]

{"sheet":"Table 7-11","index":18,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,6,7],[11,0,18,7],[20,5,20,6],[27,0,27,5],[20,1,20,4],[7,0,8,7]]}
[]
["Table 7-11",null,"ESTIMATE OF TITLE I CARRYOVER "]
[null,null,"(Annually as of September 30)"]
[]
["Section 1127(a) of ESEA permits a school system to carryover not more than 15% of Title I funds from one fiscal year to the next. The amount of carryover is calculated based on the initial 15 month expenditure period (e.g., July 1, 2021-September 30, 2022)"]
[]
[]
["REMOVED WAIVER INFORMATION"]
[]
[]
["Updated Carryover guidance for Equitable Services:"]
["In general, to ensure that equitable services are provided in a timely manner, an LEA must obligate the funds allocated for equitable services under all applicable programs in the year for which they are appropriated.. (ESEA sections 1117(a)(4)(B) and 8501(a)(4)(B).) There may be extenuating circumstances, however, in which an LEA is unable to obligate all funds within the timeframe in a responsible manner. Under those circumstances, the funds may remain available for the provision of equitable services under the respective program duirng the subsequent school year. In determining how such carryover funds will be used, the LSS must consult with appropriate private school officials. (ESEA sections 1117(b) and 8501(c).)"]
[]
[]
[]
[]
[]
[]
[]
[]
["1.","Total amount of Title I 2021-2022 allocation:"]
[]
["The estimated amount of Title I funds the school system will carryover:"]
[]
["1.","The estimated percentage of carryover Title I funds as of September 30, 2022 :",null,null,null,null,null,{"$f":"SUM(H23/H21)","v":{"$error":"#DIV/0!"}}]
[null,"THIS IS A PROJECTION"]
[]
["Does the LEA intend to apply to the State for a waiver to exceed the 15% carryover limitation "]
[]
["Yes",null,"No",null,"Not applicable- waiver"]

{"sheet":"Update C 125","index":19,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,0,47,3],[36,0,36,3],[37,0,37,3],[38,2,38,3],[39,2,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[43,0,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[35,0,35,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,0,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,0,34,3],[22,2,22,3],[11,0,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,0,15,3],[16,2,16,3],[17,2,17,3],[18,0,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[6,0,6,1],[6,7,6,8],[6,9,6,10],[7,0,7,10],[8,0,10,3],[8,4,8,10],[9,8,10,8],[9,9,10,9],[3,0,3,1],[3,2,3,4],[3,6,3,9],[4,2,4,4],[4,6,4,9],[5,0,5,1],[5,2,5,4],[5,6,5,7],[5,8,5,9],[4,0,4,1],[1,0,1,1],[1,2,1,4],[1,6,1,8],[2,0,2,1],[2,2,2,4],[2,6,2,9]]}
[null,null,null,null,null,null,null,null,null,null," "]
["Original Grant Budget",null,null,null,null,"Amended budget #"," ",null,null,"Request Date"]
["Grant Name",null,"Title I, Part A",null,null,"Grant Recipient Name"]
["MSDE Grant # ",null,null,null,null,"Recipient Grant #"]
["Revenue Source",null,null,null,null,"Recipient Agency Name"]
["Fund Source Code",null,null,null,null,"Grand Period"]
[null,null," ",null,null,null," "," "]
[]
["CATEGORY/PROGRAM",null,null,null,"BUDGET OBJECT"]
[null,null,null,null,"01- SALARIES ","02 - CONTRACT","03- SUPPLIES &      ","04 - OTHER","05 - EQUIPMENT","08 - TRANSFERS","BUDGET  BY "]
[null,null,null,null,"& WAGES","   SERVICES                           ","       MATERIALS"," CHARGES",null,null,"CAT./PROG. "]
["201 Administration"]
["Prog.",21," General Support"]
["Prog.",22," Business Support"]
["Prog.",23," Centralized Support"]
["202 Mid-Level Administration"]
["Prog.",15," Office of the Principal"]
["Prog.",16," Inst. Admin. & Supv."]
["203-205 Instruction Categories"]
["Prog.","01","Regular Prog."]
["Prog.","02","Special Prog. "]
["Prog.","03","Career & Tech Prog."," "]
["Prog.","04","Gifted & Talented Prog."]
["Prog.","07","Non Public Transfers"]
["Prog.","08","School Library Media"]
["Prog.","09","Instruction Staff Dev."]
["Prog.",10,"Guidance Services"]
["Prog.",11,"Psychological Services"]
["Prog.",12,"Adult Education"]
["206 Special Education"]
["Prog.","04","Public Sch Instr. Prog."]
["Prog.","09","Instruction Staff Dev."]
["Prog.","15","Office of the Principal"]
["Prog.","16","Inst. Admin & Superv."]
["207 Student Personnel Serv."]
["208 Student Health Services"]
["209 Student Transportation"]
["210 Plant Operation"]
["Prog.","30","Warehousing & Distr."]
["Prog.","31","Operating Services"]
["211 Plant Maintenance"]
["212 Fixed Charges"]
["214 Community Services"]
["215 Capital Outlay"]
["Prog.","34 ","Land & Improvements"]
["Prog.",35,"Buildings & Additions"]
["Prog.",36,"Remodeling"]
["Total Expenditures By Object",null,null,null,{"$f":"SUM(E13:E47)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Template Budget Narrative","index":20,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,0,18,14],[19,0,19,14],[20,0,20,14],[21,0,21,14],[12,0,12,14],[13,0,13,14],[14,0,14,14],[15,0,15,14],[16,0,16,14],[17,0,17,14]]}
[null,"FY ___________",null,"Title I Budget Narrative (See Detailed Budget Description Guidelines below the table)"]
["Title I Table 7-8, 7-9 Crosswalk","School / District","Description/Purpose: Include Expected Outcome","Category / Program Number (Aligns with C- 1-25)","Budget Object Number","Line Item","Calculation","Total","Notes","Equitable Services Proportional Share"]
["Equitable Services Proportional Share",null,null,null,null,null,null," ",null,"Parent and Family Engagement"]
["Parent and Family Engagement"]
["District-wide Title I Instructional Programs"]
["District-wide Professional Development"]
["Administration"]
["Support for Title I CSI Schools"]
["Services to Neglected Children"]
["Education for Homeless Children and Youth"]
["Homeless Liaison Position"]
["Homeless Education transportation Costs (above what LEA would have otherwise provided)"]
["Detailed Budget Description Guidelines"]
["●        The detailed budget description guidelines apply to tables 7-8, 7-9.1, 7-9.2, 7-9.3, 7-9.4 and the TSI District-level Set Aside table, all which contain this column.  "]
["●        The detailed budget description column, must include:"]
["○        Identification of the Specific Line Item (i.e. what is being purchased?)"]
["○        Description"]
["■         Description of the proposed expenditure, which must include details such as number of hours, hourly rate, number of people, and/or frequency and duration of services"]
["■         Provide a brief, budget description that explains how the funds will be used to support each activity."]
["■         Amounts including how, where, and for what purpose funds were reserved"]
["●        The calculation column must include a calculation for the proposed expenditures, include a cost breakdown."]
["●        The total column must include a total for the proposed expenditure based details shared in the calculation column.  It must align directly with the calculation (i.e. the calculation must yield this total)."]

{"sheet":"Category and Object Codes","index":21,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Category/Program #s:","Category Descriptions","Budget Object #:","Cross Walk Title I Application"]
["201 - 21-Admin-General Support","Admin-General Support","01-Salaries & Wages","Equitable Services Proportional Share"]
["201 - 22-Admin-Business Support","Admin-Business Support","02-Contract Services","Parent and Family Engagement"]
["201 - 23-Admin-Centralized Support","Admin-Centralized Support","03-Supplies & Materials","District-wide Title I Instructional Programs"]
["202 - 16- Mid-level Admin-Inst. Admin. & Supv.","Mid-level Admin-Inst. Admin. & Supv.","04-Other Charges","District-wide Professional Development"]
["203-205 - 01- Inst. Categories-Regular Prog.","Inst. Categories-Regular Prog.","05-Equipment","Administration"]
["203-205 - 02- Inst. Categories-Special Prog.","Inst. Categories-Special Prog.","08-Transfers","Support for Title I CSI Schools"]
["203-205 - 07- Inst. Categories-Non Public Transfer","Inst. Categories-Non Public Transfer",null,"Services to Neglected Children"]
["203-205 - 09- Inst. Categories-Instruction Staff Dev.","Inst. Categories-Instruction Staff Dev.",null,"Education for Homeless Children and Youth"]
["203-205 - 10- Inst. Categories-Guidance Serv.","Inst. Categories-Guidance Serv.",null,"Homeless Liaison Position"]
["203-205 - 11-Inst. Categories-Psychological Serv.","Inst. Categories-Psychological Serv.",null,"Homeless Education transportation Costs (above what LEA would have otherwise provided)"]
["207- Student Personnel Serv.","Student Personnel Serv.",null,"Optional-Foster Care Transportation"]
["208 - Student Health Services","Student Health Services"]
["209 - Student Transportation","Student Transportation"]
["212 - Fixed Charges","Fixed Charges"]
["214 - Community Services","Community Services"]