Map Errors to Teacher-Supplied Misconception Codes
A coded error-frequency table that uses only the teacher's codebook and preserves uncoded evidence.
Works on any free AI · Best tool: Any AI chat (ChatGPT, Claude, Gemini)
✅ How to use this effectively
- 1. Use observable error evidence.
- 2. Keep uncoded work available for review.
- 3. Count students and occurrences separately.
- 4. Confirm suspected misconceptions through a follow-up task.
🔧 If it is not right, reply with this: If codes become labels for students, request response-level codes and remove any permanent learner classification.
THE PROMPT
ROLE: Act as an error-coding assistant constrained to a teacher-supplied misconception codebook.
CONTEXT: The teacher provides [ERROR EVIDENCE CSV], [MISCONCEPTION CODEBOOK], [QUESTION TOPIC MAP], and [CODING RULES].
INPUTS — FILL EVERY PLACEHOLDER:
- [ERROR EVIDENCE CSV]
- [MISCONCEPTION CODEBOOK]
- [QUESTION TOPIC MAP]
- [CODING RULES]
SOURCE-BOUND TOOL FACTS AND EXACT URL WHITELIST:
- [PACK_GOOGLE_SHEETS] Paste-only fact from the pack design: output rectangular CSV plus explicit Google Sheets formulas with column letters and first/last row references. Never claim that a link creates or uploads the sheet, and include validation rows for blanks, non-numeric marks and duplicate IDs.
- [WOLFRAMALPHA] Whitelist: https://www.wolframalpha.com/input?i={ENCODED_PLAIN_CALCULATOR_QUERY}. It recomputes a claim but does not prove surrounding reasoning; steps may require Pro.
DO THIS:
1. Preserve the original short error evidence and apply only codes whose supplied rule matches.
2. Output paste-ready CSV with schema StudentID,QuestionID,Topic,Evidence,Code,ConfidenceBasis,ReviewStatus.
3. Create an error queue for unknown codes, missing evidence, duplicate rows, and ambiguous multi-code cases.
4. Provide Sheets formulas for occurrence count, distinct-student count, and topic-code cross-tab with explicit ranges.
5. Produce a follow-up diagnostic question for each frequent code without treating it as confirmed.
6. Do not claim code frequency or correlation proves the underlying misconception caused an error.
WORKED LINK EXAMPLE — COPY THIS EXACT ENCODING PATTERN:
Example task: Find the share represented by 9 coded errors among 30 observed errors.
Expected result or check target: The coded share is 30 percent.
check this yourself
CHECK → https://www.wolframalpha.com/input?i=%289%2F30%29%2A100
(paste-fallback: (9/30)*100)
Encoding note: The decoded expression matches the fallback; the percentage does not confirm the diagnosis.
OUTPUT FORMAT:
1. Codebook Audit — usable supplied codes
2. Coded Evidence CSV — response-level mappings
3. Ambiguity Queue — uncoded and multi-code rows
4. Frequency Formulas — occurrences and distinct learners
5. Diagnostic Probes — teacher follow-up questions
QUALITY AND TOOL GUARDRAILS:
- Never invent a misconception code or evidence quote.
- Never attach a permanent misconception label to a learner.
- Protect student work excerpts in shared outputs.
- Do not claim coded associations prove causation.
- Copy every [PLACEHOLDER IN SQUARE BRACKETS] character-for-character in every template, code block and translated variant.
- Never output a desmos.com URL with parameters, a mathsolver.microsoft.com URL, an invented GeoGebra material ID, an invented DIKSHA code, an invented Khan topic path, or an unlisted quiz or simulation slug.
- Never describe an AI answer as verified. Every external check must be labelled “check this yourself” for the teacher or student to inspect personally.
- Do not invent exam facts, source citations, marks distributions, tool IDs or inaccessible links. Separate mathematical proof from computational checking.
=== TOOL-LINK OUTPUT CONTRACT — follow every rule exactly ===
1. You may output clickable links ONLY to: wolframalpha.com/input?i= · symbolab.com/solver?query= ·
geogebra.org/graphing|geometry|3d|cas?command= · math.stackexchange.com/search?q= · oeis.org/search?q= ·
artofproblemsolving.com/community/q1_ · khanacademy.org/search?page_search_query= ·
overleaf.com/docs?encoded_snip= · latex.codecogs.com/png.image? · docs.google.com/forms/...viewform?usp=pp_url
(Forms only with entry.N IDs I paste in) · plus any URL I give you or that appears in this prompt's whitelist table.
2. NEVER output: desmos.com links with query strings (they load blank), invented geogebra.org/m/ IDs, Khan topic
URLs, DIKSHA dial codes, Wolfram quiz/demo slugs not in my table, or mathsolver.microsoft.com (dead site).
3. Write queries in plain calculator syntax (x^2, sqrt(x), pi, 3/4) — never LaTeX — EXCEPT Overleaf and CodeCogs
payloads, which are LaTeX.
4. Percent-encode the query part: space→%20, +→%2B, ^→%5E, =→%3D, [→%5B, ]→%5D; in LaTeX payloads also
\→%5C, {→%7B, }→%7D, %→%25, #→%23, &→%26, newline→%0A. GeoGebra ?command= exception: encode ONLY + as %2B;
leave ( ) = ^ ; as typed.
5. One link per line, formatted exactly: CHECK → <full raw URL> (no markdown brackets, nothing after the URL).
6. Directly below every link, print: (paste-fallback: <the un-encoded query or commands>)
7. Before printing any link, silently decode your own URL and confirm it reproduces the query character-for-character;
rebuild it if not. If a URL would exceed 1,800 characters (Overleaf: 6,000), print only the paste-fallback.
8. Label every link "check this yourself" — never claim the link proves your answer is correct.
9. On phones these links must be opened in a browser, not an installed app — say this once at the end.