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 |
1724208 |
2384 |
- |
2436 |
= |
-52 |
* |
(889 |
/ |
3462) |
= |
-13.35297512 |
4 |
1724209 |
2430 |
- |
2485 |
= |
-55 |
* |
(804 |
/ |
3462) |
= |
-12.77296356 |
5 |
1724212 |
2444 |
- |
2528 |
= |
-84 |
* |
(774 |
/ |
3462) |
= |
-18.77989596 |
6 |
1724213 |
2467 |
- |
2552 |
= |
-85 |
* |
(785 |
/ |
3462) |
= |
-19.27354124 |
7 |
1724216 |
2515 |
- |
2567 |
= |
-52 |
* |
(111 |
/ |
3462) |
= |
-1.66724433 |
8 |
1724217 |
2516 |
- |
2586 |
= |
-70 |
* |
(99 |
/ |
3462) |
= |
-2.00173309 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Perris Elementary
|
-68 |
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 |
53666 |
2393 |
- |
2436 |
= |
-43 |
* |
(820 |
/ |
3488) |
= |
-10.10894495 |
4 |
53669 |
2430 |
- |
2485 |
= |
-55 |
* |
(883 |
/ |
3488) |
= |
-13.9234518 |
5 |
53670 |
2448 |
- |
2528 |
= |
-80 |
* |
(787 |
/ |
3488) |
= |
-18.05045864 |
6 |
53673 |
2468 |
- |
2552 |
= |
-84 |
* |
(767 |
/ |
3488) |
= |
-18.47133019 |
7 |
53674 |
2503 |
- |
2567 |
= |
-64 |
* |
(119 |
/ |
3488) |
= |
-2.18348621 |
8 |
53677 |
2514 |
- |
2586 |
= |
-72 |
* |
(112 |
/ |
3488) |
= |
-2.31192655 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Perris Elementary
|
-65 |
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 |
55223 |
2391 |
- |
2436 |
= |
-45 |
* |
(763 |
/ |
3424) |
= |
-10.02774533 |
4 |
55226 |
2431 |
- |
2485 |
= |
-54 |
* |
(818 |
/ |
3424) |
= |
-12.90070093 |
5 |
55228 |
2450 |
- |
2528 |
= |
-78 |
* |
(835 |
/ |
3424) |
= |
-19.02161212 |
6 |
55230 |
2473 |
- |
2552 |
= |
-79 |
* |
(773 |
/ |
3424) |
= |
-17.83498826 |
7 |
55231 |
2491 |
- |
2567 |
= |
-76 |
* |
(118 |
/ |
3424) |
= |
-2.61915882 |
8 |
55233 |
2496 |
- |
2586 |
= |
-90 |
* |
(117 |
/ |
3424) |
= |
-3.0753504 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Perris Elementary
|
-65 |
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 |
55319 |
2397 |
- |
2436 |
= |
-39 |
* |
(758 |
/ |
3404) |
= |
-8.6844888 |
4 |
55320 |
2433 |
- |
2485 |
= |
-52 |
* |
(770 |
/ |
3404) |
= |
-11.76263218 |
5 |
55323 |
2440 |
- |
2528 |
= |
-88 |
* |
(793 |
/ |
3404) |
= |
-20.50058754 |
6 |
55324 |
2468 |
- |
2552 |
= |
-84 |
* |
(846 |
/ |
3404) |
= |
-20.87661568 |
7 |
55327 |
2497 |
- |
2567 |
= |
-70 |
* |
(127 |
/ |
3404) |
= |
-2.61163336 |
8 |
55329 |
2518 |
- |
2586 |
= |
-68 |
* |
(110 |
/ |
3404) |
= |
-2.19741476 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Perris Elementary
|
-67 |
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 |
55580 |
2395 |
- |
2436 |
= |
-41 |
* |
(804 |
/ |
3295) |
= |
-10.00424883 |
4 |
55581 |
2440 |
- |
2485 |
= |
-45 |
* |
(762 |
/ |
3295) |
= |
-10.40667678 |
5 |
55582 |
2445 |
- |
2528 |
= |
-83 |
* |
(720 |
/ |
3295) |
= |
-18.13657053 |
6 |
55583 |
2468 |
- |
2552 |
= |
-84 |
* |
(765 |
/ |
3295) |
= |
-19.50227614 |
7 |
55584 |
2476 |
- |
2567 |
= |
-91 |
* |
(127 |
/ |
3295) |
= |
-3.50743548 |
8 |
55585 |
2497 |
- |
2586 |
= |
-89 |
* |
(117 |
/ |
3295) |
= |
-3.16024271 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Perris Elementary
|
-65 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-68
|
-65
|
-65
|
-67
|
-65
|
-330.0 |
-66.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -63.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -69.0
For the lines, you have the data necessary to plot the chart.