File Descriptions
2025 File Descriptions
2024 File Descriptions
2023 File Descriptions
2022 File Descriptions
2021 File Descriptions
2020 File Descriptions
2019 File Descriptions
2018 File Descriptions
2017 File Descriptions
2016 File Descriptions
2025 File Descriptions
2025_CTE_FOLLOWUP_STDNT_DRAFT_<file date>.xls
2025 CTE Follow-Up Student File
This report contains information about students who are to be included in the 2025 CTE Follow-Up file for the Initial Exiting Student (S) Follow-Up Collection. This file is for districts to use to determine if a CTE Concentrator appeal should be submitted to revise the one (1) CTE Program of Concentration (POC) for a student already listed in the file.
Only the last POC in which the student was a CTE Concentrator is listed. Do not submit an appeal to have additional POCs included in the file.
The report includes the reporting LEA IRN, SSID, CTE Program of Concentration Code, CTE Program of Concentration FY, POC determination, withdrawal reason, diploma date, and ITC short name.
The "POC determination" field indicates whether the POC for the row and reporting FY was a
- District Reported POC or
- ODE Determined POC.
The Department determines the POC when a student is derived as having met CTE Concentrator status in the FY but no POC was reported in the FY by the district.
The CTE Follow-Up list is not static. Student inclusion on this file may be modified based upon current year (FY25) enrollment or if a Withdrawal Reason code that specifically excludes the student is reported.
- Students can move between the CTE Follow-Up lists of LEAs through Oct. 17, 2024.
- Students can be added to an LEA’s CTE Follow-Up list based on FY24 enrollment through Dec. 1, 2024.
- Students can be added or removed to an LEA’s CTE Follow-Up list based on FY25 enrollment through Dec. 20, 2024.
Districts should use this report to review the students who will be included in the 2025 CTE Follow-Up file for their district. Any questions regarding this file should be directed to the district's ITC for submission to the EMIS helpdesk.
2025_RPTCRD_CCWMRdy_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness
This file contains preliminary information related to the College, Career, Workforce, and Military Readiness (CCWM) measure. This measure is based on students in the 4-year graduation cohort only.
The 2025 Report Card will contain data from the 2024 graduation cohort.
The file contains a single tab showing SSID-level information for the following metrics:
- ACT – Yes/No indicator signifying the student’s remediation-free status on all parts of the ACT assessment.
- SAT – Yes/No indicator signifying the student’s remediation-free status on all parts of the SAT assessment.
- ACT_SAT_Met – Yes/No indicator signifying the student was remediation free on either the ACT or the SAT assessment.
- Honors Diploma – Yes/No indicator signifying whether or not the student earned an Honors Diploma.
- Total_ap_3_plus – Total number of AP tests on which the student scored 3 or higher.
- Total_ib_4_plus – Total number of IB tests on which the student scored 4 or higher.
- Met_AP_IB_req – Yes/No indicator signifying whether or not the student earned an AP score of 3 or higher on at least 3 AP tests, an IB score of 4 or higher on at least 3 IB tests, or met the proficiency score (3 on AP/4 on IB) on a combination of at least 3 AP or IB tests.
- Dual_enroll_credits – Total number of dual enrollment credits the student earned through dual enrollment courses.
- College_credits_met – Yes/No indicator signifying the student earned at least 12 college credits.
- Ccp_apprvd – Total number of College Credit Plus credits for the student that have been approved for reimbursement. This field is for informational purposes only.
- Ccp_not_apprvd_pending – Total number of College Credit Plus credits for the student that have either not been approved or are pending approval for reimbursement. This field is for informational purposes only.
- CTAG_eligible_courses (formerly listed as CTAG_credits) – Based upon secondary CTE courses and assessments, the total number of post-secondary courses for which the student may be eligible for transcripted credit upon enrollment in a post-secondary institution. This field is for informational purposes only.
- Credential_12_points – Yes/No indicator signifying the student earned at least 12 points of credentials within a single career field.
- Pre_apprentice_complete – Yes/No indicator signifying the student earned credential CJ99, representing pre-apprenticeship completion.
- OMJ_Seal – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal.
- WBL_250plus – Yes/No indicator signifying the student earned at least 250 hours of a Work Based Learning experience.
- OMJ_WBL – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal and at least 250 hours of a Work Based Learning experience.
- Military Enlist – Yes/No indicator signifying the student has submitted a completed Contract DD Form signifying intent to enlist in the military and reported with program code 520110.
- Post_hs_apprentice – Yes/No indicator signifying the student was reported with program code 305016, acceptance into an apprenticeship post-high school.
- Apprentice_completion – Yes/No indicator signifying the student was reported with program code 305018, completion of apprenticeship.
- Tech_skill_proficiency – Yes/No indicator signifying the student was proficient on at least three technical skill assessments.
- Ccwmr_ready_indicator – Yes/No indicator signifying the student met any of individual measure criteria for inclusion in the numerator of the CCWMR component.
The remaining elements reflect the total number of industry credential points earned by the student in specific career fields. These fields are for informational purposes only.
For technical documentation on the CCWMR Component, please visit https://education.ohio.gov/Topics/Data/Report-Card-Resources/Traditional-Report-Cards and review the "CCWMR Component Technical Documentation". For questions about this report, please contact Letitia Linville.
2024 File Descriptions
2024_CTE_FOLLOWUP_STDNT_DRAFT_<file date>.xls
2024 CTE Follow-Up Student File
This report contains information about students who are to be included in the 2024 CTE Follow-Up file for the Initial Exiting Student (S) Follow-Up Collection. This file is for districts to use to determine if a CTE Concentrator appeal should be submitted to add or remove a student from the 2024 CTE Follow-Up file or to revise the one (1) CTE Program of Concentration (POC) for a student already listed in the file.
Only the last POC in which the student was a CTE Concentrator is listed. Do not submit an appeal to have additional POCs included in the file.
The report includes the reporting LEA IRN, SSID, CTE Program of Concentration Code, CTE Program of Concentration FY, POC determination, withdrawal reason, diploma date, and ITC short name.
The "POC determination" field indicates whether the POC for the row and reporting FY was a
- District Reported POC or
- ODE Determined POC.
The Department determines the POC when a student is derived as having met CTE Concentrator status in the FY but no POC was reported in the FY by the district.
The CTE Follow-Up list is not static. Student inclusion on this file may be modified based upon current year (FY24) enrollment or if a Withdrawal Reason code that specifically excludes the student is reported.
- Students can move between the CTE Follow-Up lists of LEAs through Oct. 07, 2023.
- Students can be added to an LEA’s CTE Follow-Up list based on FY23 enrollment through Dec. 1, 2023.
- Students can be added or removed to an LEA’s CTE Follow-Up list based on FY24 enrollment through Dec. 20, 2023.
Districts should use this report to review the students who will be included in the 2024 CTE Follow-Up file for their district. Any questions regarding this file should be directed to the district's ITC for submission to the EMIS helpdesk.
2024_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2024 CTE Follow-up Credentials Earned
These reports are distributed to the CTPD Member Districts. The report is a student level file that shows all students in the 2024 CTE Follow-up and any Industry-Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential subject code, and credential description.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2024_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure- Report only Industry-Recognized Credential Elements
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD_ANY_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY23 who obtained at least one Industry-Recognized Credential in the district. The report contains the CTPD IRN, CTPD any credential denominator, numerator, and percent as well as the JVSD any credential denominator, numerator, and percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY23 who obtained at least twelve Industry-Recognized Credential points within a career field in the district. The report contains the CTPD IRN, CTPD twelve-point credential denominator, numerator, and percent as well as the JVSD twelve-point credential denominator, numerator, and percent.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2024_CTE_POST_PLACEMENT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 4 tabs:
- CTPD_JVSD_POST_PLACEMENT: provides the data points and percentages for the CTPD and JVSD for the Post-Program Placement measure. The report consists of the CTPD IRN, CTPD placement denominator, numerator, and placement percentage as well as the JVSD placement denominator, numerator, and placement percentage.
- CTPD_STUDENT_LEVEL_POST_PLACE: provides student-level data on which students are included in the post-program placement measure. The report contains the CTPD IRN, Member District IRN, SSID, status known, placement denominator, and placement numerator flags.
- CTPD_POST_PROGRAM_GRADE: a file by CTPD that shows the number of concentrators who left secondary education in FY23 who were reported as placed in the Initial Exiting Student Follow-up Collection. The file contains the CTPD post-program placement denominator, numerator, and rate as well as the CTPD status known denominator, status known numerator and rate, promotions, demotions, component rating, and 3S1 met flag.
- CTPD_POST_PLACEMENT_CATEGORIES: report breaks down the student count and percentage of each placement category (apprenticeship, employment, military, service program, and post-secondary training). Depending on what was reported in the 2024 Initial Exiting Student Follow-up Collection, students may be counted in more than one category. Each percentage is calculated with the ‘post-placement denominator' as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement denominator = apprenticeship percentage). The report consists of CTPD IRN, post-placement denominator, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, service program placed, service program percent, post-secondary placed, and post-secondary percent.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2024_CTE_POST_PROGRAM_DISTRICT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure District Detail
These reports are distributed to CTPD Member Districts. The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: a student-level file that shows status known and placement status for all concentrators who left secondary education in FY23. The data elements included in the file are reporting LEA IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the district. The options in the Post Program Placement are Yes – met the indicator for Post-Program Placement; No – student does not meet indicator.
- DIST_POC_POST_PROGRAM: a file by district and CTE program that shows placement of concentrators who left secondary education in FY23 by program of concentration. This information will be used in the Post-Program Placement measure in the 2024 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information. The file contains reporting LEA IRN, CTE program of concentration, district post-placement denominator, numerator, and placement rate by program of concentration.
- DIST_POST_PROGRAM: a file by district that shows the number of concentrators who left secondary education in FY23 that were reported as placed in the follow-up collection. The file contains reporting LEA IRN, district post-placement denominator, numerator, and district post-program placement rate.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2024_FW_STUDENTS_ADD_<file date>.xls
2024 Followup File Add
This is the Flat File Editor (FFE) file for the 2024 Exiting Student (S) Follow-Up Collection. This file corresponds to students added since the original (FLUP-001) Exiting Student Follow Up Extract (All Students) was generated.
This file includes all students who have been added to the original file and must be reported. To be included in this file, students must have exited education in the prior year and fall into one or more of the following categories: career-tech concentrators (CTE), graduates (GRAD), and students with disabilities (SWD). This file indicates which category or categories the students fall into and which district or districts are responsible for reporting the information.
The report also includes the following fields:
- FW_FLATFILE_UPLOAD: combined field of all fields as listed in the file layout at the end of EMIS Manual Section 2.23,
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: report destination IRN.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2024_FW_STUDENTS_DROP_<file date>.xls
2024 Followup File Drop
This is for districts utilizing the Flat File Editor (FFE) file for the FY24 Exiting Student (S) Follow-Up Collection. This file corresponds to (FLUP-001) Exiting Student Follow Up Extract (All Students), Result Code = ‘FP0004’, a Level 2 report.
This file includes all students who have been removed from the file and should not be included in the Exiting Student Follow-Up reporting. The file includes rows that have been generated since the last time the 2024_FW_STUDENTS_DROP file was distributed.
The report also includes the following fields:
- RPT_DEST_IRN: reporting district IRN,
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: the report destination IRN.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2024_FW_STUDENTS_ORIG_<file date>.xls
2024 Followup File
This is the Flat File Editor (FFE) file for the 2024 Exiting Student (S) Follow-Up Collection. This file corresponds to (FLUP-001) Exiting Student Follow Up Extract (All Students), a Level 2 report.
This file includes all students for whom the Exiting Student Follow-Up (FW) Record (see EMIS Manual Section 2.23) must be reported. To be included in this file, students must have exited education in the prior year and fall into one or more of the following categories: career-tech concentrators (CTE), graduates (GRAD), and students with disabilities (SWD). This file indicates which category or categories the students fall into and which district or districts are responsible for reporting the information.
The report also includes the following fields:
- FW_FLATFILE_UPLOAD: combined field of all fields as listed in the file layout at the end of EMIS Manual Section 2.23),
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: report destination IRN.
This follow-up list is not static; it could change based upon current year (FY24) enrollment or the reporting of a Withdrawal Reason Code that specifically excludes the student from follow-up reporting.
- Students can be added to an LEA’s follow-up file based on FY24 enrollment through Dec. 1, 2023.
- Students can be removed from an LEA’s follow-up file based on FY24 enrollment data through Dec. 20, 2023.
Where there is an approved FY23 CTE Concentrator appeal to revise a student’s CTE Program of Concentration, the FFE files will not reflect the approved revised CTE Program of Concentration until the Initial Exiting Student Follow-Up Collection closes. The CTE Program of Concentration has no bearing on what data is being collected or reported to EMIS in the Exiting Student Follow-Up Collection.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2024_PRIN_ESSA_Licensure_Assurances_<file date>.pdf
ESSA State Licensure Assurances Report
This report assists districts and schools as they work to meet the new federal educator qualification requirements in the Every Student Succeeds Act (ESSA). ESSA requires schools and programs receiving Title I funds to ensure that all teachers and paraprofessionals working in a program supported with these funds meet “applicable State certification and licensure requirements” (ESSA 1112(c)(6)). This Assurances report reflects the State certification and licensure determination for each core academic course. It is based on the EMIS Teacher Licensure Course Status Report that districts received throughout the FY24 Initial Staff and Course (L) Collection.
For questions about this report and its purpose, please contact propercert@education.ohio.gov. For technical questions about EMIS reporting, please contact your EMIS Coordinator.
2024_RPTCRD_CCWMRdy_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness
This file contains preliminary information related to the College, Career, Workforce, and Military Readiness (CCWM) measure. This measure is based on students in the 4-year graduation cohort only.
The 2024 Report Card will contain data from the 2023 graduation cohort.
The file contains a single tab showing SSID-level information for the following metrics:
- ACT – Yes/No indicator signifying the student’s remediation-free status on all parts of the ACT assessment.
- SAT – Yes/No indicator signifying the student’s remediation-free status on all parts of the SAT assessment.
- ACT_SAT_Met – Yes/No indicator signifying the student was remediation free on either the ACT or the SAT assessment.
- Honors Diploma – Yes/No indicator signifying whether or not the student earned an Honors Diploma.
- Total_ap_3_plus – Total number of AP tests on which the student scored 3 or higher.
- Total_ib_4_plus – Total number of IB tests on which the student scored 4 or higher.
- Met_AP_IB_req – Yes/No indicator signifying whether or not the student earned an AP score of 3 or higher on at least 3 AP tests, an IB score of 4 or higher on at least 3 IB tests, or met the proficiency score (3 on AP/4 on IB) on a combination of at least 3 AP or IB tests.
- Dual_enroll_credits – Total number of dual enrollment credits the student earned through dual enrollment courses.
- College_credits_met – Yes/No indicator signifying the student earned at least 12 college credits.
- Ccp_apprvd – Total number of College Credit Plus credits for the student that have been approved for reimbursement. This field is for informational purposes only.
- Ccp_not_apprvd_pending – Total number of College Credit Plus credits for the student that have either not been approved or are pending approval for reimbursement. This field is for informational purposes only.
- CTAG_eligible_courses (formerly listed as CTAG_credits) – Based upon secondary CTE courses and assessments, the total number of post-secondary courses for which the student may be eligible for transcripted credit upon enrollment in a post-secondary institution. This field is for informational purposes only.
- Credential_12_points – Yes/No indicator signifying the student earned at least 12 points of credentials within a single career field.
- Pre_apprentice_complete – Yes/No indicator signifying the student earned credential CJ99, representing pre-apprenticeship completion.
- OMJ_Seal – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal.
- WBL_250plus – Yes/No indicator signifying the student earned at least 250 hours of a Work Based Learning experience.
- OMJ_WBL – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal and at least 250 hours of a Work Based Learning experience.
- Military Enlist – Yes/No indicator signifying the student has submitted a completed Contract DD Form signifying intent to enlist in the military and reported with program code 520110.
- Post_hs_apprentice – Yes/No indicator signifying the student was reported with program code 305016, acceptance into an apprenticeship post-high school.
- Apprentice_completion – Yes/No indicator signifying the student was reported with program code 305018, completion of apprenticeship.
- Tech_skill_proficiency – Yes/No indicator signifying the student was proficient on at least three technical skill assessments.
- Ccwmr_ready_indicator – Yes/No indicator signifying the student met any of individual measure criteria for inclusion in the numerator of the CCWMR component.
The remaining elements reflect the total number of industry credential points earned by the student in specific career fields. These fields are for informational purposes only.
For questions about this report, please contact Letitia Linville.
2024_RPTCRD_CCWMRdy_RPTONLY_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness Report-Only
This file contains preliminary information related to the College, Career, Workforce, and Military Readiness (CCWM) report-only elements. These new measures are based on data collected for graduates within the Exiting Student Follow-Up Collection.
The file contains two tabs. The first tab, “SSID’, displays student-level information for each metric. The second tab, “Aggregate”, shows aggregate percentages for each CCWM report-only metric.
SSID Tab
- employed_count – This column contains a 1/0 indicator where 1 indicates the student was reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently any student reported as employed is counted.
- military_rptonly_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enlisted in the military.
- apprentice_count – This column contains a 1/0 indicator where 1 indicates the student was reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_stdnt_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a 4-year post-secondary institution.
- oh_tech_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a post-secondary institution other than a 2/4 year or OTC.
Aggregate Tab
- ccwm_rptonly_denom – This column is the denominator used in the calculation of all percentages and reflects the number of students reported as graduates in the 2022-2023 school year.
- employed_count – This column represents the number of students reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently any student reported as employed is counted.
- military_rptonly_count – This column represents the number of students reported as enlisted in the military.
- apprentice_count – This column represents the number of students who were reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_stdnt_count – This column represents the number of students who were reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_count – This column represents the number of students who were reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_count – This column represents the number of students who were reported as enrolled in a 4-year post-secondary institution.
- oh_tech_enroll_count – This column represents the number of students who were reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_count – This column represents the number of students who were reported as enrolled in a post-secondary institution other than a 2/4 year or OTC.
- employed_pct – This column represents the percent of students reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently any student reported as employed is counted.
- military_rptonly_pct – This column represents the percent of students reported as enlisted in the military.
- apprentice_pct – This column represents the percent of students who were reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_pct – This column represents the percent of students who were reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_pct – This column represents the percent of students who were reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_pct - This column represents the percent of students who were reported as enrolled in a 2-year post-secondary institution.
- oh_tech_enroll_pct – This column represents the percent of students who were reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_pct - This column represents the number of students who were reported as enrolled in a post-secondary institution other than a 2/4 year or OTC.
For questions about this report, please contact
Letitia Linville.
2024_RPTCRD_PBIS_Compliance_Measure _<file date>.xls
Positive Behavior Intervention Support (PBIS) Implementation Stage Compliance Measure
This file is distributed to public districts, community schools, and STEM schools. The workbook consists of 2 tabs.
- LEA_DETAIL:
- Get a “YES" flag if all schools have a reported E or F code. New schools (new IRNs for 2023-2024 school year) must have a C, D, E, or F code. A school open for two school years (new IRNs for 2022-2023 school year) must have D, E, or F reported in EMIS.
- Get a "NO" flag if any school has an A, B, C, or D reported unless they are a new school (new IRN for 2023-2024 school year), a school open for two school years (new IRNs for 2022-2023 school year), or if any school had no code reported for this element.
- ORG_DETAIL or CS_DETAIL:
- Get a "YES" flag if it has a code of E or F unless it is a new school (new IRN for 2023-2024 school year) or a school open for two school years (new IRNs for 2022-2023 school year).
- Get a "NO" flag if it has a code of A, B, C, or D unless it is a new school (new IRN for 2023-2024 school year), a school open for two school years (new IRNs for 2022-2023 school year), or if no record is reported in EMIS.
For questions about this report, contact Adam Schiming (
Adam.Schiming@education.ohio.gov).
2024_RPTCRD_SummerG3Vendor_<file date>.xls
Report Card Summer G3 Vendor File ELA and Reading Subscore Results
This file contains Summer Grade 3 ELA and Reading Subscore results from the vendor file for districts to use in data verification. The following fields are included:
- School Year
- RPTING_LEA_IRN – This field is taken directly from the vendor file and represents the attending district IRN of the student.
- SSID – Only students with vendor file results that are listed as “Attempted” will appear in this file.
- ASESMNT_TYPE_CODE – This field is populated with GN and corresponds to the Ohio’s State Tests assessment type typically submitted on the Student Assessment (FA) Record.
- GRADE_LEVEL_CODE – This field represents the grade level of the test (03).
- ASESMNT_SUBJCT_CODE – This field is populated with ELA for the summer G3 ELA assessment score and R for the summer G3 reading subscore.
- TEST_TAKEN_DATE – This date was defaulted to May 31, 2024.
- REQ_TEST_TYPE_CODE – STR – This represents the standard version of the assessment.
- STDNT_GRADE_LEVEL_CODE
- TEST_ACMDTN_CODE – Defaulted to "**" (no accommodations) for all students.
- SCORE_REASON_CODE – This field is populated with "*" or "I". The "*" represents no score not reported reason code. The "I" represents assessments listed as Invalidated in the vendor file.
- TEST_SCORE
- PROF_SCORE_LEVEL_DESCR – The proficiency level corresponding to the assessment score. All 3rd grade reading subscore results are listed as Unavailable.
For questions about this report, please contact
Letitia Linville.
2024_STUDENT_ESCHOOL_1YEAR_SSIDs_<file date>.xls
Eschool Missing Tests Per Ohio Revised Code Section 3314.26
This file provides details about eschool students with missing tests from the 2024 school year. The 1-Year results from 2024 will be combined with the 1-Year results from 2023 to create the 2023-2024 2-Year eSchool Missing Test list.
Each school’s file contains up to two tabs based on the grade levels and graduation cohorts served by the school during the 2024 school year. Schools with any students missing grades 3 through 8 tests will have the tab MISSED_ANY_ES_SSIDS. Students in the class of 2018 and later, taking EOC courses, and having any missed tests will receive the tab MISSED_ANY_EOC_NEW_PATH_SSIDS. Please note that while each school will only receive information about its own enrolled students from the 2024 school year, on occasion test data are submitted by another entity.
The MISSED_ANY_ES_SSIDS tab contains the columns SSID, IRN, and GRADE_LEVEL (2024). The remaining columns indicate the specific test grade and subjects that were missed (NO), taken (YES), or not applicable in 2024 (NA).
The MISSED_ANY_EOC_NEW_PATH_SSIDS tab includes SSID, IRN, GRADE_LEVEL_LY (2023, pertinent to retained 11th graders), GRADE_LEVEL (2024), and HS_TEST_PATH_NEW (EOC_6 indicates ELA 1 test is not required, EOC_7 indicates all seven EOC tests are required). The remaining columns indicate the specific tests that were missed (NO), taken (YES), or not applicable in 2024 (NA).
For questions about this report, please contact Karlyn Geis (
Karlyn.Geis@education.ohio.gov).
2024_STUDENT_Fall_Early_Learning_Population_11_6_2023
2024 Student Fall Early Learning Population
This report is provided for districts to identify students required to have Early Learning Assessment that have not been reported or have very few scores reported in the vendor system (KReady) as of 10/12/2023.
This list contains students reported for both the traditional/Full ELA and the new Pilot ELA. Preschool students are included that were reported to EMIS as of 11/6/2023 with an enrollment date on or before 10/12/2023, to align with the vendor file date. This report is a static list and will not be updated to reflect changes in enrollment or reporting.
Individuals assigned as Data Mangers in the KReady system for each district can generate an on-demand, up-to-date SKB Ratings Report to monitor assessment completion. Data Managers are identified in OEDS with the role Assessment Data Manager for Preschool and Kindergarten. Instructions about how to run the SKB Ratings Report are available on the KReady Help Desk website.
For questions about this report or your district's ELA submission, please contact ELAHelp@education.ohio.gov.
2023 File Descriptions
2023 Follow-Up Student Files
2023_CTE_FOLLOWUP_STDNT_DRAFT_<file date>.xls
2023 CTE Follow-Up Student File
This report contains information about students who are to be included in the 2023 CTE Follow-Up file for the Initial Exiting Student (S) Follow-Up Collection. This file is for districts to use to determine if a CTE Concentrator appeal should be submitted to add or remove a student from the 2023 CTE Follow-Up file or to revise the one (1) CTE Program of Concentration (POC) for a student already listed in the file.
Only the last POC in which the student was a CTE Concentrator is listed. Do not submit an appeal to have additional POCs included in the file.
The report includes the CTPD IRN, reporting LEA IRN, SSID, CTE Program of Concentration Code, CTE Program of Concentration FY, POC determination, withdrawal reason, diploma date, and ITC short name.
The "POC determination" field indicates whether the POC for the row and reporting FY was a
- District Reported POC or
- ODE Determined POC.
The Department determines the POC when a student is derived as having met CTE Concentrator status in the FY but no POC was reported in the FY by the district.
The CTE Follow-Up list is not static. Student inclusion on this file may be modified based upon current year (FY23) enrollment or if a Withdrawal Reason code that specifically excludes the student is reported.
- Students can move between the CTE Follow-Up lists of LEAs through Oct. 18, 2022.
- Students can be added to an LEA’s CTE Follow-Up list based on FY23 enrollment through Dec. 1, 2022.
- Students can be removed from an LEA’s CTE Follow-Up list based upon FY23 enrollment data through Dec. 27, 2022.
Districts should use this report to review the students who will be included in the 2023 CTE Follow-Up file for their district. Any questions regarding this file should be directed to the district's ITC for submission to the EMIS helpdesk.
2023_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure- Report only Industry-Recognized Credential Elements
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD_ANY_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY22 who obtained at least one Industry-Recognized Credential in the district. The report contains the CTPD IRN, CTPD any credential denominator, numerator, and percent as well as the JVSD any credential denominator, numerator and percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY22 who obtained at least twelve Industry-Recognized Credential points within a career field in the district. The report contains the CTPD IRN, CTPD twelve-point credential denominator, numerator and percent as well as the JVSD twelve-point credential denominator, numerator and percent.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2023_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2023 CTE Follow-Up Credentials Earned
These reports are distributed to the CTPD Member Districts. The report is a student level file that shows all students in the 2023 CTE Follow-up and any Industry-Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential subject code and credential description.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2023_CTE_POST_PLACEMENT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 4 tabs:
- CTPD_JVSD_POST_PLACEMENT: provides the data points and percentages for the CTPD and JVSD for the Post-Program Placement measure. The report consists of the CTPD IRN, CTPD placement denominator, numerator and placement percentage as well as the JVSD placement denominator, numerator and placement percentage.
- CTPD_STUDENT_LEVEL_POST_PLACE: provides student-level data on which students are included in the post-program placement measure. The report contains the CTPD IRN, Member District IRN, SSID, status known, placement denominator and placement numerator flags.
- CTPD_POST_PROGRAM_GRADE: is a file by CTPD that shows the number of concentrators who left secondary education in FY22 who were reported as placed in the Initial Exiting Student Follow-up collection. The file contains the CTPD post-program placement denominator, numerator and rate as well as CTPD status known denominator, status known numerator and rate, promotions, demotions and 3S1 met flag.
- CTPD_POST_PLACEMENT_CATEGORIES: report breaks down the student count and percentage of each placement category (apprenticeship, employment, military, service program and post-secondary training). Depending on what was reported in the 2023 Initial Exiting Student Collection, students may be counted in more than one category. Each percentage is calculated with the ‘post-placement denominator as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement denominator = apprenticeship percentage). The report consists of CTPD IRN, post-placement denominator, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, service program placed, service program percent, post-secondary placed, post-secondary percent.
2023_CTE_POST_PROGRAM_DISTRICT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure District Detail
These reports are distributed to CTPD Member Districts. The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: report is a student-level file that shows status known and placement status for all concentrators who left secondary education in FY22. The data elements included in the file are reporting LEA IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District. The options in the Post Program Placement are Yes – met the indicator for Post-Program Placement; No – student does not meet indicator.
- DIST_POC_POST_PROGRAM: report is a file by district and CTE program that shows placement of concentrators who left secondary education in FY22 by program of concentration. This information will be used in the Post-Program Placement measure in the 2023 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information. The file contains reporting LEA IRN, CTE program of concentration, district post-placement denominator, numerator, and placement rate by program of concentration.
DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY22 that were reported as placed in the follow-up collection. The file contains reporting LEA IRN, district post-placement denominator, numerator, and district post-program placement rate.
2023_FW_STUDENTS_ADD_<file date>.xls
2023 Followup File Add
This is the Flat File Editor (FFE) file for the 2023 Exiting Student (S) Follow-Up Collection. This file corresponds to (FLUP-001) Exiting Student Follow Up Extract (All Students), Result Code = ‘FP0003’, a Level 2 report.
This file includes all students who have been added to the original file and must be reported. To be included in this file, students must have exited education in the prior year and fall into one or more of the following categories: career-tech concentrators (CTE), graduates (GRAD), and students with disabilities (SWD). This file indicates which category or categories the students fall into and which district or districts are responsible for reporting the information.
The report also includes the following fields:
- FW_FLATFILE_UPLOAD: combined field of all fields as listed in the file layout at the end of EMIS Manual Section 2.23,
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: report destination IRN.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2023_FW_STUDENTS_DROP_<file date>.xls
2023 Followup File Drop
This is for districts utilizing the Flat File Editor (FFE) file for the 2023 Exiting Student (S) Follow-Up Collection. This file corresponds to (FLUP-001) Exiting Student Follow Up Extract (All Students), Result Code = ‘FP0004’, a Level 2 report.
This file includes all students who have been removed from the file and should not be included in the Exiting Student Follow-Up reporting.
The report also includes the following fields:
- RPT_DEST_IRN: reporting district IRN,
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: the report destination IRN.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2023_FW_STUDENTS_ORIG_<file date>.xls
2023 Followup File
This is the Flat File Editor (FFE) file for the 2023 Exiting Student (S) Follow-Up Collection. This file corresponds to (FLUP-001) Exiting Student Follow Up Extract (All Students), a Level 2 report.
This file includes all students for whom the Exiting Student Follow-Up (FW) Record (see EMIS Manual Section 2.23) must be reported. To be included in this file, students must have exited education in the prior year and fall into one or more of the following categories: career-tech concentrators (CTE), graduates (GRAD), and students with disabilities (SWD). This file indicates which category or categories the students fall into and which district or districts are responsible for reporting the information.
The report also includes the following fields:
- FW_FLATFILE_UPLOAD: combined field of all fields as listed in the file layout at the end of EMIS Manual Section 2.23),
- SSID: student’s statewide student identifier,
- FIRST_NAME: student’s first name,
- MIDDLE_NAME: student’s middle name,
- LAST_NAME: student’s last name, and
- IRN: report destination IRN.
This follow-up list is not static; it could change based upon current year (FY23) enrollment or the reporting of a Withdrawal Reason Code that specifically excludes the student from follow-up reporting.
- Students can be added to an LEA’s follow-up file based on FY23 enrollment through Dec. 1, 2022.
- Students can be removed from an LEA’s follow-up file based on FY23 enrollment data through Dec. 27, 2022.
Any questions regarding this file should be directed to the district's ITC. If the ITC cannot assist, they will submit the question to the EMIS helpdesk.
2023_GRAD_Diploma_Poss_Credit_Coding_Errors_<file date>.xls
2023 Diploma Students with Possible Credit Coding Errors File
The COURSE_REQ_FLAG that was recently added to the Graduation Cohort reports has raised some questions around how this flag is being determined by the Department. Keep in mind that the COURSE_REQ_FLAG does not impact whether a student is counted as a graduate (the Department only looks at the diploma date for this purpose). However, if ‘N’ is displayed for this flag, even though you have determined locally that the student has met course requirements, it may indicate that some credits reported on the Student Graduation – Core Summary (GC) Record have been miscoded for the 2023 graduates and these coding errors may also be present for future graduates.
This report displays a row for each student reported as having earned a diploma in FY23 who appears to have not met all course requirements for graduation based on credits reported on the Student Graduation - Core Summary (GC) Record. The purpose of this report is to help districts identify areas where the subject area for credit may not be coded correctly, resulting in the COURSE_REQ_FLAG being set to ‘N’.
For each SSID, the following columns are displayed on the report.
Column Name |
Column Description |
ENGLSH_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 4 credits of English |
MATH_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 4 credits of Mathematics, including 1 credit of Algebra 2 or equivalent |
SOC_STUD_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 3 credits of Social Studies, including 1/2 credit each of American History, American Government, and World History & Civilizations |
SCI_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 3 credits of science, including 1 credit of physical science, 1 credit of life science, and 1 credit of advanced study |
HEALTH_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 1/2 credit of Health Education |
PHYS_ED_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 1/2 credit of Physical Education or was exempt from the Physical Education graduation requirement |
ELECTV_REQ_MET_FLAG |
Flag indicating whether the student was reported with at least 5 credits in subject areas that are eligible to be included in the elective count (all subject areas for credit except for ‘ELE’, ‘HTH’, or ‘PHE’) |
CREDIT_FOR_GRADUATION_COUNT |
The total number of credits reported on the GC Record that could potentially count towards graduation course requirements (all subject areas for credit except for ‘ELE’) |
ELE_CREDIT_COUNT |
The total number of credits reported with Subject Area for Credit Code = 'ELE'. These credits do not count towards the elective course requirement. |
2023_PRIN_ESSA_Licensure_Assurances_<file date>.pdf
ESSA State Licensure Assurances Report
This report assists districts and schools as they work to meet the new federal educator qualification requirements in the Every Student Succeeds Act (ESSA). ESSA requires schools and programs receiving Title I funds to ensure that all teachers and paraprofessionals working in a program supported with these funds meet “applicable State certification and licensure requirements” (ESSA 1112(c)(6)). This Assurances report reflects the State certification and licensure determination for each core academic course. It is based on the EMIS Teacher Licensure Course Status Report that districts received throughout the FY23 Initial Staff and Course (L) Collection.
For questions about this report and its purpose, please contact propercert@education.ohio.gov. For technical questions about EMIS reporting, please contact your EMIS Coordinator.
2023_RPTCRD_CCWMRdy_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness
This file contains preliminary information related to the College, Career, Workforce, and Military Readiness (CCWM) measure that replaced the Prepared for Success measure beginning with the 2022 report card. The new measure is based on students in the 4-year graduation cohort only.
The file contains a single tab showing SSID-level information for the following metrics.
- ACT – Yes/No indicator signifying the student’s remediation-free status on all parts of the ACT assessment.
- SAT – Yes/No indicator signifying the student’s remediation-free status on all parts of the SAT assessment.
- Honors Diploma – Yes/No indicator signifying whether or not the student earned an Honors Diploma.
- Total_ap_3_plus – Total number of AP tests on which the student scored 3 or higher.
- Total_ib_4_plus – Total number of IB tests on which the student scored 4 or higher.
- Met_AP_IB_req – Yes/No indicator signifying whether or not the student earned an AP score of 3 or higher on at least 3 AP tests, an IB score of 4 or higher on at least 3 IB tests, or met the proficiency score (3 on AP/4 on IB) on a combination of at least 3 AP or IB tests.
- Dual_enroll_credits – Total number of dual enrollment credits the student earned through dual enrollment courses.
- Ccp_apprvd – Total number of College Credit Plus credits for the student that have been approved for reimbursement.
- Ccp_not_apprvd_pending – Total number of College Credit Plus credits for the student that have either not been approved or are pending approval for reimbursement.
- CTAG_eligible_courses (formerly listed as CTAG_credits) – Based upon secondary CTE courses and assessments, the total number of post-secondary courses for which the student may be eligible for transcripted credit upon enrollment in a post-secondary institution.
- Credential_12_points – Yes/No indicator signifying the student earned at least 12 points of credentials within a single career field.
- Pre_apprentice_complete – Yes/No indicator signifying the student earned credential CJ99, representing pre-apprenticeship completion.
- OMJ_Seal – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal.
- WBL_250plus – Yes/No indicator signifying the student earned at least 250 hours of a Work Based Learning experience.
- OMJ_WBL – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal and at least 250 hours of a Work Based Learning experience.
- Military Enlistment – Yes/No indicator signifying the student has submitted a completed Contract DD Form signifying intent to enlist in the military.
The remaining elements reflect the total number of industry credential points earned by the student in specific career fields.
Please note that decisions related to the data included in this preliminary file are ongoing and subject to approval by the State Board of Education. The Department will provide updates to data elements and calculation decisions as they are determined in the upcoming months.
For questions about this report, please contact Letitia Linville.
2023_RPTCRD_CCWMRdy_RPTONLY_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness Report-Only
This file contains preliminary information related to the College, Career, Workforce, and Military Readiness (CCWM) report-only elements. These new measures are based on data collected for graduates within the Exiting Student Follow-Up Collection. They will be published for the first time on the 2023 Report Card.
The file contains two tabs. The first tab, "Aggregate", shows aggregate percentages for each CCWM report-only metric. The second tab, "SSID", displays student-level information for each metric.
Aggregate Tab
- ccwm_rptonly_denom – This column is the denominator used in the calculation of all percentages and reflects the number of students reported as graduates in the 2021-2022 school year.
- employed_count – This column represents the number of students reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently, any student reported as employed is counted.
- military_rptonly_count – This column represents the number of students reported as enlisted in the military.
- apprentice_count – This column represents the number of students who were reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_stdnt_count – This column represents the number of students who were reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_count – This column represents the number of students who were reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_count – This column represents the number of students who were reported as enrolled in a 4-year post-secondary institution.
- oh_tech_enroll_count – This column represents the number of students who were reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_count – This column represents the number of students who were reported as enrolled in a post-secondary institution other than a 2- or 4-year or an OTC.
- employed_pct – This column represents the percent of students reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently any student reported as employed is counted.
- military_rptonly_pct – This column represents the percent of students reported as enlisted in the military.
- apprentice_pct – This column represents the percent of students who were reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_pct – This column represents the percent of students who were reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_pct – This column represents the percent of students who were reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_pct – This column represents the percent of students who were reported as enrolled in a 4-year post-secondary institution.
- oh_tech_enroll_pct – This column represents the percent of students who were reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_pct – This column represents the number of students who were reported as enrolled in a post-secondary institution other than a 2- or 4-year or an OTC.
SSID Tab
- employed_count – This column contains a 1/0 indicator where 1 indicates the student was reported as employed. *Note: The Department is continuing to develop business rules for gainful employment. Currently any student reported as employed is counted.
- military_rptonly_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enlisted in the military.
- apprentice_count – This column contains a 1/0 indicator where 1 indicates the student was reported as entering into an apprenticeship or other job training program.
- ccwm_enrl_stdnt_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a post-secondary institution.
- two_year_ihe_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a 2-year post-secondary institution.
- four_year_ihe_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a 4-year post-secondary institution.
- oh_tech_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in an Ohio Technical Center (OTC).
- other_enroll_count – This column contains a 1/0 indicator where 1 indicates the student was reported as enrolled in a post-secondary institution other than a 2- or 4-year or an OTC.
For questions about this report, please contact
Letitia Linville.
2023_RPTCRD_SummerG3Vendor_<file date>.xls
Report Card Summer G3 Vendor File ELA and Reading Subscore Results
This file contains Summer Grade 3 ELA and Reading Subscore results from the vendor file for districts to use in data verification. The following fields are included:
- School Year
- RPTING_LEA_IRN – This field is taken directly from the vendor file and represents the attending district IRN of the student.
- SSID – Only students with vendor file results that are listed as “Attempted” will appear in this file.
- ASESMNT_TYPE_CODE – This field is populated with GN and corresponds to the Ohio’s State Tests assessment type typically submitted on the Student Assessment (FA) Record.
- GRADE_LEVEL_CODE – This field represents the grade level of the test (03).
- ASESMNT_SUBJCT_CODE – This field is populated with ELA for the summer G3 ELA assessment score and R for the summer G3 reading subscore.
- TEST_TAKEN_DATE – This date was defaulted to May 31, 2023.
- REQ_TEST_TYPE_CODE – STR – This represents the standard version of the assessment.
- STDNT_GRADE_LEVEL_CODE
- TEST_ACMDTN_CODE – Defaulted to "**" (no accommodations) for all students.
- SCORE_REASON_CODE – This field is populated with "*" or "I". The "*" represents no score not reported reason code. The "I" represents assessments listed as Invalidated in the vendor file.
- TEST_SCORE
- PROF_SCORE_LEVEL_DESCR – The proficiency level corresponding to the assessment score. All 3rd grade reading subscore results are listed as Unavailable.
For questions about this report, please contact
Brad Hauser.
2023_STAFF_Princ_Composites_for2024_Evals_<file date>
Principal Composite reports for use in 2024 Principal Evaluations
The Principal Composite Reports provide local education agencies with the employment data for principals and assistant principals that were used to create the principal value-added measure. The reports include one year composite scores and one year building scores based on value-added measures from the one or more buildings where the principals and assistant principals served in these roles during the 2022-2023 school year. The Ohio Evaluation System (OhioES) now indicates whether the principal and assistant principal have a value-added composite on the HQSD Verification form. Download and share the Principal Composite files with Superintendents or their designees who complete evaluations for principals and assistant principals. Visit the Principal Evaluations page for more information.
2023_STUDENT_ESCHOOL_1YEAR_SSIDs_<file date>.xls
Eschool Missing Tests Per Ohio Revised Code Section 3314.26
This file provides details about eschool students with missing tests from the 2023 school year. The 1-Year results from 2023 will be combined with the 1-Year results from 2022 to create the 2022-2023 2-Year eSchool Missing Test list.
Each school’s file contains up to two tabs based on the grade levels and graduation cohorts served by the school during the 2023 school year. Schools with any students missing grades 3 through 8 tests will have the tab MISSED_ANY_ES_SSIDS. Students in the class of 2018 and later, taking EOC courses, and having any missed tests will receive the tab MISSED_ANY_EOC_NEW_PATH_SSIDS. Please note that while each school will only receive information about its own enrolled students from the 2023 school year, on occasion test data are submitted by another entity.
The MISSED_ANY_ES_SSIDS tab contains the columns SSID, IRN, and GRADE_LEVEL (2023). The remaining columns indicate the specific test grade and subjects that were missed (NO), taken (YES), or not applicable in 2024 (NA).
The MISSED_ANY_EOC_NEW_PATH_SSIDS tab includes SSID, IRN, GRADE_LEVEL_LY (2022, pertinent to retained 11th graders), GRADE_LEVEL (2023), and HS_TEST_PATH_NEW (EOC_6 indicates ELA 1 test is not required, EOC_7 indicates all seven EOC tests are required). The remaining columns indicate the specific tests that were missed (NO), taken (YES), or not applicable in 2023 (NA).
For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2023_STUDENT_in_Elective_Courses_<file date>.xls
2023 - Students in Elective Courses File
This report displays the count of students in each Local Classroom Code reported in FY23 with Subject Area for Credit = ‘ELE’ and High School Credit > 0. The purpose of this report is to help districts identify courses that could potentially be reported with a more specific subject area for credit.
2023_STUDENT_Possible_SWH_Coding_Errors_<file date>.csv
2023 Students with Possible Coding Errors related to World History and Civilizations File
Core Area Code ‘SWH’ (Social Studies - World History and Civilizations) was added as a new option on the Student Graduation–Core Summary (GC) Record in FY22. It was also added as a new Subject Area for Credit option on the Course Master (CN) Record in FY23. To meet Ohio’s graduation requirements, students must earn ½ credit of World History and Civilizations.
This report displays a row for each sophomore and junior in FY23 who was not reported with at least ½ ‘SWH’ credit on the Student Graduation–Core Summary (GC) Record but took at least one course (as reported on Course Master (CN) Record) from FY20 to FY23 with Subject Code ‘150890’ and a Subject Area for Credit Code other than ‘SWH’. The purpose of this report is to identify any students who appear to be meeting the World History and Civilizations requirement but are not being coded correctly with the ‘SWH’ Subject Area for Credit Code (on the CN Record) and the ‘SWH’ Core Area code on the GC Record. The expectation is that for continuing students in FY24, these coding errors will be corrected.
2023_STUDENT_PRELIM_2YR_SSID_MISS__<file date>.xls
Preliminary Eschool Two-Year Missing Test List
This file contains one tab, PRELIM_2YEAR_SSID_MISSED23. The tab lists the SSIDs that missed one or more required tests in both FY22 and FY23. The sheet includes IRN23, SSID_23, IRN22, and SSID22. SSIDS are only included where both the FY22 and FY23 SSIDS, and the FY22 and FY23 IRNs, match. For questions about this report, please contact Karlyn Geis (karlyn.geis@education.ohio.gov).
2023_STUDENT_SCA_Coding_Errors_<file date>.xls
2023 Students in Courses Miscoded as SCA File
Subject Area for Credit code ‘SCA’ was not supposed to be reported on the Course Master (CN) Record for courses reported after the 2021-2022 school year.
This report displays each Local Classroom Code reported on the CN Record in FY23 with Subject Area for Credit Code = ‘SCA’, along with the number of students enrolled in those courses. The purpose of this report is to help districts identify courses that were miscoded in FY23 with Subject Area for Credit Code ‘SCA’ so that they can report these courses correctly in FY24.
2023_SWD_FOLLOWUP_STDNT_DRAFT_<file date>.xls
2023 Students With Disabilities Follow-Up Student File
This report contains information about students who are to be included in the 2023 Students With Disabilities Follow-Up Student file for the Initial Exiting Student (S) Follow-Up Collection. This file provides districts with a list of students who met the following criteria in the prior fiscal year:
- Students who left secondary education and
- Are age 14-21 with a reported disability condition on their last day of enrollment.
The report includes the following fields:
- SWD_INCLUSION_IRN – the district responsible for reporting SWD Follow-Up data,
- SSID,
- RPTING_LEA_IRN – the student’s educating district,
- DISAB_CNDTN_CODE – the student’s reported Disability Condition Code,
- BIRTH_DATE – the student’s date of birth,
- WTHD_REASON_CODE – the student’s Withdrawal Reason Code, and
- ITC Short Name.
The Department determined the SWD Inclusion IRN by assigning the LEA responsible for providing FAPE for the student as the legal district of residence. For students who were enrolled in a community school or an independent STEM school, the community school or STEM school were determined to be legally responsible for providing FAPE for the student.
The SWD Follow-Up list is not static. Student inclusion on this file may be modified based upon current year (FY23) enrollment or the reporting of a Withdrawal Reason Code that specifically excludes the student.
- Students can be added to an LEA’s SWD Follow-Up list based on FY23 enrollment through Dec. 1, 2022.
- Students can be removed from an LEA’s SWD Follow-Up list based on FY23 enrollment data through Dec. 27, 2022.
Districts should use this report to review the students who will be included in the 2023 SWD Follow-Up file for their district. Any questions regarding this file should be directed to the district's ITC for submission to the EMIS helpdesk.
2022 File Descriptions
20XX_CCP_ID_HS_NP_NO_MATCH_<file date>.xls
FY20XX CCP Homeschooled and Nonpublic IDs With No Match
This report contains information about CCP Homeschooled and Nonpublic IDs that have been reported by colleges, but they do not have a matching student application. The report includes the college IRN and name, student CCP ID, program period, the number of credit hours reported by college. Colleges should check the student award letters to ensure that the correct CCP IDs were reported. The data with correct CCP ID should be re-reported to CCP HEI portal.
For questions about this file, contact CCP@education.ohio.gov.
2022_CTE_CTPD_4S1_NONTRAD_PROGRAM_ENROLL_<file date>.xls
2022 CTPD 4S1: Non-Traditional Program Enrollment Federal Performance Indicator
This report is distributed to CTPD lead districts. The workbook consists of two tabs and contains the data that will be used in the calculation of the Perkins 4S1 Non-Traditional Program Enrollment indicator. The measure is based upon students who were CTE concentrators in a pathway with a non-traditional designation during the 2021-2022 school year.
The report consists of two tabs:
- The CTPD_JVSD_NONTRAD_RATE tab provides preliminary CTPD and JVSD Non-traditional Program Enrollment calculations including the numerator, denominator, and rate.
- The CTPD_SSID_DETAIL tab contains SSID-level detail for the CTPD Non-traditional Program Enrollment indicator.
For questions about this file, please contact Kelsey Stephens.
2022_CTE_CTPD_TECHNICAL_SKILL_GRADE_<file date>.xls
2022 CTPD Technical Skill Attainment Measure
This report is only distributed to the CTPD Lead Districts. The workbook consists of two tabs and contains the preliminary data used in the calculation of the Technical Skill Attainment measure for the 2021-2022 CTPD Report Card.
- The CTPD_TECHNICAL_SKILL_PARTIC tab provides the preliminary CTPD-level technical skill participation calculations including numerator, denominator, and rate.
- The CTPD_TECHNICAL_SKILL_ATTAIN tab provides the preliminary CTPD and JVSD-level technical skill attainment calculations including numerator, denominator, rate, preliminary and final letter grade after any applicable demotions.
For questions about this report, please contact Kelsey Stephens.
2022_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure- Report only Industry-Recognized Credential Elements
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD_ANY_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY21 who obtained at least one Industry-Recognized Credential in the district. The report contains the CTPD IRN, CTPD any credential denominator, numerator, and percent as well as the JVSD any credential denominator, numerator and percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY21 who obtained at least twelve Industry-Recognized Credential points within a career field in the district. The report contains the CTPD IRN, CTPD twelve-point credential denominator, numerator and percent as well as the JVSD twelve-point credential denominator, numerator and percent.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2022_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2022 CTE Follow-up Credentials Earned
These reports are distributed to the CTPD Member Districts. The report is a student level file that shows all students in the 2022 March D file and any Industry-Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential subject code and credential description.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2022_CTE_LEA_TECH_SKILL_PROGRAM<file date>.xls
2022 CTE Program Technical Skill Attainment
This report is distributed to districts with students who were concentrators in a CTE program with aligned technical assessments during the 2021-2022 school year. The report contains the CTE program level calculations of Technical Skill Attainment that will appear in the 2022 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information.
The report consists of four tabs:
- The LEA_POC_TECH_SKILL_PARTIC tab contains the CTE program level calculations of the Technical Skill Participation rate.
- The LEA_POC_TECH_SKILL_PARTIC_DETAIL tab contains SSID level detail for program Technical Skill Participation rates.
- The LEA_POC_TECH_SKILL_PASS tab contains CTE program level calculations of the Technical Skill Passage rate.
- The LEA_POC_TECH_SKILL_PASS_DETAIL tab contains SSID level detail for program Technical Skill Passage rates.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2022D_CTE_MARCHD_CONCNTRT_<file date>.xls
2022 MarchD CTE Concentrator File
This report contains information about students who are to be included in the 2022D0000 (CTE MarchD) file. This file is for districts to use in determining if a CTE Concentrator appeal should be submitted to add or remove a student from the 2022D0000 file or add a CTE Program of Concentration for a student already listed in the file.
All CTE Programs of Concentration (POC) are listed in which the student was a CTE Concentrator. If a student had a POC in a district other than the reporting LEA, it will also be listed for that student. There is no need to submit an appeal to have a POC that was not reported by the reporting LEA removed from the file. The report includes the CTPD IRN, reporting LEA IRN, SSID, reporting FY, CTE program of concentration code, POC determination, and ITC short name.
The "POC determination" field indicates whether the POC for the row and reporting FY was a
- District Reported POC or
- Department Determined POC.
The Department determines the POC when a student is derived as having met CTE Concentrator status in the FY but no POC was reported in the FY by the district.
Districts should use this report to review the students who will be included in the 2022D0000 CTE Follow-Up file for their district. Any questions regarding this file should have an EMIS Helpdesk ticket submitted.
2022_GRAD_Cohort-EOC-Asmnt-Detail_<file date>.xls
2022 Graduating Cohort End of Course Assessment Details
This file contains the highest score and graduation points earned for each End of Course assessment area. The EMIS reporting code for each assessment area is included in the column headers. The assessment date and required test type of the highest score found are listed as well. Students included are those in the 2022 LEA graduation cohort as of current 2021-2022 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Additionally, prior ALT assessments are not included. Only actual assessment scores reported to ODE are included. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2021-2022 school year, they will be added to the report.
This report does not reflect graduation requirements for the Class of 2023 and beyond. Information related to those graduation requirements will be included in ODDEX in the coming months.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2022_GRAD_Cohort-EOC-Path-Req-Stat_<file date>.xls
2022 Graduating Cohort End of Course Pathway Requirements Status
Students in this file match the students in the Detail file. This file includes the highest number of graduation points earned for each assessment area between actual assessments taken and assessment substitutes and exemptions. If no points have been earned in an assessment area, the column will be blank. In addition, each student is evaluated against the total grad points required in Math, ELA, and Social Studies/Science, as well as against the required number of total points across all subjects. Finally, a yes/no field indicates if each of these requirements has been met, and if the student has met all the assessment requirements to graduate using the End of Course pathway. Please note: if a student is reported with out-of-state or homeschool transfer credit, then all points columns will be blank. It is up to the district to keep track of the prorated points for these students and to determine if End of Course Pathway graduation requirements have been met.
This report does not reflect graduation requirements for the Class of 2023 and beyond. Information related to those graduation requirements will be included in ODDEX in the coming months.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2022_GRAD_Cohort-Non-EOC-Pts-Detail_<file date>.xls
2022 Graduating Cohort End of Course Points from Substitutes and Exemptions
This file contains the highest score and graduation points earned for each End of Course assessment area where a substitute assessment or exemption has been submitted for a student. The EMIS reporting code for each assessment area is included in the column headers. Substitutions could include AP, IB, College Credit Plus, non-public transfers, and high school credit earned in a course before the End of Course assessment was available or during the 2019-2020 and 2020-2021 school years as a result of the March 2020 ordered school building closure and passing of state legislation due to COVID-19 allowing graduation requirement flexibility during the 2019-2020 and 2020-2021 school years. Not all substitutes apply to all assessment areas. Students included are those in the 2022 LEA graduation cohort as of current 2021-2022 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Only actual assessment scores reported to ODE are included; reported course credit alone would not cause points to be earned towards graduation. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2021-2022 school year, they will be added to the report.
In addition to assessment information, students with disabilities who have been exempted from the consequences of an End of Course graduation exam (FE exemption reported) are given three graduation points for each area of exemption. As additional FE exemptions are reported during the 2021-2022 school year in the student enrollment collection, they will be added to the report.
Based on the highest number of graduation points earned via a substitute assessment or special education exemption, the max alternate graduation points for each assessment area are listed.
This report does not reflect graduation requirements for the Class of 2023 and beyond. Information related to those graduation requirements will be included in ODDEX in the coming months.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2022_GRAD_Cohort_SAT-ACT_Path_Req_stat_<file date>.xls
2022 Graduating Cohort ACT/SAT Pathway Details
This file contains the highest score earned for each student across all reported administrations of the ACT and/or SAT. Students included are those in the 2022 LEA graduation cohort as of current 2021-2022 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned for either test. Each student is evaluated against remediation free scores in Reading, Math, and English for the ACT, and Reading, Math, and Writing for the SAT. Finally, a yes/no field indicates if the remediation free requirement on at least one of the two tests has been met.
This report does not reflect graduation requirements for the Class of 2023 and beyond. Information related to those graduation requirements will be included in ODDEX in the coming months.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2022_GRAD_Cohort_WK-IndCred_Path_Req_stat_<file date>.xls
2022 Graduating Cohort Workkeys/Industry Credentials Pathway Details
This file contains the highest score from the Workkeys assessment, as well as information on all industry credentials earned by a student. Students included are those in the 2022 LEA graduation cohort as of current 2021-2022 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned or no credential obtained. Each student is evaluated against remediation free scores on the Workkeys exam and against a 12 point standard in a single career field for industry credentials. Finally, a yes/no field indicates if the Workkeys and Credentials requirements have been met.
This report does not reflect graduation requirements for the Class of 2023 and beyond. Information related to those graduation requirements will be included in ODDEX in the coming months.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2022_RPTCRD_CCWMRdy_<file date>.xls
Report Card College, Career, Workforce, and Military Readiness
This file contains preliminary information related to the new College, Career, Workforce, and Military Readiness (CCWM) measure that will replace the Prepared for Success measure beginning with the 2022 report card. The new measure is based on students in the 4-year graduation cohort only.
The file contains a single tab showing SSID-level information for the following metrics.
- ACT – Yes/No indicator signifying the student’s remediation-free status on all parts of the ACT assessment.
- SAT – Yes/No indicator signifying the student’s remediation-free status on all parts of the SAT assessment.
- ACT_SAT_Met – Yes/No indicator signifying the student met remediation-free status on all parts of either the ACT or the SAT assessment.
- Honors Diploma – Yes/No indicator signifying whether or not the student earned an Honors Diploma.
- Total_ap_3_plus – Total number of AP tests on which the student scored 3 or higher.
- Total_ib_4_plus – Total number of IB tests on which the student scored 4 or higher.
- Met_AP_IB_req – Yes/No indicator signifying whether or not the student earned an AP score of 3 or higher on at least 3 AP tests, an IB score of 4 or higher on at least 3 IB tests, or met the proficiency score (3 on AP/4 on IB) on a combination of at least 3 AP or IB tests.
- Dual_enroll_credits – Total number of dual enrollment credits the student earned through dual enrollment courses.
- Ccp_apprvd – Total number of College Credit Plus credits for the student that have been approved for reimbursement.
- Ccp_not_apprvd_pending – Total number of College Credit Plus credits for the student that have either not been approved or are pending approval for reimbursement.
- CTAG_eligible_courses (formerly listed as CTAG_credits) – Based upon secondary CTE courses and assessments, the total number of post-secondary courses for which the student may be eligible for transcripted credit upon enrollment in a post-secondary institution.
- Credential_12_points – Yes/No indicator signifying the student earned at least 12 points of credentials within a single career field.
- Pre_apprentice_complete – Yes/No indicator signifying the student earned credential CJ99, representing pre-apprenticeship completion.
- OMJ_Seal – Yes/No indicator signifying the student earned an Ohio Means Jobs Readiness Seal.
- WBL_250plus – Yes/No indicator signifying the student earned at least 250 hours of a Work Based Learning experience.
The remaining elements reflect the total number of industry credential points earned by the student in specific career fields.
Please note that decisions related to the data included in this preliminary file are ongoing and subject to approval by the State Board of Education. The Department will provide updates to data elements and calculation decisions as they are determined in the upcoming months.
For questions about this report, please contact Letitia Linville.
2022_RPTCRD_DPR_ENROLL_AGE_VERIFICATION_SSIDs_<file date>.xls
Dropout Prevention and Recovery Report Card Enrollment Age Verification Information
This file will be provided periodically throughout the reporting window. It contains two tabs, Calculation and SSID_Details.
- The Calculation tab contains the columns ORG_IRN, ORG_NAME, COUNT_AGE_MET (numerator), HEADCOUNT (denominator), PERCENT_AGE_MET (Calculation), and AGE_CRITERIA_MET. A “Yes” in the AGE_CRITERIA_MET column indicates that the school enrolled over 50 percent of students in the applicable age range of 16 to 21.
- The SSID_Details tab contains the columns ORG_IRN, ORG_NAME, SSID, BIRTH_DATE, and AGE_CRITERIA_MET. A “Yes” in the AGE_CRITERIA_MET column indicates the student is included in the numerator and a “No” indicates the student is not included in the numerator.
For questions about this report, please contact Karlyn Geis (
Karlyn.Geis@education.ohio.gov)
.
2022_RPTCRD_DPR_STAR_SUBMITTED _<file date>.xls
STAR Assessment Records Submitted Information
This file supplements the STAR Missing List and provides score reason, test date, and score for each STAR test record that has been received by EMIS. The file will be provided periodically throughout the reporting window to schools having reported at least one STAR assessment record to EMIS. It contains one tab, STAR_SUBMITTED.
The STAR_SUBMITTED tab contains, at a minimum, the columns IRN, SSID, Fall_Star_Read_Score_Reason1, Fall_Star_Read_TestDate1, Fall_Star_Read_Score1, Fall_Star_Read_Score_Reason2, Fall_Star_Read_TestDate2, Fall_Star_Read_Score2, SPRING_Star_Read_Score_Reason1, SPRING_Star_Read_TestDate1, SPRING_Star_Read_Score1, SPRING_Star_Read_Score_Reason2, SPRING_Star_Read_TestDate2, SPRING_Star_Read_Score2, Fall_Star_Math_Score_Reason1, Fall_Star_Math_TestDate1, Fall_Star_Math_Score1, Fall_Star_Math_Score_Reason2, Fall_Star_Math_TestDate2, Fall_Star_Math_Score2, Spring_Star_Math_Score_Reason1, Spring_Star_Math_TestDate1, Spring_Star_Math_Score1, Spring_Star_Math_Score_Reason2, Spring_Star_Math_TestDate2, and Spring_Star_Math_Score2. Columns will be added if at least one school has submitted more than two reading or math records having dates falling within a single testing window.
For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2022_RPTCRD_EL_Progress_Measure_File_<file date>.xls
2022_RPTCRD_EL_Progress_Measure_File
This file contains two tabs for public districts (LEA_DETAIL and SCH_DETAIL) and one tab for STEM schools and community schools (SCH_DETAIL). The LEA_DETAIL and SCH_DETAIL tabs contain SSID-level data that includes the following.
- SCHOOL_YEAR,
- SSID,
- BASELINE_GRADE_LEVEL: the student’s grade level when baseline was established,
- BASELINE_SCORE: the student’s baseline OELPA score,
- EL_EXMPT_COUNT: the student’s total number of exemptions,
- IMPRV_PTS_NUMBER: the number of improvement points needed for the student to meet the Growth Target,
- EL_PROF_COUNT: whether or not the student scored a proficient score on the OELPA, and
- EL_GROWTH_COUNT: whether or not the student met the growth target.
For questions about this report, contact Adam Schiming (Adam.Schiming@education.ohio.gov).
2022_RPTCRD_Fall_G3ELA_Vendor_File_18-22_<file date>.xlsx
Fall 2018, 2019, 2020 and 2021 Third Grade English Language Arts Test Data from Cambium Assessment, Inc.
This is a one-time file being sent to districts as a courtesy showing pre- and post-pandemic statewide and district level student performance data on the fall administration of the third grade English language arts state test that will soon be posted on the Ohio Department of Education’s “Data Insights” webpage. The data were compiled using the fall 2018, fall 2019, fall 2020, and fall 2021 test files from Ohio’s vendor, Cambium Assessment, Inc., versus using data submitted in EMIS. Superintendents received a separate email communication about this file, and it should be forwarded to your superintendent when received.
The file contains two tabs, STATE and DISTRICT. The STATE tab contains the columns Administration (year the fall ELA test was administered), Total Tests (denominator), Advanced (percent of students scoring Advanced on the administration), Accelerated (percent of students scoring Accelerated on the administration), Proficient (percent of students scoring Proficient on the administration), Basic (percent of students scoring Basic on the administration), Limited (percent of students scoring Limited on the administration), and Proficient-Above (percent of students scoring Proficient or higher on the administration). The DISTRICT tab contains the same columns for each of the four most recent years’ fall administrations (fall 2018, fall 2019, fall 2020, and fall2021) as well as columns to note District IRN, District Name, and County. For questions about this report, please contact research@education.ohio.gov.
2022_RPTCRD_PBIS_Compliance_Measure _<file date>.xls
Positive Behavior Intervention Support (PBIS) Implementation Stage Compliance Measure
This file is distributed to public districts, community schools, and STEM schools. The workbook consists of 2 tabs:
- LEA_DETAIL:
- Get a “YES" flag if all schools have a reported D, E, or F code. New schools (new IRNs for 2021-2022 school year) must have a C, D, E, or F code.
- Get a "NO" flag if any school has an A, B, or C reported unless they are a new school (new IRN for 2021-2022 school year) or if any school had no code reported for this element.
- ORG_DETAIL or CS_DETAIL:
- Get a "YES" flag if it has a code of D, E, or F unless it is a new school (new IRN for 2021-2022 school year).
- Get a "NO" flag if it has a code of A, B, or C unless it is a new school (new IRN for 2021-2022 school year) or if no record is reported in EMIS.
For questions about this report, contact Adam Schiming (Adam.Schiming@education.ohio.gov).
2022_RPTCRD_SummerG3Vendor_<file date>.csv
Report Card Summer G3 Vendor File ELA and Reading Subscore Results
This file contains Summer Grade 3 ELA and Reading Subscore results from the vendor file for districts to use in data verification. The following fields are included:
- School Year
- RPTING_LEA_IRN – This field is taken directly from the vendor file and represents the attending district IRN of the student.
- SSID – Only students with vendor file results that are listed as “Attempted” will appear in this file.
- ASESMNT_TYPE_CODE – This field is populated with GN and corresponds to the Ohio’s State Tests assessment type typically submitted on the Student Assessment (FA) Record.
- GRADE_LEVEL_CODE – This field represents the grade level of the test (03).
- ASESMNT_SUBJCT_CODE – This field is populated with ELA for the summer G3 ELA assessment score and R for the summer G3 reading subscore.
- TEST_TAKEN_DATE – This field is defaulted to May 31, 2022.
- REQ_TEST_TYPE_CODE – STR – representing the standard version of the assessment.
- STDNT_GRADE_LEVEL_CODE
- TEST_ACMDTN_CODE – This field is defaulted to ‘**’ (no accommodations) for all students.
- SCORE_REASON_CODE – This field is populated with ‘*’ or ‘I’. The ‘*’ represents no score not reported reason code. The ‘I’ represents assessments listed as Invalidated in the vendor file.
- TEST_SCORE
- PROF_SCORE_LEVEL_DESCR – The proficiency level corresponding to the assessment score. All 3rd grade reading subscore results are listed as Unavailable.
- ACNTBL_MSR_DESCR – A description indicating whether the 3rd grade ELA score is the highest score reported across Fall/Spring/Summer administrations and will be used in Accountability measures.
2021 File Descriptions
2021_CCP_HS_NP_FY16_FY20_Refund_Report_<file date>.xls
FY 2016 – FY 2020 CCP Homeschooled and Nonpublic Refunds Due to ODE
This report contains information about CCP Homeschooled and Nonpublic Refunds that colleges owe back to ODE. The report includes the program period, student CCP ID (there are multiple lines for each student), Refund ID, college IRN and name, refund due to ODE, program. Listed below are the possible reasons for the refunds due:
For questions about this file, contact CCP@education.ohio.gov.
2021_CCP_RESOLVED_ESCALATION_REPORT_<file date>.xls
FY2016 – FY2020 CCP Escalated Records that have been Resolved
This report contains information about CCP courses that have been escalated and are now resolved. The report includes the SSID, course ID, section ID, year, term, delivery method, credit hour count, and LEA IRN associated with the escalated record.
Also included on the report is an escalated status column that is populated with one of the following values indicating how the escalation was resolved:
Colleges should use this report to verify that escalated records have been resolved.
2021_CCP_PROJECTED_PAYMENT_<file date>.xls
2021 CCP Projected Payment Report
This report contains information about CCP courses that have been approved for payment. The report includes course information reported by the college such as the course ID, course name, section ID, year, term, delivery method, credit hour code, and credit hour count. The report also includes the rate at which the course will be paid, the projected payment amount, and a rate explanation describing why the course is being paid at a particular rate. The types of courses displayed on the report include the following:
Colleges should use these reports to verify that the correct credit hours are reported and that that the expected rate is being applied. The reports can also be used by colleges to estimate what their payment will be. Keep in mind that the report is cumulative. It includes courses that have already been paid as well as courses that have not yet been paid but which are now eligible for payment.
2021_CTE_4YR_GRAD_COHORT_WORK_BASED_LEARN_<file date>.xlsx
Preliminary Work-Based Learning Hours for the 2021 CTE 4YR Graduation Cohort
This report is distributed to CTPD member districts. The workbook contains preliminary work-based learning hours reported for each student in the 2021 CTE 4yr graduation cohort who will count towards the federal 5S3 Work-Based Learning Performance Indicator and three work-based learning elements that count towards the state Career & Post-Secondary Readiness component. These measures impact the 2022 CTPD report cards and 2022 CTE District Quality Program Reviews.
The report contains SSID-level detail for work-based learning indicators, including student program of concentration, the maximum work-based learning hours grouping reported for the federal 5S3 Work-Based Learning Indicator, federal work-based learning indicator met flag, and the student program codes reported for the work-based learning, internship completion, and apprenticeship and pre-apprenticeship elements in the state Career & Post-Secondary Readiness component.
This report is not reflective of all elements included in the Career & Post-Secondary Readiness measure. For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2021_CTE_COURSE_GRADE_SUBSTITUTION_REMOVALS_<file date>.xlsx
2020-2021 School Year Ineligible CTE Course Grade Substitutions
The workbook contains a list of ineligible student course grades records reported as CTE technical assessment (GY) substitutions from the 2020-2021 school year that will be removed from the calculation of the student’s summative CTE technical assessment scores. The report is only distributed to impacted LEAs.
As outlined in House Bill 67, Section 9, course grade substitutions for end-of-course assessments were available only for students who were juniors or seniors during the 2020-2021 school year. In accordance with this, course grade substitutions that are determined to be ineligible will be removed from the calculation of CTE summative assessment scores. Student assessment records that meet the following conditions will be removed from the student’s summative technical assessment score:
If an ineligible course grade substitution and a record for an assessment taken for the same assessment were reported for a student, the score of the assessment taken will be included in the student’s summative score.
To ensure the ineligible course grade substitutions are not reported in a later collection, LEAs should remove the records identified in the report from their SIS.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2021_CTE_CTPD_4S1_NONTRAD_PROGRAM_ENROLL_<file date>.xls
2021 CTPD 4S1: Non-Traditional Program Enrollment Federal Performance Indicator
This report is distributed to CTPD lead districts. The workbook consists of two tabs and contains the data used in the calculation of the Perkins 4S1 Non-Traditional Program Enrollment indicator. The measure is based upon students who were CTE concentrators during the 2020-2021 school year.
The report consists of two tabs:
For questions about this file, please contact Kelsey Stephens.
2021_CTE_CTPD_5S3_WORK_BASED_LEARN_<file date>.xls
2021 CTPD 5S3: Work-Based Learning Federal Performance Indicator
This report is distributed to CTPD lead districts. The workbook consists of two tabs and contains the data used in the calculation of the Perkins 5S3 Work-Based Learning Participation indicator. The measure is based upon the 2020 4yr graduation cohort, and the numerator includes all students reported as having accumulated 250 or more hours in a qualified work-based learning experience using Program Codes (GQ060) 310499 or 310500 in the Student Program Record.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_CTPD_TECHNICAL_SKILL_GRADE_<file date>.xls
2021 CTPD Technical Skill Attainment Measure
This report is only distributed to the CTPD Lead Districts. The workbook consists of two tabs and contains the preliminary data used in the calculation of the Technical Skill Attainment measure for the 2020-2021 CTPD Report Card.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_CURRENT_YEAR_CONCENTRATORS_<file date>.xls
2021 Current Year Career Technical Education (CTE) Concentrator List for Career Technical Planning Districts (CTPD) and Member District Accountability
These reports are distributed to the CTPD Member Districts. 2021_CTE_CURRENT_YEAR_CONCENTRATORS contains a list of CTE Concentrators who will be used in current year accountability calculations, including Technical Skill Attainment, Performance Index, and Non-Traditional Program Enrollment. These students will also appear in the Technical Skill Attainment data on the 2021 District Quality Program Reviews.
The report contains LEA IRN, SSID, CTE Program of Concentration, and an indicator identifying if the CTE Program of Concentration was reported by the district or derived and chosen by the Department.
A student can be derived as a CTE concentrator in more than one program of concentration in a district based upon the workforce development courses that they have completed. When a student is derived as a CTE concentrator and no program of concentration is reported by the district, the Department will choose the program of concentration in which the student will count for accountability purposes. When only one program of concentration is derived, and none are reported, that program will be used for accountability purposes. The hierarchy for choosing the program of concentration to be used for accountability purposes is as follows:
- When only one program of concentration is derived, that program of concentration will be chosen.
- When more than one program of concentration is derived, the Department will choose the program of concentration among those derived for the student:
- The program that was reported for the student by the district in the prior year. If none of the derived programs were reported, then;
- The program that was reported for the student by any district in the prior year. If none of the derived programs were reported, then;
- The program in which student has the greatest number of aligned courses. If the student has the same number of aligned courses across the programs, then;
- The program in which the student has taken the greatest number of aligned CTE Technical Assessments (GY). If the student has taken the same number of CTE Technical Assessments across the derived programs, then;
- The program that comes first when sorted alphabetically.
If a district believes a student is missing, they should reference the CTAC-103: CTE Concentrator Accountability FY POC Unexpected report. If a district believes a student should not count as a current year concentrator or should not count in the program of concentration listed, they should reference the CTAC-102: CTE Concentrator Accountability FY POC Missing report. Questions regarding the CTAC reports should be submitted through the EMIS Helpdesk.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_GRAD_COHORT_CTPD_5S3_WORK_BASED_LEARN_<file date>.xls
2021 CTPD CTE 4yr Grad Cohort 5S3: Work-Based Learning Federal Performance Indicator
This report is distributed to CTPD lead districts. The workbook consists of two tabs and contains the data used in the calculation of the Perkins 5S3 Work-Based Learning Participation indicator. The measure is based upon graduates from the 2021 CTE 4yr graduation cohort, and the numerator includes all graduates reported as having accumulated 250 or more hours in a qualified work-based learning experience using Program Codes (GQ060) 310499 or 310500 in the Student Program Record.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_GRAD_COHORT_LEA_5S3_WORK_BASED_LEARN_<file date>.xls
2021 LEA CTE 4yr Grad Cohort 5S3: Work-Based Learning Federal Performance Indicator
This report is distributed to CTPD member districts. The workbook consists of three tabs and contains the data used in the calculation of the Perkins 5S3 Work-Based Learning Participation indicator and the CTE Quality Program Reviews. The measure is based upon graduates from the 2021 CTE 4yr graduation cohort, and the numerator includes all graduates reported as having accumulated 250 or more hours in a qualified work-based learning experience using Program Codes (GQ060) 310499 or 310500 in the Student Program Record.
For questions about this file, please contact Kelsey Stephens.
2021_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2020 March D Follow-Up Concentrator Credentials Earned
These reports are distributed to the CTPD Member Districts. The 2020D_CTE_INDUSTRY_CREDENTIALS is a student level file that shows all students in the 2021 March D file and any Industry-Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential code and credential description.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure- Report only Industry-Recognized Credential Elements
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
-
CTPD_ANY_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY20 who obtained at least one Industry-Recognized Credential in the district. The report contains the CTPD IRN, CTPD any credential denominator, numerator and percent as well as the JVSD any credential denominator, numerator and percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY20 who obtained at least twelve Industry-Recognized Credential points within a career field in the district. The report contains the CTPD IRN, CTPD twelve point credential denominator, numerator and percent as well as the JVSD twelve point credential denominator, numerator and percent.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_LEA_5S3_WORK_BASED_LEARN_<file date>.xls
2021 LEA 5S3: Work-Based Learning Federal Performance Indicator
This report is distributed to CTPD member districts. The workbook consists of two tabs and contains the data used in the calculation of the Perkins 5S3 Work-Based Learning Participation indicator. The measure is based upon the 2020 4yr graduation cohort, and the numerator includes all students reported as having accumulated 250 or more hours in a qualified work-based learning experience using Program Codes (GQ060) 310499 or 310500 in the Student Program Record.
For questions about this file, please contact Kelsey Stephens.
2021_CTE_LEA_POC_5S3_WORK_BASED_LEARN_<file date>.xls
2021 LEA CTE Pathway Work-Based Learning Indicator for CTE Quality Program Reviews
This report is distributed to CTPD member districts. The workbook consists of two tabs and contains the data used in the calculation of the Work-Based Learning Participation indicator that will appear on the 2021 CTE Quality Program Reviews. The measure is based upon the 2020 4yr CTE graduation cohort. The numerator includes all students reported as having accumulated 250 or more hours in a qualified work-based learning experience.
-
The LEA_POC_WBL_RATE tab provides the district CTE pathway-level work-based learning participation calculations including the CTE pathway, numerator, denominator, and rate.
- The LEA_POC_WBL_SSID_DETAIL tab contains SSID-level detail for the work-based learning indicator.
For questions about this file, contact Kelsey Stephens.
2021_CTE_LEA_TECH_SKILL_PROGRAM<file date>.xls
2021 CTE Program Technical Skill Attainment
This report is distributed to districts with students who were concentrators in a CTE program with aligned technical assessments during the 2020-2021 school year. The report contains the CTE program level calculations of Technical Skill Attainment that will appear in the 2021 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information.
The report consists of four tabs:
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2021_CTE_POST_PLACEMENT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 4 tabs:
-
CTPD_JVSD_POST_PLACEMENT: provides the data points and percentages for the CTPD and JVSD for the Post-Program Placement measure. The report consists of the CTPD IRN, CTPD placement denominator, numerator and placement percentage as well as the JVSD placement denominator, numerator and placement percentage.
- CTPD_STUDENT_LEVEL_POST_PLACE: provides student-level data on which students are included in the post-program placement measure. The report contains the CTPD IRN, SSID, placement denominator and placement numerator flags.
- CTPD_POST_PROGRAM_GRADE: is a file by CTPD that shows the number of concentrators who left secondary education in FY20 who were reported as placed in the follow-up collection. The file contains the CTPD post-program placement denominator, numerator and rate as well as CTPD status known denominator, status known numerator and status known rate.
- CTPD_POST_PLACEMENT_CATEGORIES: report breaks down the student count and percentage of each placement category (apprenticeship, employment, military, service program and post-secondary training). Depending on what was reported in the 2020D report collection, students may be counted in more than one category. Each percentage is calculated with the ‘post-placement denominator as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement denominator = apprenticeship percentage). The report consists of CTPD IRN, post-placement denominator, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, service program placed, service program percent, post-secondary placed, post-secondary percent.
For questions about this report, please contact Kelsey Stephens.
2021_CTE_POST_PROGRAM_DISTRICT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure District Detail
These reports are distributed to CTPD Member Districts. The workbook consists of 4 tabs:
-
DETAIL_POST_PROGRAM: report is a student-level file that shows placement status for all concentrators who left secondary education in FY20. The data elements included in the file are reporting LEA IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District. The options in the Post Program Placement are Yes – met the indicator for Post-Program Placement; No – student does not meet indicator.
- DIST_POC_POST_PROGRAM: report is a file by district and CTE program that shows placement of concentrators who left secondary education in FY19 by program of concentration. This information will be used in the Post-Program Placement measure in the 2021 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information. The file contains reporting LEA IRN, CTE program of concentration, district post-placement denominator, numerator, and post-program rate by program of concentration.
- DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY20 that were reported as placed in the follow-up collection. The file contains reporting LEA IRN, district post-placement denominator, numerator, and district post-program placement rate.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY20 that were reported as placed in the follow-up collection. The file contains CTPD post-program placement denominator, numerator and rate, as well as the CTPD status known denominator, numerator, and rate.
For questions about this report, please contact Kelsey Stephens.
2021_GRAD_Cohort-EOC-Asmnt-Detail_<file date>.xls
2021 Graduating Cohort End of Course Assessment Details
This file contains the highest score and graduation points earned for each End of Course assessment area. The EMIS reporting code for each assessment area is included in the column headers. The assessment date and required test type of this highest score found are listed as well. Students included are those in the 2021 LEA graduation cohort as of current 2020-2021 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Additionally, prior ALT assessments are not included. Only actual assessment scores reported to ODE are included. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2020-2021 school year, they will be added to the report.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2021_GRAD_Cohort-EOC-Path-Req-Stat_<file date>.xls
2021 Graduating Cohort End of Course Pathway Requirements Status
Students in this file match the students in the Detail files. This file includes the highest number of graduation points earned for each assessment area between actual assessments taken and assessment substitutes and exemptions. If no points have been earned in an assessment area, the column will be blank. In addition, each student is evaluated against the total grad points required in Math, ELA, and Social Studies/Science, as well as against the required number of total points across all subjects. Finally, a yes/no field indicates if each of these requirements has been met, and if the student has met all the assessment requirements to graduate using the End of Course pathway. Please note - if a student is reported with out-of-state or homeschool transfer credit, then all points columns will be blank. It is up to the district to keep track of the prorated points for these students and to determine if End of Course Pathway graduation requirements have been met.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2021_GRAD_Cohort-Non-EOC-Pts-Detail_<file date>.xls
2021 Graduating Cohort End of Course Points from Substitutes and Exemptions
This file contains the highest score and graduation points earned for each End of Course assessment area where a substitute assessment or exemption has been submitted for a student. The EMIS reporting code for each assessment area is included in the column headers. Substitutions could include AP, IB, College Credit Plus, non-public transfers, and high school credit earned in a course before the End of Course assessment was available or during the 2019-2020 and 2020-2021 school years as a result of the March 2020 ordered school building closure and passing of state legislation due to COVID-19 allowing graduation requirement flexibility during the 2019-2020 and 2020-2021 school years. Not all substitutes apply to all assessment areas. Students included are those in the 2021 LEA graduation cohort as of current 2020-2021 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Only actual assessment scores reported to ODE are included; reported course credit alone would not cause points to be earned towards graduation. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2020-2021 school year, they will be added to the report.
In addition to assessment information, students with disabilities who have been exempted from the consequences of an End of Course graduation exam (FE exemption reported) are given three graduation points for each area of exemption. As additional FE exemptions are reported during the 2020-2021 school year in the student enrollment collection, they will be added to the report.
Based on the highest number of graduation points earned via a substitute assessment or special education exemption, the max alternate graduation points for each assessment area are listed.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2021_GRAD_Cohort_SAT-ACT_Path_Req_stat_<file date>.xls
2021 Graduating Cohort ACT/SAT Pathway Details
This file contains the highest score earned for each student across all reported administrations of the ACT and/or SAT. Students included are those in the 2021 LEA graduation cohort as of current 2020-2021 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned for either test. Each student is evaluated against remediation free scores in Reading, Math, and English for the ACT, and Reading, Math, and Writing for the SAT. Finally, a yes/no field indicates if the remediation free requirement on at least one of the two tests has been met.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2021_GRAD_Cohort_WK-IndCred_Path_Req_stat_<file date>.xls
2021 Graduating Cohort Workkeys/Industry Credentials Pathway Details
This file contains the highest score from the Workkeys assessment, as well as information on all industry credentials earned by a student. Students included are those in the 2021 LEA graduation cohort as of current 2020-2021 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned or no credential obtained. Each student is evaluated against remediation free scores on the Workkeys exam and against a 12 point standard in a single career field for industry credentials. Finally, a yes/no field indicates if the Workkeys and Credentials requirements have been met.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2021_KRA_Valid_Scores_<file date>.xls
2021_KRA_Invalid_Scores_<file date>.xls
These reports contain KRA scores Districts submitted to EMIS in the KRA FY 21 EMIS collection. ODE was provided a new vendor file from the K-Ready system with updated scoring after the EMIS collection closed. Details about the vendor file changes are in this March 26 communication. Impacted students score(s) changed from 202-298 to no longer having score(s).
If the student’s scores submitted to EMIS are also in the new vendor file with a matching SSID, the scores will be in the ‘Valid Scores’ file. All other scores submitted to EMIS will be in the ‘Invalid Scores’ file. If a student’s scores were calculated outside of the K-Ready system and the District believes the scores are accurate, please submit an Appeal for these scores to be moved from the ‘Invalid Scores’ to the ‘Valid Scores’ file.
These reports include the Manifest Code, Reporting LEA IRN, SSID, Assessment Code, Assessment Subject Code, Test Score, Test Taken Date. Each student will have a row for each subject, so most students will have 5 rows.
Many Districts will have two files: a file with ‘Valid Scores’ and a file with ‘Invalid Scores’. Districts with either all valid or all invalid scores will have only one file.
For questions about these KRA reports, please contact Veronica Oblak.
2021_PBIS_Compliance_Measure _<file date>.xls
Positive Behavior Intervention Support (PBIS) Implementation Stage Compliance Measure
This file is distributed to public districts, community schools, and STEM schools. The workbook consists of 2 tabs:
-
LEA_DETAIL:
- Get a “YES" flag if all its schools have a C, D, E, or F code reported.
- Get a "NO" flag if any school has an A, B reported or if any school had no code reported for this element.
- ORG_DETAIL or CS_DETAIL:
- Get a "YES" flag if it has a code of C, D, E, or F.
- Get a "NO" Flag if it has a code of A, B or if no record is reported in EMIS.
For questions about this report, contact Adam Schiming (Adam.Schiming@education.ohio.gov).
2021_RPTCRD_DORP_Prep_for_Success_Detail_<file date>.xls
Dropout Prevention and Recovery Report Card Prep for Success Measure
This file contains two tabs for Dropout Prevention and Recovery Schools (DPR_OUTPUT and DPR_SUMMARY).
For questions about this report, please contact Letitia Linville.
2021_RPTCRD_DPR_Assessment_Pass_Rate_SSIDs_<file date>.xls
Dropout Prevention and Recovery Report Card Assessment Passage Rate Information
This file contains two tabs, SSID_Level and Calculation. The SSID_Level tab specifies which SSIDs are included in the numerator and denominator of the Assessment Passage Rate for Dropout Prevention and Recovery (DPR) Schools. The tab contains the IRN, SSID, a column indicating whether the student is included in the numerator (SSID_in_Numerator), and a column indicating whether the student is included in the denominator of the calculation (SSID_in_Denominator). A “Yes” indicates the student was included at the time the report was created and a “No” indicates the student was not included at the time the report was created. The Calculation tab reports summary results for the assessment passage rate including the IRN, numerator (ALL_TESTS_PASSED), denominator (ALL_TESTS_TAKEN), and passage rate (ALL_TESTS_PCT) currently being calculated for DPR schools.
For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2021_RPTCRD_DPR_ENROLL_AGE_VERIFICATION_SSIDs_<file date>.xls
Dropout Prevention and Recovery Report Card Enrollment Age Verification Information
This file will be provided periodically throughout the reporting window. It contains two tabs, Calculation and SSID_Details. The Calculation tab contains the columns ORG_IRN, ORG_NAME, COUNT_AGE_MET (numerator), HEADCOUNT (denominator), PERCENT_AGE_MET (Calculation), and AGE_CRITERIA_MET. A “Yes” in the AGE_CRITERIA_MET column indicates that the school enrolled over 50 percent of students in the applicable age range of 16 to 21. The SSID_Details tab contains the columns ORG_IRN, ORG_NAME, SSID, BIRTH_DATE, and AGE_CRITERIA_MET. A “Yes” in the AGE_CRITERIA_MET column indicates the student is included in the numerator and a “No” indicates the student is not included in the numerator. For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2021_RPTCRD_EL_Progress_Measure_File_<file date>.xls
2021_RPTCRD_EL_Progress_Measure_File
This file contains two tabs for public districts (LEA_DETAIL and SCH_DETAIL), and one tab for STEM schools and community schools (SCH_DETAIL). The LEA_DETAIL and SCH_DETAIL tabs contain SSID-level data that includes the SCHOOL_YEAR, SSID, BASELINE_GRADE_LEVEL – which is the student’s grade level when baseline was established, BASELINE_SCORE - which is the student’s baseline OELPA score, EL_EXMPT_COUNT - which is the student’s total number of exemptions, IMPRV_PTS_NUMBER - which are the number of improvement points needed for the student to meet the Growth Target, EL_PROF_COUNT – tells whether or not the student scored a proficient score on the OELA and EL_GROWTH_COUNT – tells whether or not the student met the growth target. For questions about this report, contact Adam Schiming (Adam.Schiming@education.ohio.gov).
2021_RPTCRD_Fall_G3ELA_Vendor_File_18-21_<file date>.xls
Fall 2018, 2019, and 2020 Third Grade English Language Arts Test Data from Cambium Assessment, Inc.
This is a one-time file being sent to districts as a courtesy showing pre- and post-pandemic statewide and district level student performance data on the fall administration of the third grade English language arts state test that will soon be posted on the Ohio Department of Education’s “Data Insights” webpage. The data were compiled using the fall 2018, fall 2019, and fall 2020 test files from Ohio’s vendor, Cambium Assessment, Inc., versus using data submitted in EMIS. Superintendents received a separate email communication about this file, and it should be forwarded to your superintendent when received.
The file contains two tabs, STATE and DISTRICT. The STATE tab contains the columns Administration (year the fall ELA test was administered), Total Tests (denominator), Advanced (percent of students scoring Advanced on the administration), Accelerated (percent of students scoring Accelerated on the administration), Proficient (percent of students scoring Proficient on the administration), Basic (percent of students scoring Basic on the administration), Limited (percent of students scoring Limited on the administration), and Proficient-Above (percent of students scoring Proficient or higher on the administration). The DISTRICT tab contains the same columns for each of the three most recent years’ fall administrations (fall 2018, fall 2019, and fall 2020) as well as columns to note District IRN, District Name, and County. For questions about this report, please contact Marianne Mottley at (Marianne.Mottley@education.ohio.gov).
2021_RPTCRD_KRA_R_18-21_<file date>.xls
Fall 2018, 2019, and 2020 Kindergarten Readiness Assessment Test Data from Johns Hopkins University
This is a one-time file being sent to districts as a courtesy showing pre- and post-pandemic statewide and district level student performance data on the fall administration of the Kindergarten Readiness Assessment that will soon be posted on the Ohio Department of Education’s “Data Insights” webpage. The data were compiled using the fall 2018 and fall 2019 data reported to EMIS and fall 2020 test file from Ohio’s vendor, Johns Hopkins University. Superintendents received a separate email communication about this file, and it should be forwarded to your superintendent when received.
The file contains three tabs, DATA NOTES, STATE, and DISTRICT. Please read the information on the Data Notes tab first. The State tab contains the percentage and number of students demonstrating, approaching, emerging readiness, and the Language & Literacy percentage on-track and not on-track. Also, break outs are provided by Ethnicity/Race, Gender, Disability Flag, and Economic Disadvantagement. The District tab contains the number of students with scores and percentage of students demonstrating, approaching, emerging readiness, and Language & Literacy percentage on-track and not on-track. For questions about this report, please contact Veronica Oblak at Veronica.Oblak@education.ohio.gov.
2021_RPTCRD_Spring_GNGE_Vendor_File_18-21
Spring 2018, 2019, and 2021 Ohio State Test Data from Cambium Assessment, Inc.
This is a one-time file being sent to districts as a courtesy showing pre- and post-pandemic statewide and district level student performance data on the spring administration of each state assessment that soon will be posted on the Ohio Department of Education’s “Data Insights” web page. The data were compiled using the spring 2018, spring 2019 and spring 2021 test files from Ohio’s vendor, Cambium Assessment, Inc., versus using data submitted in EMIS. Superintendents received a separate email communication about this file, and it should be forwarded to your superintendent when received.
The file contains two tabs, STATE and DISTRICT. The State tab contains columns showing for each state assessment the Total Tests (denominator) administered by year, Advanced (percent of students scoring Advanced on each year’s administration), Accelerated (percent of students scoring Accelerated on each year’s administration), Proficient (percent of students scoring Proficient on each year’s administration), Basic (percent of students scoring Basic on each year’s administration), Limited (percent of students scoring Limited on each year’s administration) and Proficient and Above (percent of students scoring Proficient or higher on each year’s administration). The DISTRICT tab contains the same columns for each of the three spring administrations (spring 2018, spring 2019 and spring 2021) as well as columns to note District IRN, District Name and County. For questions about this report, please contact Marianne Mottley at Marianne.Mottley@education.ohio.gov.
In addition, a chronic absence file also will be posted soon on the agency’s “Data Insights” web page. This file will provide high level data on all districts’ chronic absence rates using EMIS data from the 2018-19 and 2020-2021 school years. District personnel can delve deeper into their own district’s data in the “old” or “new” Secure Data Center (SDC). The old SDC is accessed by logging into your OHID account and clicking on the tile called “Secure Data Center”. Once in the SDC, click on the button called “Reports for Analysis” and then “Attendance Rate”. Several reports exist to see data on student absences. The new SDC also is in the OHID system, under the tile called “Report Portal.” Once in the portal, click the button called “Secure Data Center” and then “Student Attendance”. Each report has several tabs to see different slices of the data. For questions about this report, please contact Marianne Mottley at Marianne.Mottley@education.ohio.gov.
2021_STUDENT_ESCHOOL_1YEAR_SSIDs_<file date>.xls
Eschool Missing Tests Per Ohio Revised Code Section 3314.26
This file provides details about eschool students with missing tests from the 2021 school year and is considered informational only for the purposes of ORC 3314.26. Senate Bill 229 establishes the 21-22 school year as the starting point going for evaluating compliance with ORC 3314.26. Students do not need to be unenrolled as a result of missing tests during the 2021 school year.
Each school’s file contains up to three tabs based on the grade levels and graduation cohorts served by the school during the 2021 school year. Schools with any students missing grades 3 through 8 tests will have the tab MISSED_ANY_ES_SSIDS. Students in the class of 2018 and later, taking EOC courses, and having any missed tests will receive the tab MISSED_ANY_EOC_NEW_PATH_SSIDS. And a small number of schools with students in the class of 2017 and earlier, and missing OGTs, will receive the tab MISSED_ANY_OGT_SSIDS. Please note that while each school will only receive information about its own enrolled students from the 2020 school year, on occasion test data are submitted by another entity.
The MISSED_ANY_ES_SSIDS tab contains the columns SSID, IRN, and GRADE_LEVEL (2021). The remaining columns indicate the specific test grade and subjects that were missed (NO), taken (YES), or not applicable in 2020 (NA).
The MISSED_ANY_EOC_NEW_PATH_SSIDS tab includes SSID, IRN, GRADE_LEVEL_LY (2020, pertinent to retained 11th graders), GRADE_LEVEL (2021), and HS_TEST_PATH_NEW (EOC_6 indicates ELA 1 test is not required, EOC_7 indicates all seven EOC tests are required). The remaining columns indicate the specific tests that were missed (NO), taken (YES), or not applicable in 2020 (NA).
The MISSED_ANY_OGT_SSIDS tab includes SSID, IRN, GRADE_LEVEL_LY (2020, pertinent to retained 11th graders), GRADE_LEVEL (2021), and HS_TEST_PATH (OGT). The remaining columns indicate the specific tests that were missed (NO), taken (YES), or not applicable in 2020 (NA).
For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2021D_CTE_MARCHD_CONCNTRT_<file date>.xls
2021 MARCHD CTE CONCENTRATOR FILE
This report contains information about students who are to be included in the 2021D0000 (CTE MarchD) file. This file is for districts to use in determining if a CTE Concentrator appeal should be submitted to add or remove a student from the 2021D0000 file, or add a CTE Program of Concentration for a student already listed in the file.
All CTE Programs of Concentration (POC) are listed in which the student was a CTE Concentrator. If a student had a POC in a district other than the reporting LEA , it will also be listed for that student. There is no need to submit an appeal to have a POC that was not reported by the reporting LEA removed from the file. The report includes the CTPD IRN, reporting LEA IRN, SSID, reporting FY, CTE program of concentration code, POC determination and ITC short name.
The ‘POC determination’ field indicates whether the POC for the row and reporting FY was a
-
District Reported POC, or
- ODE Determined POC.
ODE determines the POC when a student is derived as having met CTE Concentrator status in the FY but no POC was reported in the FY by the district.
Districts should use this report to review the students who will be included in the 2021D0000 CTE Follow-Up file for their district. For questions about this file, contact your ITC so that an EMIS Helpdesk ticket submitted.
2021S_RPTCRD_Internet_Connectivity_File_<file date>.xls
Internet Connectivity File
The 2021 Ohio School Report Cards will include newly available data on the access to technology and learning models used during the 2020-2021 school year.
This file summarizes the measures of internet connectivity at home for students reported for schools and districts on the Student Program (GQ) Record in the Midyear and End of Year Student (S) Collections. This data will appear on this year’s report card.
These GQ Records indicate whether a student has internet connectivity at their primary residence. The level of internet connectivity for a student may change over time; however, these program codes should be reported based on the district’s assessment of a student’s status at some point during the month of March. This assessment in March can be one-time only; once a district has assessed a student’s status, the district does not need to update the status if it changes later in the month.
Handling Multiple GQ Records. The district only needs to report one applicable code; however, if the district reports multiple program codes for an individual student, the Department’s calculations will prioritize the minimum code number (i.e., if the district reports both 700401 and 700412, the appropriate code to use for the purposes of these calculations is 700401).
GQ Program Code Options: Internet Connectivity at Home
- 700401 District Provided Broadband: The student’s school or district provides internet connectivity primarily through cable, DSL, or some other non-cellular access method for the student to use to complete schoolwork at their primary residence.
- 700412 Internet Via Broadband: The student has internet connectivity primarily through cable, DSL, or some other non-cellular access method for the student to use to complete schoolwork at their primary residence.
- 700423 District Provided Hotspot: The student’s school or district provides internet connectivity primarily through cellular hotspot or cell phone for the student to use to complete schoolwork at their primary residence.
- 700434 Internet Via Hotspot: The student has internet connectivity primarily through cellular hotspot or cell phone for the student to use to complete schoolwork at their primary residence.
- 700445 No Regular Access to Internet: The student does not have regular internet connectivity for the student to use to complete schoolwork at their primary residence.
- 700499 Unknown Access to Internet: The student’s internet connectivity for completing schoolwork at their primary residence is unknown.
If no internet connectivity data is reported for a student on the Student Program (GQ) Record, then the internet connectivity reported on the report card for that student may be listed as “Unknown Access to Internet”.
For questions about this file, contact your ITC so that an EMIS Helpdesk ticket can be submitted as needed.
2021S_RPTCRD_LEARN_MODE_BY_SEASON_<file date>.xls
Learning Model by Season
This file summarizes the education delivery model information reported for schools and districts on the Organization – General Information (DN) Record in the Midyear and End of Year Student (S) Collections. This data will appear on this year’s report card. On the report card, the delivery model will be reported for three timeframes—Fall, Winter, and Spring. Whichever model (5 Day In, Hybrid, or Remote) was in place for the most days during each season will be displayed. If EMIS DN data for a school or district has not been reported, then data from a weekly survey completed via the ESCs will be used. If data from the ESC survey is not available, then the season on the report card (and in this file) may be listed as “Unknown”.
During each season, only days that existed on one or more EMIS calendar reported by a district were included. To assist in understanding how the season label was derived, the file also includes the number of days within the season for each of the three delivery models. Days that were unknown are ignored when determining the primary delivery method for a season, unless all days in the season are unknown. The date ranges for each season are Aug. 1 – Nov. 30 for Fall, Dec. 1 – Feb. 28 for Winter, and March 1 – June 30 for Spring.
The file has one row for each building in the district and one row for the district overall. If you feel the label is incorrect for one of your buildings or the district overall, please review the EDUMODELDB attribute reporting for each district/building. Note that building-level reporting is only required if a building has a different model than the district in general. However, since only the start date of each model is reported, once a building is reported as different than the district, reporting for that building must continue for the remainder of the school year, including if the building returns to the same learning model as the district.
The data used for this report card information is part of the Midyear and End of Year Student (S) Collections, which close in mid-July. Data for this information may be appealed in the student appeal window the following week, but once the student appeals close in July, this data will be final for the report card.
For questions about this file, contact your ITC so that an EMIS Helpdesk ticket can be submitted as needed.
2021S_RPTCRD_Technology_Access_File_<file date>.xls
Technology Access File
The 2021 Ohio School Report Cards will include newly available data on the access to technology and learning models used during the 2020-2021 school year.
This file summarizes the measures of technology access at home for students reported for schools and districts using a combination of the Organization-General Information (DN) and the Student Program (GQ) Records.
Calculations for technology access at home first look at the DN Record. If a district provided hardware for all students in a grade or grade range, this information will be reported in the DN Record and will be applied to all students associated with the specific grade(s) identified.
In the DN Record’s “Attribute Text" field, the district will provide the grade or grade range of students for whom hardware is provided.
- If a district provides hardware to students in a single grade or in a contiguous grade range, then only one record needs to be reported. For example, a district providing hardware to students in grades 3 through 7 should report a single record with “3–7”.
- If a district provides hardware to students in multiple non-contiguous grades or grade ranges, then the district will report multiple DN Records. For example, a district providing hardware to students in grade 3 and students in grade 7 through grade 12 should report two records: one with “3” and one with “7–12”.
In cases where a district has not used the DN Record to report that all students in a grade or grade range received hardware, the next step is to review Student Program (GQ) Records associated with individual students.
Handling Multiple GQ Records. The district only needs to report one applicable code; however, if the district reports multiple program codes for an individual student, the Department’s calculations will prioritize the minimum code number (i.e., if the district reports both 700212 and 700234, the appropriate code to use for the purposes of these calculations is 700212).
GQ Program Code Options: Technology Access at Home
- 700201 District Provided Computer: The student’s school or district provides a desktop, laptop, or tablet for the student to use to complete schoolwork at their primary residence.
- 700212 Student Access to Computer: The student has regular access to a desktop, laptop, or tablet, not provided by the student’s school, for the student to use to complete schoolwork at their primary residence.
- 700234 Student Access to Smartphone: The student has regular access to a smartphone for the student to use to complete schoolwork at their primary residence.
- 700245 No Regular Access to Hardware: The student does not have regular access to a desktop, laptop, tablet, or smartphone for the student to use to complete schoolwork at their primary residence.
- 700299 Unknown Access to Hardware: The student’s access to a desktop, laptop, tablet, or smartphone for the student to use to complete schoolwork at their primary residence is unknown.
If no internet connectivity data is reported for a student on the Student Program (GQ) Record, then the internet connectivity reported on the report card for that student may be listed as “Unknown Access to Internet”.
For questions about this file, contact your ITC so that an EMIS Helpdesk ticket can be submitted as needed.
2020 File Descriptions
20XX_CCP_ID_HS_NP_NO_MATCH_<file date>.xls
FY20XX CCP Homeschooled and Nonpublic IDs With No Match
This report contains information about CCP Homeschooled and Nonpublic IDs that have been reported by colleges, but they do not have a matching student application. The report includes the college IRN and name, student CCP ID, program period, the number of credit hours reported by college. Colleges should check the student award letters to ensure that the correct CCP IDs were reported. The data with correct CCP ID should be re-reported to CCP HEI portal.
For questions about this file, contact CCP@education.ohio.gov.
2020_CCP_ALT_AGREE_STATUS_REPORT_<file date>.xls
FY2016 – FY2020 CCP Alternate Agreements with Potential Reporting Errors
This report contains information about CCP alternate agreements that have potential reporting errors. The report includes the year, term, delivery method, and negotiated rate between the college and secondary LEA. Each alternate agreement listed on the report will have a result code and description of the potential error.
Result Code |
Result Description |
CC0018 |
Alternate agreement between private college and private secondary school not allowed |
CC0019 |
Alternate agreement is above the ceiling rate |
CC0020 |
Alternate agreement is below the floor rate and not approved |
CC0021 |
District IRN is not a valid IRN |
CC0022 |
Invalid delivery method code |
CC0024 |
Alternate agreement flagged in ODDEX |
CC0025 |
Alternate agreement reported, but no students are reported as having this alternate pay structure in place |
CC0026 |
Students are reported as having this alternate pay structure in place, but alternate agreement is either missing or reported with invalid data |
Colleges should use these reports to identify any alternate agreements that may need to be resubmitted with corrections.
2020_CCP_BAD_STUDENT_DATA_<file date>.xls
2020 CCP Bad Student Data Details
This file contains student level data for each CCP course that was reported by the college with invalid data. These courses do not appear in ODDEX and will not be eligible to be funded until the invalid data is corrected and resubmitted by the college. Reports include the student SSID, course information (course ID, course name, section ID, year, term, delivery method, and credit hour code), number of credits, and date on which the data was pulled. Also included is a column that provides an explanation of why a given record was captured in the report. Listed below are the possible reasons:
Reason |
Trigger |
Invalid delivery method code |
Delivery method code is not OL, OC, CI, or HI |
Course dates for SM term outside valid range |
Course start date is not March through August and course end date is not June through August |
Course end date earlier than course start date |
|
Roster date not between course start and end date |
|
Course dates for SP term outside valid range |
Course start date is not August through May and course end date is not January through June |
Invalid SSID format |
|
SSID does not exist |
SSID doesn’t exist in any EMIS student collection |
Public student not reported with public IRN |
SSID is reported with an IRN that does not belong to a public district, JVSD, community school, STEM, or state-supported organization |
Credit hour count is zero |
In cases where the zero count is valid no resubmission is necessary |
Non-public or Homeschooled student reported with invalid ODE-assigned ID |
CCPID is an invalid ODE-assigned ID or the ID is valid but the student with that ID does not have an approved funding application. Colleges should check the student’s award letter for the correct ID. |
2020_CCP_HEI_Payment_2020<payment month>_<file date>.xls
2020 CCP HEI Payment Details
This file contains student level data for each CCP course that is included in the College Credit Plus Payment Reports for the payment month identified in the file name. Reports include the student SSID, course information (course ID, section ID, year, term, delivery method, and credit hour code), LEA being deducted, number of credits included for payment, the actual rate at which the credits are being paid, the payment amount, and date on which the data was pulled. Also included is a column that provides an explanation of the rate being paid. Listed below are the possible rate explanations:
- Student Reported on Alt Agreement, Alt Agreement Reported - Paid Alt Agreement Rate
- Student not Reported on Alt Agreement - Paid Default Rate
- Student Reported on Alt Agreement, no Alt Agreement Reported - Paid Floor Rate
- Student not Reported on Alt Agreement; Reduced Rate Applies - Paid Reduced Rate
- Student Reported on Alt Agreement, Alt Agreement Below the Floor Rate - Paid Floor Rate (FY19 and later)
- Student Reported on Alt Agreement, Alt Agreement Below the Floor Rate and not Approved - Paid Floor Rate (FY16, FY17, and FY18)
- Student Reported on Alt Agreement but Reduced Rate is less than Alt Agreement Rate - Paid Reduced Rate
- Student not Reported on Alt Agreement but Reported Alt Agreement Rate is less than Default Rate - Paid Alt Agreement Rate
The College Credit Plus Payment Reports posted on the ODE website for a given fiscal year include WI and SP courses from the prior year along with SM and AU courses from the current year. For example, the F2019 College Credit Plus Deduction Report includes courses from WI 2018, SP 2018, SM 2019, and AU 2019. Therefore, data would need to be pulled from both the 2018_CCP_HEI_PAYMENT report and 2019_CCP_HEI_PAYMENT report in order to reconcile data with the F2019 College Credit Plus Payment Report.
20XX_CCP_HS_NP_Payment_Adjustment_Report_<file date>.xls
FY 20XX CCP Homeschooled and Nonpublic Payment Adjustments
This report contains information about CCP Homeschooled and Nonpublic payment adjustments. The report includes the program period, student CCP ID (there may be multiple lines for some students), college IRN and name, term, detailed data related to invoice, invoice ID, date, status, approved and paid/refunded amount. In cases when student has both paid and refund amounts the sum of the “Paid or Refund Amount” for each student will equal to the payment for that student. Listed below are the possible reasons for the payment adjustments:
- Students and/or courses previously reported incorrectly or not reported are now being reported correctly.
- Number of courses, credit hours, credit hour rates changed.
- FY16, FY17 and FY18 credit hour rates were updated to the statutory set rates.
- In a few instances when a college reported a 0.5 credit hour course, it was not paid before.
For questions about this file, contact CCP@education.ohio.gov.
2020_CCP_HS_NP_FY16_FY19_Refund_Report_<file date>.xls
FY 2016 – FY 2019 CCP Homeschooled and Nonpublic Refunds Due to ODE
This report contains information about CCP Homeschooled and Nonpublic Refunds that colleges owe back to ODE. The report includes the program period, student CCP ID (there are multiple lines for each student), college IRN and name, detailed data related to transactions, all transactions types, dates and an amounts related to each student that generated a net refund, balance amount. The amount displayed is the net amount due to ODE based on all of the student’s related transactions. It is displayed on every line, however these amounts should not be aggregated for all student rows as they are just a duplication of the actual amount owed. The sum of the “Transaction Amount” for each student will equal the amount listed in the “Balance Amount” cell. Listed below are the possible reasons for the refunds due:
- Originally a student was reported as taking one or more courses. The college was paid based on that data. Later college resubmitted data showing that the student didn’t take classes at all or took less credit hours.
- Originally the college was paid at the CCP default rate, but college later submitted an alternative agreement with the lower credit hour rate.
- Starting with Spring 2018: colleges that have their standard rates lower than the CCP default rates were paid at their standard rates.
- Starting with Spring 2018: colleges that provide lower than their standard tuition rate to residents of certain counties due to levy were paid at those lower rates.
- In instances when college reported 2.5 or 1.5 credit hour course – the courses were previously paid at 3 and 2 credit hours. The credit hours were adjusted downwards to what college actually reported.
Colleges should use these reports to review refunds due and if data issues are identified – resubmit correct data into HEI by 6/1/2020. For questions about this file, contact CCP@education.ohio.gov.
2020_CCP_INVALID_SSID_HEI_<file date>.xls
FY2016 – FY2018 CCP Courses Removed due to Invalid SSID
This file contains information about CCP courses from FY16, FY17, and FY18 that have been appearing in ODDEX but were reported with an invalid SSID. In some cases, we have found that another student was reported with a very similar SSID in the same course, which means that the course may be getting funded twice. If an SSID was found for a student in the same course coming from the same district that matches on 7 or 8 characters found on the invalid SSID, then the CLOSE_MATCH_FOUND column will display a ‘Y’. Courses appearing on this file will appear in ODDEX as struck-through. To receive funding, colleges will need to report the course with a valid SSID, if they have not done so already. The record with the invalid SSID will appear on the college’s Bad Data report. If they would like to remove the record with the invalid SSID from the Bad Data report, they will need to report the course with the delete flag set to ‘Y’.
2020_CCP_INVALID_SSID_LEA_<file date>.xls
FY2016 – FY2018 CCP Courses Removed due to Invalid SSID
This file contains information about CCP courses from FY16, FY17, and FY18 that have been appearing in ODDEX but were reported with an invalid SSID. In some cases, we have found that another student was reported with a very similar SSID in the same course, which means that the course may be getting funded twice. If an SSID was found for a student in the same course coming from the same district that matches on 7 or 8 characters found on the invalid SSID, then the CLOSE_MATCH_FOUND column will display a ‘Y’. Courses appearing on this file will appear in ODDEX as struck-through. To receive funding, colleges will need to report the course with a valid SSID, if they have not done so already. The record with the invalid SSID will appear on the college’s Bad Data report. If they would like to remove the record with the invalid SSID from the Bad Data report, they will need to report the course with the delete flag set to ‘Y’.
2020_CCP_REASSIGNED_HEI_<file date>.xls
FY2016 – FY2018 CCP Courses Credits Moved to another LEA
This file contains information about CCP courses from FY16, FY17, and FY18 that were originally assigned in full to one LEA and have been appearing in ODDEX as such, but will now be reassigned either in full or in part to another LEA. The file contains columns showing the current LEA assigned payment responsibility, the credits assigned to the current LEA, and current funding responsibility code as well as columns showing the new LEA assigned payment responsibility, the credits assigned to the new LEA, and the funding responsibility code (FULL/PART) assigned to the new LEA. There is also information indicating whether the course has already been approved for payment.
2020_CCP_REASSIGNED_LEA_<file date>.xls
FY2016 – FY2018 CCP Courses Credits Moved to another LEA
This file contains information about CCP courses from FY16, FY17, and FY18 that were originally assigned in full to one LEA and have been appearing in ODDEX as such, but will now be reassigned either in full or in part to another LEA. The file contains columns showing the current LEA assigned payment responsibility, the credits assigned to the current LEA, and current funding responsibility code as well as columns showing the new LEA assigned payment responsibility, the credits assigned to the new LEA, and the funding responsibility code (FULL/PART) assigned to the new LEA. There is also information indicating whether the course has already been approved for payment.
2020_CCP_NEWLY_SPLIT_HEI_<file date>.xls
FY2016 – FY2018 CCP Courses with Credit Responsibility Reduced due to Split
This file contains information about CCP courses from FY16, FY17, and FY18 that were originally assigned in full to one LEA and have been appearing in ODDEX as such, but which are now being split. The file contains columns showing the current LEA assigned payment responsibility, the credits assigned to the current LEA, and the current funding responsibility code (FULL) as well as columns showing the new number of credits now being assigned to the LEA and the new funding responsibility code (PROP) assigned to the LEA. There is also information indicating whether the course has already been approved for payment.
2020_CCP_NEWLY_SPLIT_LEA_<file date>.xls
FY2016 – FY2018 CCP Courses with Credit Responsibility Reduced due to Split
This file contains information about CCP courses from FY16, FY17, and FY18 that were originally assigned in full to one LEA and have been appearing in ODDEX as such, but which are now being split. The file contains columns showing the current LEA assigned payment responsibility, the credits assigned to the current LEA, and the current funding responsibility code (FULL) as well as columns showing the new number of credits now being assigned to the LEA, and the new funding responsibility code (PROP) assigned to the LEA. There is also information indicating whether the course has already been approved for payment.
2020_CCP_LEA_Deduct_2020<payment month>_<file date>.xls
2020 CCP LEA Deduction Details
This file contains student level data for each CCP course that is included in the College Credit Plus Deduction Reports for the payment month identified in the file name. The reports include the higher education institution and campus receiving payment, student SSID, course information (course ID, section ID, year, term, delivery method, and credit hour code), number of credits included in the deduction, the actual rate at which the credits are being paid, the deduction amount, and date on which the data was pulled. Also included is a column that provides an explanation of the rate being paid. Listed below are the possible rate explanations:
The College Credit Plus Deduction Reports posted on the ODE website for a given fiscal year include WI and SP courses from the prior year along with SM and AU courses from the current year. For example, the F2019 College Credit Plus Deduction Report includes courses from WI 2018, SP 2018, SM 2019, and AU 2019. Therefore, data would need to be pulled from both the 2018_CCP_LEA_DEDUCT report and 2019_CCP_LEA_DEDUCT report in order to reconcile data with the F2019 College Credit Plus Deduction Report.
2020_CCP_NOT_FUNDED_AT_RESP_LEA_<file date>.xls
FY 2016 – FY 2020 CCP Courses not Funded at the Responsible District
This report contains information about CCP courses for which the district is responsible, but the student taking the course is not being funded at the district on the course roster date. The report includes course information reported by the college such as the course ID, course name, section ID, year, term, delivery method, credit hour code, credit hour count, and course roster date. The report will also show any reviews placed on the course by the district as well as the date on which the data was pulled.
Districts and colleges should use these reports to reconcile any differences in reporting that result in the wrong district being assigned payment responsibility for a course.
2020_CCP_SPLIT_PAYMENT_DATA_<file date>.xls
FY 2016 – FY 2020 CCP Courses for which Payment Responsibility is Split
This report contains information about CCP courses for which ODE is unable to determine the district responsible for payment. In these cases, the responsible credits are allocated to each district based on the total percent of time reported for the student taking the course. Reports include course information reported by the college such as the course ID, course name, section ID, year, term, delivery method, and credit hour code. The reports also include the following information for each district that is assigned partial responsibility for payment of the course:
Districts should use this report to assist in determining which LEA is responsible for the course. If a course is still open for review, then the districts involved should place the appropriate flags indicating whether they should pay for the course. If a course is not open for review, then one or both districts should escalate the course. Ideally, CCP courses should not be split.
2020_CTE_CTPD_CAREER_PS_READY_COMPONENT_<file date>.xls
2020 CTPD Career & Post-Secondary Readiness Component
This report is only distributed to the CTPD Lead District. This report contains the rates and points for the Career and Post-Secondary Readiness measure.
- The SUMMARY tab contains the total points earned (numerator), the total number of students in the 4-year graduation cohorts (denominator) and the overall percentage.
- The DETAIL_OUTPUT tab contains ‘Y’, ‘N’ flags for each component of the Career and Post-Secondary measure as well as points earned for each SSID included in the measure. Components included are: ACT remediation-free, SAT remediation-free, Honors Diploma awarded, 12 Industry Credential points within a career field, Ohio Means Job Readiness Seal awarded, Internship Completion, Apprenticeship/Pre-Apprenticeship Completion, Work-Based Learning experience, CTSO Leadership experience, IB test scores of 4 or higher, AP test scores of 3 or higher, CTAG status met, proficient on a CTE Summative Assessment, 4 Industry Credential points within a career field, 4 CTE courses within a pathway, 3 or more dual enrollment credits, and total points awarded.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2020_CTE_CTPD_ENROLL_BY_LEA_<file date>.xls
2020 CTPD Report Card Enrollment
This report provides the CTPD member district summary information for the ungraded Enrollment measure. It Is distributed to CTPD lead districts. The member district summary includes a list of the member districts and the student enrollment count for the CTPD from each LEA. Please note there is a district titled “OTHER” for each CTPD. If the LEA in which the student is counting back to was not a CTPD member district that student is counted in the “OTHER” district.
Students may be counted in more than one CTPD member district in the member district summary. The CTPD Headcount of Students Participating in Career-Technical Courses on the report card will be deduplicated at the CTPD level.
The table below explains the business rules on which district a student is counted back to:
DISTRICT WHERE STUDENT COUNTS FOR CTE ENROLLMENT |
FTE FUND PATTERN CODE |
ORG TYPE |
HOW RECEIVED ELEMENT |
District reporting the CTE course |
COMM |
6 |
|
STEM |
60 |
|
RGJV |
1 |
Not equal to 'X' |
CTCR |
1 |
|
OPDD |
1 |
|
How Received IRN' reported for the student |
CTOP |
1 OR 4 |
|
CTID |
1 OR 4 |
|
CTVC |
1 OR 4 |
|
SPCO |
1 |
|
JVNR |
4 |
|
OJVR |
4 |
|
Students' legal district of residence |
RGJV |
4 |
Not equal to 'X' |
OTHER' district |
RGJV |
1 |
X |
RGJV |
4 |
X |
OPID |
4 |
|
OJVD |
4 |
|
For questions about this report, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2020_CTE_CTPD_ENROLL_BY_SSID_<file date>.xls
2020 CTPD Report Card Enrollment
This is an SSID level report on the report only enrollment measure on the CTPD Report Card. It contains SSID-level detail on the students included in the report-only enrollment measure on the CTPD report card. It Is distributed to CTPD lead districts. The report consists of:
-
CTPD_IRN
- MEMBER_DISTRICT_IRN
- SSID
- RACE_ETHNIC_CODE
- ECON_DISADV_FLAG
- DISAB_FLAG
- LEP_FLAG
The table below explains the business rules on which district a student is counted back to:
DISTRICT WHERE STUDENT COUNTS FOR CTE ENROLLMENT |
FTE FUND PATTERN CODE |
ORG TYPE |
HOW RECEIVED ELEMENT |
District reporting the CTE course |
COMM |
6 |
|
STEM |
60 |
|
RGJV |
1 |
Not equal to 'X' |
CTCR |
1 |
|
OPDD |
1 |
|
How Received IRN' reported for the student |
CTOP |
1 OR 4 |
|
CTID |
1 OR 4 |
|
CTVC |
1 OR 4 |
|
SPCO |
1 |
|
JVNR |
4 |
|
OJVR |
4 |
|
Students' legal district of residence |
RGJV |
4 |
Not equal to 'X' |
OTHER' district |
RGJV |
1 |
X |
RGJV |
4 |
X |
OPID |
4 |
|
OJVD |
4 |
|
For questions about this report, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2020_CTE_CTPD_TECHNICAL_SKILL_GRADE_<file date>.xls
2020 CTPD Technical Skill Attainment Measure
This report is only distributed to the CTPD Lead Districts. The workbook consists of two tabs and contains the preliminary data used in the calculation of the Technical Skill Attainment measure for the 2019-2020 CTPD Report Card.
Under division (C)(3) of section 3302.03 of the Ohio Revised Code, preliminary 2019-2020 report card grades have been removed from this report as of May 5, 2020. Additional information can be found online.
For questions about this file, contact Kelsey Stephens.
2020_CTE_GRAD_<file date>.xls
2020 CTPD Report Card 4 and 5 Year Graduation Rate Measures
These reports are only distributed to CTPD Lead Districts. The workbook consists of 3 tabs:
2020_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure- Report only Industry-Recognized Credential Elements
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
-
CTPD_ANY_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY19 who obtained at least one Industry-Recognized Credential in the district. The report contains the CTPD IRN, CTPD any credential denominator, numerator and percent as well as the JVSD any credential denominator, numerator and percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY19 who obtained at least twelve Industry-Recognized Credential points within a career field in the district. The report contains the CTPD IRN, CTPD twelve point credential denominator, numerator and percent as well as the JVSD twelve point credential denominator, numerator and percent.
For questions about this file, contact Kelsey Stephens.
2020_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2020 March D Follow-Up Concentrator Credentials Earned
These reports are distributed to the CTPD Member Districts. The 2020D_CTE_INDUSTRY_CREDENTIALS is a student level file that shows all students in the 2020 March D file and any Industry-Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential code and credential description.
For questions about this file, contact Kelsey Stephens.
2020_CTE_LEA_TECH_SKILL_PROGRAM<file date>.xls
2020 CTE Program Technical Skill Attainment
This report is distributed to districts with students in the 2020 March Follow-up Collection (2020D0000). The report contains the CTE program level calculations of Technical Skill Attainment that will appear in the 2020 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information.
The report consists of four tabs:
For questions about this report, contact Kelsey Stephens.
2020_CTE_POST_PLACEMENT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 4 tabs:
- CTPD JVSD POST PLACEMENT: provides the data points and percentages for the CTPD and JVSD for the Post-Program Placement measure. The report consists of the CTPD IRN, CTPD placement denominator, numerator and placement percentage as well as the JVSD placement denominator, numerator and placement percentage.
- CTPD STUDENT LEVEL POST PLACE: provides student-level data on which students are included in the post-program placement measure. The report contains the CTPD IRN, SSID, placement denominator and placement numerator flags.
- CTPD_POST_PROGRAM_GRADE: is a file by CTPD that shows the number of concentrators who left secondary education in FY19 who were reported as placed in the follow-up collection. The file contains the CTPD post-program placement denominator, numerator and rate as well as CTPD status known denominator, status known numerator and status known rate.
- CTPD POST PLACEMENT CATEGORIES: report breaks down the student count and percentage of each placement category (apprenticeship, employment, military and post-secondary training). Depending on what was reported in the 2020D report collection, students may be counted in more than one category. Each percentage is calculated with the ‘post-placement denominator as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement denominator = apprenticeship percentage). The report consists of CTPD IRN, post-placement denominator, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, post-secondary placed, post-secondary percent.
Under division (C)(3) of section 3302.03 of the Ohio Revised Code, preliminary 2019-2020 report card grades have been removed from this report as of May 5, 2020. Additional information can be found online.
For questions about this file, contact Kelsey Stephens.
2020_CTE_POST_PROGRAM_DISTRICT_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure District Detail
These reports are distributed to CTPD Member Districts. The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: report is a student-level file that shows placement status for all concentrators who left secondary education in FY19. The data elements included in the file are reporting LEA IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District. The options in the Post Program Placement are Yes – met the indicator for Post-Program Placement; No – student does not meet indicator.
- DIST_POC_POST_PROGRAM: report is a file by district and CTE program that shows placement of concentrators who left secondary education in FY19 by program of concentration. This information will be used in the Post-Program Placement measure in the 2020 CTE Program Reviews in the CTE-26 system. Visit the CTE Program Review page for additional information. The file contains reporting LEA IRN, CTE program of concentration, district post-placement denominator, numerator, and post-program rate by program of concentration.
- DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY19 that were reported as placed in the follow-up collection. The file contains reporting LEA IRN, district post-placement denominator, numerator, and district post-program placement rate.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY19 that were reported as placed in the follow-up collection. The file contains CTPD post-program placement denominator, numerator and rate, as well as the CTPD status known denominator, numerator, and rate.
Under division (C)(3) of section 3302.03 of the Ohio Revised Code, preliminary 2019-2020 report card grades have been removed from this report as of May 5, 2020. Additional information can be found online.
For questions about this file, contact Kelsey Stephens.
2020_GRAD_Cohort-EOC-Asmnt-Detail_<file date>.xls
2020 Graduating Cohort End of Course Assessment Details
This file contains the highest score and graduation points earned for each End of Course assessment area. The EMIS reporting code for each assessment area is included in the column headers. The assessment date and required test type of this highest score found are listed as well. Students included are those in the 2020 LEA graduation cohort as of current 2019-2020 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Additionally, prior ALT assessments are not included. Only actual assessment scores reported to ODE are included. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2019-2020 school year, they will be added to the report.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2020_GRAD_Cohort-EOC-Path-Req-Stat_<file date>.xls
2020 Graduating Cohort End of Course Pathway Requirements Status
Students in this file match the students in the Detail files. This file includes the highest number of graduation points earned for each assessment area between actual assessments taken and assessment substitutes and exemptions. If no points have been earned in an assessment area, the column will be blank. In addition, each student is evaluated against the total grad points required in Math, ELA, and Social Studies/Science, as well as against the required number of total points across all subjects. Finally, a yes/no field indicates if each of these requirements has been met, and if the student has met all the assessment requirements to graduate using the End of Course pathway. Please note - if a student is reported with out-of-state or homeschool transfer credit, then all points columns will be blank. It is up to the district to keep track of the prorated points for these students and to determine if End of Course Pathway graduation requirements have been met.
For questions about this file, contact Letitia Linville (
Letitia.Linville@education.ohio.gov).
2020_GRAD_Cohort-Non-EOC-Pts-Detail_<file date>.xls
2020 Graduating Cohort End of Course Points from Substitutes and Exemptions
This file contains the highest score and graduation points earned for each End of Course assessment area where a substitute assessment or exemption has been submitted for a student. The EMIS reporting code for each assessment area is included in the column headers. Substitutions could include AP, IB, College Credit Plus, non-public transfers, and high school credit earned in a course before the End of Course assessment was available. Not all substitutes apply to all assessment areas. Students included are those in the 2020 LEA graduation cohort as of current 2019-2020 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. Only actual assessment scores reported to ODE are included; reported course credit alone would not cause points to be earned towards graduation. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2019-2020 school year, they will be added to the report.
In addition to assessment information, students with disabilities who have been exempted from the consequences of an End of Course graduation exam (FE exemption reported) are given three graduation points for each area of exemption. As additional FE exemptions are reported during the 2019-2020 school year in the student enrollment collection, they will be added to the report.
Based on the highest number of graduation points earned via a substitute assessment or special education exemption, the max alternate graduation points for each assessment area are listed.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2020_GRAD_Cohort_SAT-ACT_Path_Req_stat_<file date>.xls
2020 Graduating Cohort ACT/SAT Pathway Details
This file contains the highest score earned for each student across all reported administrations of the ACT and/or SAT. Students included are those in the 2020 LEA graduation cohort as of current 2019-2020 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned for either test. Each student is evaluated against remediation free scores in Reading, Math, and English for the ACT, and Reading, Math, and Writing for the SAT. Finally, a yes/no field indicates if the remediation free requirement on at least one of the two tests has been met.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2020_GRAD_Cohort_WK-IndCred_Path_Req_stat_<file date>.xls
2020 Graduating Cohort Workkeys/Industry Credentials Pathway Details
This file contains the highest score from the Workkeys assessment, as well as information on all industry credentials earned by a student. Students included are those in the 2020 LEA graduation cohort as of current 2019-2020 school year reporting. At this time, students who most recently took an ALT assessment are not included in the file. The column will be blank if no score was earned or no credential obtained. Each student is evaluated against remediation free scores on the Workkeys exam and against a 12 point standard in a single career field for industry credentials. Finally, a yes/no field indicates if the Workkeys and Credentials requirements have been met.
For questions about this file, contact Letitia Linville (Letitia.Linville@education.ohio.gov).
2020_RPTCRD_DPR_Assessment_Pass_Rate_SSIDs_<file date>.xls
Dropout Prevention and Recovery Report Card Assessment Passage Rate Information
This file will be provided periodically throughout the reporting window. It contains two tabs, SSID_Level and Calculation.
The SSID_Level tab specifies which SSIDs are included in the numerator and denominator of the Assessment Passage Rate for Dropout Prevention and Recovery (DPR) Schools. The tab contains the SSID and two additional columns indicating whether the student is included in the numerator and/or denominator of the calculation (SSID_in_Denominator and SSID_in_Numerator). A “Yes” indicates the student was included, and a “No” indicates the student was not included.
The tab Calculation reports the assessment passage rate numerator, denominator, and percentage currently being calculated for DPR schools. The tab contains four columns, ORG_IRN, ALL_TESTS_PCT, ALL_TESTS_TAKEN, and ALL_TEST_PASSED.
For questions about this file, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2020_RPTCRD_Educators_in_your_District_<file date>.xlsx
Report Card Educators in Your District
This report contains the list of Full-Time Equivalents for the categories of the Educators in your District Report Card measure. Districts can use this report to help ensure their Staff reporting is timely and accurate.
2020_RPTCRD_Fund_Type_Expenditures_<filedate>.xls
2020 Building Expenditures by Fund Type (Federal or State/Local)
This file contains district and building level expenditure data for all schools, disaggregated by funding type. Public districts will see two tabs (DIST_BLDG_EXPENDITURES and DIST_EXPENDITURES) with the following columns:
DIST_BLDG_EXPENDITURES
DIST_IRN: The district’s IRN
DIST_NAME: The district’s name
ORG_IRN: The building’s IRN
ORG_NAME: The building’s name
EXP_PER_EQ_PUP_SCH_LVL_TOTAL: The school level spending per pupil
EXP_PER_EQ_PUP_SCH_LVL_FED: The share of school level spending per pupil from federal funds
EXP_PER_EQ_PUP_SCH_LVL_ST_LOC: The share of school level spending per pupil from state and local funds
EXP_PER_EQ_PUP_LEA_SHRE_TOTAL: The school’s share of district level spending per pupil
EXP_PER_EQ_PUP_LEA_SHRE_FED: The school’s share of district level spending per pupil from federal funds
EXP_PER_EQ_PUP_LEA_SHRE_ST_LOC: The school’s share of district level spending per pupil from state and local funds
DIST_EXPENDITURES
DIST_IRN: The district’s IRN
DIST_NAME: The district’s name
EXPND_PER_EQUIV_PUPIL_AMT: The district level spending per pupil
EXP_PER_EQ_PUP_FED: The share of district level spending per pupil from federal funds
EXP_PER_EQ_PUP_ST_LOC: The share of district level spending per pupil from state/local funds
STEM schools, community schools, and dropout prevention and recovery schools (DPR) will also see one tab (BUILDING_EXPENDITURES) with the following columns:
ORG_IRN: The school’s IRN
ORG_NAME: The school’s name
EXP_PER_EQ_PUP_CS_FED: The share of school level spending per pupil from federal funds
EXP_PER_EQ_PUP_CS_ST_LOC: The share of school level spending per pupil from state and local funds
2020_RPTCRD_Prep_for_Success_Detail_<file date>.xls
Report Card Prep for Success
This file contains five tabs for public districts and three tabs for community schools and STEM schools.
Public district files contain four tabs showing summary information (LEA_OUTPUT, LEA_BLDG_OUTPUT, LEA_SUMMARY, and LEA_BLDG_SUMMARY).
- The LEA_OUTPUT tab contains the total points earned (numerator), the total number of students in both cohorts (denominator), the overall PFS percentage, and the preliminary PFS grade.
- The LEA_BLDG_OUTPUT tab contains the same information as the LEA_OUTPUT tab, but it is disaggregated at the building level.
- The LEA_SUMMARY tab contains percentages for the following: ACT participation, ACT remediation-free, SAT participation, SAT remediation-free, IB test scores of 4 or higher, AP test scores of 3 or higher, honors diploma recipients, students meeting the industry credentials requirement, the overall PFS percentage, AP course participation, and IB course participation.
- The LEA_BLDG_SUMMARY tab contains the same information as the LEA_SUMMARY tab, but it is disaggregated at the building level.
- The public district files also contain a tab for SSID-level detail (LEA_DETAIL), which identifies the points earned by each student and whether the student met the following: ACT remediation-free, SAT remediation-free, industry credential requirement, honors diploma, at least 3 dual enrollment credits, score of 3 or higher on an AP test, or score of 4 or higher on an IB test. Districts can filter on the ORG_IRN field if they want to look at data from specific buildings.
The files for community schools and STEM schools contain two tabs with summary information (BLDG_OUTPUT and BLDG_SUMMARY).
- The BLDG_OUTPUT tab contains the same summary information as the LEA_OUTPUT tab in the public district files, as outlined above.
- The BLDG_SUMMARY tab contains the same summary information as the LEA_SUMMARY tab in the public district files, also outlined above.
- The community school and STEM school files also contain one tab with SSID-level data (BLDG_DETAIL). This tab contains the same SSID-level data as the LEA_DETAIL tab in the public district files.
***The preliminary grade is either blank or listed as “NR” in the preliminary files released prior to the closing of the 2019G0000 EMIS collection window because data are subject to change. It is only listed as “NR” for organizations with fewer than 10 students in the measure.
2020_STAFF_Princ_Composites_for2020_Evals_<file date>.xls
Principal Composite reports for use in 2020 Principal Evaluations
The Principal Composite Reports provide local education agencies with the employment data for principals and assistant principals used to create the principal value-added measure. The reports include up-to-three-year composite scores and one-, two-, and three-year building scores based on value-added measures from the one or more buildings where the principals and assistant principals served in these roles during the 2018-2019 school year. The electronic Teacher and Principal Evaluation System (eTPES) now displays three-year principal composites as the default scores. Download and share the Principal Composite files with Superintendents or their designees who complete evaluations for principals and assistant principals.
2020_Student_PBIS_Target_Reductions_<file date>.xls
This file contains baseline prekindergarten through third grade out-of-school suspension and expulsion numbers and target reduction numbers. Ohio law requires districts and community schools to eliminate, by the 2021-2022 school year, out-of-school suspensions and expulsions for students in prekindergarten through grade 3 for offenses that do not pose significant danger to school and student safety. Offenses that pose significant danger are exempt from this requirement. This file only looks at those students reported with a PS3_DSCPLN_REASON_CODE = N.
- Discipline Baseline Count: This is the number of out-of-school suspension and expulsions for students in the district in grades pre-kindergarten through third grade in 2018-2019 school year. This number is used to calculate target reductions for the 2019-2020, 2020-2021, and 2021-2022 school years.
- Discipline Actual Count for 2019-2020 School Year: This is the number of out-of-school suspension and expulsions for students in the district in grades pre-kindergarten through third grade in 2019-2020 school year.
- Target Reduction for 2019-2020 School Year: This number is a 25 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2019-2020 school year.
- Target Reduction for 2020-2021 School Year: This number is a 50 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2020-2021 school year.
- Target Reduction for 2021-2022 School Year: This number is a 75 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2021-2022 school year.
2020_TUITION_EXCESS_COST_<file date>.txt
2020 Excess Cost
This file contains the Certification of Excess Cost pursuant to ORC 3323.14 for the identified reporting period. The certified cost has been determined from the Excess Cost Application filed with the Ohio Department of Education (ODE) and has been calculated as prescribed by ORC 3323.14. The certification should be retained in your files. An adjustment will be made to the educating and resident districts’ state basic aid and will appear as a credit to the educating district and as a deduction to the resident district on the respective districts’ statements of settlement.
2020_TUITION_PER_DIEM_<file date>.txt
2020 Per Diem
This file contains the Certification of Per Diem Cost for Nonresident Pupils Enrolled Pursuant to ORC 3313.64 (C) (4) for the identified reporting period. The certified cost has been determined from the Form SF-14PD filed with Ohio Department of Education (ODE) and has been calculated as prescribed by ORC 3313.64 (C) (4). The certification should be retained in your files. An adjustment will be made to the educating and resident districts' state basic aid and will appear as a credit to the educating district and as a deduction to the resident district on the respective districts' statements of settlement.
2020L_PRIN_ESSA_Licensure_Assurances_<file date>.pdf
ESSA State Licensure Assurances Report
This report assists districts and schools as they work to meet the new federal educator qualification requirements in the Every Student Succeeds Act (ESSA). ESSA requires schools and programs receiving Title I funds to ensure that all teachers and paraprofessionals working in a program supported with these funds meet “applicable State certification and licensure requirements” (ESSA 1112(c)(6)). This Assurances report reflects the State certification and licensure determination for each core academic course. It is based on the EMIS Teacher Licensure Course Status Report that districts received throughout the FY20 Initial Staff and Course (L) Collection. For questions about this report and its purpose, please contact
propercert@education.ohio.gov. For technical questions about reporting, please contact your EMIS Coordinator.
2020S_CTE_ACNTBL_ALL_FY_POC_<file date>.xls
FY2020 CTE Concentrators From All Fiscal Years
This report contains information about students who met CTE Concentrator status in FY20 and in previous fiscal years. Students will be listed in the most recent district in which they were a CTE Concentrator. All CTE Program of Concentrations (POCs) will be listed for the student, regardless of whether the POC was from the reporting district IRN. If the student was a CTE Concentrator in more than one district in a fiscal year, only the POC of the receiving district will be listed for that fiscal year. The report includes the manifest code, reporting lea IRN, level 2 rec type code, reporting fy, ssid, cte program of concentration code, result code, err sev code, ctpd IRN, and ITC short name.
The following result codes indicate if the POC for the row and reporting fiscal year was either 1. reported by a district or 2. determined by ODE. ODE determines the POC when a student is derived as having met CTE Concentrator status in the fiscal year, but no POC was reported in that fiscal year by the district.
Result Code |
Result Description |
CN0007 |
POC reported by district |
CN0008 |
POC determined by ODE |
Districts should use this report to review the students who are being counted as CTE Concentrators and their POC.
2020S_CTE_CTAC-102_ACCNT_FY_POC_MISSING_<FILE DATE>.XLS
CTE ACCOUNTABILITY FY POC MISSING
This report lists students who do not have a CTE Program of Concentration (POC) reported in the current fiscal year in a POC ODE has derived for students having more than one completed Workforce Development course.
- FY: Year the data is being processed.
- RPTING_LEA_IRN: The district IRN of the district that reported the student course.
- SSID: Student State Identifier.
- CTE_PROG_OF_CONCNTRT_CODE: POC generated through either the student's completed courses in the FY or as reported by the district in the FY.
- ALIGNED_COURSE_FLAG: Indicates if the student has an aligned completed course to the POC within the FY.
- MULTI_COURSE_COMPLTD_FLAG: Indicates if since FY18 the student has more than one (1) aligned completed course in the POC.
- ALIGNED_CTE_TECH_ASESMNT_CODE: Reported summative aligned CTE Tech Asesmnt Code.
- PROF_CODE: CTE Technical Assessment Proficiency Code for the POC.
Proficiency Score |
Description |
A |
Advanced |
D |
Did Not Test |
I |
Incomplete |
N |
Not Proficient |
P |
Proficient |
2020S_CTE_CTAC-103_ACCNT_FY_POC_UNEXPT_<FILE DATE>.XLS
CTE ACCOUNTABILITY FY POC UNEXPECTED
This report lists students whose reported CTE Program of Concentration does not align to a CTE Program of Concentration derived by ODE for students having more than one completed Workforce Development course.
- FY: Year the data is being processed.
- RPTING_LEA_IRN: The district IRN that reported the student CTE Program of Concentration.
- SSID: Student State Identifier.
- CTE_PROG_OF_CONCNTRT_CODE: POC generated through either the student completed courses in the FY or as reported by the district in the FY.
- ALIGNED_COURSE_FLAG: Indicates if the student has an aligned completed course to the POC within the FY.
- MULTI_COURSE_COMPLTD_FLAG: Indicates if since FY18 the student has more than one (1) aligned completed course in the POC.
- ALIGNED_CTE_TECH_ASESMNT_CODE: Reported summative aligned CTE Tech Asesmnt Code.
- PROF_CODE: CTE Technical Assessment Proficiency Code for the POC.
Proficiency Score |
Description |
A |
Advanced |
D |
Did Not Test |
I |
Incomplete |
N |
Not Proficient |
P |
Proficient |
2019 File Descriptions
2019A_CTE_CTAC-001_CTE_TECH_ASSMT_<FILE DATE>.xls
File is distributed to all districts that have either
- Reported a CTE Technical Assessment for a Workforce Development course or Program of Concentration or
- Have reported enrollment for a student who should have a CTE Technical Assessment for a Workforce Development course.
Any reported CTE Technical Assessment in a Workforce Development Program of Concentration or course has a row for all potential aligned Programs of Concentration.
- RPTING_LEA_IRN
- SSID
- RESULT_CODE
- RESULT_DESCRIPTION: Description of result code
- ERR_SEV_CODE: Severity
- SUMTV_ASESMNT_CODE: Summative CTE Technical Assessment Code
- SUMTV_SCORE_DERIVE_FLAG: ‘Y/N’ flag indicating the score is derived by ODE
- CTE_PROG_OF_CONCNTRT: Aligned Program of Concentration
- EARLY_INCL_ASESMNT_DATE: Earliest CTE Technical Assessment included
- LAST_INCLD_ASESMNT_DATE: Latest CTE Technical Assessment included
- GY_ASESMNT_COUNT: Count of reported course level technical assessments (GY) that align to that CTE Program of Concentration
- GW_ASESMNT_COUNT: Count of reported industry credentials (GW) that align to a course level of the CTE Program of Concentration
- CCP_COUNT: Count of reported CTE CCP that align to a course level of the CTE Program of Concentration
- PROF_CUT_SCORE: Proficient cut score based on course level CTE tech Assmt reported
- ADVNC_CUT_SCORE: Advanced cut score based on course level CTE tech Assmt reported
- SUM_CTE_TECH_ASESMNT_SCORE: Derived CTE Tech Assmt score for the CTE Program of Concentration
- PROF_CODE: Proficiency Code: I-Incomplete, N-Not Proficient, P-Proficient, A-Advanced, N/A-Not Available
2019_ACCNTBL_Identification_Data_<filedate>
2019 Federal and State Identification Data
Due to the length of this file description, it is being provided as a linked pdf.
2019_ACCNTBL_Identification_Summary_<filedate>
2019 Federal and State Identification Summary
This file contains a maximum total of six tabs for each public district (REMOVED_FROM_FED_LIST, PRIORITY, FOCUS, WARNING, DIST_WATCH, DIST_ORG_WATCH) and a maximum of two tabs for each community school or STEM school (REMOVED_FROM_FED_LIST_ORG, PRIORITY_ORG, FOCUS_ORG, WARNING_ORG, WATCH_ORG).
DISTRICT FILES
- The REMOVED_FROM_FED_LIST tab contains the column REMOVED_FROM, which identifies the federal list from which the school was completely removed because of progress from 2018 to 2019.
- The PRIORITY tab contains the data item PRIORITY_CRITERIA, which indicates the method by which the building was identified as Priority in 2018.
- The FOCUS and WARNING tabs contain columns for each of the subgroups and whether the building is on the list, not on the list, or was removed from the list for that subgroup because it met the criteria for removal.
- The DIST_WATCH tab contains columns for each of the subgroups and whether the district was identified for that subgroup (Watch Area), eligible and not identified (Not on Watch), or not eligible for that subgroup (Not Eligible).
- The DIST_ORG_WATCH tab contains the same information for the district’s buildings.
- The PRIORITY, FOCUS, WARNING and DIST_ORG_WATCH tabs contain the column ORG_STATUS, which indicates whether the building is open or closed in OEDS (all closed buildings were open during the 2017-18 school year).
COMMUNITY SCHOOL/STEM SCHOOL FILES
Community schools and STEM schools that were identified on one of the federal lists in 2018 and are still on that list will see one of three tabs (PRIORITY_ORG, FOCUS_ORG or WARNING_ORG). These tabs contain the same information as the PRIORITY, FOCUS and WARNING tabs in the public district files, as specified above.
Any school that was identified in 2018 and met criteria for removal from the entire list (only from Focus or Warning) will see the tab REMOVED_FROM_FED_LIST_ORG, and it will specify which list the school was removed from.
All community schools and STEM schools will see the tab WATCH_ORG, which contains columns for each of the subgroups and whether the school was identified for that subgroup (Watch Area), eligible and not identified (Not on Watch), or not eligible for that subgroup (Not Eligible).
2019_CCP_ESCALATED_COURSE_<file date>.xls
2019 CCP Courses Escalated to ODE
This report contains information about CCP courses that have been escalated to ODE for resolution. The report includes course information reported by the college such as the course ID, course name, section ID, year, term, delivery method, credit hour code, and credit hour count. The report will also show any reviews placed on the course by the district, the date of the escalation, the Area Coordinator Region number assigned to the district, and the date on which the data was pulled. These reports allow districts and colleges to see in one place all CCP courses that have been escalated to ODE.
2019_CCP_NON_PAYMENT_<file date>.xls
2019 CCP Courses not Approved for Payment
This report contains information about CCP courses that have not been approved for payment. The report includes course information reported by the college such as the course ID, course name, section ID, year, term, delivery method, credit hour code, and credit hour count. The report will also show any reviews placed on the course by the district as well as the date on which the data was pulled. This report does not include courses that are found on the CCP_BAD_DATA report as those courses are not evaluated for payment until the bad data is corrected. The types of courses displayed on the report include the following:
- courses that are flagged with a review that stops funding
- courses that have not been approved or flagged but are still within the review window (i.e. have not yet aged out)
Districts and colleges should use these reports to reconcile any differences in reporting that result in non-payment of a course. For example, a college reports the wrong district IRN which results in the district placing a “NOT_ENROLLED” flag on the course.
2019_CTE_6S1 _<file date>.xls
CTPD Report Card Nontraditional Participation (6S1) Measure
These reports are only distributed to CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD 6S1: contains the preliminary nontraditional participation (6S1) numerator, denominator and rate for the CTPD.
- CTPD STUDENT LEVEL 6S1: contains preliminary student level detail for the CTPD. If the student is a nontraditional participant and counts in the numerator “YES” is indicated in the NON_TRADITIONAL_PARTICIPATION column. If the student is not a nontraditional participant and they do not count in the numerator “NO” is indicated in the NON_TRADITIONAL_PARTICIPATION column.
2019_CTE_ACHIEVEMENT_COMPONENT_<file date>.xls
2019 CTPD Achievement Component
This report is only distributed to the CTPD Lead Districts. The report contains the rates and points for the Technical Skill and Performance Index measures that are included in the Achievement component. While included in the report, the Performance Index measure is ungraded for 2018-2019. As a result, Performance Index points and weights are not applicable. Technical Skill Attainment is the only measure included in the calculation of the Achievement Component Grade for the 2018-2019 report card.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019_CTE_CTPD_CAREER_PS_READY_COMPONENT_<file date>.xls
2019 CTPD Career & Post-Secondary Readiness Component
This report is only distributed to the CTPD Lead District. This report contains the rates and points for the Career and Post-Secondary Readiness measure.
- The SUMMARY tab contains the total points earned (numerator), the total number of students in the 4-year graduation cohorts (denominator), the overall percentage, grade and component points earned.
- The DETAIL_OUTPUT tab contains ‘Y’, ‘N’ flags for each component of the Career and Post-Secondary measure as well as points earned for each SSID included in the measure. Components included are: ACT remediation-free, SAT remediation-free, Honors Diploma awarded, 12 Industry Credential points within a career field, Ohio Means Job Readiness Seal awarded, IB test scores of 4 or higher, AP test scores of 3 or higher, CTAG status met, proficient on a CTE Summative Assessment, 4 Industry Credential points within a career field, 4 CTE courses within a pathway, 3 or more dual enrollment credits, and total points awarded.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019_CTE_CTPD_GRADUATION_COMPONENT_<file date>.xls
2019 CTPD Graduation Component
This report is only distributed to the CTPD Lead District. The workbook contains the rates and points for the 4-year Graduation Rate and 5-year Graduation Rate as well as the calculation of the Graduation Component grade.
For questions about this file, contact Kelsey Stephens (kelsey.stephens@education.ohio.gov).
2019_CTE_CTPD_OVERALL_GRADE_<file date>.xls
2019 CTPD Overall Grade
This report is only distributed to the CTPD Lead Districts. The workbook contains point assignments for the Achievement, Career & Post-Secondary Readiness, Graduation and Post-Program Outcomes components as well as the calculation of the overall grade for the 2018-2019 CTPD Report Card.
For questions about this file, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2019_CTE_CTPD_PERFORMANCE_INDEX_<file date>.xls
2019 CTPD Performance Index Measure
This report is only distributed to the CTPD Lead Districts. The workbook consists of three tabs and contains the data used in the calculation of the Performance Index (PI) measure for the 2018-2019 CTPD Report Card.
- The CTPD_PERFORMANCE_INDEX tab provides the CTPD-level PI calculations by proficiency level, including final PI points and percentage.
- The CTPD_PI_UNIQUE_SSID tab provides a CTPD-level list of the SSIDs and assessment results included in the CTPD PI calculation.
- The CTPD_PI_LEA_SSID tab provides an LEA-level list of the SSIDs and assessment results included in the CTPD PI calculation. The LEA IRN listed is the LEA in which the student was considered a CTE Concentrator in 2018-2019 based on the Perkins V definition of a CTE Concentrator. Students may be listed in more than one LEA per CTPD if they met Perkins V Concentrator status in more than one LEA in the year.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019_CTE_CTPD_TECHNICAL_SKILL_GRADE_<file date>.xls
2019 CTPD Technical Skill Attainment Measure
This report is only distributed to the CTPD Lead Districts. The workbook consists of two tabs and contains the data used in the calculation of the Technical Skill Attainment measure for the 2018-2019 CTPD Report Card.
- The CTPD_TECHNICAL_SKILL_PARTIC tab provides the CTPD-level technical skill participation calculations including numerator, denominator, and rate.
- The CTPD_TECHNICAL_SKILL_ATTAIN tab provides the CTPD and JVSD-level technical skill attainment calculations including numerator, denominator, rate, and CTPD preliminary and final grades.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019_CTE_LEA_TECH_SKILL_PROGRAM_20190925_<file date>.xls
2019 CTE Program Technical Skill Attainment
This report is distributed to districts with students in the 2019 March Follow-up Collection (2019D0000). This report contains the CTE program level calculations of Technical Skill Attainment that will appear in the 2019 CTE Program Reviews. Visit the CTE Program Review page for additional information.
The report consists of four tabs:
- The LEA_POC_TECH_SKILL_PARTIC tab contains the CTE program level calculations of the Technical Skill Participation rate.
- The LEA_POC_TECH_SKILL_PARTIC_DETAIL tab contains SSID level detail for program Technical Skill Participation rates.
- The LEA_POC_TECH_SKILL_PASS tab contains CTE program level calculations of the Technical Skill Passage rate.
- The LEA_POC_TECH_SKILL_PASS_DETAIL tab contains SSID level detail for program Technical Skill Passage rates.
For questions about this report, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019_DPR_MAP_Participation_Rate_SSIDs_<file date>.xls
NWEA MAP Participation Rate Information for Fall and Spring
This file contains two tabs (FALL_PARTICIPATION and SPRING_PARTICIPATION) specifying which SSIDs were included in the numerator and denominator of the NWEA MAP participation rates for Dropout Prevention and Recovery (DPR) Schools. Each tab contains the SSID and two additional columns indicating whether the student was included in the numerator and/or denominator of the calculation (IN_FALL_DENOMINATOR and IN_FALL_NUMERATOR in the FALL_PARTICIPATION tab; IN_SPRING_DENOMINATOR and IN_SPRING_NUMERATOR in the SPRING_PARTICIPATION tab). A “Y” indicates the student was included and an “N” indicates the student was not included.
2019_GRAD_Cohort-EOC-Asmnt-Detail_<file date>.xls
2019 Graduating Cohort End of Course Assessment Details
This file contains the highest score and graduation points earned for each End of Course assessment area. The EMIS reporting code for each assessment area is included in the column headers. The assessment date and required test type of this highest score found are listed as well. Students included are those in the 2019 LEA graduation cohort as of the end of 2016-17 school year reporting. At this time, ALT assessments are not included. Only actual assessment scores reported to ODE are included. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2017-18 school year, they will be added to the report.
2019_GRAD_Cohort-EOC-Path-Req-Stat_<file date>.xls
2019 Graduating Cohort End of Course Pathway Requirements Status
Students in this file match the students in the Detail files. This file includes the highest number of graduation points earned for each assessment area between actual assessments taken and assessment substitutes and exemptions. If no points have been earned in an assessment area, the column will be blank. In addition, each student is evaluated against the total grad points required in Math, ELA, and Social Studies/Science, as well as against the required number of total points across all subjects. Finally, a yes/no field indicates if each of these requirements has been met, and if the student has met all the assessment requirements to graduate using the End of Course pathway.
2019_GRAD_Cohort-Non-EOC-Pts-Detail_<file date>.xls
2019 Graduating Cohort End of Course Points from Substitutes and Exemptions
This file contains the highest score and graduation points earned for each End of Course assessment area where a substitute assessment or exemption has been submitted for a student. The EMIS reporting code for each assessment area is included in the column headers. Substitutions could include AP, IB, College Credit Plus, non-public transfers, and high school credit earned in a course before the End of Course assessment was available. Not all substitutes apply to all assessment areas. Students included are those in the 2019 LEA graduation cohort as of the end of 2016-17 school year reporting. Only actual assessment scores reported to ODE are included; reported course credit alone would not cause points to be earned towards graduation. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2017-18 school year, they will be added to the report.
In addition to assessment information, students with disabilities who have been exempted from the consequences of an End of Course graduation exam (FE exemption reported) are given three graduation points for each area of exemption. As additional FE exemptions are reported during the 2017-18 school year in the student enrollment collection, they will be added to the report.
Based on the highest number of graduation points earned via a substitute assessment or special education exemption, the max alternate graduation points for each assessment area are listed.
2019_GRAD_Cohort_SAT-ACT_Path_Req_stat_<file date>.xls
2019 Graduating Cohort ACT/SAT Pathway Details
This file contains the highest score earned for each student across all reported administrations of the ACT and/or SAT. The column will be blank if no score was earned for either test. Each student is evaluated against remediation free scores in Reading, Math, and English for the ACT, and Reading, Math, and Writing for the SAT. Finally, a yes/no field indicates if the remediation free requirement on at least one of the two tests has been met.
2019_GRAD_Cohort_WK-IndCred_Path_Req_stat_<file date>.xls
2019 Graduating Cohort Workkeys/Industry Credentials Pathway Details
This file contains the highest score from the Workkeys assessment, as well as information on all industry credentials earned by a student. The column will be blank if no score was earned or no credential obtained. Each student is evaluated against remediation free scores on the Workkeys exam and against a 12 point standard in a single career field for industry credentials. Finally, a yes/no field indicates if the Workkeys and Credentials requirements have been met.
2019_PBIS_Compliance_Measure _<file date>.xls
Positive Behavior Intervention Support (PBIS) Implementation Stage Compliance Measure
This file is distributed to public districts, community schools, and STEM schools. The workbook consists of 2 tabs:
- LEA_DETAIL:
- Get a “YES" flag if all its schools have a B, C, D, E, or F code reported.
- Get a "NO" flag if any school has an "A" reported or if any school had no code reported for this element.
- ORG_DETAIL or CS_DETAIL:
- Get a "YES" flag if it has a code of B, C, D, E, or F.
- Get a "NO" Flag if it has a code of "A" or if no record is reported in EMIS.
For questions about this report, contact Adam Schiming (
Adam.Schiming@education.ohio.gov).
2019_RPTCRD_Chronic_Absenteeism_<file date>.xls
Report Card Chronic Absenteeism
This file contains four tabs for public districts (DIST_SUMMARY, DIST_DETAIL, BLDG_SUMMARY, and BLDG_DETAIL) and two tabs for STEM schools and community schools (ORG_SUMMARY and ORG_DETAIL).
The DIST_SUMMARY and BLDG_SUMMARY/ORG_SUMMARY tabs include the CHRONIC_ABSNT_NUMER, which is the sum of all student FTEs for those students who had at least 100 possible attendance hours and were absent for at least 10% of those hours. They also include the CHRONIC_ABSNT_DENOM, which is the sum of all student FTEs for those students who had at least 100 possible attendance hours, and the CHRONIC_ABSNT_PCT, which is the overall chronic absenteeism percentage. These tabs also include the same data for the 2017-2018 school year (CHRONIC_ABSNT_NUMER_LY, CHRONIC_ABSNT_DENOM_LY, and CHRONIC_ABSNT_LY) to show the year-to-year change in the chronic absenteeism percentage.
The DIST_DETAIL and BLDG_DETAIL/ORG_DETAIL tabs contain SSID-level data for the 2018-19 school year. They include total attendance hours (ATTND_HOURS_COUNT), absent and unauthorized absent hour counts (ABSNT_HOURS_COUNT, UNAUTH_ABSNT_HOURS_COUNT), total absent hours (TOTAL_ABSNT_HOURS), total possible attendance hours (TOTAL_HOURS), absent percentage (ABSNT_PCT), and the student’s FTE (STDNT_BASE_FTE).
NOTE: Students who are accountable at a building in another district (e.g., for special education services) are included in the home district’s BLDG_DETAIL tab showing the receiving district’s building IRN. These students are factored into the calculation for the accountable building, but are not included in the receiving district’s BLDG_DETAIL tab. This is a result of how the files are generated.
2019_RPTCRD_CTE_GRAD_<file date>.xls
2019 CTPD Report Card 4 and 5 year Graduation Rate Measures
These reports are only distributed to CTPD Lead Districts. The workbook consists of 3 tabs:
- CTPD JVSD GRAD: contains preliminary data for the CTPD and JVSD 4 year and 5 year graduation rates. This report contains the CTPD 4 and 5 year graduation rate numerator, denominator, rate and grade, CTPD graduation component grade, and the JVSD 4 and 5 year graduation rate numerator, denominator and rate.
- CTPD STUDENT LEVEL 4YR_GRAD: contains preliminary student level data for the CTE 4 year graduation rate. The report identifies which SSIDs are included in the CTE 4 year graduation rate calculation. “NO” in the CTPD_4YR_GRAD_NUM indicates the student is not counting as a graduate in the CTPD 4 year graduation rate.
- CTPD STUDENT LEVEL 5YR_GRAD: contains preliminary student level data for the CTE 5 year graduation rate. The report identifies which SSIDs are included in the CTE 5 year graduation rate calculation. “NO” in the CTPD_5YR_GRAD_NUM indicates the student is not counting as a graduate in the CTPD 5 year graduation rate.
2019_RPTCRD_DPR_Assessment_Pass_Rate_SSIDs_<file date>.xls
Dropout Prevention and Recovery Report Card Assessment Passage Rate Information
This file contains one tab (ASSESSPASS_SSIDS) specifying which SSIDs are included in the numerator and denominator of the Assessment Passage Rate for Dropout Prevention and Recovery (DPR) Schools. The tab contains the SSID and two additional columns indicating whether the student is included in the numerator and/or denominator of the calculation (SSID_in_Denominator and SSID_in_Numerator). A “Yes” indicates the student was included and a “No” indicates the student was not included. For questions about this report, please contact Karlyn Geis (
Karlyn.Geis@education.ohio.gov).
2019_RPTCRD_EL_Progress_Measure_File_<file date>.xls
2019_RPTCRD_EL_Progress_Measure_File
English Learner Progress is new to the Gap Closing calculations for the 2018 report card. This file contains two tabs for public districts (LEA_DETAIL and SCH_DETAIL), and one tab for STEM schools and community schools (SCH_DETAIL). The LEA_DETAIL and SCH_DETAIL tabs contain SSID-level data that includes the SCHOOL_YEAR, SSID, BASELINE_GRADE_LEVEL – which is the student’s grade level when baseline was established, BASELINE_SCORE - which is the student’s baseline OELPA score, EL_EXMPT_COUNT - which is the student’s total number of exemptions, IMPRV_PTS_NUMBER - which are the number of improvement points needed for the student to meet the Growth Target, EL_PROF_COUNT – tells whether or not the student scored a proficient score on the OELA and EL_GROWTH_COUNT – tells whether or not the student met the growth target. For questions about this report, contact Adam Schiming.
2019_RPTCRD_Fund_Type_Expenditures_<filedate>.xls
2019 Building Expenditures by Fund Type (Federal or State/Local)
This file contains building-level expenditure data for all schools, disaggregated by funding type. These data are being reported for the first time on the 2019 Local Report Cards. Public districts will see one tab (DISTRICT_EXPENDITURES) with the following columns:
- DIST_IRN: The district’s IRN
- DIST_NAME: The district’s name
- ORG_IRN: The building’s IRN
- ORG_NAME: The building’s name
- EXP_PER_EQ_PUP_SCH_LVL_TOTAL: The total school level spending per pupil
- EXP_PER_EQ_PUP_SCH_LVL_FED: The share of school level spending per pupil from federal funds
- EXP_PER_EQ_PUP_SCH_LVL_ST_LOC: The share of school level spending per pupil from state and local funds
- EXP_PER_EQ_PUP_LEA_SHRE_TOTAL: The school’s total share of district level spending per pupil
- EXP_PER_EQ_PUP_LEA_SHRE_FED: The school’s share of district level spending per pupil from federal funds
- EXP_PER_EQ_PUP_LEA_SHRE_ST_LOC: The school’s share of district level spending per pupil from state and local funds
STEM schools, community schools, and dropout prevention and recovery schools (DPR) will also see one tab (BUILDING_EXPENDITURES) with the following columns:
- ORG_IRN: The school’s IRN
- ORG_NAME: The school’s name
- EXP_PER_EQ_PUP_CS_FED: The share of school level spending per pupil from federal funds
- EXP_PER_EQ_PUP_CS_ST_LOC: The share of school level spending per pupil from state and local funds
For questions about this file, contact Jim Long (
James.Long@education.ohio.gov).
2019_RPTCRD_Prep_for_Success_Detail_<file date>.xls
Report Card Prep for Success
This file contains five tabs for public districts and three tabs for community schools and STEM schools. Public district files contain four tabs showing summary information (LEA_OUTPUT, LEA_BLDG_OUTPUT, LEA_SUMMARY, and LEA_BLDG_SUMMARY).
- The LEA_OUTPUT tab contains the total points earned (numerator), the total number of students in both cohorts (denominator), the overall PFS percentage, and the preliminary PFS grade.
- The LEA_BLDG_OUTPUT tab contains the same information as the LEA_OUTPUT tab, but it is disaggregated at the building level.
- The LEA_SUMMARY tab contains percentages for the following: ACT participation, ACT remediation-free, SAT participation, SAT remediation-free, IB test scores of 4 or higher, AP test scores of 3 or higher, honors diploma recipients, students meeting the industry credentials requirement, the overall PFS percentage, AP course participation, and IB course participation.
- The LEA_BLDG_SUMMARY tab contains the same information as the LEA_SUMMARY tab, but it is disaggregated at the building level.
- The public district files also contain a tab for SSID-level detail (LEA_DETAIL), which identifies the points earned by each student and whether the student met the following: ACT remediation-free, SAT remediation-free, industry credential requirement, honors diploma, at least 3 dual enrollment credits, score of 3 or higher on an AP test, or score of 4 or higher on an IB test. Districts can filter on the ORG_IRN field if they want to look at data for specific buildings.
The files for community schools and STEM schools contain two tabs with summary information (BLDG_OUTPUT and BLDG_SUMMARY).
- The BLDG_OUTPUT tab contains the same summary information as the LEA_OUTPUT tab in the public district files, as outlined above.
- The BLDG_SUMMARY tab contains the same summary information as the LEA_SUMMARY tab in the public district files, also outlined above.
- The community school and STEM school files also contain one tab with SSID-level data (BLDG_DETAIL). This tab contains the same SSID-level data as the LEA_DETAIL tab in the public district files.
Note. The preliminary grade is either blank or listed as “NR” in the preliminary files released prior to the closing of the 2018G0000 EMIS collection window because data are subject to change. It is only listed as “NR” for organizations with fewer than 10 students in the measure.
2019_STAFF_Equitable_Access_Analysis_Tool_<file date>.xls
2019 Equitable Access Analysis Tool for CCIP Planning
The Equitable Access Analysis Tool provides local education agencies with student and staffing data from 2017-2018 to engage in the FY19 local equitable access planning requirement in the CCIP. The tool provides data in a Microsoft Excel file that can be sorted for analysis purposes. The tool includes student measures, educator measures, and the Educator Workforce Strength Index. The Equitable Access Analysis Tool provides data at the state, district, and building levels. The tool allows educators to identify where, and to what extent, any inequities in access to excellent educators exist. Download and share the tool with appropriate staff (for example, Superintendent, Federal Programs Coordinators, Human Resources, and those who engage in federal programs planning process). Visit the local equity planning page for more information.
2019_STAFF_Princ_Composites_for2019_Evals_<file date>.xls
Principal Composite reports for use in 2019 Principal Evaluations
The Principal Composite Reports provide local education agencies with the employment data for principals and assistant principals that were used to create the principal value-added measure. The reports include up-to-two year composite scores and one- and two-year building scores based on value-added measures from the one or more buildings where the principals and assistant principals served in these roles during the 2017-2018 school year. The electronic Teacher and Principal Evaluation System (eTPES) now displays two-year principal composites as the default scores. Download and share the Principal Composite files with Superintendents or their designees who complete evaluations for principals and assistant principals.
2019_Student_PBIS_Target_Reductions_<file date>.xls
This file contains baseline prekindergarten through third grade out-of-school suspension and expulsion numbers and target reduction numbers. Ohio law requires districts and community schools to eliminate, by the 2021-2022 school year, out-of-school suspensions and expulsions for students in prekindergarten through grade 3 for offenses that do not pose significant danger to school and student safety. Offenses that pose significant danger are exempt from this requirement.
This report contains the following:
- PS3_DSCPLN_REASON_CODE: This is the code (N) assigned for out-of-school suspension and expulsions that are not exempt because these offenses do not pose significant danger to school and student safety.
- PS3_DSCPLN_REASON_DESCR: N: Neither exemptions apply. These are offenses that are not exempt because these offenses do not pose significant danger to school and student safety.
- Discipline Baseline Count: This is the number of out-of-school suspension and expulsions for students in the district in grades pre-kindergarten through third grade in 2018-2019 school year. This number is used to calculate target reductions for the 2019-2020, 2020-2021, and 2021-2022 school years.
- Target Reduction for 2019-2020 School Year: This number is a 25 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2019-2020 school year.
- Target Reduction for 2020-2021 School Year: This number is a 50 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2020-2021 school year.
- Target Reduction for 2021-2022 School Year: This number is a 75 percent reduction from the baseline number. Districts must reduce their out-of-school suspensions and expulsions for pre-kindergarten through third grade to this number to be in compliance with Ohio law for the 2021-2022 school year.
2019D_CTE_1S1_<file date>.xls
2019 March D Follow-Up Academic Attainment Reading (1S1) Indicator
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD JVSD 1S1 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Reading (1S1) indicator. This report contains: CTPD IRN, CTPD 1S1 den, CTPD 1S1 num, CTPD 1S1 percent, JVSD 1S1 den, JVSD 1S1 num, JVSD 1S1 percent.
- CTPD STUDENT LEVEL 1S1: report gives data on which students are included in the Academic Achievement-Reading (1S1) indicator. This report consists of CTPD IRN, SSID, CTPD student level 1S1 den, CTPD student level 1S1 num.
For questions about this report, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019D_CTE_1S2_<file date>.xls
2019 March D Follow-Up Academic Attainment Math (1S2) Indicator
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD JVSD 1S2 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Math (1S2) indicator. This report contains: CTPD IRN, CTPD 1S2 den, CTPD 1S2 num, CTPD 1S2 percent, JVSD 1S2 den, JVSD 1S2 num, JVSD 1S2 percent.
- CTPD STUDENT LEVEL 1S2: report gives data on which students are included in the Academic Achievement-Math (1S2) indicator. This report consists of CTPD IRN, SSID, CTPD student level 1S2 den, CTPD student level 1S2 num.
For questions about this report, contact Kelsey Stephens (Kelsey.Stephens@education.ohio.gov).
2019D_CTE_IC_<file date>.xls
CTPD Report Card Post-Program Outcomes Measure
- CTPD ANY INDUSTRY CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY18 who obtained at least one industry credential in the district. This report contains ctpd irn, ctpd any ic den, ctpd any ic num, ctpd any ic percent, jvsd any ic den, jvsd any ic num and jvsd any ic percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of CTE Concentrators who left secondary education in FY18 who obtained at least 12 industry credential points within a career field in the district. This report contains reporting ctpd irn, ctpd 12pts ic den, ctpd 12pts ic num, ctpd 12pts ic percent, jvsd 12pts ic den, jvsd 12pts ic num and jvsd 12pts ic percent.
For questions about this file, contact Kelsey Stephens (
Kelsey.Stephens@education.ohio.gov).
2019D_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2019 March D Follow-Up Concentrator Credentials Earned
The 2019D_CTE_INDUSTRY_CREDENTIALS report is a student level file that shows all students in the 2019 March D file and any Industry Recognized Credentials earned by each student. The report contains reporting LEA IRN, SSID, industry credential code and credential description.
2019D_CTE_POST_PLACEMENT_<file date>.xls
2019 March D Follow-Up Post-Placement Measures
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 4 tabs:
- CTPD JVSD POST PLACEMENT: report gives data points and percentages for the CTPD and JVSD for the post-placement measure. Report consists of CTPD IRN, CTPD post placement den, CTPD post placement num, CTPD post placement percent, JVSD post placement den, JVSD post placement num, JVSD post placement percent.
- CTPD STUDENT LEVEL POST PLACE: report gives data on which students are included in the post-placement measures. Report consists of CTPD IRN, SSID, CTPD post-placement den, CTPD post-placement num.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY18 that were reported as placed in the follow-up collection. The file contains CTPD post-placement denominator, CTPD post-placement numerator, CTPD post-program rate, CTPD status known denominator, CTPD status known numerator, CTPD status known rate, and CTPD post program grade.
- CTPD POST PLACEMENT CATEGORIES: report breaks down the student count and percentage of each placement category (apprenticeship, employment, military and post-secondary training). Depending on what was reported in the 2019D report collection, students may be counted in more than one category. Each percent is calculated with the ‘post-placement den’ as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement den = apprenticeship percent). Report consists of CTPD IRN, post-placement den, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, post-secondary placed, post-secondary percent.
2019D_CTE_POST_PROGRAM_DISTRICT_<file date>.xls
2019D March D Follow-Up Concentrator Post-Program Comprehensive
The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: report is a student level file that shows placement status for all concentrators who left secondary education in FY18. The data elements included in the file are reporting IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District. The options in the Post Program Placement are Yes – met the indicator for Post Program Placement; No – student does not meet indicator.
- DIST_POC_POST_PROGRAM: report is a file by district that shows placement of concentrators who left secondary education in FY18 by program of concentration. This information will be used as the Post-Program measure in the Quality Program Review in the CTE 26. The file contains reporting IRN, program of concentration, district post-placement denominator by program of concentration, district post-placement numerator by program of concentration, and district post-program rate by program of concentration.
- DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY18 that were reported as placed in the follow-up collection. The file contains reporting IRN, district post-placement denominator, district post-placement numerator, and district post-program rate.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY18 that were reported as placed in the follow-up collection. The file contains CTPD post-placement denominator, CTPD post-placement numerator, CTPD post-program rate, CTPD status known denominator, CTPD status known numerator, CTPD status known rate, and CTPD post program grade.
2019D_CTE_SECON_COMPL_< file date>.xls
2019 March D Follow-Up Secondary Completion (3S1) Measure
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD SECOND COMPLETION: contains preliminary data for the CTPD and JVSD secondary completion (3S1) measure. The report contains the CTPD and JVSD numerator, denominator and rate.
- CTPD STUDENT LEVEL SECON COMPL: contains preliminary student level data for the CTE secondary completion (3S1) measure. The report identifies which SSIDs are included in the CTE secondary completion calculation. “NO” in the CTPD_3S1_NUM indicates the student is not counting in the numerator of the completion measure.
2019D_CTE_Tech_Assmt_<file date>.xml
2019 March D Follow-Up Concentrator District Technical Assessment
Report is a student level file that shows if the assessments taken by concentrators who left secondary education in FY18 align to any of their programs of concentration listed on the 2019D file. The file contains the following columns:
- RPTING_LEA_IRN,
- SSID,
- CTE_PROG_OF_CONCNTRT_CODE: program of concentration in the 2019MarchD file,
- CTE_PROG_OF_CONCNTRT_FY: FY of the program of concentration in the 2019MarchD file,
- PATHWAY_TECH_ASSMT: reported pathway technical assessment,
- PATHWAY_TECH_ASSMT_ALIGNMENT: alignment status for the student and their reported pathway technical assessment,
- PATHWAY TECH ASSMT ALIGNED means the student had reported an aligned pathway technical assessment
- NOT ALIGNED PATHWAY TECH ASSMT means the student had reported a pathway technical assessment but it was not aligned to the reported program of concentrations
- NO PATHWAY TECH ASSMT means no pathway technical assessment was reported for the student.
- COUNT_ALIGNED_COURSE_GY: count of reported course level GY technical assessments that aligned to that CTE Program of Concentration, and
- COUNT_ALIGNED_COURSE_GW: count of reported industry credentials (GW) that align to a course level of the CTE Program of Concentration
- IRN: reporting districts IRN, only needed for ODE for file
2019D_CTE_Tech_Assmt_Part_<file date>.xml
2019 MarchD Follow-Up Concentrator District Technical Assessment
Report is a student level file that shows if the assessments taken by concentrators who left secondary education in FY18 align to the chosen programs of concentration listed on the 2019D file. The file contains the following columns:
- RPTING_LEA_IRN,
- SSID,
- CTE_PROG_OF_CONCNTRT_CODE: chosen program of concentration in the 2019MarchD file,
- POC_FY: FY of the program of concentration in the 2019MarchD file,
- TECH_ASSMT_PART: Flag indicating if the student is to be included in the CTE Technical Assessment Participation Numerator,
- IRN: reporting districts IRN, only needed for ODE for file.
2019D_CTE_Tech_Assmt_Prof_<file date>.xml
2019 MarchD Follow-Up Concentrator District Technical Assessment Proficiency
Report is a student level file that shows if the aligned CTE Technical Assessments taken by concentrators who left secondary education in FY18, students in 2019D0000, was reported with a proficient score. At this time, only reported pathway technical assessments are being examined for proficiency. The file contains the following columns:
- RPTING_LEA_IRN,
- SSID,
- CTE_PROG_OF_CONCNTRT_CODE: chosen program of concentration in the 2019MarchD file,
- POC_FY: FY of the program of concentration in the 2019MarchD file,
- TECH_ASSMT_PROF: Flag indicating if the student's reported pathway technical assessment is proficient (P = Proficient, N = Not-Proficient),
- IRN: reporting districts IRN, only needed for ODE for file.
2019D_CTPD_CTE_Tech_Assmt_<file date>.xml
2019 MarchD Follow-Up Concentrator CTPD Technical Assessment
File is distributed to the lead district of each CTPD only. Report is a comprehensive student level file for all districts within a CTPD, that shows if the assessments taken by concentrators who left secondary education in FY18 align to any of their programs of concentration listed on the 2019D file. The file contains the following columns:
- RPTING_LEA_IRN,
- SSID,
- CTE_PROG_OF_CONCNTRT_CODE: program of concentration in the 2019MarchD file,
- CTE_PROG_OF_CONCNTRT_FY: FY of the program of concentration in the 2019MarchD file,
- PATHWAY_TECH_ASSMT: reported pathway technical assessment,
- PATHWAY_TECH_ASSMT_ALIGNMENT: alignment status for the student and their reported pathway technical assessment,
- PATHWAY TECH ASSMT ALIGNED means the student had reported an aligned pathway technical assessment
- NOT ALIGNED PATHWAY TECH ASSMT means the student had reported a pathway technical assessment but it was not aligned to the reported program of concentrations
- NO PATHWAY TECH ASSMT means no pathway technical assessment was reported for the student.
- COUNT_ALIGNED_COURSE_GY: count of reported course level GY technical assessments that aligned to that CTE Program of Concentration, and
- COUNT_ALIGNED_COURSE_GW: count of reported industry credentials (GW) that align to a course level of the CTE Program of Concentration
- IRN: CTPD lead district IRN, only needed for ODE for file distribution
2019L_CTE_CTPD_ENROLL_BY_LEA_<file date>.xls
CTPD Report Card Enrollment
This report shows CTPD member district summary information for the ungraded Enrollment measure. The member district summary includes a list of the member districts and the student enrollment count for the CTPD from each district. Please note there is a district named “OTHER” for each CTPD. If the district in which the student is counting back to was not one of the CTPD member districts that student is counted in the “OTHER” district.
Students may be counted in more than one of a CTPD's member districts in the member district summary. In the CTPD Headcount of Students Participating in Career-Technical Courses on the report card students will be unduplicated at the CTPD level and only counted once.
The table below explains the business rules on which district a student is counted back to:
DISTRICT WHERE STUDENT COUNTS FOR CTE ENROLLMENT |
FTE FUND PATTERN CODE |
ORG TYPE |
HOW RECEIVED ELEMENT |
District reporting the CTE course |
COMM |
6 |
|
STEM |
60 |
|
RGJV |
1 |
Not equal to 'X' |
CTCR |
1 |
|
OPDD |
1 |
|
How Received IRN' reported for the student |
CTOP |
1 OR 4 |
|
CTID |
1 OR 4 |
|
CTVC |
1 OR 4 |
|
SPCO |
1 |
|
JVNR |
4 |
|
OJVR |
4 |
|
Students' legal district of residence |
RGJV |
4 |
Not equal to 'X' |
OTHER' district |
RGJV |
1 |
X |
RGJV |
4 |
X |
OPID |
4 |
|
OJVD |
4 |
|
For questions about this report, contact Melissa Maynard (
Melissa.Maynard@education.ohio.gov).
2019L_CTE_ENROLL_BY_SSID_<file date>.xls
CTE Report Card District Enrollment
This report is an SSID level report to both the educating LEA and the district IRN in which the student is counted back for Number of Students in Each District Participating in Career-Technical Courses report card measure. Report consists of:
- REPORT_IRN: IRN of the district receiving the report
- CTPD_IRN: CTPD_IRN that the student is counted toward
- SSID: SSID of the student
- EDUCATING_IRN: IRN of the district(s) providing CTE course for the student. If more than one district provided CTE education for the student it will state ‘MORE THAN 1’.
- EDUCATED_IN_MY_IRN: Flag indicates if the student was educated by the district receiving the report.
- ENROLLED_IRN: IRN of the district(s) the student is counting back to. If the student is counted back to more than one district it will state ‘MORE THAN 1’.
- ENROLLED_IN_MY_IRN: Flag indicates if the student is counting back to the district receiving the report.
- ETHNIC_CODE
- LEP_CODE
- DISAB_CNDTN_CODE
- ECON_DISADV_FLAG
The table below explains the business rules on which district a student is counted back to:
DISTRICT WHERE STUDENT COUNTS FOR CTE ENROLLMENT |
FTE FUND PATTERN CODE |
ORG TYPE |
HOW RECEIVED ELEMENT |
District reporting the CTE course |
COMM |
6 |
|
STEM |
60 |
|
RGJV |
1 |
Not equal to 'X' |
CTCR |
1 |
|
OPDD |
1 |
|
How Received IRN' reported for the student |
CTOP |
1 OR 4 |
|
CTID |
1 OR 4 |
|
CTVC |
1 OR 4 |
|
SPCO |
1 |
|
JVNR |
4 |
|
OJVR |
4 |
|
Students' legal district of residence |
RGJV |
4 |
Not equal to 'X' |
OTHER' district |
RGJV |
1 |
X |
RGJV |
4 |
X |
OPID |
4 |
|
OJVD |
4 |
|
For questions about this report, contact Melissa Maynard (Melissa.Maynard@education.ohio.gov).
2019L_PRIN_ESSA_Licensure_Assurances_<file date>.pdf
ESSA State Licensure Assurances Report
This report assists districts and schools as they work to meet the new federal educator qualification requirements in the Every Student Succeeds Act (ESSA). ESSA requires schools and programs receiving Title I funds to ensure that all teachers and paraprofessionals working in a program supported with these funds meet “applicable State certification and licensure requirements” (ESSA 1112(c)(6)). This Assurances report reflects the State certification and licensure determination for each core academic course. It is based on the EMIS Teacher Licensure Course Status Report that districts received throughout the FY19 Initial Staff and Course (L) Collection. For questions about this report, contact Chris Worth (
Chris.Worth@education.ohio.gov).
2018 File Descriptions
2018_CTE_6S1 _<file date>.xls
CTPD Report Card Enrollment
The file contains 2 tabs for CTPD (CTPD_6S1 and CTPD_STUDENT_LEVEL_6S1). These reports show CTPD summary information and student-level detail by CTPD. The summary tabs includes the non-traditional participation numerator, denominator and percentage. The student level detail by CTPD shows if each SSID is a non-traditional participant. If the students is a non-traditional participant and counts in the numerator then a “YES” is indicated in the NON_TRADITIONAL_PARTICIPATION column. if the student is not a non-traditional participant and they do not count in the numerator than a “NO” is indicated in the NON_TRADITIONAL_PARTICIPATION column.
2018_CTE_6S2 _<file date>.xls
CTPD Report Card Enrollment
The file contains 2 tabs for CTPD (CTPD_6S2 and CTPD_STUDENT_LEVEL_6S2). These reports show CTPD summary information and student-level detail by CTPD. The district summary tabs includes the non-traditional completion numerator, denominator and percentage. The student level detail by CTPD shows if each SSID is a non-traditional completer. If the students is a non-traditional completer and counts in the numerator then a “YES” is indicated in the NON_TRADITIONAL_COMPLETION column. If the student is not a non-traditional completer and they do not count in the numerator than a “NO” is indicated in the NON_TRADITIONAL_ COMPLETION column.
2018_CTPD_ENROLLMENT _<file date>.xls
CTPD Report Card Enrollment
The file contains 2 tabs for CTPD (CTE_CTPD_ENROLLMENT and CTPD_MEM_DIST_ENROLLMENT). These reports show CTPD member district summary information and student-level detail by CTPD for the ungraded Enrollment measure. The member district summary tabs includes a list of the member districts and the student enrollment count for the CTPD from each district. Please note there is a district named “OTHER” for each CTPD. If a student’s legal district of residence or attending Community or STEM school was not one of the CTPD member districts or if a student had multiple reported legal district of residence that student is counted in the “OTHER” district. The student level detail by CTPD shows by SSID what member district each student is counted back to.
2018_CTPD_IND_MET_RETAKE _<file date>.xls
CTPD Report Card End of Course Improvement Indicator
The End of Course Improvement Indicator is new to the 2018 report card. The report shows summary and student-level detail by CTPD. This report is distributed to the CTPD Lead Districts and consist of 2 tabs:
- CTPD_RETAKE_SUMMARY: The summary tab includes the overall percentage of assessments where students scored at least one proficiency level higher and indicates whether the CTPD met the indicator.
- CTPD_RETAKE_DETAIL: The detail tab includes each SSID and assessment the CTPD was accountable for, as well as a field indicating the proficiency level achieved on the retake in comparison to the previous administration.
2018_CTPD_TECH_ACHIEV_<file date>.XLS
CTPD Report Card Technical Component Grade
These reports are being distributed to the CTPD Lead Districts.
The file contains all of the variables that factor into the CTE Technical Achievement measure:
CTPD Technical Assessment Participation Percent, CTPD Technical Assessment Attain Percent, Flag indicating if the CTPD Technical Assessment Attain Percent is demoted based on the CTPD Technical Assessment Participation Percent, CTPD Technical Assessment Adjusted Percent, CTPD Technical Attainment Points, CTPD Indicator Met Percent, CTPD Technical Achievement Grade.
2018_EL_Progress_Measure_File_<file date>.xls
2018_EL_Progress_Measure_File
English Learner Progress is new to the Gap Closing calculations for the 2018 report card. This file contains two tabs for public districts (LEA_DETAIL and SCH_DETAIL), and one tab for STEM schools and community schools (SCH_DETAIL). The LEA_DETAIL and SCH_DETAIL tabs contain SSID-level data that includes the SCHOOL_YEAR, SSID, BASELINE_GRADE_LEVEL – which is the student’s grade level when baseline was established, BASELINE_SCORE - which is the student’s baseline OELPA score, EL_EXMPT_COUNT - which is the student’s total number of exemptions, IMPRV_PTS_NUMBER - which are the number of improvement points needed for the student to meet the Growth Target, EL_PROF_COUNT – tells whether or not the student scored a proficient score on the OELA and EL_GROWTH_COUNT – tells whether or not the student met the growth target.
2018_GRAD_Cohort-EOC-Asmnt-Detail_<file date>.xls
2018 Graduating Cohort End of Course Assessment Details
This file contains the highest score and graduation points earned for each End of Course assessment area. The EMIS reporting code for each assessment area is included in the column headers. The assessment date and required test type of this highest score found are listed as well. Students included are those in the 2018 LEA graduation cohort as of the end of 2015-16 school year reporting. At this time, ALT assessments are not included. Only actual assessment scores reported to ODE are included. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2016-17 school year, they will be added to the report.
2018_GRAD_Cohort-EOC-Path-Req-Stat_<file date>.xls
2018 Graduating Cohort End of Course Pathway Requirements Status
Students in this file match the students in the Detail files. This file includes the highest number of graduation points earned for each assessment area between actual assessments taken and assessment substitutes and exemptions. If no points have been earned in an assessment area, the column will be blank. In addition, each student is evaluated against the total grad points required in Math, ELA, and Social Studies/Science, as well as against the required number of total points across all subjects. Finally, a yes/no field indicates if each of these requirements has been met, and if the student has met all the assessment requirements to graduate using the End of Course pathway.
2018_GRAD_Cohort-Non-EOC-Pts-Detail_<file date>.xls
2018 Graduating Cohort End of Course Points from Substitutes and Exemptions
This file contains the highest score and graduation points earned for each End of Course assessment area where a substitute assessment or exemption has been submitted for a student. The EMIS reporting code for each assessment area is included in the column headers. Substitutions could include AP, IB, College Credit Plus, non-public transfers, and high school credit earned in a course before the End of Course assessment was available. Not all substitutes apply to all assessment areas. Students included are those in the 2018 LEA graduation cohort as of the end of 2015-16 school year reporting. Only actual assessment scores reported to ODE are included; reported course credit alone would not cause points to be earned towards graduation. Scores are included regardless of which LEA reported the scores to ODE. If a student does not have an actual score reported for an assessment area, the columns for that assessment area will be blank. As additional assessments are reported during the 2016-17 school year, they will be added to the report.
In addition to assessment information, students with disabilities who have been exempted from the consequences of an End of Course graduation exam (FE exemption reported) are given three graduation points for each area of exemption. As additional FE exemptions are reported during the 2016-17 school year in the student enrollment collection, they will be added to the report.
Based on the highest number of graduation points earned via a substitute assessment or special education exemption, the max alternate graduation points for each assessment area are listed.
2018_GRAD_Cohort_SAT-ACT_Path_Req_stat_<file date>.xls
2018 Graduating Cohort ACT/SAT Pathway Details
This file contains the highest score earned for each student across all reported administrations of the ACT and/or SAT. The column will be blank if no score was earned for either test. Each student is evaluated against remediation free scores in Reading, Math, and English for the ACT, and Reading, Math, and Writing for the SAT. Finally, a yes/no field indicates if the remediation free requirement on at least one of the two tests has been met.
2018_GRAD_Cohort_WK-IndCred_Path_Req_stat_<file date>.xls
2018 Graduating Cohort Workkeys/Industry Credentials Pathway Details
This file contains the highest score from the Workkeys assessment, as well as information on all industry credentials earned by a student. The column will be blank if no score was earned or no credential obtained. Each student is evaluated against remediation free scores on the Workkeys exam and against a 12 point standard in a single career field for industry credentials. Finally, a yes/no field indicates if the Workkeys and Credentials requirements have been met.
2018_Identification_Data_<file date>
2018 Federal and State Identification Data
This file contains a maximum of 19 tabs for each public district and a maximum of 15 tabs for each community school and STEM school (no buildings were eligible for Focus or Warning for the American Indian/Alaskan Native subgroup). The tabs contain information for all districts/buildings eligible for identification for that list and/or subgroup. Each tab indicates whether the district/building was or was not identified based on the data used. The following tabs outline the data columns included in each tab.
- FEDERAL_GRAD_RATE
- GRAD_COUNT: The number of students in the numerator of the federal graduation rate calculation
- TOTAL_COUNT: The number of students in the denominator of the federal graduation rate calculation
- GRAD_PCT: The federal graduation rate
- PRIORITY_GRAD: Indicates whether the building was identified as Priority due to graduation rate
- PRIORITY_DATA
- OVERALL_COMPOSITE: Overall composite score for 2018, based on all graded measures for the building
- OVERALL_GRADE: Overall letter grade for 2018, based on composite score
- PRIORITY_SCHOOL_RANKING: Building’s Priority ranking based on composite score
- TOTAL_RANKED: Total number of buildings eligible for Priority ranking
- PRIORITY_STATUS: Indicates whether the building was identified as Priority due to ranking
- FOCUS_<Subgroup Name>
- ORG_COMPOSITE_17: Overall composite score for the subgroup for 2017
- ORG_COMPOSITE_18: Overall composite score for the subgroup for 2018
- PRIORITY_COMPOSITE_17: Overall composite score for all Priority schools for 2017
- PRIORITY_COMPOSITE_18: Overall composite score for all Priority schools for 2018
- GAP_CLOSING_17: Gap Closing component grade for 2017
- GAP_CLOSING_18: Gap Closing component grade for 2018
- FOCUS_RANK_18: Building’s overall ranking based on 2018 composite score for the subgroup
- TOTAL_RANKED: Total number of buildings ranked for the subgroup
- FOCUS_STATUS: Indicates whether the building was identified as Focus for the subgroup
- WARNING_STATUS: Indicates whether the building was identified as Warning for the subgroup
- DIST_WATCH_<Subgroup Name> / ORG_WATCH_<Subgroup Name>
- ELA_PI: ELA Performance Index score for the subgroup in 2018
- ELA_STDNT_COUNT: Number of students included in the ELA PI score calculation in 2018
- VA_ELA: One-year value-added gain score in ELA for the subgroup in 2018
- VA_ELA_COUNT: Number of students included in the ELA value-added score for the subgroup in 2018
- ELA_SUBGRP_PTS: Number of ELA AMO improvement points in 2018
- MATH_PI: Math Performance Index score for the subgroup in 2018
- MATH_STDNT_COUNT: Number of students included in the Math PI score calculation in 2018
- VA_MATH: One-year value-added gain score in Math for the subgroup in 2018
- VA_MATH_COUNT: Number of students included in the Math value-added score for the subgroup in 2018
- MATH_SUBGRP_PTS: Number of Math AMO improvement points in 2018
- ELA_PI_AVG: State’s average ELA Performance Index score for the subgroup in 2018
- MATH_PI_AVG: State’s average Math Performance Index score for the subgroup in 2018
- WATCH_<Subgroup Name>: Indicates whether the district/building was identified for Watch status for the subgroup
2018_Identification_Lists_Summary_Final_<file date>
2018 Federal and State Identification Summary
This file contains a maximum total of six tabs for each public district (DIST_SUMMARY, PRIORITY, FOCUS, WARNING, DIST_WATCH, DIST_ORG_WATCH) and a maximum of two tabs for each community school or STEM school (PRIORITY_ORG, FOCUS_ORG, WARNING_ORG, WATCH_ORG). All buildings included in this file were identified for at least one of the lists. Districts that are not identified as Watch and have no buildings identified as Priority, Focus, Warning or Watch will still receive a file with the DIST_SUMMARY tab. Community schools and STEM schools not identified on any lists will not receive a file.
The DIST_SUMMARY tab contains the following data items:
- IDENTIFICATION: The district’s overall identification
- DISTRICT_WATCH_STATUS: Indicates whether the district was identified for Watch status for at least one subgroup
- LRC_RATE_DESCR: The district’s overall grade on the 2018 Report Card
- GRAD_RATE_4YR: The district’s 4-year graduation rate, as reported on the 2018 Report Card
- GAP_CLOSING_18: The district’s Gap Closing component grade for 2018
- GAP_CLOSING_17: The district’s Gap Closing component grade for 2017
- PRIORITY_COUNT: The number of identified Priority schools within the district’s hierarchy
- FOCUS_COUNT: The number of identified Focus schools within the district’s hierarchy
- WARNING_COUNT: The number of identified Warning schools within the district’s hierarchy
The PRIORITY tab contains the data item PRIORITY_CRITERIA, which indicates the method by which the building was identified as Priority. The FOCUS, WARNING and DIST_ORG_WATCH tabs contain columns for each of the subgroups and whether the building was identified for that subgroup. The DIST_WATCH tab contains columns for each of the subgroups and whether the district was identified for that subgroup. The PRIORITY, FOCUS, WARNING and DIST_ORG_WATCH tabs contain the column ORG_STATUS, which indicates whether the building is open or closed in OEDS (all closed buildings were open during the 2017-18 school year).
Community schools and STEM schools that are identified on one of the federal lists will see one of three tabs (PRIORITY_ORG, FOCUS_ORG, or WARNING_ORG). These tabs contain the same information as the PRIORITY, FOCUS and WARNING tabs in the public district files, as specified above. Any community school or STEM school identified as Watch will see the tab WATCH_ORG, which contains the same information as the DIST_ORG_WATCH tab in the public district files, as specified above.
2018_Identification_Lists_Summary_Initial_<file date>
Identification Lists
This file contains a maximum total of four tabs for each public district (DIST_SUMMARY, PRIORITY, FOCUS, WARNING) and one tab for each community school or STEM school (PRIORITY_ORG, FOCUS_ORG, or WARNING_ORG). Districts will only receive a file if at least one of their buildings was identified as Priority, Focus, or Warning. Community schools and STEM schools will only receive a file if the building was identified as Priority, Focus, or Warning.
The DIST_SUMMARY tab contains the following data items:
- IDENTIFICATION: The district’s overall identification
- LRC_RATE_DESCR: The district’s overall grade on the 2018 Report Card
- GRAD_RATE_4YR: The district’s 4-year graduation rate, as reported on the 2018 Report Card
- GAP_CLOSING_18: The district’s Gap Closing component grade for 2018
- GAP_CLOSING_17: The district’s Gap Closing component grade for 2017
- PRIORITY_COUNT: The number of identified Priority schools within the district’s hierarchy
- FOCUS_COUNT: The number of identified Focus schools within the district’s hierarchy
- WARNING_COUNT: The number of identified Warning schools within the district’s hierarchy
The PRIORITY tab contains the data item PRIORITY_CRITERIA, which indicates the method by which the building was identified as Priority. The FOCUS and WARNING tabs contain columns for each of the subgroups and whether the building was identified for that subgroup. The PRIORITY, FOCUS, and WARNING tabs contain the column ORG_STATUS, which indicates whether the building is open or closed in OEDS (all closed buildings were open during the 2017-18 school year).
Community schools and STEM schools that are identified on one of the lists will see one of three tabs (PRIORITY_ORG, FOCUS_ORG, or WARNING_ORG). These tabs contain the same information as the PRIORITY, FOCUS, and WARNING tabs in the public district files, as specified above.
Note: A subsequent release of files will include information on Watch identification. These files will be named 2018_Identification_Lists_Summary_Final_<filedate> and will include information on districts and buildings identified as Watch.
2018_RPTCRD_Chronic_Absenteeism_<file date>.xls
Report Card Chronic Absenteeism
The Chronic Absenteeism Indicator is new to the 2018 report card. This file contains four tabs for public districts (DIST_SUMMARY, DIST_DETAIL, BLDG_SUMMARY, and BLDG_DETAIL) and two tabs for STEM schools and community schools (BLDG_SUMMARY and BLDG_DETAIL).
The DIST_SUMMARY and BLDG_SUMMARY tabs include the CHRONIC_ABSNT_NUMER, which is the sum of all student FTEs for those students who had at least 100 possible attendance hours and were absent for at least 10% of those hours. They also include the CHRONIC_ABSNT_DENOM, which is the sum of all student FTEs for those students who had at least 100 possible attendance hours, and the CHRONIC_ABSNT_PCT, which is the overall chronic absenteeism percentage. These tabs also include the same data for the 2016-2017 school year (CHRONIC_ABSNT_NUMER_LY, CHRONIC_ABSNT_DENOM_LY, and CHRONIC_ABSNT_LY) to show the year-to-year change in the chronic absenteeism percentage.
The DIST_DETAIL and BLDG_DETAIL tabs contain SSID-level data for the 2017-18 school year. They include total attendance hours (ATTND_HOURS_COUNT), absent and unauthorized absent hour counts (ABSNT_HOURS_COUNT, UNAUTH_ABSNT_HOURS_COUNT), total absent hours (TOTAL_ABSNT_HOURS), total possible attendance hours (TOTAL_HOURS), absent percentage (ABSNT_PCT), and the student’s FTE (STDNT_BASE_FTE).
NOTE: Students who are accountable at a building in another district (e.g. for special education services) are included in the home district’s BLDG_DETAIL tab showing the receiving district’s building IRN. These students are factored into the calculation for the accountable building, but are not included in the receiving district’s BLDG_DETAIL tab. This is a result of how the files are generated.
2018_RPTCRD_CTE_GRAD_<file date>.xls
2018 Report Card 4 and 5 yr. Grad Measures
- CTPD JVSD GRAD: report gives data points and percentages for the CTPD and JVSD 4yr. and 5 yr. grad rate. This report contains: ctpd irn, grad 4yr den, grad 4 yr num, grad 4 yr percent, grad 4yr grade, jvsd 4yrgrad den, jvsd 4yr grad num, jvsd 4yrgrad percent, grad 5yr den, grad 5yr num, grad 5yr percent, grad 5yr grade, jvsd 5yrgrad den, jvsd 5yrgrad num, jvsd 5yrgrad percent, component grade
- CTPD STUDENT LEVEL 4YRGRAD: report consists of the student level data for the CTE 4yr. grad rate. Reports identifies which SSID are included in the CTE 4yr. Grad calculation. Report consists of ctpd irn, dist irn, ssid, ctpd 4yr grad den, ctpd 4yr grad num.
- CTPD STUDENT LEVEL 5YRGRAD: report consists of the student level data for the CTE 5yr. grad rate. Reports identifies which SSID are included in the CTE 5yr. Grad calculation. Report consists of ctpd irn, dist irn, ssid, ctpd 5yr grad den, ctpd 5yr grad num.
2018_RPTCRD_CTPD_Indicators_Detail_<file date>.xls
CTPD Report Card Indicators Met
These reports are being distributed to the CTPD Lead Districts and consist of 3 tabs:
- INDICATOR CTPD ROLLUP: The rollup tab includes the aggregated number of applicable indicators met, number of applicable indicators, indicator met percentage and indicators met grade.
- CTPD TEST SUBJCT SUMMARY: The summary tab includes aggregated number of test passes, aggregated number of tests taken, proficient percentage, indicator status.
- CTPD TEST SUBJCT DETAIL: The detail tab is a student level report by subject that shows if a student was proficient and tested in that subject.
2018_RPTCRD_CTPD_Prep_for_Success_Detail_<file date>.xls
CTPD Report Card Prep for Success
This file contains 2 tabs for Career Tech Planning Districts. These reports show the summary information as well as the SSID level detail by CTPD, lead district IRN, and reporting district IRN (CTPD_OUTPUT, CTPD_DETAIL). The Prep for Success measure includes students reported as concentrators from both the 4 and 5 year graduation cohorts. These reports show all the variables that factor into the Prep for Success grade calculation: ACT remediation free, SAT remediation free, Industry Credentials Earned (at least 12 points in a career field), earned an Honors diploma, Dual Enrollment credit (at least 3 hours earned), AP test score, and IB test score. Based on these values the total initial points and bonus points earned are shown by SSID.
2018_RPTCRD_DPR_Assessment_Pass_Rate_SSIDs_<file date>
Dropout Prevention and Recovery Report Card Assessment Passage Rate Information
This file contains one tab (ASSESSPASS_SSIDS) specifying which SSIDs are included in the numerator and denominator of the Assessment Passage Rate for Dropout Prevention and Recovery (DPR) Schools. The tab contains the SSID and two additional columns indicating whether the student is included in the numerator and/or denominator of the calculation (SSID_in_Denominator and SSID_in_Numerator). A “Yes” indicates the student was included and a “No” indicates the student was not included. For questions about this report, please contact Karlyn Geis (Karlyn.Geis@education.ohio.gov).
2018_RPTCRD_EOC_Improvement_Indicator_<file date>.xls
Report Card End of Course Improvement Indicator
The End of Course Improvement Indicator is new to the 2018 report card. This file contains 4 tabs for public districts (LEA_SUMMARY, LEA_DETAIL, BLDG_SUMMARY, and BLDG_DETAIL) and 2 tabs for STEM schools and community schools (BLDG_SUMMARY/DORP SUMMARY, BLDG_DETAIL/DORP_DETAIL). These reports show summary information and student-level detail by district and building. The summary tabs include the overall percentage of assessments where students scored at least one proficiency level higher and indicate whether the district or building met the indicator based on preliminary data. The detail tabs include each SSID and assessment the district or building was accountable for, as well as a field indicating the proficiency level achieved on the retake in comparison to the previous administration.
2018_RPTCRD_Prep_for_Success_Detail_<file date>.xls
Report Card Prep for Success
This file contains 3 tabs for public districts and 2 tabs for community schools. These reports show the summary information by district or community school (LEA_OUTPUT, BLDG_SUMMARY) as well as public school (LEA_BUILDING_SUMMARY). These reports also show all the variables that factor into Prep for Success calculation: ACT remediation free, SAT remediation free, Industry Credential Earned (at least 12 points in a career field), earned an Honors diploma, Dual Enrollment credit (at least 3 hours earned), AP test score and IB test score. Based on these values the total initial points and bonus points earned are shown by SSID.
2018_STAFF_Equitable_Access_Analysis_Tool_<file date>.xls
2018 Equitable Access Analysis Tool for CCIP Planning
The Equitable Access Analysis Tool provides local education agencies with student and staffing data from 2016-2017 to engage in the FY18 local equitable access planning requirement in the CCIP. The tool provides data in a Microsoft Excel file that can be sorted for analysis purposes. The tool includes student measures, educator measures, and the Educator Workforce Strength Index. The Equitable Access Analysis Tool provides data at the state, district, and building levels. The tool allows educators to identify where, and to what extent, any inequities in access to excellent educators exist. Download and share the tool with appropriate staff (for example, Superintendent, Federal Programs Coordinators, Human Resources, and those who engage in federal programs planning process). Visit the local equity planning page for more information.
2018_STAFF_Princ_Composites_for2018_Evals_<file date>.xls
Principal Composite reports for use in 2018 Principal Evaluations
The Principal Composite Reports provide local education agencies with the employment data for principals and assistant principals that were used to create the principal value-added measure. The reports include composite scores and one-year building scores based on value-added measures from the one or more buildings where the principals and assistant principals served in these roles during the 2016-2017 school year. The electronic Teacher and Principal Evaluation System (eTPES) now displays principal composites as the default scores. Download and share the Principal Composite files with Superintendents or their designees who complete evaluations for principals and assistant principals.
2018A_CTE_CTPD_TECH_ASSMT_<FILE DATE>
2019 MarchD Follow-Up Concentrator CTPD technical assessment
File is distributed to the lead district of each CTPD only. Report list CTE technical assessment participation: denominator, numerator, and rate, CTE technical assessment passage: denominator, numerator, and rate for the districts in the CTPD and total for the CTPD.
For questions about this report, contact Melissa Maynard (
Melissa.Maynard@education.ohio.gov).
2018A_CTE_TECH_ASSMT_<FILE DATE>
2019 MarchD Follow-Up Concentrator district technical assessment
Report is a student level file that shows if the aligned CTE Technical Assessments taken by concentrators who left secondary education in FY18, students in 2019D0000. Report contains the districts CTPD_IRN, rpting_lea_irn, ssid, Tech_assmt_part: this indicates if the student took the required aligned technical assessment, tech_assmt_pass: this indicates if the student was proficient if they took the required aligned technical assessment.
For questions about this report, contact Melissa Maynard (
Melissa.Maynard@education.ohio.gov).
2018D_CTE_CTPD_TECH_ASSMNT_<file date>.xls
2018 March D Follow-Up Concentrator CTPD Technical Achievement
CTPD_DETAIL_TECH_ASSMNT_PART: report is a comprehensive student level file of all of the students that fall under the CTPD, that shows if the assessments taken by concentrators who left secondary education in FY17 align to their program of concentration. This information will be used as Technical Skill Participation measure on the CTE Report Card. The file contains CTPD IRN, member district IRN, SSID, reported program of concentration, technical assessment, alignment status for the student and lead district IRN. ALIGNED TECHNICAL ASSESSMENT means the student took the correct assessment; NOT ALIGNED TECHNICAL ASSESSMENT means the student took an assessment but it was not aligned to the reported program of concentrations; NO TECHNICAL ASSESSMENT means no assessment was reported for the student.
2018D_CTE_IC_<file date>.XLS
- CTPD ANY INDUSTRY CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of students who obtained at least one industry credential and who left secondary education in FY16. This report contains ctpd irn, ctpd any ic den, ctpd any ic num, ctpd any ic percent, jvsd any ic den, jvsd any ic num and jvsd any ic percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of students who obtained at least 12 industry credential points. This report contains reporting ctpd irn, ctpd 12pts ic den, ctpd 12pts ic num, ctpd 12pts ic percent, jvsd 12pts ic den, jvsd 12pts ic num and jvsd 12pts ic percent.
2018D_CTE_INDUSTRY_CREDENTIAL_<file date>.xls
2018 March D Follow-Up Concentrator Credentials Earned
The 2018D_CTE_INDUSTRY_CREDENTIALS report is a student level file that shows all Industry Recognized Credentials earned by all students in the 2018 March D file. The report contains reporting IRN, SSID, credential code, and credential description.
2018D_CTE_POST_PLACEMENT_<file date>.xls
2018 March D Follow-Up Post-Placement Measures
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 3 tabs:
- CTPD JVSD POST PLACEMENT: report gives data points and percentages for the CTPD and JVSD for the post-placement measure. Report consists of CTPD IRN, CTPD post placement den, CTPD post placement num, CTPD post placement percent, JVSD post placement den, JVSD post placement num, JVSD post placement percent.
- CTPD STUDENT LEVEL POST PLACE: report gives data on which students are included in the post-placement measures. Report consists of CTPD IRN, SSID, CTPD post-placement den, CTPD post-placement num.
- CTPD POST PLACEMENT CATEGORIES: report breaks down the student count and percentage of each post-placement category (apprenticeship, employment, military and post-secondary training). Depending on what was reported in the 2018D report collection students may be counted in more than one category. Each category percent is calculated with the ‘post-placement den’ as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement den = apprenticeship percent). Report consists of CTPD IRN, post-placement den, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, post-secondary placed, post-secondary percent.
2018D_CTE_POST_PROGRAM_COMP_<file date>.xls
2018D March D Follow-Up Concentrator Post-Program Comprehensive
The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: report is a student level file that shows Placement reported status for all concentrators who left secondary education in FY17. The data elements included in the file are reporting IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District; or UNREPORTED – No Post Program information has been reported for this SSID in EMIS. The options in the Post Program Placement are Yes – met the indicator for Post Program Placement; No – student does not meet indicator; or blank if no data has been reported for that SSID.
- DIST_POC_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY17 by program of concentration that reported participation in one of the activities in the CTE Follow-Up Survey. This information will be used as the Post-Program measure in the Quality Program Review in the CTE 26. The file contains reporting IRN, program of concentration, district post-placement denominator by program of concentration, district post-placement numerator by program of concentration and district post-program rate by program of concentration.
- DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY17 that reported participation in one of the activities in the CTE Follow-Up Survey. The file contains reporting IRN, district post-placement denominator, district post-placement numerator and district post-program rate.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY17 that reported participation in one of the activities in the CTE Follow-Up Survey. The file contains reporting IRN, CTPD post-placement denominator, CTPD post-placement numerator, CTPD post-program rate, CTPD status known denominator, CTPD status known numerator, CTPD status known rate, CTPD post program grade and the district IRN of the file.
2018D_CTE_SECON_COMPL_< file date>.xls
2018 March D Follow-Up Secondary Completion (3S1) Indicator
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD SECOND COMPLETION: report gives data points and percentages for the CTPD and JVSD secondary completion (3S1) indicator. This report contains: CTPD IRN, CTPD 3S1 den, CTPD 3S1 num, CTPD 3S1 percent, JVSD 3S1 den, JVSD 3S1 num, JVSD 3S1 percent.
- CTPD STUDENT LEVEL SECON COMPL: report gives data on which students are included in the secondary completion (3S1) indicator. Report consists of: CTPD IRN, SSID, CTPD 3S1 den, CTPD 3S1 num.
2018D_CTE_TECH_ASSMNT_<file date>.xls
2018 March D Follow-Up Concentrator Technical Achievement
DETAIL_TECH_ASSMNT_PART: report is a student level file that shows if the assessments taken by concentrators who left secondary education in FY17 align to their program of concentration. This information will be used as Technical Skill Participation measure on the CTE Report Card. The file contains reporting IRN, SSID, reported program of concentration, and alignment status for the student. ALIGNED TECHNICAL ASSESSMENT means the student took the correct assessment; NOT ALIGNED TECHNICAL ASSESSMENT means the student took an assessment but it was not aligned to the reported program of concentrations; NO TECHNICAL ASSESSMENT means no assessment was reported for the student.
2018D_CTE_1S1_1S2_<file date>.xls
2018 March D Follow-Up Academic Attainment (1S1 and 1S2) indicators
These reports are only distributed to the CTPD Lead Districts. The workbook consist of 4 tabs:
- CTPD JVSD 1S1 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Reading (1S1) indicator. This report contains: CTPD IRN, CTPD 1S1 den, CTPD 1S1 num, CTPD 1S1 percent, JVSD 1S1 den, JVSD 1S1 num, JVSD 1S1 percent.
- CTPD STUDENT LEVEL 1S1: report gives data on which students are included in the Academic Achievement-Reading (1S1) indicator. This report consists of CTPD IRN, SSID, CTPD student level 1S1 den, CTPD student level 1S1 num.
- CTPD JVSD 1S2 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Math (1S2) indicator. This report contains: CTPD IRN, CTPD 1S2 den, CTPD 1S2 num, CTPD 1S2 percent, JVSD 1S2 den, JVSD 1S2 num, JVSD 1S2 percent.
- CTPD STUDENT LEVEL 1S2: report gives data on which students are included in the Academic Achievement-Math (1S2) indicator. This report consists of CTPD IRN, SSID, CTPD student level 1S2 den, CTPD student level 1S2 num.
2018D_CTPD_Industry_Credential_<file date>.xls
2018 March D Follow-Up Concentrator Credentials Earned
CTPD INDUSTRY CREDENTIAL report is a student level file that shows all Industry Recognized Credentials earned by all students in the 2018 March D file. The report contains reporting CTPD IRN, DIST IRN, SSID, credential code, and credential description.
2017 File Descriptions
2017_CTE_TECHNICAL_ACHIEVEMENT_<file date>.xls
CTPD Report Card Technical Achievement Components
These reports are being distributed to the CTPD Lead Districts.
The file contains all of the variables that factor into the CTE Technical Achievement measure: CTE Technical Assessment Participation Percent, CTE Technical Assessment Passage Percent, CTE Technical Assessment Adjusted Percent, CTE Technical Attainment Grade, CTE Technical Attainment Points, Indicators Met Percent, Indicators Met Grade, Indicator Met Points, Total Technical Achievement Points, Technical Achievement Component Grade.
2017_RPTCRD_CTPD_Indicators_Detail_<file date>.xls
CTPD Report Card Indicators Met
These reports are being distributed to the CTPD Lead Districts and consist of 4 tabs:
- INDICATOR CTPD ROLLUP: report is a summary level report that shows aggregated number of applicable indicators met, number of applicable indicators, indicator met percentage and indicators met grade.
- CTPD TEST SUBJCT SUMMARY: report is a subject level report that shows aggregated number of test passes, aggregated number of tests taken, proficient percentage, indicator status.
- CTPD TEST SUBJCT DETAIL: report is a student level report by subject level that shows if a student was proficient and tested in that subject.
- SSID PARTICIPANT LIST: report is a student level report by each reporting LEA IRN in which a student was identified as a participant. Student counts once at each CTPD IRN in which they were identified.
2017_RPTCRD_CTPD_Prep_for_Success_Detail_<file date>.xls
CTPD Report Card Prep for Success
This file contains 2 tabs for Career Tech Planning Districts. These reports show the summary information as well as the SSID level detail by CTPD, lead district IRN, and reporting district IRN (CTPD_OUTPUT, CTPD_DETAIL). The Prep for Success measure includes students reported as concentrators from both the 4 and 5 year graduation cohorts. These reports show all the variables that factor into Prep for Success grade calculation: ACT remediation free, SAT remediation free, Industry Credential Earned (at least 12 points in a career field), earned an Honors diploma, Dual Enrollment credit (at least 3 hours earned), AP test score, and IB test score. Based on these values the total initial points and bonus points earned are shown by SSID.
2017_RPTCRD_Prep_for_Success_Detail_<file date>.xls
Report Card Prep for Success
This file contains 3 tabs for public districts and 2 tabs for community schools. These reports show the summary information by district or community school (LEA_OUTPUT, BLDG_SUMMARY) as well as public school (LEA_BUILDING_SUMMARY). These reports also show all the variables that factor into Prep for Success calculation: ACT remediation free, SAT remediation free, Industry Credential Earned (at least 12 points in a career field), earned an Honors diploma, Dual Enrollment credit (at least 3 hours earned), AP test score and IB test score. Based on these values the total initial points and bonus points earned are shown by SSID.
2017D_CTE_IC_<lead district IRN>_<file date>.xls
2017 March D Follow-Up Concentrator Credentials Earned
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 3 tabs:
- CTPD INDUSTRY CREDENTIAL: report is a student level file that shows all Industry Recognized Credentials earned by all students in the 2017 March D file. The report contains reporting CTPD IRN, DIST IRN, SSID, credential code, credential description, and points received for earning that credential.
- CTPD ANY INDUSTRY CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of students who obtained at least one industry credential and who left secondary education in FY16. This report contains ctpd irn, ctpd any ic den, ctpd any ic num, ctpd any ic percent, jvsd any ic den, jvsd any ic num and jvsd any ic percent.
- CTPD_12PTS_INDUSTRY_CREDENTIAL: report is a file by CTPD and JVSD that shows the percent of students who obtained at least 12 industry credential points. This report contains reporting ctpd irn, ctpd 12pts ic den, ctpd 12pts ic num, ctpd 12pts ic percent, jvsd 12pts ic den, jvsd 12pts ic num and jvsd 12pts ic percent.
2017D_CTE_CTPD_POST_PROGRAM_COMP_<lead district IRN>_<file date>.xls
2017D March D Follow-Up Concentrator CTPD Post-Program Comprehensive
The workbook consists of 2 tabs:
- CTPD_DETAIL_POST_PROGRAM: report is a comprehensive student level file of all the students that fall under the CTPD, that shows Placement reported status for all concentrators who left secondary education in FY16. The data elements included in the file are reporting IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District; or UNREPORTED – No Post Program information has been reported for this SSID in EMIS. The options in the Post Program Placement are Yes – met the indicator for Post Program Placement; No – student does not meet indicator; or blank if no data has been reported for that SSID.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY16 that reported participation in one of the activities in the CTE Follow-Up Survey. The file contains reporting IRN, CTPD post-placement denominator, CTPD post-placement numerator, CTPD post-program rate, CTPD status known denominator, CTPD status known numerator, CTPD status known rate, CTPD post program grade and the district IRN of the file.
2017D_CTE_CTPD_TECH_ASSMT_<lead district IRN>_<file date>.xls
2017 March D Follow-Up Concentrator CTPD Technical Achievement
The workbook consists of 3 tabs:
- CTPD_DETAIL_TECH_ASSMNT_PART: report is a comprehensive student level file of all of the students that fall under the CTPD, that shows if the assessments taken by concentrators who left secondary education in FY16 align to their program of concentration. This information will be used as Technical Skill Participation measure on the CTE Report Card. The file contains CTPD IRN, member district IRN, SSID, reported program of concentration, technical assessment, alignment status for the student and lead district IRN. ALIGNED TECHNICAL ASSESSMENT means the student took the correct assessment; NOT ALIGNED TECHNICAL ASSESSMENT means the student took an assessment but it was not aligned to the reported program of concentrations; NO TECHNICAL ASSESSMENT means no assessment was reported for the student.
- CTPD_DETAIL_TECH_ASSMNT_PASS: report is a comprehensive student level file of all of the students that fall under the CTPD, that shows if concentrators who left secondary education in FY16 passed assessments that aligned to their program of concentration. This information will be used as Technical Skill Attainment measure on the CTE Report Card. The file contains reporting CTPD IRN, member district IRN, SSID, reported program of concentration, if the technical assessment was passed and lead district IRN. NO means the student did not pass the aligned technical assessment; YES means the student passed the aligned technical assessment.
- CTPD_TECH_ACHIEVEMENT_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY16 that took the technical assessment aligned to their program of concentration the number that passed the technical assessment aligned to their program of concentration and the CTPD technical assessment grade for the CTE Report Card. The file contains reporting CTPD IRN, CTPD technical participation denominator, CTPD technical participation numerator, CTPD technical passage rate, CTPD technical passage denominator, CTPD technical passage numerator and CTPD technical passage rate, CTPD technical achievement grade and the district IRN of the file.
2017D_CTE_INDUSTRY_CREDENTIALS_<file date>.xls
2017 March D Follow-Up Concentrator Credentials Earned
The 2017D_CTE_INDUSTRY_CREDENTIALS report is a student level file that shows all Industry Recognized Credentials earned by all students in the 2017 March D file. The report contains reporting IRN, SSID, credential code, credential description, and points received for earning that credential.
2017D_CTE_1S1_1S2_<lead district IRN>_<file date>.xls
2017 March D Follow-Up Academic Attainment (1S1 and 1S2) indicators
These reports are only distributed to the CTPD Lead Districts. The workbook consist of 4 tabs:
- CTPD JVSD 1S1 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Reading (1S1) indicator. This report contains: ctpd irn, ctpd 1S1 den, ctpd 1S1 num, ctpd 1S1 percent, jvsd 1S1 den, jvsd 1S1 num, jvsd 1S1 percent.
- CTPD STUDENT LEVEL 1S1: report gives data on which students are included in the Academic Achievement-Reading (1S1) indicator. This report consists of ctpd irn, ssid, ctpd student level 1S1 den, ctpd student level 1S1 num.
- CTPD JVSD 1S2 RATES: report gives data points and percentages for the CTPD and JVSD for the Academic Achievement-Math (1S2) indicator. This report contains: ctpd irn, ctpd 1S2 den, ctpd 1S2 num, ctpd 1S2 percent, jvsd 1S2 den, jvsd 1S2 num, jvsd 1S2 percent.
- CTPD STUDENT LEVEL 1S2: report gives data on which students are included in the Academic Achievement-Math (1S2) indicator. This report consists of ctpd irn, ssid, ctpd student level 1S2 den, ctpd student level 1S2 num.
2017D_CTE_POST_PLACEMENT_<lead district IRN>_<file date>.xls
2017 March D Follow-Up Post-Placement Measures
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 3 tabs:
- CTPD JVSD POST PLACEMENT: report gives data points and percentages for the CTPD and JVSD for the post-placement measure. Report consists of ctpd irn, ctpd post placement den, ctpd post placement num, ctpd post placement percent, jvsd post placement den, jvsd post placement num, jvsd post placement percent.
- CTPD STUDENT LEVEL POST PLACE: report gives data on which students are included in the post-placement measures. Report consists of ctpd irn, ssid, ctpd post-placement den, ctpd post-placement num.
- CTPD POST PLACEMENT CATEGORIES: report breaks down the student count and percentage of each post-placement category (apprenticeship, employment, military and post-secondary training). Depending on what was reported in the 2017D report collection students may be counted in more than one category. Each category percent is calculated with the ‘post-placement den’ as the denominator and the ‘category placed’ as the numerator (example: apprenticeship placed/post placement den = apprenticeship percent). Report consists of ctpd irn, post-placement den, apprenticeship placed, apprenticeship percent, employment placed, employment percent, military placed, military percent, post-secondary placed, post-secondary percent.
2017D_CTE_POST_PROGRAM_<file date>.xls
2017 March D Follow-Up Post Program Placement
The 2017D_CTE_POST_PROGRAM report is a student level file that shows the Post Program Placement reported status for all concentrators in the 2017 March D file. The data elements included in the file are reporting IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District; or UNREPORTED – No Post Program information has been reported for this SSID in EMIS. The options in the Post Program Placement are Yes – met the indicator for Post Program Placement; No – student does not meet indicator; or blank if no data has been reported for that SSID.
2017D_CTE_POST_PROGRAM_COMP_<file date>.xls
2017D March D Follow-Up Concentrator Post-Program Comprehensive
The workbook consists of 4 tabs:
- DETAIL_POST_PROGRAM: report is a student level file that shows Placement reported status for all concentrators who left secondary education in FY16. The data elements included in the file are reporting IRN, SSID, Status Known, and Post Program Placement. The options in the Status Known column are YES – Status Known; NO – Status Unknown as reported by the District; or UNREPORTED – No Post Program information has been reported for this SSID in EMIS. The options in the Post Program Placement are Yes – met the indicator for Post Program Placement; No – student does not meet indicator; or blank if no data has been reported for that SSID.
- DIST_POC_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY16 by program of concentration that reported participation in one of the activities in the CTE Follow-Up Survey. This information will be used as the Post-Program measure in the Quality Program Review in the CTE 26. The file contains reporting IRN, program of concentration, district post-placement denominator by program of concentration, district post-placement numerator by program of concentration and district post-program rate by program of concentration.
- DIST_POST_PROGRAM: report is a file by district that shows the number of concentrators who left secondary education in FY16 that reported participation in one of the activities in the CTE Follow-Up Survey. The file contains reporting IRN, district post-placement denominator, district post-placement numerator and district post-program rate.
- CTPD_POST_PROGRAM_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY16 that reported participation in one of the activities in the CTE Follow-Up Survey. The file contains reporting IRN, CTPD post-placement denominator, CTPD post-placement numerator, CTPD post-program rate, CTPD status known denominator, CTPD status known numerator, CTPD status known rate, CTPD post program grade and the district IRN of the file.
2017D_CTE_SECON_COMPL_<lead district IRN>_<file date>.xls
2017 March D Follow-Up Secondary Completion (3S1) Indicator
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 2 tabs:
- CTPD SECOND COMPLETION: report gives data points and percentages for the CTPD and JVSD secondary completion (3S1) indicator. This report contains: ctpd irn, ctpd 3S1 den, ctpd 3S1 num, ctpd 3S1 percent, jvsd 3S1 den, jvsd 3S1 num, jvsd 3S1 percent.
- CTPD STUDENT LEVEL SECON COMPL: report gives data on which students are included in the secondary completion (3S1) indicator. Report consists of: ctpd irn, ssid, ctpd 3S1 den, ctpd 3S1 num.
2017D_CTE_TECH_ASSMT_<file date>.xls
2017 March D Follow-Up Concentrator Technical Achievement
The workbook consists of 7 tabs:
- DETAIL_TECH_ASSMNT_PART: report is a student level file that shows if the assessments taken by concentrators who left secondary education in FY16 align to their program of concentration. This information will be used as Technical Skill Participation measure on the CTE Report Card. The file contains reporting IRN, SSID, reported program of concentration, and alignment status for the student. ALIGNED TECHNICAL ASSESSMENT means the student took the correct assessment; NOT ALIGNED TECHNICAL ASSESSMENT means the student took an assessment but it was not aligned to the reported program of concentrations; NO TECHNICAL ASSESSMENT means no assessment was reported for the student.
- DETAIL_TECH_ASSMNT_PASS: report is a student level file that shows if concentrators who left secondary education in FY16 passed assessments that aligned to their program of concentration. This information will be used as Technical Skill Attainment measure on the CTE Report Card. The file contains reporting IRN, SSID, reported program of concentration, and if the technical assessment was passed. NO means the student did not pass the aligned technical assessment; YES means the student passed the aligned technical assessment.
- DIST_POC_TECH_ASSMNT_PART: report is a file by district that shows the number of concentrators who left secondary education in FY16 by program of concentration that took the technical assessment aligned to their program of concentration. This information will be used as the Technical Skill Participation in the Quality Program Review in the CTE 26. The file contains reporting IRN, program of concentration, district technical participation denominator by program of concentration, district technical participation numerator by program of concentration and district technical participation rate by program of concentration.
- DIST_POC_TECH_ASSMNT_PASS: report is a file by district that shows the number of concentrators who left secondary education in FY16 by program of concentration that passed the technical assessment aligned to their program of concentration. This information will be used as the Technical Skill Passage measure in the Quality Program Review in the CTE 26. The file contains reporting IRN, program of concentration, district technical passage denominator, district technical passage numerator and district technical passage rate.
- DIST_TECH_ASSMNT_PART_RATE: report is a file by district that shows the number of concentrators who left secondary education in FY16 that took the technical assessment aligned to their program of concentration. The file contains reporting IRN, district technical participation denominator, district technical participation numerator and district technical participation rate.
- DIST_TECH_ASSMNT_PASS_RATE: report is a file by district that shows the number of concentrators who left secondary education in FY16 that passed the technical assessment aligned to their program of concentration. The file contains reporting IRN, district technical passage denominator, district technical passage numerator and district technical passage rate.
- CTPD_TECH_ACHIEVEMENT_GRADE: report is a file by CTPD that shows the number of concentrators who left secondary education in FY16 that took the technical assessment aligned to their program of concentration the number that passed the technical assessment aligned to their program of concentration and the CTPD technical assessment grade for the CTE Report Card. The file contains reporting CTPD IRN, CTPD technical participation denominator, CTPD technical participation numerator, CTPD technical passage rate, CTPD technical passage denominator, CTPD technical passage numerator and CTPD technical passage rate, CTPD technical achievement grade and the district IRN of the file.
2017D_CTE_TECH_SKILL_PARTIC_<file date>.xls
2017 March D Follow-Up Concentrator Technical Skill Alignment
The 2017D_CTE_TECH_SKILL_PARTIC report is a student level file that shows if the assessments taken by concentrators align to their program of concentration. This information will be used as Technical Skill Participation measure on the CTE Report Card. The file contains reporting IRN, SSID, reported program of concentration, and alignment status for the student. ALIGNED TECHNICAL ASSESSMENT means the student took the correct assessment; NOT ALIGNED TECHNICAL ASSESSMENT means the student took an assessment but it was not aligned to the reported program of concentrations; NO TECHNICAL ASSESSMENT means no assessment was reported for the student.
2017D_CTE_TECH_SKILL_PASSED_<file date>.xls
2017 March D Follow-Up Concentrator Technical Skill Passage
The 2017D_CTE_TECH_SKILL_PASSED report is a student level file that shows if concentrators passed assessments that aligned to their program of concentration. This information will be used as Technical Skill Attainment measure on the CTE Report Card. The file contains reporting IRN, SSID, reported program of concentration, and if the technical assessment was passed. NO means the student did not pass the aligned technical assessment; YES means the student passed the aligned technical assessment.
2017D_RPTCRD_CTE_GRAD_<lead district IRN>_<file date>.xls
2017 Report Card 4 and 5 yr. Grad Measures’
These reports are only distributed to the CTPD Lead Districts. The workbook consists of 3 tabs:
- CTPD JVSD GRAD: report gives data points and percentages for the CTPD and JVSD 4yr. and 5 yr. grad rate. This report contains: ctpd irn, grad 4yr den, grad 4 yr num, grad 4 yr percent, grad 4yr grade, jvsd 4yrgrad den, jvsd 4yr grad num, jvsd 4yrgrad percent, grad 5yr den, grad 5yr num, grad 5yr percent, grad 5yr grade, jvsd 5yrgrad den, jvsd 5yrgrad num, jvsd 5yrgrad percent, component grade
- CTPD STUDENT LEVEL 4YRGRAD: report consist of the student level data for the CTE 4yr. grad rate. Reports identifies which SSID are included in the CTE 4yr. Grad calculation. Report consists of ctpd irn, dist irn, ssid, ctpd 4yr grad den, ctpd 4yr grad num.
- CTPD STUDENT LEVEL 5YRGRAD: report consist of the student level data for the CTE 5yr. grad rate. Reports identifies which SSID are included in the CTE 5yr. Grad calculation. Report consists of ctpd irn, dist irn, ssid, ctpd 5yr grad den, ctpd 5yr grad num.
2017L_STAFF_049_ZERO_YEARS_EXP_<file date>.xls
2017 Teachers with Zero Years of Experience
This report is meant to be used in junction with Gen Issues Check 049. The file contains teachers (position code 230 and 212) who are being reported with a 0 for the Authorized Teaching Experience Years Element. The file displays the District IRN and Name where the teacher is employed, and the entity that reported the teacher. There is a designation on whether the teacher is employed by the same district where they work, or if they are contracted. If the staff member is contracted, then the district should reach out to the entity from which they contract the staff member and ensure that they are reporting the Years of Experience correctly. If the teachers shown are in fact the teachers new to the field who are on staff at your district, then this report does not reflect an error.
2017S_RPTCRD_WKC_GROUP_BY_GRADE_LEVEL _<file date>.xls
Reporting District Where Kids Count
This file contains 2 tabs for reporting districts. These reports show the summary information for Where Kids Count and the attendance rate. This information can be found on the WKC_LEA_OUTPUT tab. These reports also show the grade level breakout in cases where grade levels could have an issue. This information can be found on the WKC_LEA_DETAIL tab.
2016 File Descriptions
2016G_Prep_for_Success_Detail_<file date>.xls
Report Card Prep for Success
This file contains 3 tabs for public districts and 2 tabs for community schools. These reports show the summary information by district or community school (LEA_OUTPUT, BLDG_SUMMARY) as well as public school (LEA_BUILDING_SUMMARY). These reports also show all the variables that factor into Prep for Success calculation: ACT remediation free, SAT remediation free, Industry Credential Earned (at least 12 points in a career field), earned an Honors diploma, Dual Enrollment credit (at least 3 hours earned), AP test score and IB test score. Based on these values the total initial points and bonus points earned are shown by SSID.
VA_Component_091416_<dist_irn>.xls
2016 Progress Component Grades
- This file is available to district administrators via the Forms application housed behind SAFE. District administrators can access the file in District Document Exchange. The file is not available in the Data Collector.
- The 2016 Progress Component file includes district and building Progress Component letter grade data. These letter grades will be published on the 2016 Ohio School Report Cards on Thursday, September 15th.
- Information about how the Progress Component letter grades are calculated is available on the department’s website.
VA_NSC_091316_<district_irn>.xls
2016 Value-Added Results and National Student Clearinghouse Information
- This file is available to district administrators via the Forms application housed behind SAFE. District administrators can access the file in District Document Exchange. The file is not available in the Data Collector.
- The 2016 Value-Added Result files includes district and building Value-Added data and letter grades associated with the Overall, Gifted, Lowest 20 Percent, and Students with Disabilities subgroups, as well as the Highly Mobile Value-Added results where applicable. These results will be published on the 2016 Ohio School Report Cards on Thursday, September 15th.
- More information about Ohio’s Progress Component and Value-Added data is available online.
- The file also includes report-only information on postsecondary enrollment and completion rates, based on information provided by National Student Clearinghouse.
- Ncs_6_yr_cohort_Denom = denominator of 2009 graduation cohort
- Ncs_6_yr_college_grads = students who graduated within 6 years of high school
- Ncs_6_year_college_grad_pct = percent of 2009 graduate cohort who graduated within 6 years of high school
- Nsc_grad_rate_4yr_denom = denominator of 2013 4yr grad cohort
- Ncs_enrl_stdnt_count = students who enrolled in college within 2 years of high school
- Ncs_enrl_pct = percent of 2013 4 year grad cohort who enrolled in college within 2 years of high school
2016D_credential_points_<file date>.xls
Total Industry Credential Points
- The Industry Credential Points by SSID file is a listing of the sum of the industry credential points that were reported for the student.
- File should be reviewed to ensure expected industry credential points are being reflected for the SSID. Points for approved Credentials can be found here.
- Any data reported incorrectly or missing may be disputed during the March D appeal, which is scheduled to open July 20. Please refer to the Data Appeals site for specific dates and information on appeals.
2016D_post_placement_<file date>.xls
CTE Student Level Post Placement
- The Student Level Post Placement file is a CTE student level file.
- ‘Post Placement Denominator’ = ‘Yes’ for those students who were not reported as Status Unknown (U), Deceased (D), or Incorrectly reported as a CTE Concentrator (X) (CTE Workforce Development Follow-Up Record (GV), Other Follow-Up Status Element (GV660)) in March (D).
- ‘Post Placement Numerator’ = ‘Yes’ when student was reported as enrolled in postsecondary education or advanced training, in the military service, or employed (CTE Workforce Development Follow-Up Record (GV), Apprenticeship Element (GV620), Employed Placement Element (GV640), Military Placement Element (GV650), and Postsecondary Education or Advanced Training Element (GV670)).
- Please review to ensure accurate data has been reported for the SSIDs listed. Any data reported incorrectly or missing may be disputed during the March D appeal, which is scheduled to open July 20. Please refer to the Data Appeals site for specific dates and information on appeals.
2016D_prep_grad_data_<file date>.xls
CTE Report Card Prep for Success/Graduation
This file contains 3 tabs
- Prep For Success. Shows all variables that factor into Prep For Success calculation, act remediation free, SAT remediation free, industry credential earned (12 points), honors diploma, dual enrollment, AP test score or IB test score. Based on those values the total initial points and bonus points earned are shown.
- 4 Year Graduation Rate. Shows Students by district and diploma type (Regular or Honors) earned as well as diploma count. 1 = diploma 0 = no diploma
- 5 Year Graduation Rate. Shows Students by district and if a diploma was earned in 5 years. 1 = diploma 0 = no diploma
2016D_tech_asesmnt_<file date>.xls
- Not all districts will receive this file–only LEAs with students who meet the file criteria.
- The student level technical assessment file includes those students who were concentrators and left school and had a reported program of concentration which requires a technical assessment. Column “Technical_Asmt_Alignment” indicates if the reported assessment aligns with the student’s reported program of concentration.
2016D_tech_skills_<file date>.xls
Technical Assessment Status
- The Student Level Technical Skills file is composed of students who were required to take technical assessments and also whether the technical assessment the student did take aligns to the program of concentration reported for the student.
- Students with multiple technical assessments will be listed multiple times.
- Please review the technical assessments listed for each student, with an emphasis on those who are listed as “not aligned” and “no assessment” as these students either do not have any technical assessment reported or all the technical assessments reported for them do not align to their reported program of concentration.
- Any appealable data may be disputed during the March D appeal, which is scheduled to open July 20. Please refer to the Data Appeals site for specific dates and information on appeals.
2016invalidations<file date>.xls
- Not all districts will receive this file–only LEAs with assessments that meet the file criteria.
- The file contains the following workbooks: 1) LEA_OUPUT, 2) LEA_DETAIL, 3) BUILDING_OUTPUT, 4) BUILDING_DETAILS.
- The LEA_OUTPUT sheet lists the total number of tests that were invalidated by specific test subject in the district.
- The LEA_DETAIL sheet lists the invalidation information at the student level, including SSID and test subject.
- The BUILDING_OUTPUT sheet lists the total number of tests that were invalided by specific test subject in each of the schools in the district.
- The BUILDING_DETAIL sheet lists the invalidation information at the student level, including SSID, test subject, and building information.
2016lep<file date>.xls
- The spreadsheet lists LEP students who were coded as L in 2015 but who may need to be coded as S in 2016. Students are included in the spreadsheets based on their 2016 reporting district (i.e., a student reported at one district in 2015 and another in 2016 will appear in the 2016 district’s spreadsheet only). Not all districts will receive this file–only LEAs with students who meet the file criteria.
- There are two sheets within each workbook.
- LEA_OUTPUT contains the number of students who were not coded as ‘S’ in the second year.
- LEA_DETAILS contains the SSIDs of students who were not coded as ‘S’ in the second year.
- A summary level file is also provided for each ITC with member district counts.
Last Modified: 11/26/2024 6:05:04 PM