Sandra Tovar Medeiros Elementary (Data source)
Source data for Sandra Tovar Medeiros Elementary
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 | 2975241 | 2428 | - | 2436 | = | -8 | * | (103 | / | 441) | = | -1.86848072 | ||
4 | 2975242 | 2444 | - | 2485 | = | -41 | * | (128 | / | 441) | = | -11.90022675 | ||
5 | 2975245 | 2479 | - | 2528 | = | -49 | * | (103 | / | 441) | = | -11.44444441 | ||
6 | 2975246 | 2514 | - | 2552 | = | -38 | * | (107 | / | 441) | = | -9.21995463 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Sandra Tovar Medeiros Elementary | -34 |
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 | 91020 | 2423 | - | 2436 | = | -13 | * | (123 | / | 476) | = | -3.35924369 | ||
4 | 91022 | 2449 | - | 2485 | = | -36 | * | (104 | / | 476) | = | -7.86554618 | ||
5 | 91023 | 2491 | - | 2528 | = | -37 | * | (130 | / | 476) | = | -10.10504199 | ||
6 | 91025 | 2523 | - | 2552 | = | -29 | * | (119 | / | 476) | = | -7.25 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Sandra Tovar Medeiros Elementary | -29 |
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 | 93767 | 2418 | - | 2436 | = | -18 | * | (120 | / | 500) | = | -4.32 | ||
4 | 93769 | 2458 | - | 2485 | = | -27 | * | (134 | / | 500) | = | -7.236 | ||
5 | 93772 | 2481 | - | 2528 | = | -47 | * | (103 | / | 500) | = | -9.682 | ||
6 | 93774 | 2513 | - | 2552 | = | -39 | * | (143 | / | 500) | = | -11.154 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Sandra Tovar Medeiros Elementary | -32 |
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 | 93978 | 2436 | - | 2436 | = | 0 | * | (113 | / | 473) | = | 0.0 | ||
4 | 93980 | 2470 | - | 2485 | = | -15 | * | (120 | / | 473) | = | -3.80549682 | ||
5 | 93982 | 2488 | - | 2528 | = | -40 | * | (133 | / | 473) | = | -11.24735728 | ||
6 | 93984 | 2526 | - | 2552 | = | -26 | * | (107 | / | 473) | = | -5.88160674 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Sandra Tovar Medeiros Elementary | -21 |
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 | 94607 | 2435 | - | 2436 | = | -1 | * | (130 | / | 510) | = | -0.25490196 | ||
4 | 94608 | 2485 | - | 2485 | = | 0 | * | (111 | / | 510) | = | 0.0 | ||
5 | 94609 | 2508 | - | 2528 | = | -20 | * | (129 | / | 510) | = | -5.05882352 | ||
6 | 94610 | 2517 | - | 2552 | = | -35 | * | (140 | / | 510) | = | -9.60784311 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Sandra Tovar Medeiros Elementary | -15 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-34 | -29 | -32 | -21 | -15 | -131.0 | -26.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -5.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -47.2
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 | 44% | 40% | 37% | 45% | 46% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Turlock Unified school district | County of Stanislaus
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.
Sandra Tovar Medeiros Elementary math proficiency
Zero+ meets standard.
35% less $meal
30% less $meal
31% less $meal
39% less $meal
40% 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.