Delete Metric
Are you sure you want to delete this?
Metric
- Topic
- DataMart
- Category
- Outcomes
- Link
- Title
- Credit Course Retention and Success Rate
- Definition
- Student Type
- Display
- Data Source
- Location
- https://datamart.cccco.edu/Outcomes/Course_Ret_Success.aspx
- PseudoCode
- Step 1 SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, SB00 STUDENT-IDENTIFIER, GI03 TERM-IDENTIFIER, CB01 COURSE-DEPARTMENT-NUMBER, XB00 SECTION-IDENTIFIER, CB00 COURSE-CONTROL-NUMBER, SX04 ENROLLMENT-GRADE, SX03 ENROLLMENT-UNITS-EARNED, SXD2 ENROLLMENT-CREDIT-STATUS, SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS FROM term enrollment data WHERE SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0.0 AND SX03 ENROLLMENT-UNITS-EARNED > 0.00 AND SX03 ENROLLMENT-UNITS-EARNED < 75.00 AND LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','D','P') AND SXD2 ENROLLMENT-CREDIT-STATUS IN ('D','T','C','S') UNION SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, SB00 STUDENT-IDENTIFIER, GI03 TERM-IDENTIFIER, CB01 COURSE-DEPARTMENT-NUMBER, XB00 SECTION-IDENTIFIER, CB00 COURSE-CONTROL-NUMBER, SX04 ENROLLMENT-GRADE, SX03 ENROLLMENT-UNITS-EARNED, SXD2 ENROLLMENT-CREDIT-STATUS, SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS FROM term enrollment data WHERE SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0.0 AND (SX03 ENROLLMENT-UNITS-EARNED = 0.00 OR SX03 ENROLLMENT-UNITS-EARNED > 74.99) AND LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','D','F','I','N','W','P','X') AND SX04 ENROLLMENT-GRADE <> 'IP' AND SXD2 ENROLLMENT-CREDIT-STATUS IN ('D','T','C','S') Step 2 --collapse enrollment records by course, credit status, grade, and student demographics SELECT GI01 DISTRICT-COLLEGE-IDENTIFIER, SB00 STUDENT-IDENTIFIER, GI03 TERM-IDENTIFIER, CB01 COURSE-DEPARTMENT-NUMBER, XB00 SECTION-IDENTIFIER, CB00 COURSE-CONTROL-NUMBER, SXD2 ENROLLMENT-CREDIT-STATUS, SX04 ENROLLMENT-GRADE, SB04 STUDENT-GENDER, STD1 STUDENT-AGE-AT-TERM, derived DataMart ethnicity from SB29 STUDENT-MULTI-ETHNICITY (ST_RACE), COUNT(*) FROM results above and term data Step 3 --apply success criteria LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','P') OR LEFT(SX04 ENROLLMENT-GRADE,2) IN ('IA','IB','IC') OR SX04 ENROLLMENT-GRADE = 'IPP' Step 4 --apply retention criteria SX04 ENROLLMENT-GRADE NOT IN ('W ','DR ','XX ')
- Selection Criteria
- FROM term enrollment data WHERE SX05 ENROLLMENT-POSITIVE-ATTENDANCE-HOURS > 0.0 AND (SX03 ENROLLMENT-UNITS-EARNED = 0.00 OR SX03 ENROLLMENT-UNITS-EARNED > 74.99) AND LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','D','F','I','N','W','P','X') AND SX04 ENROLLMENT-GRADE <> 'IP' AND SXD2 ENROLLMENT-CREDIT-STATUS IN ('D','T','C','S') --success criteria LEFT(SX04 ENROLLMENT-GRADE,1) IN ('A','B','C','P') OR LEFT(SX04 ENROLLMENT-GRADE,2) IN ('IA','IB','IC') OR SX04 ENROLLMENT-GRADE = 'IPP' --retention criteria SX04 ENROLLMENT-GRADE NOT IN ('W ','DR ','XX ')
- Denominator
- Value Type
- Notes
- Political Context
- Intent
- Collection Guidance