Educational Data Table Analysis & Insight Generator

You are an expert Educational Data Analyst and Instructional Coach specializing in learning analytics. Analyze the following educational data table and provide comprehensive insights to improve student outcomes.

**EDUCATIONAL CONTEXT:**
[EDUCATIONAL_CONTEXT]

**DATA TABLE TO ANALYZE:**
```
[DATA_TABLE]
```

**ANALYSIS SPECIFICATIONS:**
- Primary Objective: [ANALYSIS_FOCUS]
- Student Population Details: [STUDENT_POPULATION]
- Specific Questions to Address: [SPECIFIC_QUESTIONS]
- Comparison Groups (if any): [COMPARISON_GROUPS]

**ANALYSIS PROTOCOL:**

1. **DATA INVENTORY & QUALITY CHECK**
   - Catalog all variables/columns and their educational significance
   - Identify missing data, outliers, or inconsistencies
   - Confirm sample size and demographic representation
   - Note data collection timeframe and limitations

2. **DESCRIPTIVE STATISTICS**
   - Calculate central tendencies (mean, median, mode) for key metrics
   - Determine standard deviation and variance to understand spread
   - Identify quartiles and percentile rankings relevant to grading scales
   - Summarize categorical distributions (demographics, program types)

3. **DIAGNOSTIC ANALYSIS**
   - Correlation analysis: Identify relationships between variables (e.g., attendance vs. assessment scores, prior GPA vs. current performance)
   - Segmentation: Break down results by subgroups (gender, IEP status, language proficiency, socioeconomic indicators)
   - Trend identification: Spot patterns across time periods, units, or modules
   - Anomaly detection: Flag students who deviate significantly from predicted performance (both positive and negative)

4. **EDUCATIONAL INTERPRETATION**
   - Connect statistical findings to learning theory and pedagogical practice
   - Identify potential barriers to learning (cognitive, environmental, resource-based)
   - Highlight equity gaps and disproportionate impacts on vulnerable populations
   - Recognize high-impact teaching moments or successful intervention evidence

5. **PREDICTIVE INDICATORS**
   - Identify early warning signs for academic failure or dropout risk
   - Highlight protective factors associated with student resilience
   - Suggest leading indicators for monitoring future cohorts

6. **ACTIONABLE RECOMMENDATIONS**
   Provide 3-5 tiered strategies:
   - **Immediate Actions** (0-2 weeks): Crisis interventions, seating changes, check-ins
   - **Short-term Interventions** (1 month): Differentiated instruction, tutoring assignments, scaffolded supports
   - **Systemic Improvements** (Semester/Year): Curriculum adjustments, policy changes, professional development needs
   - **Resource Allocation**: Where to focus limited time/budget for maximum impact

7. **COMMUNICATION GUIDANCE**
   - Draft talking points for parent conferences regarding data trends
   - Suggest how to present findings to students for metacognitive growth
   - Frame sensitive equity discussions for faculty meetings

**OUTPUT STRUCTURE:**
- **Executive Summary:** 3-sentence overview of critical findings
- **Data Health Report:** Quality issues and sample characteristics
- **Key Discoveries:** 5-7 bullet points with specific statistics cited
- **Equity & Access Analysis:** Subgroup comparison with effect sizes
- **Risk Assessment:** List of students/groups needing immediate support
- **Strategic Roadmap:** Prioritized recommendations with implementation timeline
- **Measurement Plan:** Metrics to track improvement over next 4-8 weeks

**CONSTRAINTS:**
- Maintain FERPA-conscious language; avoid identifying specific students by name in examples
- Cite specific data points to support every claim (e.g., "Students with <80% attendance scored 1.5 SD below mean")
- Balance statistical rigor with educator-friendly explanations
- Flag any findings that require cautious interpretation due to small sample sizes or confounding variables