Report 15.1 - Cohort Outcome - Count

(Updated as of 10/26/2021)

Description: Reports the Cohort Outcome Counts and Cohort Rates at a school-level. Counts and Rates are displayed by the cohort outcome categories: Graduates (HS Diploma Graduates, CHSPE Completers, Adult Ed. HS Diploma), Dropouts, Still Enrolled, Non-graduate Completers. Counts also include students removed from the cohort calculation.

Note: CALPADS has two different types of graduation reports (15.1 & 1.22) and these two graduation reports are used for different purposes. The cohort reports (15.1) satisfy the federal reporting of the 4 yr cohort rate. The one-year grad report (1.22) is a count that allows a school to get credit for their 5th and 6th year seniors and it helps LEAs that are DASS schools see what their rate might be for accountability.

Report Type: ODS

Data As Of: User Defined

Basic selection criteria:

2021/22 Four Year Cohort Membership Grade Level Academic Year Range

  • Grade 09 - July 1, 2018 - June 30, 2019
  • Grade 10 - July 1, 2019 - June 30, 2020
  • Grade 11 - July 1, 2020 - June 30, 2021
  • Grade 12 - July 1, 2021 - June 30, 2022

Students are determined in the cohort based on initial high school enrollment grade level record falling within the 2021/22 Membership date range above.

  • Grade Level = 9 -12
  • Membership Enrollment Date Range = 7/1/2018 - 6/30/2022
  • Outcome - Final Exit Date Range (Cohort Period) = 7/1/2018 - 8/15/2022
  • Cohort Report Processing Window = 4/11/2021 – 8/30/2022
  • Enrollment Status = 10 or (30 if > 30 days)
  • Student Exit Category Code <> N470, E125 or E170

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

  • Cohort Expected Graduation Year
  • LEA
  • School Type
  • School
  • Gender
  • Ethnicity/Race
  • Title 1 Part C Migrant
  • Student with Disabilities
  • Socio Economically Disadvantaged
  • English Learner
  • Foster Youth
  • Homeless Program Eligible
  • Directly Certified
  • Seal of Biliteracy
  • Golden State Seal of Merit Diploma
  • CTE Completer
  • UC/CSU Requirements Met
  • Work-Based Learning Completion for CCI Indicator
  • Adult Age Students with Disabilities in Transition Status

NOTE: The Cohort Expected Graduation Year filter enable users to select a future cohort year and see potential student cohort memberships for that year. This will allow users to see students who are expected to graduate in one-year, two-year, or three-years in the future and verify their first time 9th grade records sooner.

Report Logic


Report 15.1


Column Rule
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.
3 SENR Field 1.26 =T180, T200, T240, E130, T460, T310, or T370.
And the most recent SENR record in the Cohort Period has a Student Enrollment Exit Date >= Cohort Period Start Date and <= Cohort Period End Date.
4 SENR Field 1.26 = E230 and SENR Field 1.27 = 480
AND
The most recent SENR record in the Cohort Period where the 1.25 >= Cohort Period Start Date and <= Cohort Period End Date
5 Unduplicated Count of Students determined in the cohort where enrollment matches membership and if not Removed from Cohort or Promoted (Matriculated)
6 SENR Field 1.26 = E230
SENR Field 1.27 = 100, 104, 106 or 108
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
7 ((6) / (5)) * 100
8 SENR Field 1.26 = E230
SENR Field 1.27 = 330
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
9 ((8) / (5)) * 100
10 SENR Field 1.26 = E230
SENR Field 1.27 = 250
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
11 ((10) / (5)) * 100
12 The most recent SENR record in the Cohort Period where SENR Field 1.25 >= Cohort Period Start Date and <= Cohort Period End Date
AND
SENR Fields 1.26\1.27 = E230\360 or SENR Field 1.26 = E140, E150, E155, E300, E400, E410, E490, N420, T160, T165, T167, T270, T380 or E450.
OR
SENR Field 1.22 <= Cohort Period End Date and SENR Field 1.25 > Cohort Period End Date and SENR Field 1.25 <=Census Day
AND
SENR Fields 1.26\1.27 = E230\480 or SENR Field 1.26 = T180, T200, T240, T460, T310, T370, T260 or T280.
13 ((12) / (5)) * 100
14 SENR Field 1.22 <= Cohort Report Processing End Date
SENR Field 1.23 = 10 or 30
SENR Field 1.25 = Null or > Cohort Report Processing End Date
OR The student enrolled during the cohort period and is currently enrolled with Null Exit Date and No completer status.
OR The student “completed” between end of the cohort period and Cohort Report Processing End Date.
SENR Field 1.26/1.27 = E230/100 or SENR Field 1.26 = 106, 108, 330, 250, 320 or 120
OR Student Enrolls <= Cohort Report Processing End Date and SENR Field 1.26 = E130 between Cohort Period End Date and Cohort Report Processing End Date.
15 ((14) / (5)) * 100
16 SENR Field 1.26 = E230
SENR Field 1.27 = 120
SPRG Field 3.13 = 144 or SPED record in ODS with Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP) AND (Plan Set Start Date <= Reporting Period Through (End) Date and either ((Plan Set has no End date) or (Plan Set Exit Date >= Reporting Period From (Start) Date)))
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
17 ((16) / (5)) * 100
18 SENR Field 1.26 = E230
SENR Field 1.27 = 320
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
19 ((18) / (5)) * 100
20 SENR Field 1.26 = T260 or T280
And SENR Field 1.25 >= Cohort Period Start Date and <=Cohort Period End Date
21 ((20) / (5)) * 100

Field Code Legend

Field Code Name
SENR 1.22 (Enrollment Start Date)
SENR 1.23 (Enrollment Status)
SENR 1.25 (Enrollment Exit Date)
SENR 1.26 (Student Exit Reason Code)
SENR 1.27 Student School Completion Status)
SPRG 3.13 (Education Program Code)

Exit Code Legend

Exit Code Name
E125 PriorComplSpecEd
E130 Died
E140 NoKnownEnrollTruant
E150 MidYearEnrollmentUpdate
E155 YearEndEnrlmntExitSameSchl
E170 SecEnrlExit
E230 CompleterExit
E300 ExpellNoKnownEnroll
E400 OtherOrUnknown
E410 MedicalRsns
E450 PreK-6Exit
E490 Summer or Intersession Exit
N420 NoShowSameSchl
N470 NoShow
T160 TransCASchlRegular
T165 TransSpecDiscRsnsOrJudg
T167 TransAltSchlPrgm
T180 TransPrivate
T200 TransUS
T240 TransOutUS
T260 TransInAdult
T270 TransDropAdult
T280 TransCollege
T310 TransHealthFacil
T370 TransInstHSDipl
T380 TransInstNoHSDip
T460 TransHomeSch

Completion Code Legend

Completion Code Name
100 Graduated, standard HS diploma
104 Completed all local and state graduation requirements, failed CAHSEE
106 Grad, CAHSEE mods & waiver
108 Grad, CAHSEE exempt
120 Special Education certificate of completion
250 Adult Ed High School Diploma
320 Received a High School Equivalency Certificate (and no standard HS diploma)
330 Passed CHSPE (and no standard HS diploma)
360 Completed grade 12 without completing graduation requirements, not grad

User Roles for Access:

SENR View Role

LEA or School level org type with SENR View can access report.

Additional Resources

Cohort Glossary

List of glossary terms relevant to Cohort reporting.

ACGR Cohort Training Powerpoint

Current year ACGR Training Powerpoint deck.

ACGR Cohort Training Workbook

Current year ACGR Training Workbook.

CALPADS File Specifications

Look for Student Enrollment (SENR), Student Program (SPRG) and Special Education (SPED) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 3.1.9 provides additional information on Graduates and completers and the Cohort count calculation. Chapter 5.3 Appendix C provides additional information on Student Exit Reason code and Student School Completion status descriptions

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The Exit codes and completion code definitions are listed in this document.