John F. Kennedy Middle (Data source)
Source data for John F. Kennedy Middle
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 |
||
| 6 | 2541437 | 2478 | - | 2552 | = | -74 | * | (229 | / | 721) | = | -23.50346738 | ||
| 7 | 2541440 | 2476 | - | 2567 | = | -91 | * | (234 | / | 721) | = | -29.53398057 | ||
| 8 | 2541441 | 2497 | - | 2586 | = | -89 | * | (258 | / | 721) | = | -31.84743408 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for John F. Kennedy Middle | -85 | ||||||||||||
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 |
||
| 6 | 77495 | 2507 | - | 2552 | = | -45 | * | (213 | / | 678) | = | -14.13716814 | ||
| 7 | 77497 | 2511 | - | 2567 | = | -56 | * | (228 | / | 678) | = | -18.83185836 | ||
| 8 | 77499 | 2482 | - | 2586 | = | -104 | * | (237 | / | 678) | = | -36.35398229 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for John F. Kennedy Middle | -69 | ||||||||||||
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 |
||
| 5 | 79631 | 0 | - | 2528 | = | * | (0 | / | 679) | = | ||||
| 6 | 79632 | 2486 | - | 2552 | = | -66 | * | (193 | / | 679) | = | -18.75994105 | ||
| 7 | 79635 | 2524 | - | 2567 | = | -43 | * | (239 | / | 679) | = | -15.13549333 | ||
| 8 | 79636 | 2511 | - | 2586 | = | -75 | * | (247 | / | 679) | = | -27.28276875 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for John F. Kennedy Middle | -61 | ||||||||||||
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 |
||
| 5 | 79768 | 0 | - | 2528 | = | * | (0 | / | 688) | = | ||||
| 6 | 79769 | 2492 | - | 2552 | = | -60 | * | (202 | / | 688) | = | -17.61627906 | ||
| 7 | 79772 | 2514 | - | 2567 | = | -53 | * | (233 | / | 688) | = | -17.94912787 | ||
| 8 | 79773 | 2539 | - | 2586 | = | -47 | * | (253 | / | 688) | = | -17.28343023 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for John F. Kennedy Middle | -53 | ||||||||||||
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 |
||
| 5 | 80270 | 0 | - | 2528 | = | * | (0 | / | 647) | = | ||||
| 6 | 80271 | 2479 | - | 2552 | = | -73 | * | (194 | / | 647) | = | -21.88871712 | ||
| 7 | 80272 | 2524 | - | 2567 | = | -43 | * | (215 | / | 647) | = | -14.28902625 | ||
| 8 | 80273 | 2530 | - | 2586 | = | -56 | * | (238 | / | 647) | = | -20.59969083 | ||
| Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for John F. Kennedy Middle | -57 | ||||||||||||
Last steps
Compute the average
| 2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
|---|---|---|---|---|---|---|
| -85 | -69 | -61 | -53 | -57 | -325.0 | -65.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -29.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -101.0
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 | 75% | 55% | 48% | 49% | 59% |
| 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.
John F. Kennedy Middle math proficiency
Zero+ meets standard.
64% less $meal
42% less $meal
36% less $meal
43% less $meal
47% 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.
Intermediate/Middle Schools (Public) schools in Redwood City Elementary (2)
| John F. Kennedy Middle | McKinley Institute of Technology |