Report 3.10 - Course Sections Completed - Count and Details for Departmentalized Courses

(Updated as of 05/10/2021)

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.)

Note: This report is the course completion equivalent of the Fall 2 Report 3.7 Course Section Enrollment – Count and Details

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.
  • SINF values derived from most recent record that wholly or in part overlaps a qualified enrollment
  • Enrollment Status Code = 10, 20, or 30
  • Grade Level = 07-12 only
  • If accessed from Report 3.16, then all Educational Options courses.
  • 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:


EOY 1 Report 3.10

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

EOY 1 Report 3.10

Column Rules
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

EOY 1 Report 3.10

Column Rules
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)

User Roles for Access:

EOY 1 Reports


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.