A Year of Data Wrangling in a Time of COVID

Just about a year ago campus transitioned to work-from-home and classes moved to an online format. No one knew what the year would bring but we knew it would be nothing we had ever planned for and would require flexibility, adaptability and quick turnaround. Over the past year the Data Specialists in the Office of the Registrar have gone above and beyond to support the office, administration and students by fulfilling data requests to aid in the rapidly changing landscape.   The team has wrangled and reviewed data, created visualizations, updated reports and been an invaluable resource regarding the data requested. This is a new team that has quickly found their groove, built on solid years of experience and a trusted campus partner. Below are the highlights of the year of data wrangling; giving a brief glimpse into all the places we have assisted the Division of Enrollment Management and campus with the response to COVID.  
  • Partnered with University Health Services to provide data for testing populations, contact tracing and illness trends
  • Demonstrated and connected the correct audiences with visualization tools for tracing, such as the communicable illnesses and emergency response data for classroom utilization tracking
  • Created queries and reporting on instruction modes for campus and UHS partners
  • Represented the Office of the Registrar on a campus committee for COVID compliance data needs in Salesforce
  • Facilitated, tested and updated data feed in partnership with RO developers for COVID compliance tracking
  • Created enrollment and holds data visualization for tracking enrollment and enrollment related barriers
  • Created a course visualization preview for advising colleagues to assist with enrollment preparations
  • Provided aggregate data for university administration to determine compliance testing zip code parameters
  • Participated in a project to ensure instructors on campus had necessary microphones
  • Updated and provided enrollment reports and tracking for term and historical perspective
  • Updated grade distribution reports to reflect SD/UD grade options
  • Created PeopleSoft Query Community of Practice to help support staff remotely
  • Fulfilled numerous instruction mode reporting requests
  • Updated the Curricular Audit Tools viz to include instruction mode to provide information to campus users
  • Updated practices related to the Central Data Request to review and test for SD/UD grades and remote instruction mode