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 |
2666556 |
2456 |
- |
2436 |
= |
20 |
* |
(54 |
/ |
364) |
= |
2.96703296 |
4 |
2666557 |
2516 |
- |
2485 |
= |
31 |
* |
(55 |
/ |
364) |
= |
4.68406593 |
5 |
2666560 |
2515 |
- |
2528 |
= |
-13 |
* |
(58 |
/ |
364) |
= |
-2.07142857 |
6 |
2666561 |
2591 |
- |
2552 |
= |
39 |
* |
(60 |
/ |
364) |
= |
6.4285714 |
7 |
2666564 |
2606 |
- |
2567 |
= |
39 |
* |
(66 |
/ |
364) |
= |
7.07142856 |
8 |
2666565 |
2622 |
- |
2586 |
= |
36 |
* |
(71 |
/ |
364) |
= |
7.02197802 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Loma Prieta Joint Union Elementary
|
26 |
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 |
81262 |
2466 |
- |
2436 |
= |
30 |
* |
(53 |
/ |
368) |
= |
4.32065217 |
4 |
81265 |
2513 |
- |
2485 |
= |
28 |
* |
(57 |
/ |
368) |
= |
4.33695651 |
5 |
81266 |
2584 |
- |
2528 |
= |
56 |
* |
(59 |
/ |
368) |
= |
8.97826082 |
6 |
81268 |
2576 |
- |
2552 |
= |
24 |
* |
(74 |
/ |
368) |
= |
4.82608694 |
7 |
81271 |
2618 |
- |
2567 |
= |
51 |
* |
(62 |
/ |
368) |
= |
8.59239126 |
8 |
81272 |
2642 |
- |
2586 |
= |
56 |
* |
(63 |
/ |
368) |
= |
9.58695651 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Loma Prieta Joint Union Elementary
|
41 |
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 |
83510 |
2475 |
- |
2436 |
= |
39 |
* |
(47 |
/ |
382) |
= |
4.79842931 |
4 |
83513 |
2512 |
- |
2485 |
= |
27 |
* |
(57 |
/ |
382) |
= |
4.02879579 |
5 |
83515 |
2563 |
- |
2528 |
= |
35 |
* |
(59 |
/ |
382) |
= |
5.40575914 |
6 |
83516 |
2612 |
- |
2552 |
= |
60 |
* |
(84 |
/ |
382) |
= |
13.19371722 |
7 |
83519 |
2598 |
- |
2567 |
= |
31 |
* |
(69 |
/ |
382) |
= |
5.59947643 |
8 |
83521 |
2654 |
- |
2586 |
= |
68 |
* |
(66 |
/ |
382) |
= |
11.74869109 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Loma Prieta Joint Union Elementary
|
45 |
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 |
83737 |
2484 |
- |
2436 |
= |
48 |
* |
(40 |
/ |
361) |
= |
5.31855955 |
4 |
83739 |
2538 |
- |
2485 |
= |
53 |
* |
(39 |
/ |
361) |
= |
5.72576172 |
5 |
83741 |
2548 |
- |
2528 |
= |
20 |
* |
(57 |
/ |
361) |
= |
3.15789472 |
6 |
83742 |
2584 |
- |
2552 |
= |
32 |
* |
(77 |
/ |
361) |
= |
6.82548474 |
7 |
83745 |
2638 |
- |
2567 |
= |
71 |
* |
(79 |
/ |
361) |
= |
15.53739612 |
8 |
83746 |
2640 |
- |
2586 |
= |
54 |
* |
(69 |
/ |
361) |
= |
10.32132964 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Loma Prieta Joint Union Elementary
|
47 |
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 |
84351 |
2480 |
- |
2436 |
= |
44 |
* |
(45 |
/ |
356) |
= |
5.56179774 |
4 |
84352 |
2529 |
- |
2485 |
= |
44 |
* |
(41 |
/ |
356) |
= |
5.06741572 |
5 |
84353 |
2588 |
- |
2528 |
= |
60 |
* |
(45 |
/ |
356) |
= |
7.58426964 |
6 |
84354 |
2569 |
- |
2552 |
= |
17 |
* |
(67 |
/ |
356) |
= |
3.1994382 |
7 |
84355 |
2603 |
- |
2567 |
= |
36 |
* |
(80 |
/ |
356) |
= |
8.08988764 |
8 |
84356 |
2655 |
- |
2586 |
= |
69 |
* |
(78 |
/ |
356) |
= |
15.11797749 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Loma Prieta Joint Union Elementary
|
45 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
26
|
41
|
45
|
47
|
45
|
204.0 |
40.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 64.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 16.8
For the lines, you have the data necessary to plot the chart.