Analyze the ELA and Math scores for each school system. (with deep research)

Prompt: Analyze the ELA and Math scores for each school system. 

Methodolgy: 

Analyzing WV School Performance Data

Research Websites and Files

(1) Search online for the definitions of "Assessment ELA Performance Value" and "Assessment ELA Progress Value" in the context of the West Virginia (WV) Balanced Scorecard system to understand the scoring metrics used in the provided file. (2) Access the uploaded file `WV_Balanced_Scorecard_Data_2025 (1).xlsx - SY25 Balanced Scorecard Results.csv`. (3) For each `District Name`, locate the row where the `School Name` is "District Record", the `School Type` is "All Schools", and the `Subgroup` is "Totals". (4) From these specific rows, extract and list the overall `Assessment ELA Performance Value` and `Assessment Math Performance Value` for each school system (district). (5) Analyze the extracted district-level ELA and Math performance values to identify the highest and lowest performing school systems. Also, examine the corresponding `Assessment ELA Proficiency Meets Annual Target?` and `Assessment Math Proficiency Meets Annual Target?` columns to determine how many districts met their annual proficiency goals. (6) Using the "District Record" rows for each district, compare the "Totals" ELA and Math performance values across the different `School Type` categories (Elementary, Middle, Secondary) to analyze performance variations within each school system. (7) Examine the `Assessment ELA Progress Value` and `Assessment Math Progress Value` for each district's "All Schools - Totals" row to provide an analysis of student growth, as distinct from absolute performance. (8) For a selection of districts, including Greenbrier County, analyze the "All Schools" data to compare the ELA and Math performance values of the "Economically Disadvantaged" and "Children With Disabilities" subgroups against the district's "Totals" subgroup to identify significant performance gaps.

Analyze Results

 

Create Report

 https://docs.google.com/document/d/19QuvF6ReD5GtQvKxlOmJ_6OsrgFXAgmaQmTRUN2SLmU/edit?usp=sharing

 Web Page App:

 https://gemini.google.com/share/4642b54a83fa