Advisees course completion tracking spreadsheet for advisors
A spreadsheet that could automatically tally the courses advisees needed to take in order to graduate was developed in April 2023. The spreadsheet also provided information of use to an advisor during registration. Link to view the spreadsheet The first tab contains advisees, their program courses, their grade points in each course and a status flag. The advisees are listed in column A. Column B is their grade in a course recorded as grade points. This helps the advisor know what courses might need to be retaken. The code "ip" is used to denote that a course is in progress. Column C is whether a student is taking/has taken a course (1) or has not yet taken/needs to retake a course (0). Columns D to G are copied and pasted from templates on the second tab. All advisees in all programs are listed on the first tab. The second tab contains program templates as blocks of cells that are manually copied and pasted into the second tab ...