Analyze Model 2 Per Hypothesis

 

Based on 2025 Balanced Scorecard--Research this for West Virginia.

Prioritize "Progress Value" as a Key Metric for Success Based on

Hypothesis 2, school leadership and PLCs (Professional Learning

Communities) should use the Assessment ELA Progress Value and Assessment

Math Progress Value as primary indicators for evaluating instructional

strategies. A school with high progress (even if proficiency is still

low) has found a successful formula that should be scaled, whereas a

high-proficiency but low-progress school may be stagnating. List top ten and bottom ten performing schools. 

 --------------------------------------------------------------------------

Research Websites and Files

(1) Access the attached file `WV_Balanced_Scorecard_Data_2025 (1).xlsx - SY25 Balanced Scorecard Results.csv` to analyze the statewide school performance data for 2025. (2) Filter the data to isolate records where the 'Group' column is 'Total' and the 'Subgroup' column is 'Totals'. This will ensure the analysis is based on the overall performance of each school, not specific subgroups. (3) From this filtered list, exclude any schools where 'Assessment ELA Progress Value' or 'Assessment Math Progress Value' is listed as 'Not Reportable'. (4) For each of the remaining schools, calculate a 'Combined Progress Value' by averaging its 'Assessment ELA Progress Value' and 'Assessment Math Progress Value'. (5) Rank all schools based on their 'Combined Progress Value' and list the top ten performing schools in West Virginia. (6) List the bottom ten performing schools in West Virginia based on the lowest 'Combined Progress Value'. (7) For each school in the top ten and bottom ten lists, present its Name, District, its 'Combined Progress Value', and its 'Assessment ELA Performance Value' (Proficiency) and 'Assessment Math Performance Value' (Proficiency). (8) In accordance with the hypothesis, analyze the ranked lists to: (a) Identify schools in the top ten that have high 'Combined Progress Value' but low 'Performance Value' (proficiency), representing potential successful formulas. (b) Search the full dataset for schools that have high 'Performance Value' (proficiency) but low 'Combined Progress Value', representing potential stagnation.

 

----------------------------------------------------------------------------------------------------