Choose one of three approaches. The steps for that option appear below.
Choose an option above. On a phone, swipe the tabs left or right to see all options →
Gemini builds the pattern table and drafts the sheet. You correct the table, then check the final sheet.
Ready the inputs
Build pattern table
Correct the table
Draft feedback sheet
Check and decide
Use: You
Collect the ratio-response summary, representative errors and lesson objective. Keep the originals unchanged.
Check each file is the right one and your organisation allows the tool.
Use: Gemini
In Gemini, add the checked data and ask for the pattern table with counts and examples, each count showing how it was reached.
What to paste into the tool
From the added data, build an anonymous pattern table with counts and examples. Show how each count was reached. If something is not in the data, write UNRESOLVED.
Use: You
Correct the draft pattern table row by row and keep the unresolved items in place.
Check the counts against the originals and recount a sample by hand.
Use: Gemini
Ask Gemini to draft the class feedback sheet with worked examples and correction tasks, using only the corrected table.
What to paste into the tool
From this corrected pattern table, draft a class feedback sheet with anonymous examples and correction tasks. Use only what is in the table. If something is not in the table, write UNRESOLVED.
Use: You
Decide what to keep in the final class feedback sheet.
Check each statement traces to the corrected table and tasks address patterns without ranking learners.
Gemini Notebook drafts the table and the sheet. You correct the table in between, then check the final sheet.
Ready the inputs
Draft pattern table
Correct the table
Draft feedback sheet
Check and decide
Use: You
Collect the ratio-response summary, representative errors and lesson objective. Keep the originals unchanged.
Check each file is the right one and your organisation allows the tool.
Use: Gemini Notebook
Add the checked inputs to a notebook and ask for the pattern table with counts, examples and source locations.
What to paste into the tool
Using only the added inputs, produce an anonymous pattern table with counts and examples. Give one row per item with its source location. If the inputs do not support a row, write UNRESOLVED. Do not add outside facts.
Use: You
Correct the draft pattern table row by row and keep the unresolved items in place.
Check the counts against the originals and recount a sample by hand.
Use: Gemini Notebook
Give Gemini Notebook the corrected table and ask for the class feedback sheet with worked examples and correction tasks.
What to paste into the tool
Using only the corrected table, draft the class feedback sheet with anonymous examples and correction tasks. Mark anything the table does not support as UNRESOLVED.
Use: You
Decide what to keep in the final class feedback sheet.
Check each statement traces to the corrected table and tasks address patterns without ranking learners.
Coda builds the pattern table and drafts the feedback sheet in one go. You check and decide.
Ready the inputs
Build table and sheet
Check and decide
Use: You
Collect the ratio-response summary, representative errors and lesson objective. Keep the originals unchanged.
Check each file is the right one and your organisation allows the tool.
Use: Coda
Ask Coda for a pattern table with counts and examples, then the feedback sheet with correction tasks, then a summary of the draft.
What to paste into the tool
From the added data, build an anonymous pattern table with counts and examples, showing how each count was reached. Then draft a class feedback sheet with anonymous examples and correction tasks from that table only. If something is not in the data, write UNRESOLVED. Summarize this draft in a short list of points. Do not add content that is not in the draft.
Use: You
Compare the summary with your intent, point by point; correct the sheet where they differ.
Check counts against the originals and recount a sample by hand. Check each draft statement traces to a row of the table. Check tasks address patterns without ranking learners.
Best when: You want the tool to build both drafts, you correct between stages
What it does: Gemini builds the table and drafts the sheet; you correct and check
Strong at: Pulls data from files and answers plain-language requests
Limit: Not confirmed to build this exact table; test on a small sample
Free plan: Yes
Best when: You want both stages drafted, with your correction in between
What it does: Gemini Notebook drafts both stages; you correct the table and check
Strong at: Answers cite quoted text from your uploaded sources
Limit: Not confirmed to build this exact table; test on a small sample
Free plan: Yes, limited (notebook and source caps)
Best when: You want a table and a first feedback draft in one place
What it does: Coda builds the table and drafts; you check
Strong at: Can draft from scratch, summarise and build tables
Limit: Not confirmed to build this exact table; test on a small sample
Free plan: Yes, limited (1 GB attachments per doc)
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Every stage output is checked by the named person before the next stage.
Unresolved items stay visible and are not filled in by the tool.
Only the supplied sources are used as authority.
Check the result against your original inputs. Approve it before sharing or acting.