Saving time and improving accuracy for common admin processes
To improve updates to the college’s course catalogue, 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 that approvers and members of staff 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 Programme (EAP), Google's product pilot programme 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 catalogue using Docs. The new process eliminated the back-and-forth email chains and error corrections that added time to catalogue creation. 'The team that 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 Centre 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 Centre 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.
The ITS team at SNC 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 that 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 staff members showing that students had 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 slot feature in Google Calendar.