Tool Search: CTE Reports
The CTE Data Reports editor provides users with the ability to generate and submit CTE data to the Nevada Department of Education. This tool provides three report types:
- Student Course Combined:
- Version:
- Count Date: Reports all students actively enrolled and rostered into a CTE course as of the count date.
- End of Year: Reports all CTE students and CTE courses completed during the reported period.
- Version:
- Student Concentrators:
- Reports all students who have completed at least two credits towards a CTE Program of Study.
- Student Graduates:
- Reports all students who have completed a CTE Program of Study and are no longer enrolled in the district.
CTE Data Reports Editor Report Logic
The following reporting logic is used to generate each available Report Type.
Student Course Combined
- All enrollment types are considered
- Student must have an active CTE course roster or earned credit in a CTE course
- Courses are considered CTE if the SCED code or the first five digits of the State Code are included in Appendix A
- For every unique student/course combination, one line reports
- This report is available in two versions:
- Count Date
- Student must have an active enrollment record on the Effective Date
- Student must have an active roster record in a CTE course on the Effective Date
- End of Year
- Student must have an active enrollment record at some point during the reporting period indicated by the dates entered in the Start and End Date fields in the Extract Editor
- Student must have earned credit in a CTE course during the reporting period indicated by the dates entered in the Start and End Date fields in the Extract Editor
- Count Date
- When the student’s course or section is marked as cross-site and the Exclude Cross-Site Data checkboxis marked on the extract editor, the cross-site course or section enrollment does NOT generate arecord.
Student Concentrators
- All enrollment types are considered
- Student must have an active enrollment record at some point during the reporting period indicated by the dates entered in the Start and End Date fields in the Extract Editor.
- Student must have completed specific CTE program criteria
- Student must have earned at least 1 credit in an L1 course AND at least 1 credit in an L2 course both tied to the same Program of Study
- Courses where SCED Course Level = E are not considered
- Courses are considered CTE if the SCED code or the first five digits of the State Code are included in Appendix A
- One line reports for every Program of Study that meets all requirements when Summary is selected
- One line reports for every course tied to a Program of Study that meets all requirements when Detail is selected
Student Graduates
- All enrollment types are considered
- Student must have an active enrollment record at some point during the reporting period indicated by the dates entered in the Start and End Date fields in the Extract Editor.
- Student enrollment must have an End Status of W3F
- Student must have Diploma Type: B18, B19, B24, B26, B27 or H
- Student must have completed specific CTE program criteria
- Student must have earned at least 1 credit in an L1 course AND at least 1 credit in an L2 course both tied to the same Program of Study
- Courses are considered CTE if the SCED code or the first five digits of the State Code are included in Appendix A
- Courses where SCED Course Level = E are not considered
- Program of Study is defined by SCED Code - see Appendix A
- If Program of Study is marked as "Will never pull a Concentrator" the Program will not report
- If student has completed the indicated concentrator status lines in a Program of Study marked as "Will never pull a Concentrator" AND they have achieved a Certification in the State Award Code listed for that same Program of Study they will report one record for that combination.
- One line reports for every course tied to a Program of Study that meets all requirements
Report Editor
| Field | Description |
|---|---|
| Report Type | Available reports:
|
| Version | Only applies to Student Course Combined. Includes the following options:
|
| Type | Applies to:
|
| Effective Date | Used to indicate the count date for the report. Applies to:
|
| Exclude Cross-Site Data | Cross-site section enrollment data is not included in the report when checked.
|
| Start Date | The start date of the reporting period. Applies to:
|
| End Date | The end date of the reporting period. Applies to:
|
| Ad Hoc Filter | Select an Ad Hoc filter to limit report results to those that meet filter requirements. |
| Format |
|
| Filter By | This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools. |
| Select Calendars | The calendar(s) from which data is pulled for the report. This field displays when the selected Filter By option is Calendar. |
| Generate Report | The report appears in a separate window in the designated format. |
| Submit to Batch | This process allows larger reports to be generated in the background without disrupting Campus use. See the Batch Queue article for more information about submitting a report to the batch queue. |
Report Layout
| Element | Description | Location |
|---|---|---|
| School Year | It reports the two-digit start year and two-digit end year (e.g., 21/22 will report as 2122). Report Types: Student Course Combined Student Concentrators Student Graduates | Calendar Information > School Year |
| District Code | The District code of the student's enrollment. Report Types: Student Course Combined Student Concentrators Student Graduates | School & District Settings > District > District Information > Master District Code District.number |
| District Name | The name of the district to which the enrollment is tied. Report Types: Student Course Combined Student Concentrators Student Graduates | School & District Settings > District > District Information > Name District.name |
| School Name | Student Course Combined: Reports the name of the school to which the enrollment is tied. Student Concentrators: Reports the name of the school where concentration was achieved. If student began earning program credits in one school but finished earning program credits at another, the ending school reports. Report Types: Student Course Combined Student Concentrators Student Graduates | School & District Settings > Schools > School Information > Name School.name |
| School Code | Student Course Combined: Reports the State School Number where courses were taken. Student Concentrators: Reports the school code of the school where concentration was achieved. If a student began earning program credits in one school but finished earning program credits at another, the ending school reports. If the State School Number is fewer than 5 digits, the Master District Code reports concatenated with the State School Number. Report Types: Student Course Combined Student Concentrators Student Graduates | School & District Settings > Schools > School Information > State School Number School & District Settings > District > District Information > Master District Code School.number District.number |
| Local ID | Reports the student's Local Student Number Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > Local Student Number |
| State Unique ID | Reports the student's Student State ID. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > Student State ID |
| First Name | The reporting student's first name. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > First name Identity.firstName |
| Middle Name | The reporting student's middle name. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > Middle Name Identity.middleName |
| Last Name | The reporting student's last name. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > Last Name Identity.lastName |
| Grade | Reports the student's State Grade Level. Grade levels must be mapped to State Grade Levels in order for data to report properly. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade |
| Gender | Reports the student's Gender code. F = Female M = Male X = Non-Binary Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > Gender Identity.gender |
| Ethnicity | Reports the student's Ethnicity code. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Demographics > State Race Ethnicity Identity.raceEthnicity |
| IEP | Student Course Combined:
Y reports if the student had an active locked IEP at any time during the reporting period AND the Special Ed Exit Date is NULL or comes after the report Start Effective Date. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > General > Special Ed > General > Documents AND Student Information > General > Enrollments > Special Ed Fields > Special Ed Exit Date |
| FRL | Reports the student's Free and Reduced Lunch status. Student Course Combined: Y reports for all students even if an active FRAM record exists if:
Otherwise:
Y reports for all students even if an active FRAM record exists if:
Otherwise, if a student has a FRAM record with an Eligibility of Free or Reduced at any time during the reporting period, Y reports. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | School Information > Provision > Select CEP AND School Information > Provision > Provision II And Provision Base Year |
| EL | Student Course Combined:
Student Concentrators & Student Graduates: Y reports if the student has an EL record with a Program Status EL that was active at any time during the reporting period. Otherwise, N reports. Otherwise, this field reports N. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > Program Participation > English Learners (EL) > EL > Program Status AND Identified Date AND Program Exit Date |
| Homeless | Y reports if Primary Nighttime Residence on Enrollment is not NULL. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > Program Participation > Homeless > Primary Nighttime Residence |
| Foster | Y reports if Foster on Enrollment is True. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > General > Enrollments > Foster |
| Military | Student Course Combined:
Student Concentrators & Student Graduates: Y reports if the student has a Household member marked as a Guardian with an active Military Connected record at any point during the reporting period. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | Census > People > Military Connections |
| Migrant | Student Course Combined:
AND If the Service End Date equals NULL or is greater than or equal to the date entered into the Extract Editor date, otherwise N reports. OR If the Service End Date is less than the Extract EdItor date, N reports. Otherwise, N reports. Report Types: Student Course Combined Student Concentrators Student Graduates | Student Information > Program Participation > Migrant > Last Qualifying Arrival Date Student Information > Program Participation > Migrant > Services End Date Calculation |
| Non-Trad | Student Concentrators:
The following logic applies to the reporting program:
Report Types: | Census > People > Demographics > Gender AND Course/Section > Course > Non-traditional Course OR Student Information > General > Transcript > Non-traditional Course |
| State Code | Student Course Combined:
Student Concentrators: Reports the State Code values from the Transcript only if Type = Detail on the Extract Editor.Report Types: | Course/Section > Course > State Code OR Student Information > General > Transcript > State Code |
| SCED Code | Student Course Combined: Reports the SCED Subject Area concatenated with the SCED Course Identifier.
Report Types: | Course/Section > Course > SCED Subject Area AND SCED Course Identifier OR Student Information > General > Transcript > SCED Subject Area AND SCED Course Identifier OR Course/Section > Course > State Code OR Student Information > General > Transcript > State Code |
| SCED Course Level | Student Course Combined: Reports the SCED Course Level code.
Student Concentrators: Reports the SCED Course Level code values from the Transcript. If the SCED Course Level is NULL, the sixth digit of the State Code reports. This field only reports if Type = Detail on the Extract Editor. Report Types: | Course/Section > Course > SCED > Course Level OR Student Information > General > Transcript > SCED Course Level OR Course/Section > Course > State Code OR Student Information > General > Transcript > State Code |
| Available Carnegie Unit Credit | Student Course Combined: Reports the Available Carnegie Unit Credit value. If the value is NULL, digits 7-10 of the State Code reports.
Student Concentrators: Reports the Available Carnegie Unit Credit value from the Transcript. If the value is NULL, digits 7-10 of the State Code reports. This field only reports if Type = Detail on the Extract Editor. Report Types: | Course/Section > Course > Available Carnegie Unit Credit OR Course/Section > Course > State Code OR Student Information > General > Transcript > Available Carnegie Unit Credit OR Student Information > General > Transcript > State Code |
| SCED Seq of Course | Student Course Combined: Reports the n value from SCED Sequence (part n of m). If the SCED Sequence is NULL, the 11th digit of the State Code reports.
Student Concentrators: Reports the n value from SCED Sequence (part n of m) from Transcript. If the SCED Sequence is NULL, the 11th digit of the State Code reports. This field only reports if Type = Detail on the Extract Editor. Report Types: | Course/Section > Course > SCED Sequence OR Course/Section > Course > State Code OR Student Information > General > Transcript > SCED Sequence OR Student Information > General > Transcript > State Code |
| Concentrator Cluster Code | Student Concentrators: Reports the Cluster value associated with the reporting Program of Study from the table in Appendix A. Report Types: | Calculated |
| Completion Code | Reports the student's Diploma Type code. Report Types: Student Graduates | Student Information > General > Graduation > Diploma Type |
| CTE Certificate | For the Program of Study reported:
Student Graduates | Student Information > General > Graduation > Graduation Award Information |
| CIP Code | Student Course Combined: Reports the course CIP Code.
Report Types: | Course/Section > Course > Course Information > CIP Code OR Student Information > General > Transcript > CIP Code Course.cipCode |
| Course Catalog Name | Student Course Combined: Reports the Course name.
Report Types: | Course/Section > Course > Course Information > CTE Course Catalog Name Course.abbreviation |
| Abbreviated Name | Student Course Combined: Reports the Abbreviated Course Name from the Course.
Report Types: | Course/Section > Course > Course Information > Name |
| Program Name | Student Course Combined: Reports the Program of Study the course belongs to. Student Concentrators & Student Graduates: Reports the Program of Study determined by the SCED Code. If Type = Summary on the Extract Editor, one line will report for each course completed within the Program. Report Types: Student Course Combined Student Concentrators Student Graduates | Calculated (See Appendix A) |
| ACT ELA Prof Level | Student Concentrators: Reports the Result value if the student has a State-Published assessment with the name ACT ELA AND a State Test Code of ACT that is dated within the reporting period. Report Types: | Student Information > General > Assessments |
| ACT Mathematics Prof Level | Student Concentrators: Reports the Result value if the student has a State-Published assessment with the name ACT Math AND a State Test Code of ACT that is dated within the reporting period. Report Types: | Student Information > General > Assessments |
| HS Science Exam Prof Level | Student Concentrators: Reports blank. Assessment Unavailable. Report Types: | Student Information > General > Assessments |
| Program Code | Student Course Combined: Reports the CTE State Program Area Code.
Report Types: | Course/Section > Course > CTE > State Program Area OR Student Information > General > Transcript > CTE State Program Area |
| Course Cluster Code / Concentrator Cluster | Student Course Combined: Reports the Cluster value. See Appendix A. Report Types: | Calculated (See Appendix A) |
| Completion Code | Reports the student's Diploma Type code. Report Types: | Student Information > General > Graduation > Diploma Type |
| CTE Certificate | For the Program of Study being reported:
Report Types: Student Graduates | Student Information > General > Graduation > Graduation Award Information |
| College Credit | Y reports if one or more courses in the Program of Study have a SCED Course Level = C OR if the 6th digit of the State Code of one or more courses in the Program of Study = C. Otherwise, N reports. Report Types: | Student Information > General > Transcript > SCED Course Level |
| Credit Earned | Student Course Combined:
Report Types: | Student Information > General > Enrollments > Credit Earned TranscriptCredit.creditsEarned |
| End Status Code | Reports the State Code the student's End Status is mapped to. Report Types: | Student Information > General > Enrollments > End Status AND Enrollment > End Status Type |
| College Credit | Y reports if SCED Course Level = C OR if SCED Course Level is NULL and the 6th digit of the State Code = C. Otherwise, N reports. Student Course Combined:
Report Types: | Course/Section > Course > SCED Course Level OR Student Information > General > Transcript > SCED Course Level OR Course/Section > Course > State Code OR Student Information > General > Transcript > State Code |
| Teacher First Name | Student Course Combined:
Report Types: | Course/Section > Section > Staff History |
| Teacher Last Name | Student Course Combined:
Report Types: | Course/Section > Section > Staff History |
