reset password

IRP Data Cleaning

1. Duplicate Entries in FTF_COHORTS

Several students have two entries the FTF_COHORTS table. Based on the class enrollment information in the CLASSES table, we removed one entry for each of the student:

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 only two terms in which the student registered for classes, which means this student was admitted twice, and in both cases, immediately dropped out.
7
<205844,2076>
<205844,2096>
This student dropped out after 2076 and was readmitted 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.

 

This page has been viewed 3154 times.