Automatic Reports from University Survey Data
Faculty Sponsor(s)
Kate Lorenzen
Subject Area
Mathematics
Description
Consulting job done for Data Science Consulting Class Fall 2024. For this project, I was tasked with helping Jennifer Ballard in the institutional research department to create a script that would automatically generate reports when a new survey year was given. This survey data was taken each year from alumni who had graduated the previous year. To create the report, I started by going through all the data and coming up with ideas on what I could do that would be of interest in a report. Then, I went through and created tables and graphs of every column I could, cleaning the data as needed and combining columns when appropriate. I then had meetings with Jennifer Ballard to present my progress, and she told me what order she wanted the data presented in, as well as what data was not important. I then went through and put the data for the reports in order and formatted the tables and charts. Through a couple more meetings, I finalized the script and sent the script along with the reports for each year of data gathered so far. These reports were split up by department, as well as major.
Recommended Citation
Crossler, Aidan J., "Automatic Reports from University Survey Data" (2025). Linfield University Student Symposium: A Celebration of Scholarship and Creative Achievement. Event. Submission 9.
https://digitalcommons.linfield.edu/symposium/2025/all/9
Automatic Reports from University Survey Data
Consulting job done for Data Science Consulting Class Fall 2024. For this project, I was tasked with helping Jennifer Ballard in the institutional research department to create a script that would automatically generate reports when a new survey year was given. This survey data was taken each year from alumni who had graduated the previous year. To create the report, I started by going through all the data and coming up with ideas on what I could do that would be of interest in a report. Then, I went through and created tables and graphs of every column I could, cleaning the data as needed and combining columns when appropriate. I then had meetings with Jennifer Ballard to present my progress, and she told me what order she wanted the data presented in, as well as what data was not important. I then went through and put the data for the reports in order and formatted the tables and charts. Through a couple more meetings, I finalized the script and sent the script along with the reports for each year of data gathered so far. These reports were split up by department, as well as major.
