24th July 2023 to present
Birmingham City University
Academic Services
Various tasks associated with the on-going maintenance and improvement of processes allowing students to submit absences and staff to review absence submissions.
BCU had a number of complex rules governing when a student absence would require authorisation by their tutor. A key metric concerned the number of absence days taken by the student during the current academic year. I wrote a process (largely using PL/SQL) in order to calculate the total absences taken by a student during the current academic year, producing two metrics: total calendar absence days, and total working day absences (that is, by excluding weekends, bank holidays and any other holidays as defined by the university).
The project covered the management and continual upkeep for tasks in e:Vision related to dissertation and placements. Custom views existed for both staff and students.
Administrative staff required the means to assign a secondary dissertation supervisor to a student, where applicable. In turn, the student would then need to view details of their currently assigned dissertation supervisor(s). Azure DevOps ref 12127.