Roy Cloud Elementary (Data source)
Source data for Roy Cloud 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 | 2539099 | 2435 | - | 2436 | = | -1 | * | (78 | / | 504) | = | -0.1547619 | ||
4 | 2539100 | 2487 | - | 2485 | = | 2 | * | (81 | / | 504) | = | 0.32142857 | ||
5 | 2539103 | 2514 | - | 2528 | = | -14 | * | (90 | / | 504) | = | -2.49999999 | ||
6 | 2539104 | 2568 | - | 2552 | = | 16 | * | (93 | / | 504) | = | 2.95238094 | ||
7 | 2539107 | 2573 | - | 2567 | = | 6 | * | (78 | / | 504) | = | 0.92857142 | ||
8 | 2539108 | 2582 | - | 2586 | = | -4 | * | (84 | / | 504) | = | -0.66666666 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Roy Cloud Elementary | 1 |
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 | 77417 | 2458 | - | 2436 | = | 22 | * | (79 | / | 511) | = | 3.40117415 | ||
4 | 77419 | 2500 | - | 2485 | = | 15 | * | (82 | / | 511) | = | 2.40704501 | ||
5 | 77422 | 2520 | - | 2528 | = | -8 | * | (82 | / | 511) | = | -1.28375734 | ||
6 | 77424 | 2540 | - | 2552 | = | -12 | * | (95 | / | 511) | = | -2.23091976 | ||
7 | 77426 | 2597 | - | 2567 | = | 30 | * | (92 | / | 511) | = | 5.40117414 | ||
8 | 77427 | 2583 | - | 2586 | = | -3 | * | (81 | / | 511) | = | -0.47553816 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Roy Cloud Elementary | 7 |
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 | 79555 | 2468 | - | 2436 | = | 32 | * | (77 | / | 487) | = | 5.05954822 | ||
4 | 79556 | 2511 | - | 2485 | = | 26 | * | (78 | / | 487) | = | 4.16427105 | ||
5 | 79559 | 2528 | - | 2528 | = | 0 | * | (78 | / | 487) | = | 0.0 | ||
6 | 79560 | 2568 | - | 2552 | = | 16 | * | (76 | / | 487) | = | 2.4969199 | ||
7 | 79562 | 2579 | - | 2567 | = | 12 | * | (90 | / | 487) | = | 2.21765914 | ||
8 | 79564 | 2592 | - | 2586 | = | 6 | * | (88 | / | 487) | = | 1.08418891 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Roy Cloud 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 | 79693 | 2494 | - | 2436 | = | 58 | * | (73 | / | 470) | = | 9.00851058 | ||
4 | 79696 | 2512 | - | 2485 | = | 27 | * | (72 | / | 470) | = | 4.1361702 | ||
5 | 79697 | 2549 | - | 2528 | = | 21 | * | (79 | / | 470) | = | 3.52978723 | ||
6 | 79700 | 2549 | - | 2552 | = | -3 | * | (82 | / | 470) | = | -0.52340426 | ||
7 | 79701 | 2613 | - | 2567 | = | 46 | * | (74 | / | 470) | = | 7.24255317 | ||
8 | 79704 | 2612 | - | 2586 | = | 26 | * | (90 | / | 470) | = | 4.97872339 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Roy Cloud 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 | 80198 | 2474 | - | 2436 | = | 38 | * | (72 | / | 477) | = | 5.73584905 | ||
4 | 80199 | 2534 | - | 2485 | = | 49 | * | (85 | / | 477) | = | 8.73165614 | ||
5 | 80200 | 2555 | - | 2528 | = | 27 | * | (72 | / | 477) | = | 4.07547169 | ||
6 | 80201 | 2573 | - | 2552 | = | 21 | * | (86 | / | 477) | = | 3.78616352 | ||
7 | 80202 | 2605 | - | 2567 | = | 38 | * | (87 | / | 477) | = | 6.93081761 | ||
8 | 80203 | 2621 | - | 2586 | = | 35 | * | (75 | / | 477) | = | 5.50314464 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Roy Cloud Elementary | 35 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
1 | 7 | 15 | 28 | 35 | 86.0 | 17.2 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 59.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -24.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 | 12% | 8% | 7% | 8% | 10% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
Redwood City Elementary school district County of San Mateo
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.
Roy Cloud Elementary math proficiency
Zero+ meets standard.
9% less $meal
6% less $meal
5% less $meal
7% less $meal
9% 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.
Elementary School (Public) schools in Redwood City Elementary (9)
Clifford Elementary | Garfield Elementary | Henry Ford Elementary |
Hoover Elementary | North Star Academy | Roosevelt Elementary |
Roy Cloud Elementary | Selby Lane Elementary | Taft Elementary |