University of Cape Town Student Admissions Data 2020-2025

The version of the data continues the processing done in a document entitled "Notes on preparing the UCT Student Admissions Data" from earlier the series:

1. The application file is assembled from 13 relational tables with respective foreign keys in the application file. The result are that an application becomes the unit of observation uniquely identified by an application ID variable. An applicant, identified by the person ID variable, may have more than one application. There are a total of 3,196,780 applications between 2020 and 2024.
2. The person file has each individual uniquely identified by a personl ID variable. Each individual is associated with information on "work experience" and "key subjects" from separate relational tables also contained in the database.They may be more than one instance of an individual because job roles change over time.
3. In the secondary school subjects file a person ID are the row entries associated with secondary school subjects in the columns. These subjects are quite specific and the data allows the researcher to distinguish between, for example, higher grade accounting and standard grade accounting. It also allows the researcher to identify the educational authority issuing the qualification e.g. Cambridge Internal Examinations (CIE) versus National Senior Certificate (NSC). This file spans 2020 to 2024.
4. The tertiary education file is the smallest of the four data files. There are multiple entries for each person in this dataset. Each row entry contains information on the year, institution and transcript information and can be associated with a person.This file spans 2020 to 2024.