Cohort Tracking

From CSUMB Data Glossary
Jump to navigation Jump to search

Cohort Tracking as used on the Faculty Student Success dashboard indicates a student's enrollment or graduation tracking status as enrolled not graduated, neither enrolled nor graduated, or graduated.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Other Reports:N/A
Data Custodian
Institutional Assessment and Research
Data Source
Source System:CMS - SA
Source Table Name:N/A
Source Field Name:N/A
Census Process:N/A
Logical Transformation / Calculation
distinct case when NOT_GRAD_ENR_CNT = 0 and GRADUATED_CNT = 0 and ENROLLED_CNT = 1 then 'Enrolled Not Graduated' when NOT_GRAD_ENR_CNT = 0 and GRADUATED_CNT = 1 and ENROLLED_CNT = 0 then 'Graduated' when NOT_GRAD_ENR_CNT = 1 and GRADUATED_CNT = 0 and ENROLLED_CNT = 0 then 'Not Graduated Not Enrolled' else 'Enrolled Not Graduated' end
OBIEE Folder and Column
Folder Heading:"Dim - Cohort Fac-Stdnt Success"
Column Heading:"Cohort Status"

Recently matriculated cohorts would be expected to have a greater percentage of enrolled not graduated students while older matriculated cohorts would be expected to have greater percentages of graduated students and perhaps neither enrolled nor graduated students.

Examples

  • Enrolled Not Graduated
  • Not Graduated Not Enrolled
  • Graduated