{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Enabling Macros","Instructions","Contact Info","Programs and Facilities","Students Served","Academic & Vocational Outcomes","Academic Performance","Basic Data Quality Report"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Enabling Macros","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,0,3,2],[0,0,0,2],[1,0,1,2],[9,2,10,2]]}
["CSPR Data Collection Template"]
["For the July 1, 2019 - June 30, 2020 reporting year"]
[]
["In order to use this tool, macros must be enabled. If upon opening this workbook, this is the only tab available on the bottom of your screen, macros are not enabled on your system. To enable macros, please follow the instructions below."]
[]
[]
["Excel 2007 or newer versions of Excel:",null,"Earlier versions of Excel:"]
[]
["There should be a bar at the top of your screen resembling those below:",null,"Click Tools >> Macro >> Security (see below)."]
[null,null,"In the resulting Security dialog box, set the security level to Medium. Close this file and all Excel files you have open. Reopen this file and click Enable Macros when prompted. You should now be able to see additional tabs on the bottom of this document."]
[]
["Click the Options button, select \"Enable this content\", then click OK. Or click the Enable Content button. You should now be able to see additional tabs on the bottom of this document.",null,"When you are done filling out this tool, return the macro security level to its previous setting."]

{"sheet":"Instructions","index":1,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[5,0,5,2],[9,0,9,2],[20,0,20,2],[22,0,22,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[16,0,16,2],[19,0,19,2],[17,0,17,2]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
["Which students should be reported in this template?"]
[]
["Report only students who received Title I, Part D services during the reporting period. Students who did not receive or benefit from Title I, Part D services should not be included."]
[]
["Using this tool:"]
[]
["Fill out the tabs in order. Within each tab, fill out the cells in order, going down each column before proceeding to the next column or tab. Fill out the tables completely, do not leave any cell blank. Providing complete tables will decrease the amount of follow-up necessary."]
["Click the \"Check your data!\" button on each tab when you are done to check for potential data errors."]
["If you make any changes to your data, be sure to click the \"Check your data!\" button again when you are finished, in order to update the display of potential data quality issues. This button should always be clicked before moving to the next tab."]
["Upon closing the template, the workbook will automatically revert back to the \"Enabling Macros\" tab and ask you to save your work. This ensures the workbook will function properly when reopened."]
[]
["Missing data versus Actual Zero Values:"]
[]
["Missing data: If a data element is not collected or is missing, please enter \"Missing\". Do not use zeros to indicate missing data."]
["          For example: A facility is unable to track students after they leave, and therefore cannot report student outcomes after exit. The column marked\n              90 days after exit on the Vocational Outcomes tab should be marked \"Missing\" to indicate the data is not available. A written explanation clarifying \n              why the data are missing must be provided in the Comments field."]
[]
["Actual zero values: If the number of students to be reported for a data element is zero, insert the number zero (0). Do not leave the field blank."]
["          For example: No students obtained their high school diploma while in the facility. The number zero (0) should be inserted to indicate no students \n              attained that academic outcome. Leaving the field blank would indicate the data is missing or unavailable."]
[]
["Please note that, for any data that are missing, incomplete, appear erroneous, or generate a warning, a written explanation of the problem (and any additional data) must be provided in the Comments field on that tab."]

{"sheet":"Contact Info","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[9,1,9,5],[9,6,9,15],[11,1,11,5],[11,6,11,15],[3,1,3,15],[5,1,5,5],[5,6,5,15],[7,1,7,5],[7,6,7,15]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Contact Info"}]
[]
[null,"1) Name of person completing template:"]
[]
[null,"2) Title of person completing template:"]
[]
[null,"3) Email address:"]
[]
[null,"3) Phone number:"]

{"sheet":"Programs and Facilities","index":3,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,2,17,14],[19,3,19,15],[21,12,21,15],[19,1,19,2],[13,2,13,14],[15,1,15,13],[15,14,15,15],[7,14,7,15],[7,1,7,13],[9,2,9,14],[11,1,11,12],[0,0,0,16],[1,0,1,16],[3,1,3,15],[5,1,5,5],[5,6,5,15],[11,13,11,15]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Programs and Facilities"}]
[]
[null,"1) Name of your program or facility:"]
[]
[null,"2) Does your facility run more than one program that receives Title I, Part D funds (i.e., a multipurpose facility)?"]
[]
[null,null,"Multipurpose facility: An institution, program, or facility which serves more than one programming purpose. For example, the same facility may run both a juvenile corrections program and a neglected program.\n\nNOTE: Multipurpose facilities must complete separate templates for each program."]
[]
[null,"3) How is your facility classified by the US Department of Education for the purposes of funding?"]
[]
[null,null,"Adult Corrections: 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.\n\nJuvenile Corrections: An institution for delinquent children and youth is a public or private residential facility other than a foster home that is operated for the care of children and youth who have been adjudicated delinquent or in need of supervision. Include any programs serving adjudicated youth (including non–secure facilities and group homes) in this category.\n\nJuvenile Detention Facilities: Detention facilities are shorter term institutions that provide care to children who require secure custody pending court adjudication, court disposition, or execution of a court order, or care to children after commitment\n\nNeglected Programs: An institution for neglected children and youth is a public or private residential facility, other than a foster home, that is operated primarily for the care of children who have been committed to the institution or voluntarily placed under applicable State law due to abandonment, neglect, or death of their parents or guardians.\n\nAt-Risk Programs: Programs operated (through LEAs) that target students who are at risk of academic failure, have a drug or alcohol problem, are pregnant or parenting, have been in contact with the juvenile justice system in the past, are at least 1 year behind the expected age/grade level, have limited English proficiency, are gang members, have dropped out of school in the past, or have a high absenteeism rate at school.\n\nOther Programs: Any other programs, not defined above, which receive Title I, Part D funds and serve non–adjudicated children and youth. "]
[]
[null,"4) What is the average length of stay (in days) at your facility?"]
[]
[null,null,"Average length of stay: The 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."]
[null,""]
[null,"Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Students Served","index":4,"n_rows":78,"n_cols":17,"rows_kept":78,"cut":false,"hidden":false,"merged":[[73,9,73,13],[73,14,73,15],[69,9,69,13],[69,14,69,15],[70,9,70,13],[70,14,70,15],[71,9,71,13],[71,14,71,15],[66,9,66,13],[66,14,66,15],[67,9,67,13],[67,14,67,15],[68,9,68,13],[68,14,68,15],[72,9,72,13],[72,14,72,15],[63,9,63,13],[63,14,63,15],[64,9,64,13],[64,14,64,15],[65,9,65,13],[65,14,65,15],[60,9,60,13],[60,14,60,15],[61,9,61,13],[61,14,61,15],[62,9,62,13],[62,14,62,15],[37,1,37,8],[58,1,58,8],[58,9,58,13],[58,14,58,15],[59,9,59,13],[59,14,59,15],[0,0,0,16],[1,0,1,16],[3,1,3,15],[19,14,19,15],[43,9,43,13],[43,14,43,15],[11,1,11,13],[11,14,11,15],[13,2,13,14],[15,1,15,13],[15,14,15,15],[5,1,5,15],[20,9,20,13],[7,1,7,13],[7,14,7,15],[9,2,9,14],[27,14,27,15],[26,9,26,13],[75,1,75,2],[75,3,75,15],[77,12,77,15],[17,2,17,14],[52,9,52,13],[50,9,50,13],[51,9,51,13],[22,2,22,14],[24,1,24,8],[24,9,24,13],[24,14,24,15],[20,14,20,15],[19,1,19,8],[19,9,19,13],[33,1,33,8],[33,9,33,13],[33,14,33,15],[25,9,25,13],[25,14,25,15],[31,9,31,13],[31,14,31,15],[30,9,30,13],[30,14,30,15],[27,9,27,13],[26,14,26,15],[29,9,29,13],[29,14,29,15],[28,9,28,13],[28,14,28,15],[34,9,34,13],[34,14,34,15],[35,9,35,13],[35,14,35,15],[38,9,38,13],[38,14,38,15],[39,9,39,13],[39,14,39,15],[40,9,40,13],[40,14,40,15],[37,14,37,15],[37,9,37,13],[54,9,54,13],[45,9,45,13],[46,9,46,13],[47,9,47,13],[56,2,56,14],[52,14,52,15],[53,14,53,15],[54,14,54,15],[41,9,41,13],[41,14,41,15],[42,9,42,13],[42,14,42,15],[53,9,53,13],[48,9,48,13],[49,9,49,13],[44,9,44,13],[44,14,44,15],[45,14,45,15],[46,14,46,15],[47,14,47,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Students Served"}]
[]
[null,"Guidelines:\nIn this section, report the demographic counts of students who were served in Title I, Part D programs and facilities.  Demographics should reflect an unduplicated count of students. The subtotals for each category should be equal to the total number of unduplicated students reported. If all data cannot be included, provide a note in the comments section indicating why some students are not reported within the table."]
[]
[null,"1) Duplicated count"]
[]
[null,null,"Duplicated Count: Reflects the total number of student enrollments (those served in Title I, Part D programs and facilities), counting students more than once if they were admitted multiple times. This count is necessary in order to calculate the statewide average length of stay.\n\nExample: A facility served ten (10) students during the reporting period. Seven (7) students were only admitted to the program once, while the other three (3) students exited and were later re-admitted to the program (within the same reporting year). The duplicated count should be 13, as each of those three (3) students should be counted twice (3 students with 2 enrollments each = 6 separate enrollments)."]
[]
[null,"2) Total unduplicated students served"]
[]
[null,null,"Unduplicated Count: 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."]
[]
[null,"3) Total long-term students served"]
[]
[null,null,"Long-term students: Long-term refers to students who were enrolled for at least 90 consecutive calendar days during the reporting year."]
[]
[null,"4) Student subgroups",null,null,null,null,null,null,null,"4.1) Students with disabilities (IDEA)"]
[null,null,null,null,null,null,null,null,null,"4.2) English learner students"]
[]
[null,null,"Students with disabilities: Children having intellectual disability; hearing impairment, including deafness; speech or language impairment; visual impairment, including blindness; serious emotional disturbance (hereafter referred to as emotional disturbance); orthopedic impairment; autism; traumatic brain injury; developmental delay; other health impairment; specific learning disability; deaf-blindness; or multiple disabilities and who, by reason thereof, receive special education and related services under the Individuals with Disabilities Education Act (IDEA) according to an Individualized Education Program (IEP), Individualized Family Service Plan (IFSP), or a services plan.\n\nEnglish learner students / LEP students: A student (1) who was not born in the United States or whose native languages are languages other than English; or (2) who is a Native American or Alaska Native, or a native resident of the outlying areas, and who comes from an environment where a language other than English has had a significant impact on the individual’s level of English language proficiency; or (3) who is migratory, whose native language is a language other than English, and who come from an environment where a language other than English is dominant. In addition, to be classified as an English learner, that individual must also be a student whose difficulties in speaking, reading, writing, or understanding the English language may be sufficient to deny the individual the ability to meet the challenging State academic standards, the ability to successfully achieve in classrooms where the language of instruction is English, or the opportunity to participate fully in society."]
[]
[null,"5) Race/Ethnicity",null,null,null,null,null,null,null,"5.1) American Indian or Alaska Native"]
[null,null,null,null,null,null,null,null,null,"5.2) Asian"]
[null,null,null,null,null,null,null,null,null,"5.3) Black or African American"]
[null,null,null,null,null,null,null,null,null,"5.4) Hispanic or Latino"]
[null,null,null,null,null,null,null,null,null,"5.5) Native Hawaiian or other Pacific Islander"]
[null,null,null,null,null,null,null,null,null,"5.6) White"]
[null,null,null,null,null,null,null,null,null,"5.7) Two or more races"]
[null,null,null,null,null,null,null,null,null,"Race/Ethnicity subtotal",null,null,null,null,{"$f":"SUM(O25:P31)","v":0}]
[]
[null,"6) Sex",null,null,null,null,null,null,null,"6.1) Male"]
[null,null,null,null,null,null,null,null,null,"6.2) Female"]
[null,null,null,null,null,null,null,null,null,"Sex subtotal",null,null,null,null,{"$f":"SUM(O34:P35)","v":0}]
[]
[null,"7) Age",null,null,null,null,null,null,null,"7.1) 3 through 5"]
[null,null,null,null,null,null,null,null,null,"7.2) 6"]
[null,null,null,null,null,null,null,null,null,"7.3) 7"]
[null,null,null,null,null,null,null,null,null,"7.4) 8"]
[null,null,null,null,null,null,null,null,null,"7.5) 9"]
[null,null,null,null,null,null,null,null,null,"7.6) 10"]
[null,null,null,null,null,null,null,null,null,"7.7) 11"]
[null,null,null,null,null,null,null,null,null,"7.8) 12"]
[null,null,null,null,null,null,null,null,null,"7.9) 13"]
[null,null,null,null,null,null,null,null,null,"7.10) 14"]
[null,null,null,null,null,null,null,null,null,"7.11) 15"]
[null,null,null,null,null,null,null,null,null,"7.12) 16"]
[null,null,null,null,null,null,null,null,null,"7.13) 17"]
[null,null,null,null,null,null,null,null,null,"7.14) 18"]
[null,null,null,null,null,null,null,null,null,"7.15) 19"]
[null,null,null,null,null,null,null,null,null,"7.16) 20"]
[null,null,null,null,null,null,null,null,null,"7.17) 21"]
[null,null,null,null,null,null,null,null,null,"Age subtotal",null,null,null,null,{"$f":"SUM(O38:P54)","v":0}]
[]
[null,null,"Age: Report students in the highest age attained during the reporting year."]
[null,""]
[null,"8) Grade",null,null,null,null,null,null,null,"8.1) Pre-K"]
[null,null,null,null,null,null,null,null,null,"8.2) Kindergarten"]
[null,null,null,null,null,null,null,null,null,"8.3) 1st grade"]
[null,null,null,null,null,null,null,null,null,"8.4) 2nd grade"]
[null,null,null,null,null,null,null,null,null,"8.5) 3rd grade"]
[null,null,null,null,null,null,null,null,null,"8.6) 4th grade"]
[null,null,null,null,null,null,null,null,null,"8.7) 5th grade"]
[null,null,null,null,null,null,null,null,null,"8.8) 6th grade"]
[null,null,null,null,null,null,null,null,null,"8.9) 7th grade"]
[null,null,null,null,null,null,null,null,null,"8.10) 8th grade"]
[null,null,null,null,null,null,null,null,null,"8.11) 9th grade"]
[null,null,null,null,null,null,null,null,null,"8.12) 10th grade"]
[null,null,null,null,null,null,null,null,null,"8.13) 11th grade"]
[null,null,null,null,null,null,null,null,null,"8.14) 12th grade"]
[null,null,null,null,null,null,null,null,null,"8.14) 13th grade +"]
[null,null,null,null,null,null,null,null,null,"Grade subtotal",null,null,null,null,{"$f":"SUM(O59:P73)","v":0}]
[]
[null,"Comments"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]

{"sheet":"Academic & Vocational Outcomes","index":5,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,1,27,2],[27,3,27,15],[29,12,29,15],[8,1,8,13],[8,14,8,15],[10,2,10,14],[13,1,13,11],[16,2,16,14],[12,14,12,15],[12,12,12,13],[14,1,14,11],[13,12,13,13],[13,14,13,15],[14,12,14,13],[14,14,14,15],[18,12,18,13],[0,0,0,16],[1,0,1,16],[3,1,3,15],[5,1,5,15],[7,14,7,15],[18,14,18,15],[19,1,19,11],[19,12,19,13],[19,14,19,15],[23,1,23,11],[23,12,23,13],[23,14,23,15],[25,2,25,14],[22,1,22,11],[22,12,22,13],[22,14,22,15],[20,1,20,11],[20,12,20,13],[20,14,20,15],[21,1,21,11],[21,12,21,13],[21,14,21,15]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Academic & Vocational Outcomes"}]
[]
[null,"Guidelines:\nIn this section, report the number of students who attained academic and vocational outcomes. If your facility is unable to track outcomes after students exit the facility, you must provide an explanation in the comments section.\n \nIn facility: While enrolled in the program or facility.\n \n90 days after exit: Within the 90 calendar days after exiting"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 days after exit"]
[null,"1) Number of students who enrolled in their local district school within 90 days after exit"]
[]
[null,null,"Guidelines: Outcomes a student is able to achieve only after exit. Provide the unduplicated number of students who enrolled, or planned to enroll, in their local school district within 90 calendar days after exiting. A student may be reported only once, per program type."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"In facility",null,"90 days after exit"]
[null,"2) Number of students who earned a GED"]
[null,"3) Number of students who obtained a high school diploma"]
[]
[null,null,"Guidelines: Outcomes a student is able to achieve only one time. Provide the unduplicated number of students who attained the listed outcomes either while enrolled in the program/facility (\"In facility\") or in the 90 calendar days after exiting (\"90 days after exit\"). A student may be reported only once across the two time periods, per program type."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"In facility",null,"90 days after exit"]
[null,"4) Number of students who earned high school course credits"]
[null,"5) Number of students who enrolled in a GED program"]
[null,"6) Number of students who were accepted and/or enrolled into post-secondary education"]
[null,"7) Number of students who enrolled in job training courses/programs"]
[null,"8) Number of students who obtained employment"]
[]
[null,null,"Guidelines: Outcomes a student may achieve more than once. \"In facility\" - provide the unduplicated number of students who attained academic and vocational outcomes while enrolled in the program/facility. \"90 days after exit\" - provide the unduplicated number of students who attained academic and vocational outcomes within 90 calendar days after exiting. If a student attained an outcome once in the program/facility, and once during the 90 day transition period, that student may be reported once in each column."]
[]
[null,"Comments"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Academic Performance","index":6,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,16],[3,1,3,15],[5,1,5,15],[8,1,8,13],[8,14,8,15],[27,12,27,15],[7,1,7,15],[13,1,13,13],[12,14,12,15],[12,1,12,13],[11,14,11,15],[11,1,11,13],[10,14,10,15],[10,1,10,13],[25,1,25,2],[25,3,25,15],[23,8,23,13],[22,14,22,15],[23,14,23,15],[21,14,21,15],[14,8,14,13],[14,14,14,15],[17,14,17,15],[19,14,19,15],[13,14,13,15],[20,14,20,15],[20,1,20,13],[21,1,21,13],[22,1,22,13],[16,1,16,15],[17,1,17,13],[19,1,19,13]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Academic Performance"}]
[]
[null,"Guidelines:\nIn this section, provide the unduplicated number of long-term students served by Title I, Part D, who participated in reading/math pre- and post-testing. Students should be reported in only one of the four change categories.\n\nReport only information on a student's most recent testing data. Student who were pre-tested prior to July 1 of the reporting year may be included if their post-test was administered during the reporting year. Students who were post-tested after the reporting year ended should be counted in the following year."]
[]
[null,"Reading"]
[null,"1) Number of long-term students who took both the pre- and post-test reading exams:"]
[]
[null,"2) Long-term students with negative grade level change from the pre- to post-test exams"]
[null,"3) Long-term students with no change in grade level from the pre- to post-test exams"]
[null,"4) Long-term students with improvement up to one full grade level from the pre- to post-test exams"]
[null,"5) Long-term students with improvement of more than one full grade level from the pre- to post-test exams"]
[null,null,null,null,null,null,null,null,"Subtotal of Lines 2 through 5",null,null,null,null,null,{"$f":"SUM(O11:O14)","v":0}]
[]
[null,"Math"]
[null,"6) Number of long-term students who took both the pre- and post-test math exams:"]
[]
[null,"7) Long-term students with negative grade level change from the pre- to post-test exams"]
[null,"8) Long-term students with no change in grade level from the pre- to post-test exams"]
[null,"9) Long-term students with improvement up to one full grade level from the pre- to post-test exams"]
[null,"10) Long-term students with improvement of more than one full grade level from the pre- to post-test exams"]
[null,null,null,null,null,null,null,null,"Subtotal of Lines 7 through 10",null,null,null,null,null,{"$f":"SUM(O20:O23)","v":0}]
[]
[null,"Comments"]

{"sheet":"Basic Data Quality Report","index":7,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,1,8,13],[8,14,8,15],[0,0,0,16],[1,0,1,16],[3,1,3,15],[5,1,5,15],[7,1,7,15],[9,1,9,13],[9,14,9,15],[10,1,10,13],[10,14,10,15],[11,1,11,13],[11,14,11,15],[19,1,19,13],[19,14,19,15],[12,1,12,13],[12,14,12,15],[13,1,13,13],[13,14,13,15],[14,1,14,13],[14,14,14,15],[15,1,15,13],[15,14,15,15],[17,1,17,15],[18,1,18,13],[18,14,18,15],[27,1,27,13],[27,14,27,15],[20,1,20,13],[20,14,20,15],[21,1,21,13],[21,14,21,15],[22,1,22,13],[22,14,22,15],[23,1,23,13],[23,14,23,15],[24,1,24,13],[24,14,24,15],[26,1,26,15],[28,1,28,13],[28,14,28,15],[29,1,29,13],[29,14,29,15],[30,1,30,13],[30,14,30,15]]}
[{"$f":"'Enabling Macros'!A1:C1","v":"CSPR Data Collection Template"}]
[{"$f":"'Enabling Macros'!A2:C2","v":"For the July 1, 2019 - June 30, 2020 reporting year"}]
[]
[null,{"$f":"MID(CELL(\"filename\",B4),FIND(\"]\",CELL(\"filename\",B4))+1,255)","v":"Basic Data Quality Report"}]
[]
[null,"The purpose of this page is to provide some basic feedback regarding the completeness, consistency, and usability of your CSPR data. The Basic Data Quality Report focuses primarily on data completeness and key calculations regarding student outcomes and academic performance."]
[]
[null,"Students Served"]
[null,"1) Was the duplicated count reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O8>0,\"YES\",\"NO\")","v":"NO"}]
[null,"2) Was the unduplicated count reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O12>0,\"YES\",\"NO\")","v":"NO"}]
[null,"3) Was the number of long-term students reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O16>0,\"YES\",\"NO\")","v":"NO"}]
[null,"4) Was the number of students with disabilities (IDEA) reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Students Served'!O20)>0,IF('Students Served'!O20=\"Missing\",\"NO\",\"YES\"),\"NO\")","v":"NO"}]
[null,"5) Was the number of LEP students reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Students Served'!O21)>0,IF('Students Served'!O21=\"Missing\",\"NO\",\"YES\"),\"NO\")","v":"NO"}]
[null,"6) Is the race/ethnicity subtotal equivalent to the unduplicated count?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O12='Students Served'!O32,\"YES\",\"NO\")","v":"YES"}]
[null,"7) Is the gender subtotal equivalent to the unduplicated count?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O12='Students Served'!O36,\"YES\",\"NO\")","v":"YES"}]
[null,"8) Is the gender subtotal equivalent to the unduplicated count?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Students Served'!O12='Students Served'!O55,\"YES\",\"NO\")","v":"YES"}]
[]
[null,"Academic & Vocational Outcomes"]
[null,"1) Is the number of students earning a GED less than or equal to the number of students age 17 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M14+'Academic & Vocational Outcomes'!O14<=SUM('Students Served'!O50:P54),\"YES\",\"NO\")","v":"YES"}]
[null,"2) Is the number of students obtaining a HS diploma less than or equal to the number of students age 17 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M15+'Academic & Vocational Outcomes'!O15<=SUM('Students Served'!O50:P54),\"YES\",\"NO\")","v":"YES"}]
[null,"3) Is the number of students enrolling in a GED program less than or equal to the number of students age 17 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M21<=SUM('Students Served'!O50:P54),IF('Academic & Vocational Outcomes'!O21<=SUM('Students Served'!O50:P54),\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[null,"4) Is the number of students accepted and/or enrolled into post-secondary education less than or equal to the number of students age 17 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M22<=SUM('Students Served'!O50:P54),IF('Academic & Vocational Outcomes'!O22<=SUM('Students Served'!O50:P54),\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[null,"5) Is the number of students earning high school course credits less than or equal to the number of students age 13 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M20<=SUM('Students Served'!O46:P54),IF('Academic & Vocational Outcomes'!O20<=SUM('Students Served'!O46:P54),\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[null,"6) Is the number of students enrolled in job training courses/programs less than or equal to the number of students age 16 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M23<=SUM('Students Served'!O49:P54),IF('Academic & Vocational Outcomes'!O23<=SUM('Students Served'!O49:P54),\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[null,"7) Is the number of students obtaining employment less than or equal to the number of students age 16 or older?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic & Vocational Outcomes'!M24<=SUM('Students Served'!O49:P54),IF('Academic & Vocational Outcomes'!O24<=SUM('Students Served'!O49:P54),\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[]
[null,"Academic Performance"]
[null,"1) Was the number of long-term students who took both the pre- and post-test reading exams reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Academic Performance'!O9)>0,IF('Academic Performance'!O9=\"Missing\",\"NO\",\"YES\"),\"NO\")","v":"NO"}]
[null,"2) Is the grade level change subtotal for equivalent to the number of students who took both the pre- and post-test reading exams?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic Performance'!O9='Academic Performance'!O15,\"YES\",\"NO\")","v":"YES"}]
[null,"3) Was the number of long-term students who took both the pre- and post-test math exams reported?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Academic Performance'!O18)>0,IF('Academic Performance'!O18=\"Missing\",\"NO\",\"YES\"),\"NO\")","v":"NO"}]
[null,"4) Is the grade level change subtotal for equivalent to the number of students who took both the pre- and post-test math exams?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Academic Performance'!O18='Academic Performance'!O24,\"YES\",\"NO\")","v":"YES"}]