MyTrips Comparison Tool

The Problem

Every term, students studying abroad have to register their travel in myTrips and then get credit for it in a Canvas course. When i first arrived to the office this task meant manually matching names across canvas and the MyTrips website which took hours to complete manually.

The Solution/Tool

My first solution to this problem was to write a Excel script that allowed me to compare the spreadsheets and produce a list of students that where yet to be graded, this reduced the time to do the task to half of hours instead of hours as before. I made a tutorial that could be used by other GEO staff but quickly noticed that the process of using an excel script was too much of a barrier of entry that the script went unused. This led me to this solution where i used Claude AI to convert the excel scripts functionality into a .html page that creates a easy to use GUI to interact with the code. I now host this tool below and because its a simple html page all data stays on the devices at the school and nothing is saved or kept so it acts the same as using Excel.