Report 3.9 - Course Sections Completed - Count by Content Area for Departmentalized Courses
(Updated as of 5/01/2026)
*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: Snapshot / Certification (EOY 2)
Data As Of:
• Snapshot version, July 1 – June 30 of reporting year
Security Role(s) Required: EOY Reports
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 | Description |
|---|---|---|
| 1 | School Code | Derived from user ID permission and Expected Schools Table. |
| 2 | School Name | Determined by School Code and Expected Schools Table. Links to Report3.10 Course Sections Completed – Count and Details for Departmentalized Courses |
| 3 | Content Area | Derived using CRS-State Course Code (CRSC Field 9.07) mapped to Course Group Master Combos (Valid Code Combo sheet – Content Area Category Assignment Code). |
| 4 | State Course Code Name | CRSC Field 9.07 – Displays name of each State Course Code with student enrollment. |
| 5 | Course Content Area Subcategory | CRSC Field 9.28. |
| 6 | Standards Grade Level Range | CRSC Field 9.29 – Departmentalized Course Standards Grade Level Range. |
| 7 | Local Course ID and Name | CRSC Fields 9.08 (Local Course ID) and 9.09 (Course Name). |
| 8 | Course Section Count | Count of unique combinations of Course Section ID (CRSC 9.14) and Academic Term (CRSC 9.15) per Local Course ID and School. Multiple marking periods counted once. |
| 9 | Male Student Count | Unduplicated count where SINF 2.19 = M with at least one SCSC record for the Local Course ID and School. Counted once per Academic Term. |
| 10 | Female Student Count | Unduplicated count where SINF 2.19 = F with at least one SCSC record for the Local Course ID and School. Counted once per Academic Term. |
| 11 | Nonbinary Student Count | Unduplicated count where SINF 2.19 = X with at least one SCSC record for the Local Course ID and School. Counted once per Academic Term. |
| 12 | Total Student Count | 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.