Metric Details

DataMart Metric Details

---

Category

Outcomes

Title

Credit Course Retention and Success Rate

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

Related Elements

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

Edit | Back to List