Instead of normal referering to create a calculated column, a structured referencing can be used. In all added columns (K, L, M, N), structured referencing are used to use its benefits in calculated columns.
Tuition Difference column is difference in tuition with the previous student.
Extra Attendent is OfficeHoursParticipated + TutorialsAttended
Attendance column is based on ClassSkipped column (Award/Not Award).
Department column is the department of each faculty based on the Lookup table in the right (P and Q columns).