Overview
The CCGI Course Grade report (officially named CCGI Course Data Elements) is a California state-specific report. It creates a list of student courses for the CCGI submission. The list includes:
-
Completed courses with final grades, taken from stored grades.
-
Courses in progress that students are currently taking, taken from their current section enrollments. These are called work in progress records.
This report is a required part of the College Career Guidance Initiative (CCGI) submission package.
Purpose
This report is one of the core data files required for the CCGI submission. It provides course and academic performance information, including:
-
Student course enrollment details
-
Final course grades and credits for completed courses
-
Courses in progress, marked as work in progress
-
Academic rigor indicators (AP, IB, Honors)
-
Dual enrollment status
-
UC/CSU subject area designations
Report Requirements
Important: Make sure grades are finalized for completed courses before you run this report. You don't need to finish or grade courses that are still in progress. The report includes them automatically as work-in-progress records.
Eligibility
This report includes students in grades 9-12 with completed courses taken in grades 7-12 and covers courses students are currently enrolled in.
Section-Level CCGI Overrides
A course in progress doesn't have a stored grade yet. So for work in progress records, the report takes its override values from the section instead of the Historical Grades page. These fields work like the matching CCGI fields on Historical Grades.
To set them:
-
Go to School Management > Course Sections.
-
Create or edit a section.
-
Fill in the fields under California College Guidance Initiative.
|
Field |
Type |
Description |
|---|---|---|
|
ATP Code Override |
Text (up to 20 characters) |
The CEEB code of the institution where the course is taken. |
|
Course Curriculum Term Override |
Text (up to 3 characters) |
The curriculum term code, for example S1, Q2, or F. |
|
Dual Enrollment Indicator Override |
Drop-down |
(N) No, (Y) Yes |
|
Academic Indicator Override |
Drop-down |
(AP) Advanced Placement, (IB) International Baccalaureate, (H) Honors |
|
CDS Code |
Smart search |
The 14-digit CDS code. |
If you leave these fields blank, the report uses default values from the course, term, school, and student records. For example, if CDS Code is blank, the school's CDS code is used.
Report Input
|
Field |
Description |
|---|---|
|
Select Schools |
Unique identifiers for the schools to include in the report. Select schools using Ctrl+Click to choose multiple or select All Schools to include all schools. Only schools not excluded from state reporting are available. This is a required field. |
|
Select Students |
Use the Student Selection page to filter and select students for the report. This is a required field. |
|
SFTP connections |
Select the SFTP connection for uploading the report. The report uploads automatically to the |
Report Output
|
Data Element |
Description |
[Table]FieldName |
|---|---|---|
|
StateID |
The 10-digit California State Student ID (SSID) assigned to the student. |
[Students]State_StudentNumber |
|
CDSCode |
The County-District-School (CDS) code for the course institution. |
[S_CA_SGR_X]CDS_Code For work-in-progress records: [S_CA_SEC_X]CDS_Code (if blank, the school's CDS code is used) |
|
ATPCode |
Alternative To Participation (ATP) code for the course. |
[S_CA_SGR_X]CCGI_ATPCode For work-in-progress records: [S_CA_SEC_X]CCGI_ATPCode |
|
CourseInstitutionName |
The name of the institution where the course was taken. |
[S_CA_SGR_X]CCGI_CourseCurrTerm |
|
IsWorkInProgress |
Indicates whether the course is still in progress.
|
Calculated: Y for records from section enrollments, N for records from stored grades |
|
GradeLevel |
The student's grade level when the course was taken (07, 08, 09, 10, 11, or 12). |
[StoredGrades]Grade_Level |
|
SchoolYear |
The school year in which the course was taken, formatted as YYYY-YY (e.g., 2024-25). |
[Terms]FirstDay and LastDay (Calculated) |
|
TermDescription |
The full name/description of the academic term. |
[Terms]Name |
|
Term |
The abbreviated term code (e.g., S1, S2, Y1). |
[StoredGrades]StoreCode |
|
CourseCurriculumTerm |
The curriculum term code for the course. |
[StoredGrades]StoreCode For work-in-progress records: [S_CA_SEC_X]CCGI_CourseCurrTerm |
|
LocalCourseID |
The local course identification number assigned by the district. |
[StoredGrades]Course_Number or [S_CA_SGR_X]AlternateCourseNumber |
|
TranscriptAbbreviation |
The abbreviated course name as it appears on the transcript. |
[StoredGrades]Course_Name |
|
SubjectArea |
The UC/CSU subject area designation (e.g., A-G requirements). |
[S_CA_SGR_X]UCCSU_Area |
|
AcademicIndicator |
Indicates the academic rigor level of the course. Valid values: AP (Advanced Placement), IB (International Baccalaureate), H (Honors). |
[S_CA_SGR_X]CCGI_AcademicInd or calculated from [S_CA_SEC_X]NS_Instructional_Lvl or [S_CA_CRS_X]NS_Instructional_Lvl For work-in-progress records: [S_CA_SEC_X]CCGI_AcademicInd, then the existing NS_Instructional_Lvl calculation |
|
DualEnrollmentIndicator |
Indicates dual enrollment status. Valid values: DE (Dual Enrollment). |
[S_CA_SGR_X]CCGI_DualEnrInd_YN or calculated from [S_CA_SEC_X]NS_Instructional_Lvl or [S_CA_CRS_X]NS_Instructional_Lvl Work in progress: [S_CA_SEC_X]CCGI_DualEnrInd_YN, or calculated from [S_CA_SEC_X]NS_Instructional_Lvl or [S_CA_CRS_X]NS_Instructional_Lvl |
|
CreditsAttempted |
The number of credits attempted for the course. |
[StoredGrades]PotentialCrHrs |
|
CreditsEarned |
The number of credits earned for the course. |
[StoredGrades]EarnedCrHrs |
|
CourseGrade |
The final letter grade received for the course (e.g., A, B, C, D, F). |
[StoredGrades]Grade |