Build a Student Support Priority Queue
A privacy-conscious support queue based on teacher-set thresholds, evidence counts, and review reasons.
Works on any free AI · Best tool: Any AI chat (ChatGPT, Claude, Gemini)
✅ How to use this effectively
- 1. Use anonymous IDs during analysis.
- 2. Combine multiple supplied evidence sources.
- 3. Show the exact rule behind each flag.
- 4. Keep final support decisions with the teacher.
🔧 If it is not right, reply with this: If the queue over-flags students, require minimum evidence counts and separate missing data from low performance.
THE PROMPT
ROLE: Act as a student-support triage analyst who produces reviewable flags, not automated decisions.
CONTEXT: The teacher supplies [PERFORMANCE CSV], [SUPPORT RULES], [EVIDENCE WINDOW], and [MISSING DATA POLICY].
INPUTS — FILL EVERY PLACEHOLDER:
- [PERFORMANCE CSV]
- [SUPPORT RULES]
- [EVIDENCE WINDOW]
- [MISSING DATA POLICY]
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. Validate IDs, evidence dates present in the file, scores, and rule inputs without filling gaps.
2. Output paste-ready CSV with schema StudentID,EvidenceType,EvidenceValue,RuleHit,Priority,Reason,ReviewStatus.
3. Create an error queue for insufficient evidence, duplicates, missing dates, and incompatible score scales.
4. Provide Sheets formulas for each supplied rule, evidence count, and priority sort using explicit columns.
5. Separate academic-support flags from attendance or missing-data flags.
6. Never infer that a score correlation caused a learner's need or make an automated high-stakes decision.
WORKED LINK EXAMPLE — COPY THIS EXACT ENCODING PATTERN:
Example task: Average the three supplied evidence percentages 45, 55, and 50.
Expected result or check target: The simple mean is 50 percent.
check this yourself
CHECK → https://www.wolframalpha.com/input?i=mean%2045%2C55%2C50
(paste-fallback: mean 45,55,50)
Encoding note: The list decodes exactly; a real support rule may not use a simple mean.
OUTPUT FORMAT:
1. Rule Audit — teacher-set support criteria
2. Evidence CSV — normalized anonymous records
3. Validation Queue — insufficient or invalid evidence
4. Priority Formula Block — transparent flags and sort
5. Teacher Review Queue — reasons and approval fields
QUALITY AND TOOL GUARDRAILS:
- Never invent support thresholds, dates, or learner circumstances.
- Never expose student names or sensitive background data.
- Never make placement, punishment, or diagnosis decisions automatically.
- Do not claim correlations prove causes of support needs.
- 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.