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 a skill-by-date table, then drafts cautious trends. You correct the table between passes.
Get ready
Build the table
Correct the table
Draft the trends
Compare and decide
Use: You
Four dated fraction checks, skill tags, item counts and answer criteria.
Use: Gemini
Attach the checks to Gemini Apps web chat. Normalise attempts by skill and conditions into a skill-by-date table.
What to paste into the tool
Task: Skill-by-date table with denominators and changes. Using only the uploaded checks, skill tags, item counts and answer criteria, build a skill-by-date table with attempt IDs, denominators, conditions and missingness. Treat missing attempts as missing, not as failures, and flag any change in difficulty or conditions between checks. Mark uncertainty instead of inventing marks.
Use: You
Check original marks and task comparability against the table. Correct it and keep unresolved items.
Check every row against the original marks.
Use: Gemini
Give it the corrected table and ask for cautious trends and next learning checks.
What to paste into the tool
Task: Draft progress narrative with denominators and comparison limits. From the corrected skill-by-date table, draft a cautious progress review: describe observed performance only, keep denominators explicit, flag changed difficulty, and propose next learning checks. Do not infer mastery; mark uncertainty instead.
Use: You
Compare the trends with the corrected table and originals, then decide next checks.
Check the narrative describes observed performance only, flags changed difficulty, claims no mastery, uses matched skills and explicit denominators, and keeps missing attempts missing. The chosen next checks change no grades or placement.
Gemini Notebook drafts a Data Table. You write observed-performance wording in Sheets. Claude drafts limits and next checks.
Get ready
Generate the table
Write statements
Draft limits
Compare and decide
Use: You
Four dated fraction checks, skill tags, item counts and answer criteria.
Use: Gemini Notebook
Attach the checks to a Gemini Notebook chat. Generate a skill-by-date Data Table with denominators, conditions, missingness and citations.
What to paste into the tool
Task: Skill-by-date Data Table with citations, denominators and changes. Using only the sources in this notebook, generate a Data Table with one row per attempt: attempt ID, date, skill, denominator, conditions and missingness. Treat missing attempts as missing, not as failures, and flag any change in difficulty or conditions. Customize the rows and columns to match this structure.
Use: You
Export to Google Sheets, check marks, correct rows, and write one observed-performance statement per skill. Attach the table as TXT to Claude.
No mastery wording. Check every row and citation against the original marks and conditions; each citation points to the right check.
Use: Claude
Ask for comparability limits and next learning checks, leaving the teacher's observed statements as written.
What to paste into the tool
Task: Draft progress narrative with denominators and comparison limits. From the pasted annotated table, keep the teacher's observed-performance statements exactly as written and draft only: the comparability limits (changed difficulty, differing denominators, missing attempts that are not failures) and proposed next learning checks. Do not infer mastery; mark uncertainty instead.
Use: You
Compare the narrative with the corrected table and originals, then decide next checks.
Check the narrative keeps your statements word for word, describes observed performance only, uses explicit denominators, keeps missing attempts missing, and flags changed difficulty.
ChatGPT drafts the skill-by-date table, then the narrative. You check both against the originals.
Get ready
Draft the table
Check the table
Draft the trends
Compare and decide
Use: You
Four dated fraction checks, skill tags, item counts and answer criteria.
Use: ChatGPT
Ask ChatGPT to draft a skill-by-date table from the checks, with denominators and changes.
What to paste into the tool
Task: Draft skill-by-date table with denominators and changes. From the supplied screened copies only, draft a skill-by-date table: every attempt with its skill, denominator, conditions and any missing attempt. Do not invent results and do not infer mastery.
Use: You
Check every drafted row against the original marks and correct the table. Keep unresolved items.
Check denominators, conditions and missingness.
Use: ChatGPT
Attach only the checked table to a ChatGPT conversation. Ask for cautious trends and next learning checks.
What to paste into the tool
Task: Draft progress narrative with denominators and comparison limits. From the supplied skill-by-date table only, draft a cautious progress review: describe observed performance only, keep denominators explicit, flag changed difficulty, and propose next learning checks. Do not infer mastery and do not invent data beyond the supplied table.
Use: You
Compare the trends with your corrected table and the originals, decide next checks.
Check the narrative uses only the supplied table, describes observed performance only, flags changed difficulty, claims no mastery, and keeps missing attempts missing.
Best when: You want one chat to build and draft
What it does: Gemini builds the table and drafts trends; you correct
Strong at: Table feeds the narrative directly
Limit: You check every row against originals
Free plan: Yes, limited
Best when: You want the observed wording to be yours
What it does: Notebook tables; you write statements; Claude adds limits
Strong at: Your statements stay word for word
Limit: Extra export and attach step
Free plan: Yes, limited (notebook/source and 5-hour usage caps)
Best when: You want AI to draft table and narrative
What it does: ChatGPT drafts both; you check each against originals
Strong at: Narrative built on a table you checked
Limit: Two checking passes for you
Free plan: Yes, limited (uploads and data analysis)
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Deciding between ChatGPT and Claude for this? See the comparison.
Compare the proposed trends with matched skills and explicit denominators, flag changed difficulty, treat missing attempts as missing, separate observed performance from inferred mastery and choose next checks without changing grades or placement.
Check the result against your original inputs. Approve it before sharing or acting.