Online Classroom Integration

Ontario Education Online

Designed seamless Google Classroom integration for provincial education platform, improving teacher workflow efficiency.

Online Classroom Integration

Overview

Ontario Education Online is a platform that offers high school courses to students across the province, with a mission to increase access to quality education through online learning. I was brought in to design and build the core digital workflows that power the business — from course purchasing and student intake to Google Classroom enrollment and teacher coordination.

As the sole designer and systems architect, I was responsible for translating a manually run education model into a scalable, automated web experience that could serve thousands of students, parents, and educators.

The Challenge

The existing process was entirely manual — involving spreadsheets, emails, and significant back-and-forth between admins, parents, and teachers. This led to:

  • Missed student onboarding steps
  • Delayed classroom access
  • High operational overhead
  • Limited visibility for educators

We needed to turn a disjointed process into a cohesive, automated experience — one that could handle real-time enrollment, data capture, and teacher notifications without requiring a full-scale engineering team.

My Approach

I designed a Shopify-powered purchase flow integrated with Google Sheets, Airtable, and Google Classroom via Zapier and custom scripting. The goal was to keep the front-end user experience simple while creating powerful back-end automations that would:

  • Enroll students in the correct Google Classroom based on the course they purchased
  • Notify teachers with relevant student/parent info
  • Track milestones like midterm and final report submissions
  • Trigger payments and reminders automatically

Key systems built:

  • Embedded student intake form with course sync to Airtable
  • Zapier workflows to create student rows, enroll in Google Classroom, and email stakeholders
  • Airtable dashboard for admin and teacher reporting
  • Midterm/final payment triggers based on student progress
  • Automated error logging and fallbacks

I also designed the updated website experience — including homepage, course catalog, testimonial sections, and partner pages — with a focus on mobile performance, clarity, and warmth for parents.

The Outcome

⏱ Reduced onboarding time from ~3 days to near-instant enrollment
🧠 Empowered teachers to focus on teaching, not admin
💸 Enabled reliable milestone-based teacher payments
📊 Gave the admin team real-time oversight of student progress
📈 Doubled enrollment capacity without adding headcount