Tracking Two Sons' Tutoring Progress With Otter.ai, ChatGPT and Google Sheets

0 comments

Apps it uses

Skip the pictures to the steps

I'm a parent with two boys, one preparing for GCSEs and the other for the 11+ entrance exams, and they have several tutors covering Maths, English, Science and Music Theory. I wanted a better way to manage their education and to understand whether they were actually making progress. This is a parent-built system, not a commercial education product, and I developed it using AI tools without needing traditional software development skills. It suits any parent juggling multiple tutors who wants a structured view of what is being learned.

  1. I record tutoring sessions and use Otter.ai to generate transcripts. These give me a record of what was taught, questions the boys struggled with, tutor feedback and homework assigned.
  2. I use ChatGPT to review the Otter transcripts, summarise each lesson, identify areas of weakness, extract homework and recommend follow-up actions. It also compares feedback across sessions to see whether particular learning gaps are improving.
  3. I bring together lesson transcripts, tutor communications, school feedback, academic targets and our family calendar. ChatGPT helps consolidate this so I'm not constantly searching through emails, recordings and notes.
  4. I maintain a structured Google Sheets tracker for lesson history, progress information, schedules and parent actions.
  5. Using ChatGPT, I created a shareable website that brings everything together in one place. It covers both boys, their different subjects, tutoring schedules, progress checkpoints and outstanding actions.
  6. On Fridays I hold a progress checkpoint where ChatGPT helps review recent lessons, highlight learning gaps, identify overdue actions and suggest what to prioritise with each tutor.
  7. I use the analysis to prepare specific questions for tutors, adjust learning priorities and find additional practice material, which is particularly useful for GCSE and 11+ preparation.

The biggest benefit is that I'm no longer just paying for tutoring and hoping it's working. It also saves me time on organising schedules, reviewing recordings, summarising lessons and keeping track of what needs doing.

0 comments

Have a question about this workflow, or a way to improve it?

Log in to comment Create a free account

No comments yet. Ask the first question or say what worked for you.

Posting guidelines