{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Lists","Cover Page","Contents","Instructions","Section I","Section II","Section III","Section IV","Section V","Section VI","Section VII","Data Check Sheet","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":0,"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":"Lists","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["SP1Facilities","Districts"]
["Select Facility Name  --->","Select District Name  --->"]
["Bethel Youth Facility (LKSD)","Anchorage"]
["Fairbanks Youth Facility (FBX)","Fairbanks"]
["Johnson Youth Center (JNU)","Juneau"]
["Marathon School (KEN)","Kenai"]
["Ketchikan Youth Facility (KET)","Ketchikan"]
["Mat-Su Youth Center (MAT)","Lower Kuskokwim"]
["McLaughlin Youth Center (ANC)","Mat-Su"]
["Nome Youth Facility (NOM)","Nome"]
["The New Path HS (DOC)"]

{"sheet":"Cover Page","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["ANNUAL PROGRAM EVALUATION\nof Title I, Part D, Subpart 1 - Formula\nPREVENTION AND INTERVENTION PROGRAMS\nFOR CHILDREN AND YOUTH WHO ARE\nNEGLECTED OR DELINQUENT\nas required by Title I, Part D\nof the Every Student Succeeds Act "]
[]
["Based on Fiscal Year 2023 (July 1, 2022 - June 30, 2023)"]
["Due November 30, 2023"]
[{"$f":"\"District:  \"&IF('Section I'!B2=\"Select District Name  --->\",\"Enter District Name on the Section I tab\",'Section I'!B2&\": \"&'Section I'!B3)","v":"District:  Choose one: Select Facility Name  --->"}]
["Alaska Department of Education & Early Development\nPO Box 110500, 333 Willoughby AVE, 9th FL, State Office\nJuneau, AK  99811-0500\nhttp://education.alaska.gov/"]
["Form # 05-24-011"]
["end of page"]

{"sheet":"Contents","index":2,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["CONTENTS"]
["INSTRUCTIONS FOR COMPLETING THIS EVALUATION"]
["SECTION I: FACILITY AND SCHOOL DISTRICT INFORMATION"]
["SECTION II: PROGRAM EVALUATION"]
["SECTION III: ASSESSMENT TOOLS"]
["SECTION IV: FACILITY AND STUDENTS COUNT INFORMATION"]
["SECTION V: STUDENT DEMOGRAPHIC INFORMATION"]
["SECTION VI: ACADEMIC AND VOCATIONAL OUTCOMES"]
["SECTION VII: ACADEMIC ACHIEVEMENT DATA"]
["DATA QUALITY CHECK SHEET"]
["ABOUT THIS FORM"]
["Evaluation Form is an XLSM File - An XLSM file extension is an Excel Macro-Enabled Workbook file. In order to use this tool, macros must be enabled. Be sure to save the evaluation as an XLSM file."]
["Hyperlinks - Hyperlinks can be found throughout the evaluation. Hyperlinks are written in blue. Click on a blue hyperlink and it will take you to the designated area. For example, hyperlinks can be found in the contents listed above. Click the desired topic, and the hyperlink will take you to the corresponding tab."]
["Data Check Sheet Tab – The purpose of the  tab is to provide feedback regarding the completeness, consistency, and usability of the evaluation data. Fields will become highlighted in yellow if there is a discrepancy in the data provided. The person completing the form will need to go back to the appropriate tables and fix any inconsistencies or provide justification. For quick access to a table, please click the desired hyperlink on the Data Check Sheet tab."]
["CHANGES FOR THIS YEAR"]
["SECTION I: FACILITY AND SCHOOL DISTRICT INFORMATION\nUpdated Type of Program to include Delinquent and removed Juvenile and Adult. Additional program type selection required."]
["SECTION III: ASSESSMENT TOOLS\nUpdated pre- and post- with Initial and Follow-up"]
["SECTION IV: FACILITY AND STUDENTS COUNT INFORMATION\nAdded Average number of days served (row 5)\nAdded Deliquent Programs to the columns and removed Juvenile and Adult programs"]
["SECTION V: STUDENT DEMOGRAPHIC INFORMATION\nAdded Delinquent Programs to the columns and removed Juvenile and Adult programs"]
["SECTION VI: ACADEMIC & VOCATIONAL OUTCOMES\nAdded Delinquent Programs to the columns and removed Juvenile and Adult programs"]
["SECTION VII: ACADEMIC ACHIEVEMENT DATA\nUpdated pre- and post- with Initial and Follow-up\nAdded new Results on Assessment: Reading & Mathematics G, H, & I.\nAdded Deliquent Programs to the columns and removed Juvenile and Adult programs"]

{"sheet":"Instructions","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS FOR COMPLETING THIS EVALUATION"]
["This form collects data on programs and facilities that serve students who are neglected or delinquent under Title I, Part D, and characteristics about and services provided to these students.\nAn evaluation should be submitted for each State Agency Facility for each of those programs that receive formula funding under Title I, Part D, Subpart 1."]
["Throughout this form:\n• Report data for the program year of July 1, 2022 through June 30, 2023.\n• Count programs/facilities based on how the program was classified to DEED for funding purposes.\n• Do not include programs funded solely through Title I, Part A.\n• Only report zeroes if the students or outcomes could be counted but there were none; do not use zeroes to indicate missing data or data that were not applicable.\n"]
["Return this form to:\nJeanny Smith, Education Associate II\nAlaska Department of Education & Early Development\nPO Box 110500 • 333 Willoughby AVE, 9th FL, State Office\nJuneau, AK  99811-0500\njeanny.smith@alaska.gov"]
["If submitting electronically, please use ZendTo."]
["end of page"]

{"sheet":"Section I","index":4,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["SECTION I: FACILITY AND SCHOOL DISTRICT INFORMATION (Submit ONE report per institution) "]
["1. Name of School District:","Choose one"]
["2. Legal Name of Facility:","Select Facility Name  --->"]
["3. Type of Program: (See definitions below)"]
["         Neglected Program:","Choose one"]
["         Delinquent Program:","Choose one"]
["If \"Other\" selected above, please include a description:"]
["4. Academic Offerings: (Choose ALL that apply)"]
["During this reporting year students were awarded, through our program or through another agency:"]
["         at least one H.S. course credit:","Choose one"]
["         at least one H.S. diploma:","Choose one"]
["         at least one GED:","Choose one"]
["end of page"]
["Definitions Neglected"]
["Group homes ","A group home is a long-term facility in which residents are allowed extensive contact with the community, such as attending school or holding a job. Includes halfway houses."]
["Shelters","A shelter is a short-term facility that provides temporary care in a physically unrestricting environment. Includes runaway/homeless shelters and other types of shelters."]
["Community day programs ","The term “community day program” means a regular program of instruction provided by a State agency at a community day school operated specifically for neglected children and youth (ESEA section 1432(3))."]
["Residential treatment home","A residential treatment home is a program that provides clinical treatment services in a 24-hour living environment."]
["Other programs ","Any other programs, not defined above, which receive Title I, Part D funds and serve neglected or delinquent children and youth."]
[]
["Definitions Delinquent"]
["Adult correction ","An adult correctional institution is a facility in which persons, including persons 21 and under, are confined as a result of conviction for a criminal offense (ESEA section 1432(1))."]
["Community day programs","The term “community day program” means a regular program of instruction provided by a State agency at a community day school operated specifically for delinquent children and youth. "]
["Juvenile detention centers ","A juvenile detention center is a shorter-term institution that provides care to children who require secure custody pending court adjudication, court disposition, or execution of a court order, or care to children after commitment."]
["Shelters","A shelter is a short-term facility that provides temporary care similar to that of a detention center, but in a physically unrestricting environment. The Department notes that it is unlikely that most shelters will meet the definition of an institution for delinquent children and youth. "]
["Group homes ","A group home is a long-term facility in which residents are allowed extensive contact with the community, such as attending school or holding a job. Includes halfway houses."]
["Ranch/wilderness camps","A ranch/wilderness camp is a long-term residential facility for persons whose behavior does not necessitate the strict confinement of a long-term secure facility, often allowing them greater contact with the community. Includes ranches, forestry camps, wilderness or marine programs, or farms. "]
["Residential treatment centers ","A residential treatment center is a facility that focuses on providing some type of individually planned treatment program for youth (e.g., substance abuse, sex offender, mental health, etc.) in conjunction with residential care. The Department notes that it is unlikely that most treatment centers will meet the definition of an institution for delinquent children and youth."]
["Long-term secure juvenile facilities","A long-term secure facility is a public or private residential facility that provides confinement of its residents, for the care of children who have been adjudicated to be delinquent or in need of supervision. Similar to juvenile correctional facility. "]
["Other programs ","Any other facilities or programs, not defined above, which meet the definition of an institution for delinquent children and youth."]

{"sheet":"Section II","index":5,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["SECTION II: PROGRAM EVALUATION"]
["1) Please describe the educational goals and objectives of your program below."]
[]
["2) Have the goals and objectives of the program changed since the beginning of the fiscal year? Answer below."]
["Choose one"]
["3) What information does the district use to evaluate whether the programs and activities funded using Title I, Part D, Subpart 1 grants are effective in reaching the targeted population? Answer below."]
[]
["4) What results have been shown in the academic achievement data from Subpart 1, Section VIII of this report? Answer below."]
[]
["5) Have the programs and activities been successful? Answer below."]
["Choose one"]
["6) Describe how the results of the evaluation will be used to improve the program. Answer below."]
[]
["end of page"]

{"sheet":"Section III","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["SECTION III: ASSESSMENT TOOLS"]
["Specify the instruments used for assessments. (Choose ALL that apply.)"]
["1) State Assessments:","Choose one"]
["2) Initial & Follow-up Assessments: answer below"]
["            Reading (Provide name of assessment):","Choose one"]
["            Mathematics (Provide name of assessment):","Choose one"]
["3) Additional Assessments:"]
["            WRAT-III (Wide Range Achievement Test):","Choose one"]
["            TABE (Test of Adult Basic Education):","Choose one"]
["            AIMSWeb:","Choose one"]
["            MAP (Measures of Academic Progress):","Choose one"]
["            Other (Provide names):","Choose one"]
["end of page"]

{"sheet":"Section IV","index":7,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,0,10,3]]}
["SECTION IV: FACILITY COUNT INFORMATION"]
["In the table below, provide the number of State agency Title I, Part D, Subpart 1 programs and facilities that serve neglected and delinquent students and the average length of stay by program/facility type for these students. Report only programs and facilities that received Title I, Part D, Subpart 1 funding during the reporting year. Leave blank any columns that do not apply to your facility."]
["Table 2.4.1.1: Average Length of Stay","Neglected Programs","Delinquent Programs"]
["Average Length of Stay in DAYS*"]
["Average number of days served"]
["end of table 1 of 2"]
["Definitions\n"]
["Average Length of Stay in DAYS\n\n","The average number of days per student enrollment for each facility or program during the reporting year. Multiple visits can be included."]
["Average number of days served","The average number of days that each student is in attendance and receiving services supported by Title I, Part D in the reporting year."]
["*How is average length of stay calculated?\nThe average length of stay should be weighted by number of students and should include the number of days, per visit, for each student enrolled during the reporting year, regardless of entry or exit date. Multiple visits for students who entered more than once during the reporting year can be included. The average length of stay in days should not exceed 365."]
["SECTION IV: STUDENT COUNT INFORMATION"]
["In the table below, provide the number of neglected and delinquent students served by\nTitle I, Part D, Subpart 1 programs and facilities. Report only students who received Title I, Part D, Subpart 1 services during the reporting year. \nIn row (A), provide the unduplicated number of students served by each program, \nand in row (B), the total number of students in row 1 who are long-term.\nLeave blank any columns that do not apply to your facility."]
["Table 2.4.1.2: Students Served","Neglected Programs","Delinquent Programs","TOTAL"]
["(A) Unduplicated Student Count",null,null,{"$f":"SUM(B14:C14)","v":0}]
["(B) Number of Long-term Students",null,null,{"$f":"SUM(B15:C15)","v":0}]
["end of table 2 of 2, frequent questions below"]
["Definitions"]
["Unduplicated count\n","An unduplicated count is one that counts students only once, even if they were admitted to a facility or program multiple times within the reporting year."]
["Long-term","Long-term refers to students who were enrolled for at least 90 consecutive calendar days from July 1, 2022 through June 30, 2023."]

{"sheet":"Section V","index":8,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["SECTION V: STUDENT DEMOGRAPHIC INFORMATION"]
["Provide the number of neglected and delinquent students served in State agency Title I, Part D, Subpart 1 programs and facilities. Report only students who received Title I, Part D, Subpart 1 services during the reporting year."]
["Providing unduplicated counts: Students should only be counted once, regardless of how many times they enter the facility during a reporting period. The unduplicated count should be equal to the subtotals of each demographic category, and all demographic category counts should be equivalent to each other. For example, if the unduplicated count of students equals 120 students, then the race/ethnicity total should equal 120, the gender total should equal 120,\nand the age total should equal 120."]
["In the table below, provide the unduplicated number of students served that were identified as students with disabilities (IDEA) or identified as an English learner (EL), served by Title I, Part D, Subpart 1 programs. Leave blank any columns that do not apply to your facility."]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES"]
["Table 2.4.1.2: SwD/LEP","Neglected Programs","Delinquent Programs","TOTAL"]
["Students with Disabilities (IDEA)",null,null,{"$f":"SUM(B7:C7)","v":0}]
["English Learners (EL) ",null,null,{"$f":"SUM(B8:C8)","v":0}]
["end of table 1 of 4"]
["In the tables below, provide the number of students served by race/ethnicity, by sex, and by age.\nThe total number of students by race/ethnicity, by sex and by age will be automatically calculated."]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES"]
["Table 2.4.1.2: Race/Ethnicity","Neglected Programs","Delinquent Programs"]
["American Indian or Alaska Native"]
["Asian"]
["Black or African-American"]
["Hispanic or Latino"]
["Native Hawaiian or other Pacific Islander"]
["White (non-Hispanic)"]
["Two or more races"]
["TOTAL Race/Ethnicity:",{"$f":"SUM(B13:B19)","v":0},{"$f":"SUM(C13:C19)","v":0}]
["end of table 2 of 4"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES"]
["Table 2.4.1.2: Gender","Neglected Programs","Delinquent Programs"]
["Male"]
["Female"]
["TOTAL Gender:",{"$f":"SUM(B24:B25)","v":0},{"$f":"SUM(C24:C25)","v":0}]
["end of table 3 of 4"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES"]
["Table 2.4.1.2: Age","Neglected Programs","Delinquent Programs"]
["3 through 5"]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
["TOTAL Age:",{"$f":"SUM(B30:B46)","v":0},{"$f":"SUM(C30:C46)","v":0}]
["end of table 4 of 4; frequent questions and comment box below"]
["FAQ: Reporting a student's age: \nReport the age the student was when he/she left the facility or the age at the end of the reporting year (June 30), if the student is still enrolled."]
["Do the totals for race/ethnicity, gender, or age differ? If the total number of students differs between demographics, please explain in comment box below."]
[]
["end of page"]

{"sheet":"Section VI","index":9,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["SECTION VI: ACADEMIC & VOCATIONAL OUTCOMES"]
["The table below provides information on the age ranges used for federal reporting by the US Department of Education. These age ranges designate which age range of students could reasonably be expected to achieve each academic and vocational outcome."]
["Academic or Vocational Outcome","Age Ranges"]
["Enroll in a local school district","6-21"]
["Earn high school course credits","13-21"]
["Enroll in a GED program","14-21"]
["Earn a GED","16-21"]
["Obtain a high school diploma","16-21"]
["Be accepted to postsecondary education","16-21"]
["Enroll in a postsecondary education","16-21"]
["Enroll in elective job training/courses","16-21"]
["Enroll in external job training education","16-21"]
["Obtain employment","14-21"]
["end of table 1 of 4"]
["NOTE: Items in bold reflect Federal performance measures."]
["In the following tables, for each program type, first provide the unduplicated number of students who\nattained academic and vocational outcomes while enrolled in the State agency program/facility (white\ncolumn) and next provide the unduplicated number of students who attained academic and vocational \noutcomes within 90 calendar days after exiting (blue column). "]
["If the numbers include students outside the Title I, Part D Outcome Specific Age Ranges (see above),\nindicate this by checking the “Yes” box, below. The numbers should not exceed those reported earlier in\nthe facility counts. Leave blank any columns that do not apply to your facility."]
["Do the student counts in the following tables include students outside the Title I-D Outcome Specific Age Ranges, as shown above?","Choose one"]
["If so, please indicate the ages outside of the range below."]
[]
["Collection of Academic and Vocational Outcomes"]
["Click on the hyperlink to go to specific definition"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES","Neglected Programs",null,"Delinquent Programs"]
["2.4.1.3.2: Academic & Vocational Outcomes (once per student, only after exit)","In Facility\n(Neglected)","90 days after exit\n(Neglected)","In Facility\n","90 days after exit\n"]
["Enrolled in their local district school"]
["end of table 2 of 4"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES","Neglected Programs",null,"Delinquent Programs"]
["2.4.1.3.2: Academic & Vocational Outcomes (once per student)","In Facility\n(Neglected)","90 days after exit\n(Neglected)","In Facility\n","90 days after exit\n"]
["Earned a GED"]
["Obtained high school diploma"]
["end of table 3 of 4"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES","Neglected Programs",null,"Delinquent Programs"]
["2.4.1.3.2: Academic & Vocational Outcomes (once per student per time period)","In Facility\n(Neglected)","90 days after exit\n(Neglected)","In Facility\n","90 days after exit\n"]
["Earned high school course credits"]
["Enrolled in a GED program"]
["Accepted/enrolled in post-secondary ed"]
["Enrolled in job training courses/programs"]
["Obtained employment"]
["end of table 4 of 4; clarification on outcome tables below"]
["Additional Clarification for  Academic and Vocational Outcome Tables "]
["• No length-of-stay requirement: There is no length-of-stay requirement for reporting a student’s academic and vocational outcomes – all students may be included regardless of their length of stay."]
["• One student achieving multiple outcomes: The same student may be counted as having attained\nmore than one outcome. For example, the same student may have obtained employment and \nreturned to a district school."]
["• Actual, not anticipated, outcomes: Counts should reflect actual, not anticipated, outcomes."]
["• Multiple student enrollments are allowed: Data for academic and vocational outcomes are not\nrestricted to a student’s most recent enrollment/exit period. All outcomes achieved over multiple\nenrollment/exit periods during the reporting year should be included."]
["• Student counts, not outcome counts: In general, outcomes may be counted once per student per time period. (See exceptions for one-time events, such as earned a GED and obtained a high school "]
["Definitions for Outcomes"]
["1. Once Per Student, Only After Exit: Outcomes a student is able to achieve only after exit.\nA student may be reported only once, per program type. "]
["2. Once Per Student: Outcomes a student is able to achieve only one time.\n A student may be reported only once across the two time periods, per program type."]
["3. Once Per Student Per Time Period: Outcomes a student may achieve more than once.\nIf a student attained an outcome once in the facility and once during the 90 day transition period,\nthat student may be reported once in each column."]
["Definitions for Time Periods"]
["1. In Facility: This refers to outcomes achieved or attained during any point within the reporting year\nwhile the student was enrolled in the facility or program."]
["2. 90 Days After Exit: This refers to any time up to 90 days after a student has been released from the facility or program. Exiting does not refer to transfer to another facility within the juvenile justice \nor child welfare systems."]
["• The 90-day period does not require States to track children and youth for a full 90 days after exit.\nRather, this period gives States that are able to provide transition data a longer tracking window\nin which students may be able to achieve outcomes after exiting. If States are only able to\nprovide data for a shorter period of time (i.e., 10, 20, or 30 days after exit) and students have\nachieved these outcomes, those data should be reported."]
["end of page"]

{"sheet":"Section VII","index":10,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["SECTION VII: ACADEMIC ACHIEVEMENT DATA"]
["In the tables below, provide the unduplicated number of long-term students served\nby Title I, Part D, Subpart 1, who participated in reading and mathematics initial and follow-up testing.  Students should be reported in only one of the four change categories.\nReport only information on a student’s most recent testing data.  Students who were Initially tested prior to July 1, 2023, may be included if their Follow-up test was administered during the reporting year.  Students who were Follow-up  after the reporting year ended should be counted in the following year. Leave blank any columns that do not apply to your facility."]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES; UNDUPLICATED COUNTS ONLY"]
["2.4.1.6.1: Achievement Data - READING"]
["Performance Data for Long-Term Students (based on most recent pre/follow-up test data)","Neglected Programs","Delinquent Programs"]
["A.1. Initial test ONLY results in reading"]
["A.2. Complete initial and follow-up test results in reading"]
["A.3. Follow-up test ONLY results in reading"]
["A.4. NO initial or follow-up test results in reading"]
["B.1. With initial test results who tested at or above grade-level in reading upon entry"]
["B.2. With initial test results who tested below grade-level in reading upon entry"]
["Of the students reported in A.2. above (who have both Initial  & follow-up test results),\nthe number who showed…"]
["C. Negative grade-level change from the initial to follow-up test reading exams"]
["D. No change in grade-level from the initial  to follow-up test reading exams"]
["E. Improvement from up to one full grade-level from the initial  to follow-up test reading exams"]
["F. Improvement of more than one full grade-level from the initial to follow-up test reading exams"]
["READING TOTAL",{"$f":"SUM(B13:B16)","v":0},{"$f":"SUM(C13:C16)","v":0}]
["G. The number of students who participated in a statewide assessment (optional)"]
["H. The number of students who attained proficiency on a statewide assessment (optional)"]
["I. The number of students who did not attain proficiency on a statewide assessment (optional)"]
["NOTE: The sum of rows A.1. through B.2.\nmust equal the number of long-term students in Section IV.\nThe sum of rows A.1. and A.2. must equal the sum of B.1. and B.2.\nThe number of students reported in row A.2. must equal the sum of rows C through F."]
["end of table 1 of 2"]
["USE WHOLE NUMBERS ONLY - NO PERCENTAGES; UNDUPLICATED COUNTS ONLY"]
["2.4.1.6.2: Achievement Data - MATHEMATICS"]
["Performance Data for Long-Term Students (based on most recent initial/follow-up test data)","Neglected Programs","Delinquent Programs"]
["A.1. Initial test ONLY results in math"]
["A.2. Complete initial and follow-up test results in math"]
["A.3. Follow-up test ONLY results in math"]
["A.4. NO initial or follow-up test results in math"]
["B.1. With initial test results who tested at or above grade-level in math upon entry"]
["B.2. With initial test results who tested below grade-level in math upon entry"]
["Of the students reported in A.2. above\n(who have both Initial  & follow-up test results),\nthe number who showed…"]
["C. Negative grade-level change from the initial to follow-up test math exams"]
["D. No change in grade-level from the initial to follow-up test math exams"]
["E. Improvement from up to one full grade-level from the initial to follow-up test math exams"]
["F. Improvement of more than one full grade-level from the initial to follow-up test math exams"]
["MATHEMATICS TOTAL",{"$f":"SUM(B33:B36)","v":0},{"$f":"SUM(C33:C36)","v":0}]
["G. The number of students who participated in a statewide assessment (optional)"]
["H. The number of students who attained proficiency on a statewide assessment (optional)"]
["I. The number of students who did not attain proficiency on a statewide assessment (optional)"]
["NOTE:\nThe sum of rows A.1. through B.2. must equal the number of long-term students in Section IV.\nThe sum of rows A.1. and A.2. must equal the sum of B.1. and B.2.\nThe number of students reported in row A.2. must equal the sum of rows C through F."]
["end of table 2 of 2; end of page"]

{"sheet":"Data Check Sheet","index":11,"n_rows":116,"n_cols":5,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Title I-D Subpart 1 Annual Program Evaluation Data Check Cheet -\"&'Section I'!B3","v":"Title I-D Subpart 1 Annual Program Evaluation Data Check Cheet -Select Facility Name  --->"}]
["SECTION IV: Table 2.4.1.1: Average Length of Stay","Neglected Programs","Delinquent Programs"]
["Average Length of Stay in DAYS",{"$f":"'Section IV'!B4","v":0},{"$f":"'Section IV'!C4","v":0}]
["Criteria: Cannot exceed 365 days."]
["end table 1 of 11"]
["SECTION IV: Table 2.4.1.2: Students Served","Neglected Programs","Delinquent Programs"]
["(A) Unduplicated Student Count",{"$f":"'Section IV'!B14","v":0},{"$f":"'Section IV'!C14","v":0}]
["(B) Number of Long-term Students",{"$f":"'Section IV'!B15","v":0},{"$f":"'Section IV'!C15","v":0}]
["Criteria: Long-term Count (B) cannot exceed Unduplicated Count (A)."]
["(B) Number of Long-term Students",{"$f":"'Section IV'!B15","v":0},{"$f":"'Section IV'!C15","v":0}]
["Section VII: Reading A.1 - A.4",{"$f":"SUM('Section VII'!B6:B9)","v":0},{"$f":"SUM('Section VII'!C6:C9)","v":0}]
["Section VII: Mathematics A.1 - A.4",{"$f":"SUM('Section VII'!B26:B31)","v":0},{"$f":"SUM('Section VII'!C26:C29)","v":0}]
["Criteria: Total of §VII: Reading A.1 - A.4 must equal §IV: Number of Long-term Students; Total of §VII: Mathematics A.1 - A.4 must equal §IV: Number of Long-term Students"]
["end table 2 of 11"]
["SECTION V: Table 2.4.1.2: SwD/EL","Neglected Programs","Delinquent Programs"]
["Students with Disabilities (IDEA)",{"$f":"'Section V'!B7","v":0},{"$f":"'Section V'!C7","v":0}]
["English Learners",{"$f":"'Section V'!B8","v":0},{"$f":"'Section V'!C8","v":0}]
["Criteria: Cannot exceed Unduplicated Count (A) in Table 2.4.1.2."]
["end table 3 of 11"]
["SECTION V: Table 2.4.1.2: Race/Ethnicity","Neglected Programs","Delinquent Programs"]
["TOTAL Race/Ethnicity:",{"$f":"'Section V'!B20","v":0},{"$f":"'Section V'!C20","v":0}]
["Criteria: Must equal that of Unduplicated Count (A) in Table 2.4.1.2."]
["end table 4 of 11"]
["SECTION V: Table 2.4.1.2: Gender","Neglected Programs","Delinquent Programs"]
["TOTAL Gender:",{"$f":"'Section V'!B26","v":0},{"$f":"'Section V'!C26","v":0}]
["Criteria: Must equal that of Unduplicated Count (A) in Table 2.4.1.2."]
["end table 5 of 11"]
["SECTION V: Table 2.4.1.2: Age","Neglected Programs","Delinquent Programs"]
["TOTAL Age:",{"$f":"'Section V'!B47","v":0},{"$f":"'Section V'!C47","v":0}]
["Criteria: Must equal that of Unduplicated Count (A) in Table 2.4.1.2."]
["end table 6 of 11"]
["SECTION VI: 2.4.1.3.2: Once per student, only after exit","Neglected Programs\nCount","Neglected Programs\nCannot Exceed","Delinquent Programs Count","Delinquent Programs Cannot Exceed"]
["Enrolled in their local district school (age 6-21)",{"$f":"'Section VI'!C25","v":0},{"$f":"SUM('Section V'!B31:B46)","v":0},{"$f":"'Section VI'!E25","v":0},{"$f":"SUM('Section V'!C31:C46)","v":0}]
["Criteria: Cannot exceed total of applicable ages from Section V: Table 2.4.1.2: Age."]
["end table 7 of 11"]
["SECTION VI: 2.4.1.3.2: Once per student","Neglected Programs\nCount","Neglected Programs\nCannot Exceed","Delinquent Programs Count","Delinquent Programs Cannot Exceed"]
["Earned a GED (age 16-21)",{"$f":"'Section VI'!C29","v":0},{"$f":"SUM('Section V'!B41:B46)","v":0},{"$f":"'Section VI'!D29","v":0},{"$f":"SUM('Section V'!C41:C46)","v":0}]
["Obtained high school diploma (age 16-21)",{"$f":"'Section VI'!C30","v":0},{"$f":"SUM('Section V'!B41:B46)","v":0},{"$f":"'Section VI'!D30","v":0},{"$f":"SUM('Section V'!C41:C46)","v":0}]
["Criteria: Cannot exceed total of applicable ages from Section V: Table 2.4.1.2: Age."]
["end table 8 of 11"]
["SECTION VI: 2.4.1.3.2: Once per student per time period","Neglected Programs\nCount","Neglected Programs\nCannot Exceed","Delinquent Programs Count","Delinquent Programs Cannot Exceed"]
["Earned high school course credits (age 13-21)",{"$f":"'Section VI'!B34+'Section VI'!C34","v":0},{"$f":"SUM('Section V'!B38:B46)*2","v":0},{"$f":"'Section VI'!D34+'Section VI'!E34","v":0},{"$f":"SUM('Section V'!C38:C46)*2","v":0}]
["Enrolled in a GED program (age 14-21)",{"$f":"'Section VI'!B35+'Section VI'!C35","v":0},{"$f":"SUM('Section V'!B39:B46)*2","v":0},{"$f":"'Section VI'!D35+'Section VI'!E35","v":0},{"$f":"SUM('Section V'!C39:C46)*2","v":0}]
["Accepted OR enrolled into post-secondary (age 16-21)",{"$f":"'Section VI'!B36+'Section VI'!C36","v":0},{"$f":"SUM('Section V'!B41:B46)*2","v":0},{"$f":"'Section VI'!D36+'Section VI'!E36","v":0},{"$f":"SUM('Section V'!C41:C46)*2","v":0}]
["Enrolled in job training courses/programs (age 16-21)",{"$f":"'Section VI'!B37+'Section VI'!C37","v":0},{"$f":"SUM('Section V'!B41:B46)*2","v":0},{"$f":"'Section VI'!D37+'Section VI'!E37","v":0},{"$f":"SUM('Section V'!C41:C46)*2","v":0}]
["Obtained employment (age 14-21)",{"$f":"'Section VI'!B38+'Section VI'!C38","v":0},{"$f":"SUM('Section V'!B39:B46)*2","v":0},{"$f":"'Section VI'!D38+'Section VI'!E38","v":0},{"$f":"SUM('Section V'!C39:C46)*2","v":0}]
["Criteria: Cannot exceed total of applicable ages from Section V: Table 2.4.1.2: Age."]
["end table 9 of 11"]
["SECTION VII: 2.4.1.6.1: Achievement Data - READING","Neglected Programs","Delinquent Programs"]
["A.1. Pre-test ONLY results in reading",{"$f":"'Section VII'!B6","v":0},{"$f":"'Section VII'!C6","v":0}]
["A.2. Complete pre- and post-test results in reading",{"$f":"'Section VII'!B7","v":0},{"$f":"'Section VII'!C7","v":0}]
["B.1. With pre-test results who tested at or above grade-level in reading upon entry",{"$f":"'Section VII'!B10","v":0},{"$f":"'Section VII'!C10","v":0}]
["B.2. With pre-test results who tested below grade-level in reading upon entry",{"$f":"'Section VII'!B11","v":0},{"$f":"'Section VII'!C11","v":0}]
["READING TOTAL - Sum of C, D, E, & F",{"$f":"'Section VII'!B17","v":0},{"$f":"'Section VII'!C17","v":0}]
["Criteria: A1 + A2 must equal B1 + B2.",{"$f":"IF(B50+B51=B52+B53,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C50+C51=C52+C53,\"Yes\",\"No\")","v":"Yes"}]
["Criteria: A2 must equal the sum of C, D, E, & F.",{"$f":"IF(B51=B54,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C51=C54,\"Yes\",\"No\")","v":"Yes"}]
["Criteria: A2 cannot exceed total long-term Section IV: Table 2.4.1.2.b: Long-term Students Served",{"$f":"IF(B54<=B8,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C54<=C8,\"Yes\",\"No\")","v":"Yes"}]
["end table 10 of 11"]
["SECTION VII: 2.4.1.6.2: Achievement Data - MATH","Neglected Programs","Juvenile Detention"]
["A.1. Pre-test ONLY results in math",{"$f":"'Section VII'!B26","v":0},{"$f":"'Section VII'!C26","v":0}]
["A.2. Complete pre- and post-test results in math",{"$f":"'Section VII'!B27","v":0},{"$f":"'Section VII'!C27","v":0}]
["B.1. With pre-test results who tested at or above grade-level in math upon entry",{"$f":"'Section VII'!B30","v":0},{"$f":"'Section VII'!C30","v":0}]
["B.2. With pre-test results who tested below grade-level in math upon entry",{"$f":"'Section VII'!B31","v":0},{"$f":"'Section VII'!C31","v":0}]
["MATHEMATICS TOTAL - Sum of C, D, E, & F",{"$f":"'Section VII'!B37","v":0},{"$f":"'Section VII'!C37","v":0}]
["Criteria: A1 + A2 must equal B1 + B2.",{"$f":"IF(B60+B61=B62+B63,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C60+C61=C62+C63,\"Yes\",\"No\")","v":"Yes"}]
["Criteria: A2 must equal the sum of C, D, E, & F.",{"$f":"IF(B61=B64,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C61=C64,\"Yes\",\"No\")","v":"Yes"}]
["Criteria: A2 cannot exceed total long-term Section IV: Table 2.4.1.2.b: Long-term Students Served",{"$f":"IF(B64<=B8,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(C64<=C8,\"Yes\",\"No\")","v":"Yes"}]
["end table 11 of 11 (definitions listed below)"]
["One-Time Outcome Definitions and Instructions "]
["Enrolled in their local district school: The number of students who returned to or enrolled in local district schools (but external to the juvenile justice system)."]
["• What time period to report in: "]
["o 90 Days After Exit Only: If a student enrolled, or planned to enroll, in his or her local district school after exit, report the student in this column."]
[" Earned a GED: The number of students who earned a GED."]
["• Students may be counted for this item in locations where the GED is awarded by the State (rather than the facility)."]
["•What time period to report in: "]
["o In Facility Only: If the student earned a GED while enrolled in the facility, report the student in this column."]
["o 90 Days After Exit Only:  If the student earned a GED between 1–90 days after exit, report the student in this column."]
["o Do not report the student in both columns."]
["Obtained a high school diploma: The number of students who earned a high school diploma."]
["• What time period to report in: "]
["o In Facility Only: If the student obtained a high school diploma while enrolled in the facility or program, report the student in this column."]
["o 90 Days After Exit Only:  If the student obtained a high school diploma between 1–90 days after exit, report the student in this column."]
["o Do not report the student in both columns."]
["Outcomes Potentially Occuring Across the Two Time Periods Definitions and Instructions "]
["Earned high school course credits: The number of students who earned transferable high school course credits."]
["•  What time period to report in:"]
["o  In Facility Only: If the student earned high school course credits only while in the facility or program, report the student in this column."]
["o  90 Days After Exit Only:  If the student earned high school course credits only within 1–90 days after exit, report the student in this column."]
["o  Both Time Periods:  If the student earned high school course credits both while in the facility or program AND within 90 days after exit, report the student once in each column."]
["Enrolled in a GED program: The number of students who enrolled in a program or course designed specifically to help students pass the GED."]
["• The GED course need not be run by the facility itself for students to be reported under this item."]
["• What time period to report in: "]
["o In Facility Only: and the student continues enrollment in the same GED course after exiting, report the student here, as enrollment was initiated in the facility.If the student enrolled in a GED program only while enrolled in the facility, report the student in this column. If a student enrolls in a GED program while in the facility\n "]
["o 90 Days After Exit Only:  If the student enrolled in a GED program only within 90 days after exit, report the student in this column."]
["o Both Time Periods:  If the student enrolled in one GED program while in the facility or program and then enrolled in a different GED program within 90 days after exit, report the student\nonce in each column."]
["Accepted or enrolled in postsecondary education: The number of students accepted and/or enrolled in postsecondary programs. Postsecondary education\nrefers to an independent postsecondary educational program; it does not refer to individual college-level courses that are part of a facility’s educational programming. Students may be reported if they meet one of the following criteria: (1) they are accepted into a postsecondary program (and subsequently enroll or decline), or (2) enroll in a program that does not require an application process. Accepting and then enrolling in the same school may only be counted one time in one time period."]
["• The programs/courses need not be run by, and the outcomes need not be awarded by, the facility itself to be counted."]
["• What time period to report in: "]
["o In Facility Only: If the student is accepted and/or enrolls in a postsecondary program only while enrolled in the facility, report the student in this column."]
["o 90 Days After Exit Only:  If the student is accepted and/or enrolls in a postsecondary program only within 90 days after exit, report the student in this column."]
["o Both Time Periods:  If the student is accepted and/or enrolls in one postsecondary program while in the facility, and later is accepted and/or enrolls in a different postsecondary program\nwithin 90 days after exit, report the student once in each column."]
["Enrolled in job training courses/programs: The number of students enrolled in vocational/job training programs or courses. The programs or courses should not\nbe part of a 2- or 4-year postsecondary degree program, which should be reported under “Accepted or enrolled into postsecondary education” (above)."]
["• The programs or courses may be provided by the facility/program or through an external organization."]
["• Dual outcomes with HS course credits. If a student earned transferrable high school course credit through a job training course, districts may count the student both as\nhaving earned high school course credit and as having enrolled in job training courses/programs."]
["• Required vocational education. If enrollment in vocational courses is required by the facility, districts  may also include students enrolled in those types of vocational\nprograms under this item."]
["• What time period to report in: "]
["o In Facility Only: If the student enrolled in job training courses/programs only while enrolled in the facility, report the student in this column."]
["o 90 Days After Exit Only:  If the student enrolled in job training courses/programs only within 90 days after exit, report the student in this column."]
["o Both Time Periods:  If the student enrolled in job training courses/programs while in the facility and then enrolled in a different job training course/program within 90 days after exit,\nreport the student once in each column."]
["Obtained employment: The number of students who received job offers."]
["• Employing students within a facility. Students who are employed within the facility during their enrollment should not be counted under “obtained employment in\nfacility.” The purpose of this indicator is to capture transition outcomes for students as they leave facilities or programs. If a student obtains employment with and\nremains working in the facility or program after their exit date, then they may be included."]
["• What time period to report in: "]
["o In Facility Only: If the student received a job offer only while enrolled in the facility for a job they intend to work at after exit, report the student in this column."]
["o 90 Days After Exit Only:  If the student received a job offer only within 90 days after exit, report the student in this column."]
["o Both Time Periods: If the student received a job offer while in the facility and also received a different job offer within 90 days after exit, report the student once in each column."]
["end of page (last page of form/workbook)"]

{"sheet":"Template","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}