Wednesday, August 30, 2017

Automating Teacher Recommendation Forms





The technology team recently debugged issues with the teacher recommendation forms used in the college application process.  Teachers were experiencing many software-related issues and generating tickets to correct a malfunction in the PDF file.  In conjunction with College Counseling, technology office team reviewed the existing system, analyzed potential solutions, and created an automated process to address the issue.  The system combines the use of Google Forms, Google Spreadsheets, Google Docs, and Gmail. Teachers submit a Google form, a script creates a Google doc in the correct format, generates a PDF, and emails it as an attachment to both the teacher and college counselors. A final form is automatically saved in Google Drive and the information is stored in a Google Spreadsheet.

No comments:

Post a Comment