Health Sciences Middle (Data source)
Source data for Health Sciences 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 | 2232644 | 2465 | - | 2552 | = | -87 | * | (41 | / | 149) | = | -23.9395973 | ||
7 | 2232647 | 2463 | - | 2567 | = | -104 | * | (71 | / | 149) | = | -49.55704697 | ||
8 | 2232648 | 2494 | - | 2586 | = | -92 | * | (37 | / | 149) | = | -22.84563752 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Health Sciences Middle | -96 |
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 | 68502 | 2442 | - | 2552 | = | -110 | * | (39 | / | 153) | = | -28.0392156 | ||
7 | 68504 | 2520 | - | 2567 | = | -47 | * | (39 | / | 153) | = | -11.98039212 | ||
8 | 68506 | 2494 | - | 2586 | = | -92 | * | (75 | / | 153) | = | -45.09803918 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Health Sciences Middle | -85 |
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 |
||
6 | 70321 | 2466 | - | 2552 | = | -86 | * | (45 | / | 124) | = | -31.20967735 | ||
7 | 70322 | 2440 | - | 2567 | = | -127 | * | (36 | / | 124) | = | -36.87096766 | ||
8 | 70325 | 2489 | - | 2586 | = | -97 | * | (43 | / | 124) | = | -33.63709672 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Health Sciences Middle | -102 |
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 |
||
6 | 70443 | 2433 | - | 2552 | = | -119 | * | (38 | / | 123) | = | -36.76422759 | ||
7 | 70445 | 2456 | - | 2567 | = | -111 | * | (46 | / | 123) | = | -41.51219503 | ||
8 | 70447 | 2446 | - | 2586 | = | -140 | * | (39 | / | 123) | = | -44.3902438 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Health Sciences Middle | -123 |
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 |
||
7 | 70928 | 2465 | - | 2567 | = | -102 | * | (36 | / | 92) | = | -39.91304339 | ||
8 | 70929 | 2482 | - | 2586 | = | -104 | * | (56 | / | 92) | = | -63.30434781 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Health Sciences Middle | -103 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-96 | -85 | -102 | -123 | -103 | -509.0 | -101.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average:
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average:
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 | 53% | 69% | 77% | 77% | 74% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
San Diego Unified school district County of San Diego
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.