Sherwood Montessori (Data source)
Source data for Sherwood Montessori
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 |
||
3 | 136355 | 2433 | - | 2436 | = | -3 | * | (17 | / | 75) | = | -0.68 | ||
4 | 136356 | 2445 | - | 2485 | = | -40 | * | (23 | / | 75) | = | -12.26666664 | ||
5 | 136359 | 2475 | - | 2528 | = | -53 | * | (17 | / | 75) | = | -12.0133333 | ||
6 | 136360 | 0 | - | 2552 | = | * | (7 | / | 75) | = | ||||
7 | 136363 | 0 | - | 2567 | = | * | (7 | / | 75) | = | ||||
8 | 136364 | 0 | - | 2586 | = | * | (4 | / | 75) | = | ||||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Sherwood Montessori | -25 |
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 |
||
3 | 3929 | 2461 | - | 2436 | = | 25 | * | (21 | / | 85) | = | 6.17647058 | ||
4 | 3932 | 2456 | - | 2485 | = | -29 | * | (17 | / | 85) | = | -5.8 | ||
5 | 3933 | 2481 | - | 2528 | = | -47 | * | (22 | / | 85) | = | -12.16470586 | ||
6 | 3935 | 2528 | - | 2552 | = | -24 | * | (16 | / | 85) | = | -4.51764706 | ||
7 | 3937 | 0 | - | 2567 | = | * | (3 | / | 85) | = | ||||
8 | 3939 | 0 | - | 2586 | = | * | (6 | / | 85) | = | ||||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Sherwood Montessori | -16 |
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 |
||
3 | 4013 | 2405 | - | 2436 | = | -31 | * | (22 | / | 86) | = | -7.93023254 | ||
4 | 4015 | 2467 | - | 2485 | = | -18 | * | (17 | / | 86) | = | -3.55813952 | ||
5 | 4018 | 2490 | - | 2528 | = | -38 | * | (18 | / | 86) | = | -7.95348835 | ||
6 | 4020 | 2511 | - | 2552 | = | -41 | * | (17 | / | 86) | = | -8.10465114 | ||
7 | 4022 | 0 | - | 2567 | = | * | (0 | / | 86) | = | ||||
8 | 4024 | 0 | - | 2586 | = | * | (0 | / | 86) | = | ||||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Sherwood Montessori | -28 |
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 |
||
3 | 4020 | 2370 | - | 2436 | = | -66 | * | (19 | / | 99) | = | -12.66666661 | ||
4 | 4021 | 2410 | - | 2485 | = | -75 | * | (25 | / | 99) | = | -18.9393939 | ||
5 | 4024 | 2466 | - | 2528 | = | -62 | * | (16 | / | 99) | = | -10.02020198 | ||
6 | 4025 | 2464 | - | 2552 | = | -88 | * | (23 | / | 99) | = | -20.44444442 | ||
7 | 4028 | 2552 | - | 2567 | = | -15 | * | (11 | / | 99) | = | -1.66666667 | ||
8 | 4029 | 0 | - | 2586 | = | * | (0 | / | 99) | = | ||||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Sherwood Montessori | -64 |
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 |
||
3 | 4062 | 2357 | - | 2436 | = | -79 | * | (23 | / | 92) | = | -19.75 | ||
4 | 4063 | 2417 | - | 2485 | = | -68 | * | (12 | / | 92) | = | -8.86956518 | ||
5 | 4064 | 2402 | - | 2528 | = | -126 | * | (20 | / | 92) | = | -27.3913043 | ||
6 | 4065 | 2453 | - | 2552 | = | -99 | * | (11 | / | 92) | = | -11.83695648 | ||
7 | 4066 | 2516 | - | 2567 | = | -51 | * | (16 | / | 92) | = | -8.86956519 | ||
8 | 4067 | 0 | - | 2586 | = | * | (10 | / | 92) | = | ||||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Sherwood Montessori | -77 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-25 | -16 | -28 | -64 | -77 | -210.0 | -42.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average:
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average:
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 | 24% | 32% | 23% | 44% | 47% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Chico Unified school district County of Butte
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation, parent education.
NOT what teachers want.
NOT what principals want.
NOT what parents want.