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 |
1687432 |
2394 |
- |
2436 |
= |
-42 |
* |
(1541 |
/ |
10413) |
= |
-6.21549982 |
4 |
1687433 |
2433 |
- |
2485 |
= |
-52 |
* |
(1482 |
/ |
10413) |
= |
-7.40074904 |
5 |
1687436 |
2446 |
- |
2528 |
= |
-82 |
* |
(1498 |
/ |
10413) |
= |
-11.79640832 |
6 |
1687437 |
2488 |
- |
2552 |
= |
-64 |
* |
(1536 |
/ |
10413) |
= |
-9.44050701 |
7 |
1687440 |
2473 |
- |
2567 |
= |
-94 |
* |
(1485 |
/ |
10413) |
= |
-13.40535861 |
8 |
1687441 |
2485 |
- |
2586 |
= |
-101 |
* |
(1495 |
/ |
10413) |
= |
-14.50062414 |
11 |
1687444 |
2512 |
- |
2628 |
= |
-116 |
* |
(1376 |
/ |
10413) |
= |
-15.32853162 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Jurupa Unified
|
-78 |
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 |
52628 |
2404 |
- |
2436 |
= |
-32 |
* |
(1395 |
/ |
10390) |
= |
-4.29643888 |
4 |
52631 |
2439 |
- |
2485 |
= |
-46 |
* |
(1554 |
/ |
10390) |
= |
-6.88007699 |
5 |
52633 |
2453 |
- |
2528 |
= |
-75 |
* |
(1510 |
/ |
10390) |
= |
-10.89990375 |
6 |
52635 |
2482 |
- |
2552 |
= |
-70 |
* |
(1518 |
/ |
10390) |
= |
-10.22714147 |
7 |
52637 |
2481 |
- |
2567 |
= |
-86 |
* |
(1517 |
/ |
10390) |
= |
-12.55649656 |
8 |
52639 |
2507 |
- |
2586 |
= |
-79 |
* |
(1484 |
/ |
10390) |
= |
-11.2835418 |
11 |
52640 |
2530 |
- |
2628 |
= |
-98 |
* |
(1412 |
/ |
10390) |
= |
-13.31819049 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Jurupa Unified
|
-69 |
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 |
54138 |
2407 |
- |
2436 |
= |
-29 |
* |
(1430 |
/ |
10188) |
= |
-4.07047506 |
4 |
54139 |
2442 |
- |
2485 |
= |
-43 |
* |
(1399 |
/ |
10188) |
= |
-5.90469176 |
5 |
54142 |
2454 |
- |
2528 |
= |
-74 |
* |
(1517 |
/ |
10188) |
= |
-11.01864936 |
6 |
54143 |
2484 |
- |
2552 |
= |
-68 |
* |
(1543 |
/ |
10188) |
= |
-10.29878285 |
7 |
54145 |
2479 |
- |
2567 |
= |
-88 |
* |
(1437 |
/ |
10188) |
= |
-12.4122497 |
8 |
54148 |
2499 |
- |
2586 |
= |
-87 |
* |
(1499 |
/ |
10188) |
= |
-12.80064773 |
11 |
54150 |
2533 |
- |
2628 |
= |
-95 |
* |
(1363 |
/ |
10188) |
= |
-12.70956018 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Jurupa Unified
|
-69 |
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 |
54247 |
2401 |
- |
2436 |
= |
-35 |
* |
(1438 |
/ |
10218) |
= |
-4.92562144 |
4 |
54248 |
2442 |
- |
2485 |
= |
-43 |
* |
(1456 |
/ |
10218) |
= |
-6.12722643 |
5 |
54251 |
2459 |
- |
2528 |
= |
-69 |
* |
(1425 |
/ |
10218) |
= |
-9.62272454 |
6 |
54252 |
2483 |
- |
2552 |
= |
-69 |
* |
(1565 |
/ |
10218) |
= |
-10.56811507 |
7 |
54255 |
2471 |
- |
2567 |
= |
-96 |
* |
(1464 |
/ |
10218) |
= |
-13.75455072 |
8 |
54256 |
2491 |
- |
2586 |
= |
-95 |
* |
(1456 |
/ |
10218) |
= |
-13.53689561 |
11 |
54259 |
2522 |
- |
2628 |
= |
-106 |
* |
(1414 |
/ |
10218) |
= |
-14.66862397 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Jurupa Unified
|
-73 |
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 |
54489 |
2405 |
- |
2436 |
= |
-31 |
* |
(1419 |
/ |
10217) |
= |
-4.30547127 |
4 |
54490 |
2443 |
- |
2485 |
= |
-42 |
* |
(1440 |
/ |
10217) |
= |
-5.91954581 |
5 |
54491 |
2463 |
- |
2528 |
= |
-65 |
* |
(1473 |
/ |
10217) |
= |
-9.37114607 |
6 |
54492 |
2492 |
- |
2552 |
= |
-60 |
* |
(1493 |
/ |
10217) |
= |
-8.76774 |
7 |
54493 |
2483 |
- |
2567 |
= |
-84 |
* |
(1531 |
/ |
10217) |
= |
-12.58725653 |
8 |
54494 |
2494 |
- |
2586 |
= |
-92 |
* |
(1460 |
/ |
10217) |
= |
-13.14671619 |
11 |
54495 |
2524 |
- |
2628 |
= |
-104 |
* |
(1401 |
/ |
10217) |
= |
-14.2609376 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Jurupa Unified
|
-68 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-78
|
-69
|
-69
|
-73
|
-68
|
-357.0 |
-71.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -59.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -83.4
For the lines, you have the data necessary to plot the chart.