Streamlining Scholarship Management with Form Director:
A Success Story from Chagrin Falls Schools
How Brian McKenna revolutionized the scholarship program with automation, saving time and ensuring accuracy for over a dozen committees
Quick facts
Location: 400 East Washington Street
Chagrin Falls, OH 44022
440-247-5500
Industry: Education
Chagrin Falls Exempted Village Schools, located in Chagrin Falls, Ohio, is a small suburban school district renowned for its high academic standards and commitment to student excellence.
Discover how an innovative educational institution streamlined its scholarship application process using automation.
By integrating Form Director, they transformed manual workflows into an efficient, error-free system that saves time and ensures accuracy. See how automation enhances productivity and simplifies data management in education
By integrating Form Director, they transformed manual workflows into an efficient, error-free system that saves time and ensures accuracy. See how automation enhances productivity and simplifies data management in education
About Chagrin Falls Exempted Village Schools
Chagrin Falls Exempted Village Schools is a high-performing, suburban school district located in Ohio. With a history dating back to 1849, the district comprises four schools: a primary, intermediate, middle, and high school, serving the community with dedication to excellence. Consistently ranked in the top 3% of Ohio's 611 districts and recognized nationally for its academic standards, the district has received numerous accolades, including five-star ratings across categories in the Ohio School Report Card, U.S. News & World Report rankings, and multiple Blue Ribbon recognitions.
The district places a strong emphasis on community engagement, offering programs like Community Education and opportunities for professionals to connect with students. Chagrin Falls Schools has a culture of innovation and excellence in academics, arts, and financial transparency.
The Challenge
Brian McKenna, a teacher and the Alumni Director at Chagrin Falls Schools, was facing a logistical challenge in managing the district’s annual scholarship program.
Each year, students submit applications through Google Forms for a dozen different scholarship committees. Brian needed a way to efficiently organize and present the completed forms in a readable, categorized format for each committee.
This process required significant manual effort, with forms needing to be reviewed, formatted, and sorted into individual folders.
The workflow was time-consuming, prone to errors, and created bottlenecks in the scholarship process.
Seeking a Solution
Brian McKenna, a dedicated teacher and Alumni Director at Chagrin Falls Schools, faced a significant challenge during the annual scholarship program. Managing the data and creating organized documents for multiple scholarship committees became a daunting task.
He needed:
Automation: A tool that could seamlessly convert Google Form submissions into human-readable, professionally formatted documents without manual intervention.
Efficient File Organization: A streamlined system to automatically organize these documents into separate folders, ensuring each scholarship committee received the correct submissions without any mix-ups.
User-Friendly Scalability: A reliable solution that was simple to implement, easy to use, and scalable to handle the increasing volume of submissions year after year.
Form Director as a Solution
Brian McKenna turned to Form Director, a Google Workspace add-on, to streamline and automate the scholarship program’s data management process. With Form Director, the workflow was transformed:
Automated Document Creation: Completed Google Form submissions were automatically converted into well-formatted Google Docs. - Make it specific
Efficient Organization: Each Scholarship application document was pushed into designated Google Drive folders, ensuring every scholarship committee had easy access to its respective applications.
Time-Saving Automation: The entire program’s data management process, from form submission to document organization, was automated, eliminating the need for manual intervention.
Results
With Form Director, Brian McKenna successfully eliminated the inefficiencies in the scholarship program’s management. The district experienced:
Time Efficiency: The time required to process and organize applications was drastically reduced, allowing staff to focus on more impactful tasks.
Enhanced Accuracy: Automation minimized errors, ensuring that scholarship applications were properly formatted and organized.
Improved Accessibility: Scholarship committees could access their respective documents quickly and efficiently, improving their ability to review applications thoroughly.
Brian McKenna praised the integration, stating, “With the help of Form Director, the completed forms are automatically pushed along into templates. The final result is readable documents separated into respective folders for over a dozen scholarship committees.”
The scholarship committee was pleased with the automated solutions deployed by Brian McKenna
Testimonial
"We have an annual scholarship program where students complete a Google Form. With the help of Form Director, the completed forms are automatically pushed along into templates.
The final result are readable documents separated into respective folders for over a dozen scholarship committees."
_ Brian McKenna, a teacher and the Alumni Director at Chagrin Falls Schools
The final result are readable documents separated into respective folders for over a dozen scholarship committees."
_ Brian McKenna, a teacher and the Alumni Director at Chagrin Falls Schools
About Brian McKenna
Brian McKenna is a dedicated educator and the Alumni Director at Chagrin Falls Exempted Village Schools, with over 25 years of experience. He has been with the district since 1999, contributing as both a teacher and administrator. Brian holds a Master of Education (MEd) from The Ohio State University and a Bachelor of Arts (BA) from Skidmore College.
In his current role, he plays a key part in managing the scholarship program and improving student services, leveraging tools like Form Director to streamline processes.
His commitment to education and community makes him a valued member of the Chagrin Falls Schools family.
About Jivrus Technologies and Form Director
Jivrus Technologies is a software products company focused on intelligent integration and hyper-automation. Our goal is to connect people and software platforms to streamline processes and drive growth. Our products are designed to provide a seamless and efficient user experience.
Form Director” is an add-on application for Google Workspace that directs your Google Form submissions to Google Workspace apps like Google Docs, Slides, Sheets, Calendar, Contacts, Tasks, etc, and external systems like Database, Trello, Slack, Asana, HubSpot, PayPal, Webhook, Insightly, Quickbooks & many more.