Camino Real Elementary (Data source)
Source data for Camino Real 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 | 1692903 | 2428 | - | 2436 | = | -8 | * | (119 | / | 454) | = | -2.0969163 | ||
| 4 | 1692904 | 2444 | - | 2485 | = | -41 | * | (123 | / | 454) | = | -11.10792951 | ||
| 5 | 1692907 | 2475 | - | 2528 | = | -53 | * | (110 | / | 454) | = | -12.84140964 | ||
| 6 | 1692909 | 2524 | - | 2552 | = | -28 | * | (102 | / | 454) | = | -6.29074888 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Camino Real Elementary | -32 | ||||||||||||
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 | 52800 | 2441 | - | 2436 | = | 5 | * | (112 | / | 476) | = | 1.17647059 | ||
| 4 | 52803 | 2468 | - | 2485 | = | -17 | * | (125 | / | 476) | = | -4.46428571 | ||
| 5 | 52805 | 2478 | - | 2528 | = | -50 | * | (127 | / | 476) | = | -13.3403361 | ||
| 6 | 52807 | 2506 | - | 2552 | = | -46 | * | (112 | / | 476) | = | -10.82352938 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Camino Real Elementary | -27 | ||||||||||||
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 | 54320 | 2448 | - | 2436 | = | 12 | * | (114 | / | 479) | = | 2.85594989 | ||
| 4 | 54321 | 2486 | - | 2485 | = | 1 | * | (115 | / | 479) | = | 0.24008351 | ||
| 5 | 54323 | 2496 | - | 2528 | = | -32 | * | (128 | / | 479) | = | -8.55114822 | ||
| 6 | 54325 | 2513 | - | 2552 | = | -39 | * | (122 | / | 479) | = | -9.93319415 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Camino Real Elementary | -15 | ||||||||||||
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 | 54432 | 2444 | - | 2436 | = | 8 | * | (114 | / | 498) | = | 1.8313253 | ||
| 4 | 54435 | 2471 | - | 2485 | = | -14 | * | (126 | / | 498) | = | -3.54216867 | ||
| 5 | 54437 | 2494 | - | 2528 | = | -34 | * | (124 | / | 498) | = | -8.46586342 | ||
| 6 | 54439 | 2502 | - | 2552 | = | -50 | * | (134 | / | 498) | = | -13.45381525 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Camino Real Elementary | -24 | ||||||||||||
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 | 54676 | 2447 | - | 2436 | = | 11 | * | (96 | / | 465) | = | 2.27096773 | ||
| 4 | 54677 | 2479 | - | 2485 | = | -6 | * | (122 | / | 465) | = | -1.57419355 | ||
| 5 | 54678 | 2492 | - | 2528 | = | -36 | * | (125 | / | 465) | = | -9.67741934 | ||
| 6 | 54679 | 2513 | - | 2552 | = | -39 | * | (122 | / | 465) | = | -10.23225805 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Camino Real Elementary | -19 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -32 | -27 | -15 | -24 | -19 | -117.0 | -23.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -5.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -41.4
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% | 44% | 47% | 50% | 48% |
| Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Jurupa Unified school district | County of Riverside
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.
Camino Real Elementary math proficiency
Zero+ meets standard.
33% less $meal
35% less $meal
36% less $meal
43% less $meal
43% 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.