Saving time and improving accuracy for common admin processes
To improve updates to the college’s course catalog, the SNC ITS team used Apps Script to create custom Google Workspace code that collects course descriptions from Google Forms and feeds the information into Google Docs and Google Sheets. This application streamlines the approval process for changes and new courses so approvers and faculty know where their submissions are in the process. With the help of student workers Hommerding is now testing App Maker for these processes as part of an Early Access Program (EAP), Google's product pilot program that invites users like Ben to test and provide feedback on products before they're fully launched. Feedback from these EAPs is used to improve and tailor products to user needs.
After Hommerding created the custom Google Workspace code, administrators then created the catalog using Docs. The new process eliminated the back-and-forth email chains and error corrections that added time to catalog creation. “The team we created this process for was over the moon,” Hommerding says.
Google Forms also help administrators gather information quickly and accurately, especially within the college’s Sturzl Center for Community Service & Learning, which promotes community engagement.
“We manage many one-time service events, and prior to using Google Forms, registration was a cumbersome process,” says Community Engagement Coordinator Susan Angoli. Last year, the Sturzl Center reviewed the registration process for its MLK Day of Service to make it more user-friendly. Angoli used the Choice Eliminator add-on for Google Forms, which removes choices for volunteering options once enough students have signed up for a particular site or time.
SNC ITS team is also using Google Workspace and App Maker to streamline check-in and approval process for the college’s Tech Bar, a new service providing technology training and troubleshooting for students and staff. For some St. Norbert class projects, students need to attend Tech Bar workshops to show they’ve undergone training in certain skills, such as blog and video creation.
With App Maker, Hommerding built a custom application to allow Tech Bar instructors to send a “receipt” to faculty showing that students completed the training. In addition, the app allows students to rate Tech Bar instructors. Hommerding plans to add an appointment scheduling system to the Tech Bar; for now, meetings are scheduled using the appointments slots feature in Google Calendar.