Report 3.9 - Course Sections Completed - Count by Content Area for Departmentalized Courses
(Updated 04/15/2024)
Description: Reports number of departmentalized course sections for each Course within Content Area. (LEAs are instructed to submit those course sections that began during the Reporting Year (i.e. Academic Year), regardless of when they were completed.) For each course, it includes the number of students who completed at least one course section of the course.
Note: a student in multiple course sections related to one local course ID is counted only once. A student with a same course section and term with multiple marking periods is counted only once.
Report Type: ODS and Snapshot / Certification (EOY 1)
Security Roles: EOY 1 Reports Role
Data As Of:
- If ODS version, user defined
- If Snapshot version, July 1 – June 30 of reporting year.
Basic selection criteria:
- Open Enrollment within the LEA at any time during the Report Period qualifies for selection.
- Enrollment Status Code = 10, 20, or 30
- Grade Level = 07-12
- SINF values derived from most recent record that wholly or in part overlaps a qualified enrollment
- Departmentalized Course section (NOT 1000-self-contained) with 1 or more enrollment
Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected
- Academic Year
- LEA
- Status
- School Type
- School
- Enrollment Status
- Grade
- Gender
- Ethnicity/Race
- Student with Disabilities
- Content Area
- State Course Code
- Course Content Area Subcategory
- Departmentalized Course Standards Grade Level Range
- CTE Course
- UC/CSU Approved Course
- Non-Standard Instructional Level
- Educational Options Course
- Academic Term
Report Logic:
Click image to expand
| Column | Rules |
|---|---|
| 1 | School code is derived from user ID permission and Expected Schools table |
| 2 | School Name is determined by #1 and the Expected Schools Table. |
| Links to Report3.10 Course Sections Completed – Count and Details for Departmentalized Courses | |
| 3 | Use CRS‐State Course Code Field 9.07 to look‐up value in Course Group Master Combos document, Valid Code Combo sheet/tab, to derive corresponding Content Area code and name. |
| See the Content Area Category Assignment Code column on the Course Group Master Combos tab of the CALPADS Valid Code Combinations | |
| 4 | CRSC Field 9.07 to display name of each State Course Code with student enrollment |
| 5 | CRSC Field 9.28 – Displays the Course Content Area Subcategory |
| 6 | CRSC Field 9.29 – Displays the Departmentalized Course Standards Grade Level Range |
| 7 | CRSC Field 9.08 and CRSC Field 9.09 to Display name of each Local Course ID and Course Name. |
| 8 | Count of unique combinations of Course Section ID (CRSC Field 9.14) and Academic Term (CRSC Field 9.15) with the same Local Course ID (CRSC Field 9.08) and School of Attendance (SENR 1.05). If a course section has multiple marking periods, the course section is counted only once. |
| 9 | SINF Field 2.19 = M. Total unduplicated count of male students with at least one SCSC record that contains the specified Local Course ID (SCSC Field 10.13) and School of Attendance (SENR 1.05). If a student is in multiple course sections related to one local course ID, the student is counted once per Academic Term. |
| 10 | SINF Field 2.19 = F. Total unduplicated count of female students with at least one SCSC record that contains the specified Local Course ID (SCSC Field 10.13) and School of Attendance (SENR 1.05). If a student is in multiple course sections related to one local course ID, the student is counted once per Academic Term. |
| 11 | SINF Field 2.19 = X. Total unduplicated count of nonbinary students with at least one SCSC record that contains the specified Local Course ID (SCSC Field 10.13) and School of Attendance (SENR 1.05). If a student is in multiple course sections related to one local course ID, the student is counted once per Academic Term. |
| 12 | Callout (9) + Callout (10) + Callout (11) |
Additional Resources
CALPADS File Specifications
Look for Course Completion (CRSC), Student Course Completion (SCSC) and Student Information (SINF) tabs for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.3 provides additional information on Course Completion data.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The different course-related code definitions are listed in this document.
CALPADS Valid Code Combinations
This document lists codes that can only be used in specific combinations in CALPADS.