Five-year CTE Concentrator Extract

On this page

Introduction

A tab-delimited extract of the completion status of each student for the previous five years to correctly calculate the CTE Federal reporting indicators. For example, the following school years are needed for the 2019-2020 school year
• 2015-2016
• 2016-2017
• 2017-2018
• 2018-2019
• 2019-2020

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 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.

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

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

Data Collection View	Description
Choose category	Select CTE Views
Choose data view	Five-year CTE Concentrator Extract

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 to 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
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
Cluster Complete	Lists the clusters. If the student has completed multiple clusters, then each cluster is listed as a separate record.	The calculated result from the Concentrator Calculation Report in the Concentrator field. Current course enrollment and also historical credit earned shall be considered in the respective Groups [S_NC_GP_PATH.S_NC_GP_SUB_REQREQ_GROUP] = 4, 5, and 6. Displays the respective Career Cluster [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. Displays the respective Career Cluster [S_NC_GP_PATH_REQDESCRIPTION] only if the course has been completed and there is a stored grade.
Pathway Complete	Lists the pathways. If the student has completed multiple pathways, then each pathway is listed as a separate record.	The calculated result from the Concentrator Calculation Report in the Concentrator field. Current course enrollment and also historical credit earned shall be considered in the respective Groups [S_NC_GP_SUB_REQ.S_NC_GP_SUB_REQREQ_GROUP] = 4, 5, and 6. Displays the respective Career Pathway S_NC_GP_PATHS_NC_GP_PATH_REQDESCRIPTION and "+" if the student is currently enrolled in the course and the final grade has yet to be stored. Displays the respective Career Pathway [S_NC_GP_PATH_REQDESCRIPTION] only if the course has been completed and there is a stored grade.
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
Single Parent	Indicates whether the student is flagged as a single parent. Valid values: Yes No	[S_NC_ACADEMIC]SINGLE_PARENT
Non-Traditional	Indicates whether the student is flagged as a student of non-traditional gender. Valid values: Yes No	If S_NC_GP_PATH_REQ.STR5 = M and sex (UI) [gender] = M, then Non-traditional = Yes; If S_NC_GP_PATH_REQ. STR5 = F and sex (UI) [gender] = F, then Non-traditional = Yes; If S_NC_GP_PATH_REQ. STR5 = M and sex (UI) [gender] = F, then Non-traditional = No; If S_NC_GP_PATH_REQ. STR5 = F and sex (UI) [gender]= M, then Non-traditional = No; If S_NC_GP_PATH_REQ. STR5 = N/A, then Non-traditional = N/A
School Number	The school number.	[Schools]School_Number