Report 3.19 Career Technical Education Completers – Count by Pathway

(Updated as of 04/03/2023)

Description: Reports the total number of CTE Completers by Pathway at the school level, by gender. School level data is also aggregated at the LEA level. In addition, the number of Completers within each Core Indicator group are counted.

Report Type: Snapshot / (EOY 1)

Security Roles: EOY 1 Reports

Data As Of:

  • If ODS version, user defined
  • If Snapshot version, July 1 – June 30

Basic selection criteria:

  • Enrollment at a school any time during the Report Period
  • Enrollment Status Code = 10, 20, or 30
  • Grade Level = 07-12
  • Course Completion record (CRSC Field 9.07) must map to a state course code within the pathway code reported from SCTE file (SCTE Field 11.13)
  • SCTE Pathway Code (Field 11.13) and SCTE Pathway Completion Academic Year ID (Field 11.14) are used to determine Industry Sector. Using Valid Code Combos – Pathway-Industry Sector tab
  • Only students who have completed a CTE Course and who have an associated SCTE record should be included in this report.

Student Data Rules:

  • A student may have more than one CTE Pathway Code for the Reporting Year. All SCTEs are examined to determine the number of unique CTE Pathway Codes for each student. For each unique CTE Pathway Code value where the Enrollment Period overlaps the Reporting Year of the SCTE containing the CTE Pathway Code (Field 11.13), count the student in that Pathway. Specific/Exception rules:
  • A student who has different CTE Pathways (SCSC & SCTE) at the same school during the Reporting Period should be counted for each CTE Pathway.
  • A student who has the same CTE Pathway (SCSC & SCTE) at the same school during the Reporting Period should only be counted once for that CTE Pathway.

  • At the school level, a student who has the same or different CTE Pathways for two different schools within the same LEA (both schools hold a SCSC & SCTE) during the Reporting Period should be counted for each CTE Pathway (count in both schools).

  • At the school level, a student who has an SCSC at one school and SCTE at another school during the Reporting Period (within the same Reporting LEA and for the same SCTE Pathway), the student should only count once at the school where the student is primarily enrolled.

  • In the case where the student has two primary enrollments during the Reporting Period, and one school holds the SCSC and the other school holds the SCTE, the school where the student took the Capstone course (SCSC/CRSC) should receive the Completer count.

  • In the case where the SCSC & SCTE are only at the non-primary school, count the student as a Completer at that non-primary school.

  • The total for selected schools (LEA level) should represent an unduplicated count of students across the LEA identified as CTE Completers.

  • For counting within a Core Indicator, unduplicate at the State Course Code and School level.
  • For Nontraditional Course Enrollment only, count students where student gender = gender specified in CTE Non-Traditional Gender for State Group Course Code in each course for which a nontraditional gender has been established

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected

  • Academic Year
  • LEA
  • Status
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Perkins/CTEIG Fundable
  • CTE Industry Sector
  • Students with Disabilities (IDEA)
  • Socio-economically Disadvantaged
  • Nontraditional Course Enrollment
  • English Learners
  • Foster Youth
  • Education Program

NOTE: Default = Y ‘Y’ value indicates that the course is CTE related, the teacher has an appropriate CTE credential, AND that the student reported has a valid SCTE record and a related course completion record

REMINDER: CTE completers do not need the High Quality CTE Course Indicator equal to Y in the course record to appear on the CA Dashboard. All CTE courses will be accounted for in the dashboard. Flagging a course with High Quality CTE Course Indicator equal to Y is only needed if the LEA is receiving Perkins funding, which requires CTE courses are taught by CTE credentialed teachers.

Report Logic:


EOY1Report3.19.png

Click image to expand


Column Rules
1 School code is derived from user ID permission and Expected Schools Table.
2 School Name is determined by #1 and the Expected Schools Table.
3 CTE Industry Sector Code based on Pathway from SCTE Field 11.13 CTE Pathway Code. See CALPADS Valid Code Combinations
4 SCTE Field 11.13 – CTE Pathway Code
5 CRSC Field 9.07 – State Course Code
6 SINF Field 2.19 – Gender
7 CRSE Field 9.36 – High Quality CTE Course Indicator = Y
8 CRSC Field 9.12 – Postsecondary Articulated Course Indicator = Y
9 CRSC Field 9.19 Course Instructional Level = 23-College Credit Only
10 CRSC Field 9.19 Course Instructional Level = 24-Dual Credit
11 Unduplicated count of CTE Completers by CTE Pathway
12 Unduplicated count of overlapping 504 Accommodation Plan (SPRG Field 3.13 Education Program Code = Code 101) or overlapping active SPED record in ODS with Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP)
13 Option 1: Parent/Guardian Highest Education Level Code (SINF Field 2.50 = 14-Not HS Graduate) from most recent SINF record
Option 2: SPRG Field 3.13 = 181 or 182
Option 3: SPRG Field 3.13 = 135
Option 4: SPRG Field 3.13 = 191
Option 5: Foster Program Eligible
Option 6: Direct Certification = Y
Option 7: Students enrolled in a Juvenile Court School
Option 8: SPRG Field 3.13 = 193
14 CRSC Filed 9.07 CRS State Course Code = 7000-8999 AND SINF 2.19 Student Gender Code = count of CTE Non-Traditional Gender for State Group Course Code in Valid Code Combinations document.
CTE Non-Traditional Gender is not NULL in CALPADS Valid Code Combinations document
15 Nontraditional Course Enrollment # / Total CTE Participants * 100 where Nontraditional Course Enrollment # is not “N/A
16 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 162
17 Unduplicated count of students with SELA Field 12.13 English Language Acquisition Status Code = EL.
18 Unduplicated count of students in Foster Youth
19 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 193
20 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 191
21 Unduplicated count of students with SPRG Field 3.13 Education Program Code = 192

Additional Resources

CALPADS File Specifications

Look for Course Completion (CRSC), Student Course Completion (SCSC), Student Career Technical Education (SCTE) and Student Information (SINF) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 3.2.1 provides additional information on CTE Completion data.

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The different course-related code definitions are listed in this document.

CALPADS Valid Code Combinations

This document lists course codes with its corresponding pathway designation that can only be used in specific combinations in CALPADS.