New Prompt with Deep Research

Research Websites and Files

(1) Search online for the definitions and context of West Virginia's ESSA per-pupil expenditure reporting, specifically to understand the meaning of the columns STPERPUP, SH_STPERPUP, and GR_TOT found in the `WV Details ESSA_PerPupil.xls - ESSA_PerPupil.csv` file. (2) Analyze the `WV Details ESSA_PerPupil.xls - ESSA_PerPupil.csv` file to identify the schools (LOC) and districts (DIST) with the highest and lowest values for state per-pupil expenditure (STPERPUP) and total per-pupil expenditure (GR_TOT). (3) Examine the `WV_Balanced_Scorecard_Data_2025 (1).xlsx - SY25 Balanced Scorecard Results.csv` file to identify key academic performance indicators for schools, focusing on 'Assessment ELA Performance Value', 'Assessment Math Performance Value', 'Grad. Rate 4-Year Value', and 'Attendance Value'. (4) Cross-reference the data from both files by matching school codes (LOC) and district codes (DIST). Compare the per-pupil expenditure data (STPERPUP, GR_TOT) from the first file with the academic performance data (ELA/Math performance, graduation rates) from the second file for a selection of schools. (5) Investigate the relationship between the 'SH_STPERPUP' (share of state per-pupil expenditure) column in `ESSA_PerPupil.csv` and the 'Title 1 Indicator' column in `SY25 Balanced Scorecard Results.csv` to see if there is a pattern related to funding distribution. (6) Specifically isolate the data for Greenbrier County (District Code 026) in both files. Analyze its schools' per-pupil expenditures (STPERPUP, GR_TOT) and compare their academic performance indicators against the district and state totals provided in the files. (7) Compare the funding and performance data of Greenbrier County (026) with adjacent or similar counties available in the data, such as Nicholas County (062) and Monroe County (057), to provide a relative analysis. (8) Synthesize the findings to provide an overall analysis of the data, summarizing any observable correlations between per-pupil expenditure (STPERPUP, GR_TOT) and academic success indicators across the provided West Virginia school data.