Tool Search: CTE Tooling
The CTS Attendance Tooling extracts data used to assist districts in applying for CTS Attendance Funding.
CTE Tooling Editor - CTE Attendance Tooling Type
Report Logic
To report, a student must have at least one enrollment active during the extract date range that is not marked as State Exclude or No Show or mapped to an excluded Grade Level or in an excluded Calendar. The section being reported must be scheduled at least one day during the extract date range, with at least one rostered student. Courses must have a State Course Code and a CTE Course Level selected to report. At least one day in the calendar must be marked as School, Attendance, and Instruction.
Sections in a non-rotating schedule structure report one record. Sections in a rotating schedule structure report one record per unique rotation or per unique period per period schedule based on days per week and minutes per day.
Generating the CTE Attendance Tooling
- Select the Tooling Type of CTS Attendance Tooling.
- Select a CTE Course Level of Intro Courses or Inter & Capstone Courses. These levels are indicated on the Course tab.
- Enter a Start Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Enter an End Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Select an Ad hoc Filter to limit the results reported based on the pre-defined filter.
- Select the Format by using the dropdown list.
- Select a Calendar from the list. More than one can be selected.
- Click Generate Extract. to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a Student Assessment report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Report Layout
Results are sorted by Calendar Name, then by the Campus-generated Section ID.
Element Name | Description & Format | Campus Location |
|---|---|---|
| CalendarName | The name of the Calendar selected. Alphanumeric | System Administration > Calendar > Calendar > Name Calendar.name |
| schoolID | The SDE assigned State District Number for the reporting district. Alphanumeric, 6 characters | System Administration > Resources > School School.number |
| stateCourseCode | The State Code for the course. Courses with no State Code do not report. Alphanumeric, 5 or 6 characters | Scheduling > Courses > Course > Course Editor > State Code Course.stateCode |
| CourseName | The name of the Course. Alphanumeric | Scheduling > Courses > Course > Name Course.name |
| courseType | The structure and environment of the course, indicates how student work is expected to be completed and the student's interaction with a teacher or other certificated staff person. Reports the Course Type of the section. Alphanumeric, 1 character | Scheduling > Courses > Section > Course Type Section.courseType |
| period | A unique identifier of that describes the course section. This field reports the concatenated names of all periods in which the course is schedule, each separated by a space. For example, if the class is scheduled during periods 01 and 02, reports as 01 02. If the concatenated value exceeds 15 characters, reports the last 15 characters. Alphanumeric, 15 characters | Reports based on System Administration > Calendar > Periods > Name Calculated |
| sectionNumber | The number of the section. Alphanumeric | Scheduling > Courses > Section > Number Section.number |
| sectionID | Reports the Campus-generated Section ID.This value is displayed in the upper left hand corner of the Section editor. Alphanumeric, 20 characters | Scheduling > Courses > Section > Section ID Section.sectionID |
| PrimaryTeacherName | The name of the Primary Teacher assigned to the section on the Staff History active on the extract End Date. Does not report if Staff History Role is NSR. Reports Last Name and First Name separated by a space. Alphanumeric | Scheduling > Courses > Section > Staff History > Primary Teacher Identity.lastName, Identity.firstName |
| PrimaryTeacherStateID | The State Staff ID of the staff member reported above. Alphanumeric | Census > People > Demographics > Person Identifiers > Staff State ID Person.stateStaffID |
| HostSchool | The Provider School Name entered on the course. If null, reports the description of the Virtual/Distance Learning Provider code selected. Otherwise reports School Name. Alphanumeric | Scheduling > Courses > Course > Provider School Name, Virtual/Distance Learning Provider; System Administration > Resources > School > Name Course.providerSchoolName, Course.providerSchool, School.name |
| DaysOfWeek | The concatenated days this class is offered (M, T, W, TH, F), separated by a space. Alphanumeric | Calculated, not dynamically stored |
| PeriodStartTime | If the class is scheduled at the same period each session, reports the Period Start Time. If the class is scheduled during different periods, based on the periods reported in the record. Alphanumeric | System Administration > Calendar > Calendar > Periods > Period Schedule/Periods Editor > Period Information > Start Time Period.startTime |
| PeriodEndTime | If the class is scheduled at the same period each session, reports the Period End Time. If the class is scheduled during different periods, based on the periods reported in the record. Alphanumeric | System Administration > Calendar > Calendar > Periods > Period Schedule/Periods Editor > Period Information > End Time Period.endTime |
| TotalDaysScheduled | The total days on which the section is scheduled within the date range. To report, days must be marked as School, Attendance, and Instruction. Numeric | Calculated, not dynamically stored |
| TotalStudentRostered | The total number of students rostered into the section for at least one day. Students who drop a section and then re-enroll are only counted once. Numeric | Calculated, not dynamically stored |
| TotalAttendance | For each rostered student, reports the total days that student was rostered into the class, minus the student's total absences. Numeric | Calculated, not dynamically stored |
| MinutesPerDay | The total minutes per day of for the section based on the Period Start and End Times, minus any non-instructional minutes. Numeric | Calculated, not dynamically stored |
