IRP Data Cleaning
1. Duplicate Entries in FTF_COHORTS
Several students have two entries the FTF_COHORTS table. Based on the class registration information in the CLASSES table, we removed some of the duplicate entries that we believe to be erroneous.
| 1 |
<203756,2069>
<203756,2083>
|
This student dropped all classes in term 2069 and re-entered the program in term 2083. |
| 2 |
<203760,2079>
<203760,2083>
|
This student had been enrolled continuously from 2079 to 2083, so the second entry is likely an error. |
| 3 |
<203765,2079>
<203765,2083> |
This student had been enrolled continuously from 2079 to 2083, so the second entry is likely an error. |
| 4 |
<203779,2081>
<203779,2083> |
This student had been enrolled continuously from 2081 to 2083, so the second entry is likely an error. |
| 5 |
<205796,2069>
<205796,2093>
|
There is an one-year gap (2083-2091) in this student's class registration records, which means this student took an one-year leave (or dropped out) then was re-admitted. In this case both records are valid. |
| 6 |
<205801,2079>
<205801,2093>
|
2079 and 2093 are the only two terms in which the student registered for classes, which means this student was admitted twice, and in both cases, dropped out immediately after. |
| 7 |
<205844,2076>
<205844,2096>
|
This student dropped out after 2076 and was re-admitted in 2096. |
| 8 |
<207875,2099>
<207875,2101>
|
This student had been enrolled continuously from 2099 to 2101, so the second entry is likely an error. |
| 9 |
<215361,2089>
<215361,2133>
|
This student had been enrolled continuously from 2089 to 2131, so the second entry is likely an error. |
2. UNT_TAKEN_PRGRSS in TERMS
In order to determine whether a student dropped out, we must know if a student took any class in a particular quarter. For this purpose the value of UNT_TAKEN_PRGRSS is inadequate because it does not included the units from many classes such as Writing Proficiency and Introduction to Higher Ed.
We consider a student enrolled in a term if the student took at least one class in that term, and we define "taking a class" as enrolled in a class and received a grade other than W or WU. Note that although W (Withdraw) and WU (Unauthorized Withdraw) are different in terms of grades, for our purpose they are the same as in both cases the student left the class. Another special case is the classes with NULL grades, like the Study Abroad Program and some sports classes. Taking one of these classes also meets our definition of being enrolled in a term.
|
