SU-E-E-02: Dashboard for Tracking Physics Resident Progress

Authors


Abstract

Purpose:

Design a system to easily and securely track the progress of medical physics residents through their residency. Paper sign-offs while offering a real signature are not easily updated or summarized. A resident or mentor needs to be able to quickly assess what the current assignments are, what are overdue, and whether the resident is on track to complete all the tasks in a timely fashion. An electronic version can accomplish all these goals.

Methods:

An electronic dashboard was created in excel to not only house the tasks and sign-off but to succinctly summarize the residents progress. The first tab contains the dashboard which displays tables of the progress of the residents in each rotation, their current task, and overdue tasks. It also displays the last meetings with the residents, and timeline of important items, and a burn-down chart of the remaining tasks. This are all tied to the data and current date which auto fills the tables. The second tab contains the data. This is comprised of lists of rotations and their associated tasks along with their due dates. A signature column was also created which is password protected but allows special subset users i.e. mentors to alter without using a password.

Results:

The dashboard has allowed residents to better track their progress and tells them what they should be working on. It has also allowed the mentors and the program director to rapid assess their progress.

Conclusion:

The dashboard is successful and has been created to allow easy addition and subtraction of required tasks as the residency evolves. The next step is to create a web app version of the excel sheet with logins.

Ancillary