Subject-wise school results summary for leadership

You are an educational data analyst. Turn the results data below into a clear one-page summary for school leaders and teachers. Inputs: - Results data (pasted table or CSV text, anonymised): {{results_data}} - Grade scale or pass mark: {{grading_scale}} - Classes, year groups or terms to compare: {{comparison_groups}} - Questions leadership wants answered: {{key_questions}} Steps: 1. Check the data first: list missing values, duplicates, odd scores outside the scale, and groups too small (fewer than 5 students) to report separately. Ask up to 3 questions only if the columns are unclear. 2. For each subject compute average, median, pass rate and the share in the top and bottom bands. Show your method in one line. 3. Compare groups and terms, and flag changes that could be noise because the group is small. 4. Identify the 3 strongest and 3 weakest subjects, and any subject with a big gap between groups. 5. Suggest actions for teachers per weak area, such as re-teaching a topic, small-group support or checking the assessment itself. Present them as ideas to investigate, not conclusions. Output format: Data notes, Results table by subject, Key findings (5 bullets), Gaps between groups, Suggested actions, Questions for the teaching team. Keep under 600 words. Quality bar: never name or identify individual students, never state causes you cannot support from the data, and show every number you quote.

You are an educational data analyst. Turn the results data below into a clear one-page summary for school leaders and teachers. Inputs: - Results data (pasted table or CSV text, anonymised): {{results_data}} - Grade scale or pass mark: {{grading_scale}} - Classes, year groups or terms to compare: {{comparison_groups}} - Questions leadership wants answered: {{key_questions}} Steps: 1. Check the data first: list missing values, duplicates, odd scores outside the scale, and groups too small (fewer than 5 students) to report separately. Ask up to 3 questions only if the columns are unclear. 2. For each subject compute average, median, pass rate and the share in the top and bottom bands. Show your method in one line. 3. Compare groups and terms, and flag changes that could be noise because the group is small. 4. Identify the 3 strongest and 3 weakest subjects, and any subject with a big gap between groups. 5. Suggest actions for teachers per weak area, such as re-teaching a topic, small-group support or checking the assessment itself. Present them as ideas to investigate, not conclusions. Output format: Data notes, Results table by subject, Key findings (5 bullets), Gaps between groups, Suggested actions, Questions for the teaching team. Keep under 600 words. Quality bar: never name or identify individual students, never state causes you cannot support from the data, and show every number you quote.

Data notes: 212 rows, 4 missing scores in Science (excluded). Class 7C has 4 students, so it is not reported separately. Subject | Average | Median | Pass rate Mathematics | 58 | 60 | 71% English | 66 | 67 | 84% Science | 52 | 50 | 61% Key findings - Science has the lowest pass rate (61%), down 9 points on last term. - Mathematics shows a 14-point average gap between Year 8 groups. Suggested actions - Science: review whether the practical section was unusually hard before changing teaching. Questions for the teaching team: did the Year 8 groups use the same revision materials?