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 |
759295 |
2414 |
- |
2436 |
= |
-22 |
* |
(5906 |
/ |
39911) |
= |
-3.25554357 |
4 |
759298 |
2450 |
- |
2485 |
= |
-35 |
* |
(5919 |
/ |
39911) |
= |
-5.19067423 |
5 |
759299 |
2481 |
- |
2528 |
= |
-47 |
* |
(5810 |
/ |
39911) |
= |
-6.84197335 |
6 |
759302 |
2495 |
- |
2552 |
= |
-57 |
* |
(5607 |
/ |
39911) |
= |
-8.00779229 |
7 |
759303 |
2514 |
- |
2567 |
= |
-53 |
* |
(5589 |
/ |
39911) |
= |
-7.42193879 |
8 |
759306 |
2525 |
- |
2586 |
= |
-61 |
* |
(5714 |
/ |
39911) |
= |
-8.73328155 |
11 |
759307 |
2547 |
- |
2628 |
= |
-81 |
* |
(5366 |
/ |
39911) |
= |
-10.89038107 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Long Beach Unified
|
-50 |
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 |
23849 |
2424 |
- |
2436 |
= |
-12 |
* |
(5766 |
/ |
39493) |
= |
-1.75200668 |
4 |
23850 |
2460 |
- |
2485 |
= |
-25 |
* |
(5792 |
/ |
39493) |
= |
-3.66647253 |
5 |
23852 |
2482 |
- |
2528 |
= |
-46 |
* |
(5804 |
/ |
39493) |
= |
-6.76028659 |
6 |
23855 |
2506 |
- |
2552 |
= |
-46 |
* |
(5660 |
/ |
39493) |
= |
-6.5925607 |
7 |
23857 |
2518 |
- |
2567 |
= |
-49 |
* |
(5529 |
/ |
39493) |
= |
-6.85997516 |
8 |
23858 |
2539 |
- |
2586 |
= |
-47 |
* |
(5565 |
/ |
39493) |
= |
-6.62281921 |
11 |
23860 |
2553 |
- |
2628 |
= |
-75 |
* |
(5377 |
/ |
39493) |
= |
-10.21130325 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Long Beach Unified
|
-42 |
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 |
24348 |
2441 |
- |
2436 |
= |
5 |
* |
(5596 |
/ |
38786) |
= |
0.72139432 |
4 |
24349 |
2470 |
- |
2485 |
= |
-15 |
* |
(5609 |
/ |
38786) |
= |
-2.16921053 |
5 |
24352 |
2493 |
- |
2528 |
= |
-35 |
* |
(5690 |
/ |
38786) |
= |
-5.13458463 |
6 |
24354 |
2515 |
- |
2552 |
= |
-37 |
* |
(5523 |
/ |
38786) |
= |
-5.26867942 |
7 |
24355 |
2525 |
- |
2567 |
= |
-42 |
* |
(5595 |
/ |
38786) |
= |
-6.0586294 |
8 |
24358 |
2541 |
- |
2586 |
= |
-45 |
* |
(5432 |
/ |
38786) |
= |
-6.30227399 |
11 |
24359 |
2547 |
- |
2628 |
= |
-81 |
* |
(5341 |
/ |
38786) |
= |
-11.15405041 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Long Beach Unified
|
-35 |
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 |
24370 |
2449 |
- |
2436 |
= |
13 |
* |
(5266 |
/ |
37791) |
= |
1.8114895 |
4 |
24372 |
2482 |
- |
2485 |
= |
-3 |
* |
(5500 |
/ |
37791) |
= |
-0.43661189 |
5 |
24374 |
2505 |
- |
2528 |
= |
-23 |
* |
(5552 |
/ |
37791) |
= |
-3.37900558 |
6 |
24376 |
2528 |
- |
2552 |
= |
-24 |
* |
(5439 |
/ |
37791) |
= |
-3.45415574 |
7 |
24378 |
2530 |
- |
2567 |
= |
-37 |
* |
(5432 |
/ |
37791) |
= |
-5.3183033 |
8 |
24380 |
2548 |
- |
2586 |
= |
-38 |
* |
(5503 |
/ |
37791) |
= |
-5.53343388 |
11 |
24382 |
2547 |
- |
2628 |
= |
-81 |
* |
(5099 |
/ |
37791) |
= |
-10.92903071 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Long Beach Unified
|
-27 |
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 |
24544 |
2453 |
- |
2436 |
= |
17 |
* |
(5352 |
/ |
36941) |
= |
2.46295442 |
4 |
24545 |
2488 |
- |
2485 |
= |
3 |
* |
(5166 |
/ |
36941) |
= |
0.41953385 |
5 |
24546 |
2515 |
- |
2528 |
= |
-13 |
* |
(5387 |
/ |
36941) |
= |
-1.89575268 |
6 |
24547 |
2534 |
- |
2552 |
= |
-18 |
* |
(5374 |
/ |
36941) |
= |
-2.61855391 |
7 |
24548 |
2543 |
- |
2567 |
= |
-24 |
* |
(5343 |
/ |
36941) |
= |
-3.47126498 |
8 |
24549 |
2551 |
- |
2586 |
= |
-35 |
* |
(5344 |
/ |
36941) |
= |
-5.06320889 |
11 |
24550 |
2553 |
- |
2628 |
= |
-75 |
* |
(4975 |
/ |
36941) |
= |
-10.10056575 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Long Beach Unified
|
-20 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-50
|
-42
|
-35
|
-27
|
-20
|
-174.0 |
-34.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -1.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -67.8
For the lines, you have the data necessary to plot the chart.