Classic View: AZ State Reporting > 21st CCLC Summary of Classes

Search Term: 21st CCLC Summary of Classes

The 21st CCLC Summary of Classes extract provides districts with a summary of 21st CCLC course information within a specific calendar.

Tool Rights

Classic View: System Administration > User Security > Users > Tool Rights

Search Term: Tool Rights

Users must have at least R(ead) tool rights in order to generate and view the 21st CCLC Summary of Classes extract.

Reporting Population

Report one record for each section in the selected calendar that has the 21st CCLC field populated on the course.

The section must be provided within the date range of the extract editor.
State Excluded and Inactive courses are not reported.
If the Start Date is NULL, consider 7/1/YYYY as the default begin of the report time span (with YYYY as the start year of the selected calendar)
If the End Date is NULL, consider the Current Date as the default end of the report time span

Generate the Report

Enter the Start Date. If this field is left null, the tool will use 7/1/YYYY as the date (with YYYY being the start year of the selected calendar).
Enter the End Date. Only CCLC courses active between the start and end date are reported. If this field is left null, the current date is used.
Select the report Format.
Filter data by selecting an existing Ad Hoc Filter (optional).
Select which calendar(s) will report data.
Click Generate Report to generate the report immediately or click Submit to Batch to schedule when the system will process and generate the report.

Understand the Report

Use the table below to understand each element in the report:

Data Element	Description and Logic	Campus UI Location
Class Name	Reports as follows: Course Name-Teacher Last Name-Section Number	Schedule > Course > Course > Name Schedule > Course > Section > Staff History Schedule > Course > Section > Section ID
Instructor Name	Reports a comma delimited list of all staff members listed in the Staff History tab of the section Note: Names are reported as first name last name format	Schedule > Course > Section > Staff History
Dates of class and total weeks to date	Report the start date and end date of the section using the term dates the section is scheduled into as well as the number of weeks the course has been offered up to the end date entered in the extract editor. For weeks, count the number of weeks (Mon-Sun) starting from the start date of the course through the end date that is entered in the extract editor. Note: Date is formatted as mm/dd/yy Format of the field is mm/dd/yy - mm/dd/yy (x wks)	Schedule > Course > Section > Sections System Administration > Calendar > Calendar > Terms
# of hours session is provided	Report the average hours the section is provided per day for a full week of instruction This is calculated as follows: Sum the period minutes from each instructional day the section is offered within the start/end dates of the extract editor Divide the sum by the number of instructional days the section was offered within the start/end dates of the extract editor Divide that value by 60 Round to the second decimal place	Schedule > Course > Section > Sections System Administration > Calendar > Calendar > Periods
Days of Week	Report the abbreviation for each day of the week the section is scheduled into using the abbreviations below Monday - M Tuesday - T Wednesday - W Thursday - Th Friday - F	Schedule > Course > Section > Sections System Administration > Calendar > Calendar > Periods
Average Daily Attendance	Report the average number of students that were present each day the section was offered. To calculate this: Count the number of students that were present each day the section was offered from the start date of the section through the end date on the extract editor Sum the counts of each day Divide this sum by the number of days the section was offered from the start date of the section through the end date on the extract editor Round down to the nearest whole number	Schedule > Course > Section > Roster Schedule > Course > Section > Sections System Administration > Calendar > Calendar > Periods

Data Element

Description and Logic

Campus UI Location

Class Name

Reports as follows:

Course Name-Teacher Last Name-Section Number

Schedule > Course > Course > Name

Schedule > Course > Section > Staff History

Schedule > Course > Section > Section ID

Instructor Name

Reports a comma delimited list of all staff members listed in the Staff History tab of the section

Note: Names are reported as first name last name format

Schedule > Course > Section > Staff History

Dates of class and total weeks to date

Report the start date and end date of the section using the term dates the section is scheduled into as well as the number of weeks the course has been offered up to the end date entered in the extract editor.

For weeks, count the number of weeks (Mon-Sun) starting from the start date of the course through the end date that is entered in the extract editor.

Note:

Date is formatted as mm/dd/yy
Format of the field is mm/dd/yy - mm/dd/yy (x wks)

Schedule > Course > Section > Sections

System Administration > Calendar > Calendar > Terms

# of hours session is provided

Report the average hours the section is provided per day for a full week of instruction

This is calculated as follows:

Sum the period minutes from each instructional day the section is offered within the start/end dates of the extract editor
Divide the sum by the number of instructional days the section was offered within the start/end dates of the extract editor
Divide that value by 60
Round to the second decimal place

Schedule > Course > Section > Sections

System Administration > Calendar > Calendar > Periods

Days of Week

Report the abbreviation for each day of the week the section is scheduled into using the abbreviations below

Monday - M
Tuesday - T
Wednesday - W
Thursday - Th
Friday - F

Schedule > Course > Section > Sections

System Administration > Calendar > Calendar > Periods

Average Daily Attendance

Report the average number of students that were present each day the section was offered.

To calculate this:

Count the number of students that were present each day the section was offered from the start date of the section through the end date on the extract editor
Sum the counts of each day
Divide this sum by the number of days the section was offered from the start date of the section through the end date on the extract editor
Round down to the nearest whole number

Schedule > Course > Section > Roster

Schedule > Course > Section > Sections

System Administration > Calendar > Calendar > Periods

21st CCLC Summary of Classes (Arizona)

Tool Rights

Reporting Population

Understand the Report

Related Articles