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 like 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.
|