Meeting Average Change of Previous Years by quintile

This method of calculating student growth is used when there are previous years data using the same template.

1. Determine the Target term of data

2. Calculate the 5 groupings based on historic pretest scores (exclude the target term).

3. Add the 5 records to the template’s “Growth Requirement” table.

4. Run the SQL statement to assign pretest groupings to each student’s record in the Tagret Term. UPDATE s_slo SET SloSsgID = calcSloBandID(SloID, SloSlaID, SloNtmID) WHERE SloSlaID = 61 AND SloNtmID = 38;

5. Calculuate the average growth for each Target Term quintile: SELECT SloSsgID, ROUND(AVG(SLOGrowth),1) FROM (SELECT SloSsgID, (SloPostTestScore - SloPreTestScore) AS 'SLOGrowth' FROM s_slo WHERE SloSlaID = 61 AND SloNtmID = 38) AS SLOGrowths GROUP BY SloSsgID;

6. Update the SLO Template with the quintile growth requirements.