How is the graduation rate calculated?
The data set includes all MS, MPS, CER students admitted in the Fall of 2018 and four years prior to the current fall admit term. For example, in today's data set (1/27/2025), it contains data from AY19 to AY22.
If a student's total enrollment term exceeds the NYAS maximum term, then the student is excluded from the graduation rate calculation.
If a student's total enrollment term is less than the NYAS maximum term, then the student is excluded from the graduation rate calculation.
A student will only count once if they switch modality.
If a student is admitted to a program and admitted to a different program, then the student will be counted twice.
Steps were used to calculate the Graduation Rate
List all MS, MPS, and CER students with their PID, Enrollment Term_Identifier, Program_Code, Degree, Field_Work_Flag
List all PIDs of students who changed the modality
List all students with PID, Admit_Term_ID, Program_Code, Degree_Code, IsEnrolled, and IsGraduated of students who did NOT CHANGE MODALITY.
List all students with PID, Admit_Term_ID, Program_Code, Degree_Code, IsEnrolled, and IsGraduated for students who CHANGED MODALITY.
Combined both tables for final output. (Changed Modality and Not Changed Modality)
Add Comment