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 |
1323021 |
2367 |
- |
2436 |
= |
-69 |
* |
(184 |
/ |
1183) |
= |
-10.73203713 |
4 |
1323024 |
2409 |
- |
2485 |
= |
-76 |
* |
(170 |
/ |
1183) |
= |
-10.92138628 |
5 |
1323025 |
2421 |
- |
2528 |
= |
-107 |
* |
(163 |
/ |
1183) |
= |
-14.74302614 |
6 |
1323028 |
2434 |
- |
2552 |
= |
-118 |
* |
(162 |
/ |
1183) |
= |
-16.15891799 |
7 |
1323029 |
2472 |
- |
2567 |
= |
-95 |
* |
(153 |
/ |
1183) |
= |
-12.28655957 |
8 |
1323032 |
2467 |
- |
2586 |
= |
-119 |
* |
(192 |
/ |
1183) |
= |
-19.31360944 |
11 |
1323033 |
2501 |
- |
2628 |
= |
-127 |
* |
(159 |
/ |
1183) |
= |
-17.06931524 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Dos Palos Oro Loma Joint Unified
|
-101 |
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 |
41523 |
2358 |
- |
2436 |
= |
-78 |
* |
(161 |
/ |
1172) |
= |
-10.71501701 |
4 |
41525 |
2417 |
- |
2485 |
= |
-68 |
* |
(181 |
/ |
1172) |
= |
-10.50170648 |
5 |
41526 |
2429 |
- |
2528 |
= |
-99 |
* |
(168 |
/ |
1172) |
= |
-14.19112619 |
6 |
41528 |
2427 |
- |
2552 |
= |
-125 |
* |
(165 |
/ |
1172) |
= |
-17.59812275 |
7 |
41531 |
2486 |
- |
2567 |
= |
-81 |
* |
(165 |
/ |
1172) |
= |
-11.40358354 |
8 |
41532 |
2476 |
- |
2586 |
= |
-110 |
* |
(156 |
/ |
1172) |
= |
-14.64163822 |
11 |
41535 |
2525 |
- |
2628 |
= |
-103 |
* |
(176 |
/ |
1172) |
= |
-15.46757674 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Dos Palos Oro Loma Joint Unified
|
-95 |
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 |
42537 |
2373 |
- |
2436 |
= |
-63 |
* |
(174 |
/ |
1246) |
= |
-8.79775275 |
4 |
42540 |
2400 |
- |
2485 |
= |
-85 |
* |
(167 |
/ |
1246) |
= |
-11.39245582 |
5 |
42542 |
2433 |
- |
2528 |
= |
-95 |
* |
(198 |
/ |
1246) |
= |
-15.09630817 |
6 |
42544 |
2403 |
- |
2552 |
= |
-149 |
* |
(172 |
/ |
1246) |
= |
-20.56821822 |
7 |
42545 |
2474 |
- |
2567 |
= |
-93 |
* |
(174 |
/ |
1246) |
= |
-12.98715882 |
8 |
42547 |
2457 |
- |
2586 |
= |
-129 |
* |
(180 |
/ |
1246) |
= |
-18.63563399 |
11 |
42549 |
2528 |
- |
2628 |
= |
-100 |
* |
(181 |
/ |
1246) |
= |
-14.5264847 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Dos Palos Oro Loma Joint Unified
|
-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 |
3 |
42551 |
2370 |
- |
2436 |
= |
-66 |
* |
(178 |
/ |
1287) |
= |
-9.12820511 |
4 |
42553 |
2405 |
- |
2485 |
= |
-80 |
* |
(184 |
/ |
1287) |
= |
-11.43745136 |
5 |
42554 |
2423 |
- |
2528 |
= |
-105 |
* |
(172 |
/ |
1287) |
= |
-14.03263397 |
6 |
42557 |
2423 |
- |
2552 |
= |
-129 |
* |
(207 |
/ |
1287) |
= |
-20.74825164 |
7 |
42558 |
2451 |
- |
2567 |
= |
-116 |
* |
(185 |
/ |
1287) |
= |
-16.67443659 |
8 |
42561 |
2445 |
- |
2586 |
= |
-141 |
* |
(176 |
/ |
1287) |
= |
-19.28205118 |
11 |
42563 |
2495 |
- |
2628 |
= |
-133 |
* |
(185 |
/ |
1287) |
= |
-19.11810402 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Dos Palos Oro Loma Joint Unified
|
-110 |
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 |
42694 |
2376 |
- |
2436 |
= |
-60 |
* |
(184 |
/ |
1296) |
= |
-8.51851848 |
4 |
42695 |
2424 |
- |
2485 |
= |
-61 |
* |
(180 |
/ |
1296) |
= |
-8.47222217 |
5 |
42696 |
2425 |
- |
2528 |
= |
-103 |
* |
(185 |
/ |
1296) |
= |
-14.70293204 |
6 |
42697 |
2399 |
- |
2552 |
= |
-153 |
* |
(180 |
/ |
1296) |
= |
-21.24999986 |
7 |
42698 |
2451 |
- |
2567 |
= |
-116 |
* |
(219 |
/ |
1296) |
= |
-19.6018518 |
8 |
42699 |
2435 |
- |
2586 |
= |
-151 |
* |
(187 |
/ |
1296) |
= |
-21.78780857 |
11 |
42700 |
2495 |
- |
2628 |
= |
-133 |
* |
(161 |
/ |
1296) |
= |
-16.52237654 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Dos Palos Oro Loma Joint Unified
|
-111 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-101
|
-95
|
-102
|
-110
|
-111
|
-519.0 |
-103.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -85.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -121.8
For the lines, you have the data necessary to plot the chart.