New Haven Elementary (Data source)
Source data for New Haven 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 | 2424329 | 2410 | - | 2436 | = | -26 | * | (62 | / | 403) | = | -3.99999998 | ||
4 | 2424332 | 2447 | - | 2485 | = | -38 | * | (63 | / | 403) | = | -5.94044663 | ||
5 | 2424333 | 2453 | - | 2528 | = | -75 | * | (62 | / | 403) | = | -11.53846148 | ||
6 | 2424336 | 2501 | - | 2552 | = | -51 | * | (83 | / | 403) | = | -10.50372203 | ||
7 | 2424337 | 2515 | - | 2567 | = | -52 | * | (67 | / | 403) | = | -8.64516125 | ||
8 | 2424340 | 2516 | - | 2586 | = | -70 | * | (66 | / | 403) | = | -11.46401984 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for New Haven Elementary | -52 |
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 | 73983 | 2421 | - | 2436 | = | -15 | * | (62 | / | 396) | = | -2.34848484 | ||
4 | 73986 | 2450 | - | 2485 | = | -35 | * | (56 | / | 396) | = | -4.94949494 | ||
5 | 73988 | 2449 | - | 2528 | = | -79 | * | (66 | / | 396) | = | -13.16666661 | ||
6 | 73989 | 2505 | - | 2552 | = | -47 | * | (69 | / | 396) | = | -8.18939393 | ||
7 | 73991 | 2538 | - | 2567 | = | -29 | * | (78 | / | 396) | = | -5.71212118 | ||
8 | 73993 | 2533 | - | 2586 | = | -53 | * | (65 | / | 396) | = | -8.69949494 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for New Haven Elementary | -43 |
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 | 75970 | 2406 | - | 2436 | = | -30 | * | (83 | / | 431) | = | -5.77726218 | ||
4 | 75973 | 2444 | - | 2485 | = | -41 | * | (69 | / | 431) | = | -6.56380509 | ||
5 | 75975 | 2460 | - | 2528 | = | -68 | * | (66 | / | 431) | = | -10.412993 | ||
6 | 75977 | 2494 | - | 2552 | = | -58 | * | (65 | / | 431) | = | -8.74709971 | ||
7 | 75979 | 2511 | - | 2567 | = | -56 | * | (68 | / | 431) | = | -8.83526678 | ||
8 | 75980 | 2540 | - | 2586 | = | -46 | * | (80 | / | 431) | = | -8.53828305 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for New Haven Elementary | -49 |
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 | 76162 | 2440 | - | 2436 | = | 4 | * | (57 | / | 401) | = | 0.56857855 | ||
4 | 76163 | 2463 | - | 2485 | = | -22 | * | (78 | / | 401) | = | -4.27930173 | ||
5 | 76166 | 2479 | - | 2528 | = | -49 | * | (68 | / | 401) | = | -8.30922689 | ||
6 | 76167 | 2499 | - | 2552 | = | -53 | * | (65 | / | 401) | = | -8.59102244 | ||
7 | 76170 | 2520 | - | 2567 | = | -47 | * | (56 | / | 401) | = | -6.56359098 | ||
8 | 76171 | 2583 | - | 2586 | = | -3 | * | (77 | / | 401) | = | -0.57605985 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for New Haven Elementary | -28 |
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 | 76686 | 2434 | - | 2436 | = | -2 | * | (45 | / | 371) | = | -0.2425876 | ||
4 | 76687 | 2443 | - | 2485 | = | -42 | * | (57 | / | 371) | = | -6.45283019 | ||
5 | 76688 | 2495 | - | 2528 | = | -33 | * | (72 | / | 371) | = | -6.40431264 | ||
6 | 76689 | 2512 | - | 2552 | = | -40 | * | (68 | / | 371) | = | -7.33153636 | ||
7 | 76690 | 2516 | - | 2567 | = | -51 | * | (66 | / | 371) | = | -9.07277627 | ||
8 | 76691 | 2570 | - | 2586 | = | -16 | * | (63 | / | 371) | = | -2.71698112 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for New Haven Elementary | -32 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-52 | -43 | -49 | -28 | -32 | -204.0 | -40.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -10.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -70.8
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 | 51% | 49% | 46% | 50% | 48% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Manteca Unified school district County of San Joaquin
Just a coincidence? That's absurd.
It's a system that causes this pattern to repeat.
THIS chart shows what the
follow-the-schedule method wants.
NOT what teachers want.
NOT what principals want.
NOT what parents want.





• 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.