Analyzing school assessment results for leadership teams

Usage context

A principal, academic coordinator, or district administrator who needs to present standardized assessment results to the teaching staff, school board, or broader school community. This prompt converts a table of scores into a narrative analysis focused on the most relevant gaps and actionable levers for improvement.

Paste before

Data must be fully anonymized before you paste it. Never include:

• Individual student names or ID numbers
• Individual performance records linked to a specific person
• Special education needs records tied to individuals

Paste instead:

• Average scores by grade level (e.g., "Grade 4: 267 points in Reading")
• Year-over-year comparisons or benchmarks against your network/national average
• Performance distribution by achievement band (e.g., Below Basic / Basic / Proficient / Advanced), without individual linkage
• School context: socioeconomic index, school type, approximate enrollment

You are an education data analyst helping a school leadership team interpret standardized assessment results. I need to prepare an analysis to present to the teaching staff and school board.

Assessment data (anonymized):
{{assessment_data}}

School context:
{{school_context}}

Please:
1. Identify the three most significant gaps in the results (between grade levels, between subjects, between achievement bands, or over time).
2. For each gap, offer a possible explanatory hypothesis — not a definitive conclusion, but a question the team should investigate.
3. Identify two or three strengths evident in the data that deserve explicit recognition with the teaching staff.
4. Propose three concrete action lines for the next semester, ordered by feasibility.
5. Draft an introductory paragraph for the staff presentation, in an informative, non-alarmist tone.

Avoid treating national averages as the only measure of success. The school's socioeconomic context matters for interpreting results accurately.

Expected output

GAPS IDENTIFIED

1. Reading in Grade 4: the Below Basic band grew from 18% to 29% between 2023 and 2024. Hypothesis worth exploring: Was there staff continuity in that grade level? How was post-pandemic recovery handled?

2. A 31-point gap between the highest and lowest performing Grade 6 Math classrooms. Hypothesis: differences in instructional approach between parallel classes…

STRENGTHS
- In Grade 8 Science, the Proficient+Advanced band grew by 12 points. This coincides with the shift to collaborative lesson planning in that team.

INTRODUCTORY PARAGRAPH
"This year's results give us useful information about where we stand and what we need to sharpen. Rather than dwelling on the numbers alone…"

Watch out for

• Never paste individual student records, ID numbers, names, or special education files. Only aggregated, anonymized data. This applies even if you're using a private or local model.
• AI models can suggest causal relationships where there are only correlations. Every hypothesis the model produces is a starting point for team discussion, not a conclusion.
• If your school has confidentiality agreements with your district or education authority regarding assessment data, check whether using an external AI tool is compatible with those agreements before pasting any data.

Suggested iteration

If you need a version for parents (simpler language): "Adapt the introductory paragraph to communicate results to families. Everyday language, no technical terms like 'achievement bands,' no data that could prompt comparisons between classrooms."

If you want a more focused analysis: "Focus the analysis only on Reading from Grades 1–4. I want to understand the learning trajectory across that cycle."