Savannah Xu collaborated with the Palau Ministry of Education to enhance the management and accessibility of Special Education data and improve the operational efficiency of the Ministry.
During her project with the Palau Ministry of Education, student consultant Savannah Xu focused on consolidating and cleaning the Special Education data, which was previously scattered across 1,200 Excel files. She developed a Python tool that automated the extraction and cleaning process, resulting in a master file that is accurate, consistent, and easily accessible. Additionally, Savannah redesigned the Student Information System (SIS) website, incorporating an automated issue tracking system to ensure no concerns were overlooked, and reorganized the MOE Resource site for improved user-friendliness. The project included creating Standard Operating Procedures (SOPs) to streamline common tasks within the Rediker Software. Savannah's work significantly enhances data management and operational efficiency within the Ministry, supporting its mission to ensure that children and youth thrive in Palauan society and beyond.