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.
- On the Start Page, click State Reports. then State Reporting Dashboard. The list of collections for the school appears.
- 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
- Next to the In-Field Out-Of Field Data Collection, click Review.
- 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 View | Description |
---|---|
Choose category | Select the applicable category:
|
Choose data view | Select the applicable data view:
|
Review Exceptions
Use the following steps to review exceptions for data collection.
- From the Dashboard, click Review. The Review page appears.
- Select Exceptions from the Reviews drop-down menu. Exceptions associated with a data collection display.
- 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. - To narrow your search, select one or more filters, if available.
- 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 Element | Description | [Table]FieldName |
---|---|---|
Student Number | The state assigned student number of students that are excluded from the concentrator calculation report. | [Students]State_StudentNumber |
First Name | Student's first name. | [Students]First_Name |
Last Name | Student's first name. | [Students]Last_Name |
Grade | The student’s current grade level. | [Students]Grade_Level |
Career Pathway | The 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 |
Override | The 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 Year | School Year that the student became a CTE Concentrator | [s_nc_rpt_cte_students]TERMID |
Sex | The student's sex. Valid values:
| [Students]Gender |
Race/Ethnicity | The student's ethnicity. | [Students]Ethnicity |
Career Cluster | Displays the different careers that match the skills. | [S_NC_GP_BASE]S_NC_GP_BASE_REQBASE_SUBJECT |
School Number | The school number. | [Schools]School_Number |
Concentrator Completion Status
Report Output Format: Excel spreadsheet, CSV