Concentrator Completion Status

On this page

Introduction

The report lists the student's completed approved Career Pathways and progress towards completion. 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 who has successfully completed a Concentrator course in an approved Career Pathway. A Foundational Prerequisite Course provides fundamental knowledge and skills needed for student success in secondary and post-secondary education and careers in the Career Pathway. A Prerequisite Course provides fundamental or intermediate knowledge and skills for student success in secondary and post-secondary education and careers in the Career Pathway. The course is completed prior to enrolling in another or concentrator course. 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.
• The student must have enrolled in a CTE course for any Cluster|Pathway (Unless an Override is imported as Y).
• Students may potentially have a CTE Override S_NC_ACADEMIC.CTE_OVERRIDE even if not enrolled in a CTE course.

Report Input

Run Report Collection

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

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 to the selected data view.

Click Export to export the data collection results to an Excel spreadsheet.

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.

Data Element	Description	[Table]FieldName
Student Number	The state assigned student number for the student.	[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
Concentrator	The Concentrator status is Y (yes) or N (no).	S_NC_GP_BASE_REQBASE_SUBJECT, S_NC_GP_BASE_REQNUM_CREDITS_NEEDED, S_NC_GP_PATH_REQDESCRIPTION, S_NC_GP_SUB_REQREQ_GROUP, S_NC_GP_SUB_REQNUM_CREDITS_NEEDED, S_NC_GP_COURSE_ASSOCCOURSE_CODE, and S_NC_EC.EC_REFERRED
Override	The override status. A CTE Override could either be Y (Yes) or N (No). If Y; student will meet the Concentrator for the Cluster/Pathway the override was imported as Yes for. If N; the student will have Concentrator or Yes reverted to No for the Cluster/Pathway the override was imported as No for.	[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 OR S_NC_ACADEMIC.USER_DEFINED_10 is Null 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: M - Male F - Female	[Students]Gender
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.
Foundational Prerequisite Course	List any group-4 course that applies to the pathway. This is associated with the cluster/pathway, not the student.	S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP = 4
Prerequisite Course	List any group-5 course that applies to the pathway. This is associated with the cluster/pathway, not the student.	S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP = 5
Concentrator Course	List any group-6 course that applies to the pathway. This is associated with the cluster/pathway, not the student.	S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP = 6
Total Applicable Credits	The sum of all credit hours.	S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP = 4 or 5 or 6
Course in Progress	Lists group 4,5, and 6 courses in progress.	S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP = 4 or 5 or 6
ECS/OCS Flag	This field displays Yes if there is an O or E for the student's designation in the EC Designated Course of Study field.	[S_NC_EC]EC_REFERRED
Race/Ethnicity	The student's ethnicity.	[Students]Ethnicity
Career Cluster	Displays the different careers that match the skills and concentrator courses.	[S_NC_GP_BASE]S_NC_GP_BASE_REQBASE_SUBJECT Displays the calculated result of the Concentrator field
School Number	The school number.	[Schools]School_Number