Scandinavian Middle (Data source)
Source data for Scandinavian Middle
2015
Step 1 | Step 2 | Step 3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get Mean Scale Score from line numbers in this data file. | Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard | Multiply Distance From Standard by proportion of students in grade. | ||||||||||||
Grade | Line number |
Mean Scale Score |
- | Scale Score: met min |
= | Distance from standard |
* | (Students tested in grade |
/ | Students) tested in school |
= | Weighted Distance From Standard |
||
7 | 331896 | 2448 | - | 2567 | = | -119 | * | (373 | / | 701) | = | -63.31954348 | ||
8 | 331897 | 2465 | - | 2586 | = | -121 | * | (328 | / | 701) | = | -56.6162624 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Scandinavian Middle | -120 |
2016
Step 1 | Step 2 | Step 3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get Mean Scale Score from line numbers in this data file. | Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard | Multiply Distance From Standard by proportion of students in grade. | ||||||||||||
Grade | Line number |
Mean Scale Score |
- | Scale Score: met min |
= | Distance from standard |
* | (Students tested in grade |
/ | Students) tested in school |
= | Weighted Distance From Standard |
||
7 | 9903 | 2458 | - | 2567 | = | -109 | * | (356 | / | 726) | = | -53.44903573 | ||
8 | 9905 | 2472 | - | 2586 | = | -114 | * | (370 | / | 726) | = | -58.09917352 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Scandinavian Middle | -112 |
2017
Step 1 | Step 2 | Step 3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get Mean Scale Score from line numbers in this data file. | Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard | Multiply Distance From Standard by proportion of students in grade. | ||||||||||||
Grade | Line number |
Mean Scale Score |
- | Scale Score: met min |
= | Distance from standard |
* | (Students tested in grade |
/ | Students) tested in school |
= | Weighted Distance From Standard |
||
7 | 10231 | 2442 | - | 2567 | = | -125 | * | (386 | / | 730) | = | -66.09589038 | ||
8 | 10234 | 2447 | - | 2586 | = | -139 | * | (344 | / | 730) | = | -65.50136976 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Scandinavian Middle | -132 |
2018
Step 1 | Step 2 | Step 3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get Mean Scale Score from line numbers in this data file. | Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard | Multiply Distance From Standard by proportion of students in grade. | ||||||||||||
Grade | Line number |
Mean Scale Score |
- | Scale Score: met min |
= | Distance from standard |
* | (Students tested in grade |
/ | Students) tested in school |
= | Weighted Distance From Standard |
||
7 | 10250 | 2465 | - | 2567 | = | -102 | * | (345 | / | 713) | = | -49.35483863 | ||
8 | 10251 | 2454 | - | 2586 | = | -132 | * | (368 | / | 713) | = | -68.12903222 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Scandinavian Middle | -117 |
2019
Step 1 | Step 2 | Step 3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get Mean Scale Score from line numbers in this data file. | Subtract 'met min' Scale Score. from Mean Scale Score to get Distance From Standard | Multiply Distance From Standard by proportion of students in grade. | ||||||||||||
Grade | Line number |
Mean Scale Score |
- | Scale Score: met min |
= | Distance from standard |
* | (Students tested in grade |
/ | Students) tested in school |
= | Weighted Distance From Standard |
||
7 | 10328 | 2458 | - | 2567 | = | -109 | * | (369 | / | 710) | = | -56.64929568 | ||
8 | 10329 | 2460 | - | 2586 | = | -126 | * | (341 | / | 710) | = | -60.51549294 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Scandinavian Middle | -117 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-120 | -112 | -132 | -117 | -117 | -598.0 | -119.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -98.6
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -140.6
For the lines, you have the data necessary to plot the chart.
Very last step
The percent of students getting a Free or Reduced Price Meal comes from the following sources:
2015 | 2016 | 2017 | 2018 | 2019 | |
---|---|---|---|---|---|
Percent | 93% | 95% | 98% | 96% | 95% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Fresno Unified school district | County of Fresno
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation: wealth/poverty.
NOT what teachers want.
NOT what principals want.
NOT what parents want.
Scandinavian Middle math proficiency
Zero+ meets standard.
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
75% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
74% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
76% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
76% less $meal
![](/assets/house_drawing_5in-c6442fed32af63d603d8b366066112e716dad0472d326bacc949d19f4beb6f9b.png)
78% less $meal
• Any result above zero is proficient; below is not proficient. • There is a 99% chance that results will remain the same in coming years, which is to say, between the Upper and Lower Control Limits (the gray lines). • The houses with the % of students receiving a Free or Reduced Price Meal is a measure of wealth/poverty.