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 |
54803 |
2439 |
- |
2436 |
= |
3 |
* |
(971 |
/ |
6422) |
= |
0.45359701 |
4 |
54806 |
2468 |
- |
2485 |
= |
-17 |
* |
(888 |
/ |
6422) |
= |
-2.35066956 |
5 |
54807 |
2501 |
- |
2528 |
= |
-27 |
* |
(876 |
/ |
6422) |
= |
-3.68296481 |
6 |
54810 |
2525 |
- |
2552 |
= |
-27 |
* |
(942 |
/ |
6422) |
= |
-3.96044845 |
7 |
54811 |
2541 |
- |
2567 |
= |
-26 |
* |
(914 |
/ |
6422) |
= |
-3.70040484 |
8 |
54814 |
2566 |
- |
2586 |
= |
-20 |
* |
(934 |
/ |
6422) |
= |
-2.90875116 |
11 |
54815 |
2610 |
- |
2628 |
= |
-18 |
* |
(897 |
/ |
6422) |
= |
-2.51417003 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Livermore Valley Joint Unified
|
-19 |
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 |
1440 |
2451 |
- |
2436 |
= |
15 |
* |
(904 |
/ |
6439) |
= |
2.10591707 |
4 |
1442 |
2479 |
- |
2485 |
= |
-6 |
* |
(961 |
/ |
6439) |
= |
-0.89548066 |
5 |
1444 |
2502 |
- |
2528 |
= |
-26 |
* |
(886 |
/ |
6439) |
= |
-3.57757416 |
6 |
1446 |
2530 |
- |
2552 |
= |
-22 |
* |
(884 |
/ |
6439) |
= |
-3.02034476 |
7 |
1447 |
2547 |
- |
2567 |
= |
-20 |
* |
(952 |
/ |
6439) |
= |
-2.95698088 |
8 |
1450 |
2565 |
- |
2586 |
= |
-21 |
* |
(929 |
/ |
6439) |
= |
-3.02981828 |
11 |
1452 |
2603 |
- |
2628 |
= |
-25 |
* |
(923 |
/ |
6439) |
= |
-3.58363098 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Livermore Valley Joint Unified
|
-15 |
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 |
1477 |
2450 |
- |
2436 |
= |
14 |
* |
(965 |
/ |
6931) |
= |
1.94921367 |
4 |
1479 |
2491 |
- |
2485 |
= |
6 |
* |
(987 |
/ |
6931) |
= |
0.85442216 |
5 |
1481 |
2507 |
- |
2528 |
= |
-21 |
* |
(1051 |
/ |
6931) |
= |
-3.18438897 |
6 |
1484 |
2537 |
- |
2552 |
= |
-15 |
* |
(940 |
/ |
6931) |
= |
-2.03433848 |
7 |
1486 |
2562 |
- |
2567 |
= |
-5 |
* |
(967 |
/ |
6931) |
= |
-0.69759054 |
8 |
1488 |
2564 |
- |
2586 |
= |
-22 |
* |
(1012 |
/ |
6931) |
= |
-3.21223487 |
11 |
1490 |
2606 |
- |
2628 |
= |
-22 |
* |
(1009 |
/ |
6931) |
= |
-3.20271244 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Livermore Valley Joint Unified
|
-10 |
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 |
1507 |
2457 |
- |
2436 |
= |
21 |
* |
(924 |
/ |
6990) |
= |
2.77596566 |
4 |
1509 |
2492 |
- |
2485 |
= |
7 |
* |
(989 |
/ |
6990) |
= |
0.99041487 |
5 |
1511 |
2514 |
- |
2528 |
= |
-14 |
* |
(1006 |
/ |
6990) |
= |
-2.01487839 |
6 |
1513 |
2540 |
- |
2552 |
= |
-12 |
* |
(1077 |
/ |
6990) |
= |
-1.84892704 |
7 |
1515 |
2557 |
- |
2567 |
= |
-10 |
* |
(978 |
/ |
6990) |
= |
-1.39914163 |
8 |
1517 |
2577 |
- |
2586 |
= |
-9 |
* |
(983 |
/ |
6990) |
= |
-1.26566523 |
11 |
1519 |
2598 |
- |
2628 |
= |
-30 |
* |
(1033 |
/ |
6990) |
= |
-4.43347638 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Livermore Valley Joint Unified
|
-7 |
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 |
1537 |
2456 |
- |
2436 |
= |
20 |
* |
(957 |
/ |
7000) |
= |
2.7342857 |
4 |
1538 |
2497 |
- |
2485 |
= |
12 |
* |
(935 |
/ |
7000) |
= |
1.60285714 |
5 |
1539 |
2522 |
- |
2528 |
= |
-6 |
* |
(980 |
/ |
7000) |
= |
-0.84 |
6 |
1540 |
2537 |
- |
2552 |
= |
-15 |
* |
(1002 |
/ |
7000) |
= |
-2.14714286 |
7 |
1541 |
2558 |
- |
2567 |
= |
-9 |
* |
(1076 |
/ |
7000) |
= |
-1.38342857 |
8 |
1542 |
2577 |
- |
2586 |
= |
-9 |
* |
(982 |
/ |
7000) |
= |
-1.26257143 |
11 |
1543 |
2586 |
- |
2628 |
= |
-42 |
* |
(1068 |
/ |
7000) |
= |
-6.40799998 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Livermore Valley Joint Unified
|
-8 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-19
|
-15
|
-10
|
-7
|
-8
|
-59.0 |
-11.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 3.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -26.8
For the lines, you have the data necessary to plot the chart.