Turn two weeks of paper classroom surveys into a data sheet, report and parent email with Gemini
- Posted
- by Jessica McKellar (LinkedIn)
- Last checked
- Method:
- How we verify
Evidence: Described by posterThe person describes what happened in words, without screenshots or video.
Outcome
Jessica McKellar volunteers as chair of the parent advisory committee at their daughter's two-campus preschool. When the school changed food programmes and got a lot of parent feedback, it ran two weeks of classroom surveys tracked on paper. McKellar photographed the sheets and gave them to Gemini, which turned them into spreadsheets of raw data, analysed and summarised them in a management report for the administrative team, and drafted an email for the school to send parents explaining the results.
Agent
Prompt Recreated prompt
The source didn't share its exact prompt, so we wrote this from what it describes.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn photos of paper survey sheets into clean data, a short report and a draft email to parents. Fill in before running: - Photos of the survey sheets: [ATTACH PHOTOS] - What the survey asked and over what dates: [DETAILS] - Who the report is for: [AUDIENCE] Rules: - Transcribe every sheet into one table, one row per response or tally, and list anything you couldn't read. - Total the results and show them by question, class and day. - Write a one-page summary of what the results show, without guessing at reasons. - Draft a short, neutral email to parents explaining the results. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: A spreadsheet-ready table, a one-page report and a draft email. You'll know it worked when: the school has clear results to act on and parents get a plain explanation.
Customize this prompt
Answer these questions and we'll put your answers into the prompt for you. You can leave any of them empty.
Your prompt
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn photos of paper survey sheets into clean data, a short report and a draft email to parents. Fill in before running: - Photos of the survey sheets: [ATTACH PHOTOS] - What the survey asked and over what dates: [DETAILS] - Who the report is for: [AUDIENCE] Rules: - Transcribe every sheet into one table, one row per response or tally, and list anything you couldn't read. - Total the results and show them by question, class and day. - Write a one-page summary of what the results show, without guessing at reasons. - Draft a short, neutral email to parents explaining the results. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: A spreadsheet-ready table, a one-page report and a draft email. You'll know it worked when: the school has clear results to act on and parents get a plain explanation.
Scroll to see the whole prompt. Your answers show in green.
3 blanks are still empty: Photos of the survey sheets; What the survey asked and over what dates; Who the report is for. They'll stay in brackets in your prompt, so the chat tool may ask you about them.
What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page. If you use a "Try this in" button, your answers go to that tool as part of the prompt.
Try this in:
This prompt has blanks to fill in, like [ATTACH PHOTOS]. We'll copy it instead of filling it in, so you can edit it before you send.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.
Optional stronger version
Our rewrite with extra checks. The poster didn't test it.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn photos of paper survey sheets into clean data, a short report and a draft email to parents. Fill in before running: - Photos of the survey sheets: [ATTACH PHOTOS] - What the survey asked and over what dates: [DETAILS] - Who the report is for: [AUDIENCE] Rules: - Transcribe every sheet into one table, one row per response or tally, and list anything you couldn't read. - Total the results and show them by question, class and day. - Write a one-page summary of what the results show, without guessing at reasons. - Draft a short, neutral email to parents explaining the results. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. - Make a simple chart for each question. Output: A spreadsheet-ready table, a one-page report and a draft email. You'll know it worked when: the school has clear results to act on and parents get a plain explanation. Before you finish: re-read my goal and constraints, check your answer against each one, and list anything you assumed or couldn't confirm.
Source
Related cases
- Understand a Year 2 maths worksheet well enough to help your child with GeminiRecreated promptEvidence: Described by posterBeginner-friendly
Matthew Wemyss, who has dyslexia, dyspraxia and dyscalculia, pointed Gemini's vision mode at the maths practice questions their Year 2 daughter had been set. Wemyss didn't use it to do the work; it talked them through an example so they understood what was being asked. After that the two of them spent the next half hour working through the questions together.
Gemini · Personal · Source date:
- Add a whole school year's calendar to the family calendar with Claude and catch clashes with work trips months aheadRecreated promptEvidence: Article or interview
Hally Peck, a chief marketing officer in New York with two kids and a husband who also works full-time, used to schedule life only days or a week ahead. Peck gave Claude the kids' school calendars for the year, with holidays, vacations and parent-teacher conference dates, and had it add them to the family calendar and cross-check school events against existing plans. It flagged a few conflicts with work trips already booked. Catching them months in advance rather than days or weeks means the family can resolve or plan around them.
Claude · Personal · Source date:
- Make a picture book to prepare a child with autism for a new school with Gemini's StorybookRecreated promptEvidence: Screenshots or logsBeginner-friendly
Ahead of their son starting a new school, the poster gave Gemini's Storybook Gem some background and his interests, uploaded a photo of the two of them, and got a short illustrated picture book. The poster, who works in education technology, plans to make more social stories this way.
Gemini · Personal · Source date: