Report 3.10 - Course Sections Completed - Count and Details for Departmentalized Courses
(Updated 04/15/2024)
Description: Reports the details of completed local course sections by State Course Code within Content Area as well as the number of students who completed each course section (LEAs are instructed to submit those course sections that began during the Reporting Year (i.e. Academic Year), regardless of when they were completed.) N
Note: This report is the course completion equivalent of the Fall 2 Report 3.7 Course Section Enrollment – Count and Details
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.
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
- If accessed from Report 3.16, then only Educational Options courses are displayed.
- If accessed from Report 3.9, then departmentalized courses only.
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
- Students with Disabilities
- Content Area
- State Course Code
- Course Content Area Subcategory
- Departmentalized Course Standards Grade Level Range
- CTE Course
- CTE Postsecondary Articulated Course Indicator
- UC/CSU Approved Course
- Academic Term
- Non-Standard Instructional Level
- Educational Options Course
- Program Fund Source
Report Logic:
Click image to expand
| Column | Rules |
|---|---|
| 1 | LEA 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 Report 3.11 Course Sections Completed - Student List 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.30 – Displays the Content Standards Alignment |
| 8 | CRSC Field 9.08 and CRSC Field 9.09 to Display name of each Local Course ID and Course Name. |
| 9 | CRSC Field 9.36 to display High Quality CTE Course Indicator |
| 10 | CRSC Field 9.12 CTE Postsecondary Articulated Course = Y |
| 11 | CRSC Field 9.07 CRS-State Course Code = 7000 – 8900 |
| 12 | CRSC Field 9.13 UC-CSU Approved Indicator = Y |
| 13 | SCSC Field 10.14 - A unique identifier for a Course Section assigned by a local educational agency. |
| 14 | CRSC Field 9.15 - A coded value representing an Academic Term. |
| 15 | CRSC Field 9.19 Course Sec Inst Level |
| 16 | CRSC Field 9.31 Charter Non-Core, Non-College Prep Course Indicator = Y. |
| 17 | CRSC Field 9.32 AP/IB Course Code Cross Reference. |
| 18 | CRSC Field 9.33 Online Course Instruction Type |
| 19 | CRSC Field 9.34 Middle School Core Course Indicator. |
| 20 | CRSC Field 9.35 Local Assignment Option Code |
| 21 | CRSC Field 9.22 Instructional Strategy |
| 22 | CRSC Field 9.27 CTE Course Section Provider |
| 23 | CRSC Field 9.23 Independent Study Indicator = Y. |
| 24 | CRSC Field 9.24 Distance Learning Indicator = Y. |
| 25 | CRSC Field 9.26 Education Program Funding Source |
| 26 | CRSC Field 9.07 CRS Course Code = 9211. |
| 27 | CRSC Filed 9.07 CRS Course Code = IB course code. |
| 28 | 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. |
| 29 | 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. |
| 30 | 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. |
| 31 | Callout (27) + Callout (28) + Callout (29) |
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.