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 |
2550002 |
2452 |
- |
2436 |
= |
16 |
* |
(1339 |
/ |
7380) |
= |
2.90298102 |
4 |
2550003 |
2502 |
- |
2485 |
= |
17 |
* |
(1317 |
/ |
7380) |
= |
3.03373983 |
5 |
2550006 |
2533 |
- |
2528 |
= |
5 |
* |
(1302 |
/ |
7380) |
= |
0.88211382 |
6 |
2550007 |
2548 |
- |
2552 |
= |
-4 |
* |
(1214 |
/ |
7380) |
= |
-0.65799458 |
7 |
2550010 |
2561 |
- |
2567 |
= |
-6 |
* |
(1130 |
/ |
7380) |
= |
-0.91869919 |
8 |
2550011 |
2570 |
- |
2586 |
= |
-16 |
* |
(1078 |
/ |
7380) |
= |
-2.33712736 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for San Mateo-Foster City
|
3 |
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 |
77723 |
2461 |
- |
2436 |
= |
25 |
* |
(1332 |
/ |
7554) |
= |
4.4082605 |
4 |
77725 |
2500 |
- |
2485 |
= |
15 |
* |
(1287 |
/ |
7554) |
= |
2.55559968 |
5 |
77727 |
2536 |
- |
2528 |
= |
8 |
* |
(1320 |
/ |
7554) |
= |
1.39793486 |
6 |
77729 |
2554 |
- |
2552 |
= |
2 |
* |
(1260 |
/ |
7554) |
= |
0.33359809 |
7 |
77732 |
2567 |
- |
2567 |
= |
0 |
* |
(1191 |
/ |
7554) |
= |
0.0 |
8 |
77734 |
2582 |
- |
2586 |
= |
-4 |
* |
(1164 |
/ |
7554) |
= |
-0.61636219 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for San Mateo-Foster City
|
8 |
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 |
79873 |
2459 |
- |
2436 |
= |
23 |
* |
(1263 |
/ |
7490) |
= |
3.87837116 |
4 |
79875 |
2498 |
- |
2485 |
= |
13 |
* |
(1301 |
/ |
7490) |
= |
2.25807743 |
5 |
79876 |
2529 |
- |
2528 |
= |
1 |
* |
(1259 |
/ |
7490) |
= |
0.16809079 |
6 |
79878 |
2547 |
- |
2552 |
= |
-5 |
* |
(1265 |
/ |
7490) |
= |
-0.84445928 |
7 |
79880 |
2573 |
- |
2567 |
= |
6 |
* |
(1216 |
/ |
7490) |
= |
0.97409879 |
8 |
79883 |
2581 |
- |
2586 |
= |
-5 |
* |
(1186 |
/ |
7490) |
= |
-0.7917223 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for San Mateo-Foster City
|
6 |
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 |
80014 |
2454 |
- |
2436 |
= |
18 |
* |
(1234 |
/ |
7404) |
= |
2.99999999 |
4 |
80015 |
2498 |
- |
2485 |
= |
13 |
* |
(1223 |
/ |
7404) |
= |
2.14735278 |
5 |
80018 |
2527 |
- |
2528 |
= |
-1 |
* |
(1280 |
/ |
7404) |
= |
-0.17287952 |
6 |
80019 |
2548 |
- |
2552 |
= |
-4 |
* |
(1226 |
/ |
7404) |
= |
-0.66234468 |
7 |
80022 |
2576 |
- |
2567 |
= |
9 |
* |
(1247 |
/ |
7404) |
= |
1.51580227 |
8 |
80023 |
2586 |
- |
2586 |
= |
0 |
* |
(1194 |
/ |
7404) |
= |
0.0 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for San Mateo-Foster City
|
6 |
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 |
80510 |
2464 |
- |
2436 |
= |
28 |
* |
(1296 |
/ |
7354) |
= |
4.93445742 |
4 |
80511 |
2497 |
- |
2485 |
= |
12 |
* |
(1201 |
/ |
7354) |
= |
1.9597498 |
5 |
80512 |
2521 |
- |
2528 |
= |
-7 |
* |
(1219 |
/ |
7354) |
= |
-1.16032091 |
6 |
80513 |
2549 |
- |
2552 |
= |
-3 |
* |
(1208 |
/ |
7354) |
= |
-0.49279304 |
7 |
80514 |
2570 |
- |
2567 |
= |
3 |
* |
(1210 |
/ |
7354) |
= |
0.49360892 |
8 |
80515 |
2588 |
- |
2586 |
= |
2 |
* |
(1220 |
/ |
7354) |
= |
0.33179222 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for San Mateo-Foster City
|
6 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
3
|
8
|
6
|
6
|
6
|
29.0 |
5.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 8.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 2.8
For the lines, you have the data necessary to plot the chart.