{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Lists","Cover Page","Program & Student Information","Outcomes & Achievement","Program Evaluation","Data Check Sheet","Definitions","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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"]
["Golden Heart Academy (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":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"ANNUAL PROGRAM EVALUATION\nof Title I, Part D, Subpart 2 \nAT-RISK PROGRAMS"]
[null,{"$error":"#VALUE!"}]
[null,"Based on the previous school year"]
[null,"Due October 31"]
[null,{"$f":"\"District: \"&'Program & Student Information'!D2","v":"District: "}]
[null,"Form # 05-24-011"]
[]
[null,"CONTENTS"]
[null,"FACILITY AND SCHOOL DISTRICT INFORMATION"]
[null,"OUTCOMES & ACHIEVEMENT"]
[null,"PROGRAM EVALUATION"]
[null,"DATA CHECK SHEET"]
[null,"DEFINITIONS"]
[null,"ABOUT THIS FORM"]
[null,"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."]
[null,"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."]
[null,"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."]
[null,"CHANGES FOR THIS YEAR"]
[null,"Significant changes to the structure and layout of the evaluation."]
[null,"Unnecessary elements removed."]
[null,"No new elements added."]
[]
[null,"INSTRUCTIONS FOR COMPLETING THIS EVALUATION"]
[null,"This form collects data on at-risk programs that serve students under Title I, Part D, subpart 2 and characteristics about and services provided to these students. "]
[null,"Throughout this form:\n• Report data for the previous program year as indicated in the notification email.\n• Do not include programs funded solely through Title I, Part A.\n• 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."]
[null,"• All cells with this color must be completed. Cells left blank are assumed to be missing data."]
[null,"SUBMITTING THE COMPLETED EVALUATION"]
[null,"Submit completed form via ZendTo to:"]
[null,"drop.state.ak.us"]
[null,"eed.NorDdata@alaska.gov"]

{"sheet":"Program & Student Information","index":2,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"SECTION I: SCHOOL DISTRICT INFORMATION (Submit ONE report per district, per program) "]
[null,"1. Name of School District:"]
[]
[null,"SECTION II: STUDENT COUNT & DEMOGRAPHIC INFORMATION"]
[null,"In the table below, report only students that received Title I, Part D, Subpart 2 funding through the district's at-risk program during the reporting year. "]
[null,"Table 2.5.1.1."]
[null,"Average length of stay in days"]
[null,"Average number of days served"]
[null,"Table 2.5.1.2: Students Served"]
[null,"Unduplicated Student Count"]
[null,"Number of Long-term Students"]
[null,"Students with Disabilities (IDEA)"]
[null,"English Learners (EL) "]
[null,"Table 2.5.1.3: Race/Ethnicity",null,"TOTAL Race/Ethnicity:",{"$f":"SUM(C15:C21)","v":0}]
[null,"American Indian or Alaska Native"]
[null,"Asian"]
[null,"Black or African-American"]
[null,"Hispanic or Latino"]
[null,"Native Hawaiian or other Pacific Islander"]
[null,"White (non-Hispanic)"]
[null,"Two or more races"]
[null,"Table 2.5.1.3: Sex",null,"TOTAL Sex:",{"$f":"SUM(C23:C24)","v":0}]
[null,"Male"]
[null,"Female"]
[null,"Table 2.5.1.3: Age",null,"TOTAL Age:",{"$f":"SUM(C26:C42)","v":0}]
[null,"3 through 5"]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,"Report the age the student was when they left the facility/program or the age at the end of the reporting year (June 30), if the student is still enrolled."]

{"sheet":"Outcomes & Achievement","index":3,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"SECTION III: ACADEMIC & VOCATIONAL OUTCOMES"]
[null,"In the tables below, first provide the unduplicated number of students who attained academic and vocational outcomes while enrolled in the district's at-risk program and provide the unduplicated number of students who attained academic and vocational outcomes within 90 calendar days after exiting the program. \n\nUSE WHOLE NUMBERS ONLY - NO PERCENTAGES; UNDUPLICATED COUNTS ONLY"]
[null,"Table 2.5.1.4.2 Academic & Vocational Outcomes (once per student, only after exit)","In Program","90 days after exit"]
[null,"Enrolled in their local district school"]
[null,"Table 2.5.1.4.2 Academic & Vocational Outcomes (once per student)","In Program","90 days after exit"]
[null,"Earned a GED"]
[null,"Obtained high school diploma"]
[null,"Table 2.5.1.4.2 Academic & Vocational Outcomes (once per student per time period)","In Program","90 days after exit"]
[null,"Earned high school course credits"]
[null,"Enrolled in a GED program"]
[null,"Accepted/enrolled in post-secondary ed"]
[null,"Enrolled in job training courses/programs"]
[null,"Obtained employment"]
[]
[null,"SECTION VI: ACADEMIC ACHIEVEMENT DATA"]
[null,"In the tables below, provide the unduplicated number of long-term students served by Title I, Part D, Subpart 2 in the district's at-risk program, who participated in reading and mathematics initial and follow-up assessment. If there were no long-term students in the at-risk program, enter zeroes for all categories. Do not leave blank.\n\nReport only information on a student’s most recent testing data.  Students who were initially tested prior to July 1 of the reporting year may be included if their follow-up test was administered during the reporting year.  Students who completed a follow-up test after the reporting year ended should be counted in the following year. Leave blank any rows that do not apply.\n"]
[null,"USE WHOLE NUMBERS ONLY - NO PERCENTAGES; UNDUPLICATED COUNTS ONLY"]
[null,"Provide the name of the assessment used for initial and follow-up data:"]
[null,"Number of long-term students",{"$f":"'Program & Student Information'!C11","v":0}]
[null,"2.5.2.1: Long-Term Student Achievement Data - READING"]
[null,"Long-Term Student Initial/Follow-Up Assessments - READING"]
[null,"(A1) Number of long-term students with complete initial and follow-up test results in reading"]
[null,"Long-Term Student Progress Level - READING"]
[null,"(B1) Negative grade-level change from the initial to follow-up reading assessment"]
[null,"(B2) No change in grade-level from the initial  to follow-up reading assessment"]
[null,"(B3) Improvement of up to one full grade level from the initial to follow-up reading assessment"]
[null,"(B4) Improvement of more than one full grade from the initial to follow-up reading assessment"]
[null,"Total of B1-B4 should equal A1."]
[null,"READING GRADE CHANGE TOTAL",{"$f":"SUM(C24:C27)","v":0}]
[null,"If the number provided in A1 does not equal the number of long-term students listed above, provide an explanation below:"]
[]
[]
[null,"2.5.2.1: Long-Term Student Achievement Data - MATHEMATICS"]
[null,"Long-Term Student Initial/Follow-Up Assessments - MATHEMATICS"]
[null,"(A1) Number of long-term students with complete initial and follow-up test results in math"]
[null,"Long-Term Student Progress Level - MATHEMATICS"]
[null,"(B1) Negative grade-level change from the initial to follow-up math assessment"]
[null,"(B2) No change in grade-level from the initial  to follow-up math assessment"]
[null,"(B3) Improvement of up to one full grade level from the initial to follow-up math assessment"]
[null,"(B4) Improvement of more than one full grade from the initial to follow-up math assessment"]
[null,"Total of B1-B4 should equal A1."]
[null,"MATH GRADE CHANGE TOTAL",{"$f":"SUM(C37:C40)","v":0}]
[null,"If the number provided in A1 does not equal the number of long-term students listed above, provide an explanation below:"]

{"sheet":"Program Evaluation","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"PROGRAM EVALUATION"]
[null,"1) Provide a description of the at-risk program, including the types of services provided:"]
[]
[null,"2) Provide a description of the educational goals and objectives of your program:"]
[]
[null,"3) What information does the district use to evaluate whether the at-risk program is effective in reaching the targeted population? Include all objective criteria, such as assessments used, as well as other information:"]
[]
[null,"4) Describe how the programs and activities have been successful:"]
[]
[null,"5) Describe how the results of this evaluation will be used to improve the program:"]

{"sheet":"Data Check Sheet","index":5,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Title I-D Subpart 2 At-Risk Annual Program Evaluation Data Check Sheet -"]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.1: Average Length of Stay"]
[null,"(A) Average Length of Stay in DAYS",{"$f":"'Program & Student Information'!C7","v":0}]
[null,"Criteria: Cannot exceed 365 days."]
[null,"(B) Average number of days served",{"$f":"'Program & Student Information'!C8","v":0}]
[null,"Criteria: Cannot exceed average length of stay"]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.2: Students Served"]
[null,"(A) Unduplicated Student Count",{"$f":"'Program & Student Information'!C10","v":0}]
[null,"(B) Number of Long-term Students",{"$f":"'Program & Student Information'!C11","v":0}]
[null,"Criteria: Long-term Count (B) cannot exceed Unduplicated Count (A)."]
[null,"Section IV: Reading A.1 ",{"$f":"'Outcomes & Achievement'!C22","v":0}]
[null,"Section IV: Mathematics A.1 ",{"$f":"'Outcomes & Achievement'!C35","v":0}]
[null,"Criteria: Total of IV: Reading A.1 must equal: Number of Long-term Students; Total of IV: Mathematics A.1 must equal: Number of Long-term Students"]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.2: SwD/EL"]
[null,"Students with Disabilities (IDEA)",{"$f":"'Program & Student Information'!C12","v":0}]
[null,"English Learners",{"$f":"'Program & Student Information'!C13","v":0}]
[null,"Criteria: Cannot exceed Unduplicated Count (A) in Table 2.5.1.2."]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.2: Race/Ethnicity"]
[null,"TOTAL Race/Ethnicity:",{"$f":"'Program & Student Information'!E14","v":0}]
[null,"Criteria: Must equal that of Unduplicated Count (A) in Table 2.5.1.2."]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.2: Sex"]
[null,"TOTAL Sex:",{"$f":"'Program & Student Information'!E22","v":0}]
[null,"Criteria: Must equal that of Unduplicated Count (A) in Table 2.5.1.2."]
[]
[null,"FACILITY & STUDENT INFORMATION Table 2.5.1.2: Age"]
[null,"TOTAL Age:",{"$f":"'Program & Student Information'!E25","v":0}]
[null,"Criteria: Must equal that of Unduplicated Count (A) in Table 2.5.1.2."]
[]
[null,"OUTCOMES & ACHIEVEMENT 2.5.1.6.1: Achievement Data - READING"]
[null,"A.1. Complete initial and follow-up results in reading",{"$f":"C13","v":0}]
[null,"Criteria: A1 cannot exceed total long-term Section IV: Table 2.5.1.2.: Long-term Students Served",{"$f":"IF(C35<=C11,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"OUTCOMES & ACHIEVEMENT 2.5.1.6.2: Achievement Data - MATH"]
[null,"A.1. Complete initial and follow-up results in math",{"$f":"C14","v":0}]
[null,"Criteria: A1 cannot exceed total long-term Section IV: Table 2.5.1.2.: Long-term Students Served",{"$f":"IF(C39<=C11,\"Yes\",\"No\")","v":"Yes"}]

{"sheet":"Definitions","index":6,"n_rows":76,"n_cols":3,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Definitions Table 2.5.1.1."]
[null,"Average Length of Stay","The average length of stay should include the number of days, per visit, for each student enrolled in the at-risk program 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, but should be counted as separate visits for this calculation.  This value should not exceed 365."]
[null,"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. For more information on calculating the average number of days served, see: "]
[null,null,"Calculating the Average Number of Days Served"]
[]
[null,"Definitions Table 2.5.1.2."]
[null,"Unduplicated Count","Students are counted only once, even if they were admitted to the facility or program multiple times within the reporting year."]
[null,"Long-term student","Long-term refers to students who were enrolled for at least 90 consecutive calendar days from July 1 to June 30 of the reporting year."]
[]
[null,"Definitions for Outcomes 2.5.1.4.2."]
[null,"Once Per Student, Only After Exit","Outcomes a student is able to achieve only after exit. A student may be reported only once, per program type. "]
[null,"Once Per Student","Outcomes a student is able to achieve only one time.  A student may be reported only once across the two time periods, per program type."]
[null,"Once Per Student Per Time Period","Outcomes a student may achieve more than once. If a student attained an outcome once in the facility and once during the 90 day transition period, that student may be reported once in each column."]
[null,"Definitions for Time Periods"]
[null,"In Facility","This refers to outcomes achieved or attained during any point within the reporting year while the student was enrolled in the facility or program."]
[null,"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 or child welfare systems."]
[]
[null,"One-Time Outcome Definitions and Instructions "]
[null,"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). Students already enrolled in their local school district while attending the at-risk program should not be counted here."]
[null,null,"• What time period to report in: "]
[null,null,"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."]
[null," Earned a GED","The number of students who earned a GED."]
[null,null,"• Students may be counted for this item in locations where the GED is awarded by the facility, state, or other agency."]
[null,null,"•What time period to report in: "]
[null,null,"o In Facility : If the student earned a GED while enrolled in the facility, report the student in this column."]
[null,null,"o 90 Days After Exit:  If the student earned a GED between 1–90 days after exit, report the student in this column."]
[null,null,"o Do not report the student in both columns."]
[null,"Obtained a high school diploma","The number of students who earned a high school diploma."]
[null,null,"• What time period to report in: "]
[null,null,"o In Facility: If the student obtained a high school diploma while enrolled in the facility or program, report the student in this column."]
[null,null,"o 90 Days After Exit:  If the student obtained a high school diploma between 1–90 days after exit, report the student in this column."]
[null,null,"o Do not report the student in both columns."]
[]
[null,"Outcomes Potentially Occuring Across the Two Time Periods Definitions and Instructions "]
[null,"Earned high school course credits","The number of students who earned transferable high school course credits."]
[null,null,"•  What time period to report in:"]
[null,null,"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."]
[null,null,"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."]
[null,null,"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."]
[null,"Enrolled in a GED program","The number of students who enrolled in a program or course designed specifically to help students pass the GED."]
[null,null,"• The GED course need not be run by the facility itself for students to be reported under this item."]
[null,null,"• What time period to report in: "]
[null,null,"o In Facility: If a student enrolled in a GED program while in the facility and the student continued 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. "]
[null,null,"o 90 Days After Exit:  If a student enrolled in a GED program only within 90 days after exit, report the student in this column."]
[null,null,"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 once in each column."]
[null,"Accepted/enrolled in postsecondary education","The number of students accepted and/or enrolled in postsecondary programs. Postsecondary education refers 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."]
[null,null,"• The programs/courses need not be run by, and the outcomes need not be awarded by, the facility itself to be counted."]
[null,null,"• What time period to report in: "]
[null,null,"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."]
[null,null,"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."]
[null,null,"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 within 90 days after exit, report the student once in each column."]
[null,"Enrolled in job training courses/programs","The number of students enrolled in vocational/job training programs or courses. The programs or courses should not be part of a 2- or 4-year postsecondary degree program, which should be reported under “Accepted or enrolled into postsecondary education” (above)."]
[null,null,"• The programs or courses may be provided by the facility/program or through an external organization."]
[null,null,"• 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."]
[null,null,"• 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."]
[null,null,"• What time period to report in: "]
[null,null,"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."]
[null,null,"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."]
[null,null,"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, report the student once in each column."]
[null,"Obtained employment","The number of students who received job offers."]
[null,null,"• Employing students within a facility. Students who are employed within the facility during their enrollment should not be counted under “obtained employment in facility.” 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 remains working in the facility or program after their exit date, then they may be included."]
[null,null,"• What time period to report in: "]
[null,null,"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."]
[null,null,"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."]
[null,null,"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."]
[]
[null,"Additional Clarification for  Academic and Vocational Outcome Tables "]
[null,"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."]
[null,"One student achieving multiple outcomes","The same student may be counted as having attained more than one outcome. For example, the same student may have obtained employment and returned to a district school."]
[null,"Actual, not anticipated, outcomes","Counts should reflect actual, not anticipated, outcomes."]
[null,"Multiple student enrollments are allowed","Data for academic and vocational outcomes are not restricted to a student’s most recent enrollment/exit period. All outcomes achieved over multiple enrollment/exit periods during the reporting year should be included."]
[null,"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 diploma)."]
[]
[null,"Definition At-Risk"]
[null,"At-Risk","The term ‘‘at-risk’’, when used with respect to a child, youth, or student, means a school aged individual who is at-risk of academic failure, dependency adjudication, or delinquency adjudication, has a drug or alcohol problem, is pregnant or is a parent, has come into contact with the juvenile justice system or child welfare system in the past, is at least 1 year behind the expected grade level for the age of the individual, is an English learner, is a gang member, has dropped out of school in the past, or has a high absenteeism\nrate at school. "]

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