Skip to main content
Skip table of contents

CTE Data Collection

On this page

Introduction

This report lists students that have successfully completed or are projected to complete an approved Career Pathway. Career Clusters™ are groupings of occupations used as an organizing tool for curriculum design and instruction. The Career Cluster approach makes it easier for students to understand the relevance of their required courses and helps them select their elective courses. Career Pathways are sub-groupings of occupations within a Career Cluster used as an organizing tool for curriculum design and instruction. Occupations are grouped into career pathways based on the set of common knowledge and skills required for career success. A Concentrator is a student that has successfully completed a Concentrator course in an approved Career Pathway. A Concentrator Course is a second or third-level course in the Career Pathway that builds upon technical skills acquired in a prerequisite course.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects which school records that are not excluded from state reporting.

Student Selection

The report selects which student records to use based on the following criteria:

  • The student is not enrolled in a school that is not excluded from state reporting.
  • The student was actively enrolled at the school at some time during the selected reporting period.
  • Student must have enrolled in a CTE course, Cluster Pathway, and the Concentraor must have Yes.
  • Student must have Yes for CTE Override S_NC_ACADEMIC.CTE_OVERRIDE.

Report Input

Run Report Collection

This report collection is run at the LEA and School level.

Use the following steps to generate the CTE Concentrator Calculation report.

  1. On the Start Page, click State Reports. then State Reporting Dashboard. The list of collections for the school appears.
  2. Next to the CTE Concentrator Calculation, click Run. The system validates the data against the business rules set up for the collection and completes the process.

Review Data Collection

  1. Next to the In-Field Out-Of Field Data Collection, click Review.
  2. Select one of the following In-Field Out-Of Field Data Collection views from the Data View drop-down menu. The Results section displays the data collection results specific for the selected data view.

Notes:

  • Click Export to export the data collection results to an Excel spreadsheet
  • The In-Field Out-Of Field Data Collection can be run for students who transfer between LEAs.
Data Collection ViewDescription
Choose category

Select the applicable category:

  • Common LEA
  • CTE Views
Choose data view

Select the applicable data view:

  • School Approvals (displays if Common LEA is selected for the category)
  • Concentrator Calculation
  • ECS and OCS Exclusions
  • Associated Pathway Courses
  • Associated Supplemental and Major Courses
  • Five-year CTE Concentrator Extract

Review Exceptions

Use the following steps to review exceptions for data collection.

  1. From the Dashboard, click Review. The Review page appears.
  2. Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
  3. Select the exception type from the Choose exception drop-down menu. The Business Rule and Steps to Correct for the selected exception type appear on the page.
    The Results section displays detailed information associated with the selected exception.
  4. To narrow your search, select one or more filters, if available.
  5. Click Refresh. The Results section displays the filtered exception results specific for the selected data view.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

This data review is available aggregated for all schools at the LEA level.

Concentrator Calculation

The report run at the LEA level includes only these fields:

  • School Number

  • Career Cluster

  • Career Pathway

  • Grade

  • Total

Report Output Format: Excel spreadsheet, CSV

ECS and OCS Exclusions

Report Output Format: Excel spreadsheet, CSV

Data ElementDescription[Table]FieldName
Student NumberThe state assigned student number of students that are excluded from the concentrator calculation report.[Students]State_StudentNumber
First NameStudent's first name.[Students]First_Name
Last NameStudent's first name.[Students]Last_Name
Grade

The student’s current grade level.

[Students]Grade_Level

Career PathwayThe career pathway of the student is calculated based on the Concentrator field.[S_NC_GP_PATH.S_NC_GP_PATH_REQDESCRIPTION] and "+" if the student is currently enrolled in the course and the final grade has yet to be stored. Display the respective Career Pathway only [S_NC_GP_PATH_REQDESCRIPTION] if the course has been completed and there is a stored grade.
Concentrator

The Cocentrator status Y (yes) or N (no).

S_NC_GP_BASE_REQBASE_SUBJECT & S_NC_GP_BASE_REQNUM_CREDITS_NEEDED and S_NC_GP_PATH_REQDESCRIPTION & S_NC_GP_SUB_REQREQ_GROUP and S_NC_GP_SUB_REQNUM_CREDITS_NEEDED & S_NC_GP_COURSE_ASSOCCOURSE_CODE and S_NC_EC.EC_REFERRED
ECS/OCS Flag

This field displays O or E based on the student's designation in the EC Designated Course of Study field.

[S_NC_EC]EC_REFERRED

OverrideThe override status.

[S_NC_ACADEMIC]CTE_OVERRIDE

S_NC_ACADEMIC.USER_DEFINED_10 is S_NC_GP_PATH_REQ]DESCRIPTION in a pipe delimited format (i.e., ANSC|EQSC|CARP) where [S_NC_ACADEMIC.CTE_OVERRIDE] is Y

School YearSchool Year that the student became a CTE Concentrator[s_nc_rpt_cte_students]TERMID
Sex

The student's sex.

Valid values:

  • M - Male
  • F - Female
[Students]Gender
Race/EthnicityThe student's ethnicity.[Students]Ethnicity
Career ClusterDisplays the different careers that match the skills.

[S_NC_GP_BASE]S_NC_GP_BASE_REQBASE_SUBJECT
Display the calculated result of the Concentrator field

School NumberThe school number.[Schools]School_Number


Concentrator Completion Status

Report Output Format: Excel spreadsheet, CSV

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.