File Descriptions

2019 File Descriptions
2018 File Descriptions
2017 File Descriptions
2016 File Descriptions

 

2019 File Descriptions

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.


2018 File Descriptions

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_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_<filedate>.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. Visit the Student Growth Measures for Principals page for more information.
 

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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:

  1. 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.
  2. 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.
  3. 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:

  1. 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.
  2. 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:

  1. 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.
  2. 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.
  3. 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:

  1. 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.
  2. 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.
  3. 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.
  4. 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:

  1. 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.
  2. 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.
  3. CTPD POST PLACEMENT CATEGORIES: report breaksdown 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:

  1. 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.
  2. 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.
  3. 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.
  4. 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:

  1. 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.
  2. 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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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:

  1. 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
  2. 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.
  3. 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 here.
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 here.
  • 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: 12/8/2017 4:27:25 PM