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 |
4 |
1864520 |
2445 |
- |
2485 |
= |
-40 |
* |
(106 |
/ |
344)
|
= |
-12.32558136 |
5 |
1864521 |
2473 |
- |
2528 |
= |
-55 |
* |
(120 |
/ |
344)
|
= |
-19.1860465 |
6 |
1864524 |
2483 |
- |
2552 |
= |
-69 |
* |
(118 |
/ |
344)
|
= |
-23.6686046 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Cesar Chavez Intermediate
|
-55 |
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 |
4 |
57580 |
2430 |
- |
2485 |
= |
-55 |
* |
(145 |
/ |
372)
|
= |
-21.43817203 |
5 |
57583 |
2464 |
- |
2528 |
= |
-64 |
* |
(108 |
/ |
372)
|
= |
-18.58064512 |
6 |
57585 |
2505 |
- |
2552 |
= |
-47 |
* |
(119 |
/ |
372)
|
= |
-15.03494623 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Cesar Chavez Intermediate
|
-55 |
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 |
4 |
59257 |
2439 |
- |
2485 |
= |
-46 |
* |
(136 |
/ |
394)
|
= |
-15.87817254 |
5 |
59259 |
2454 |
- |
2528 |
= |
-74 |
* |
(144 |
/ |
394)
|
= |
-27.04568524 |
6 |
59262 |
2490 |
- |
2552 |
= |
-62 |
* |
(114 |
/ |
394)
|
= |
-17.93908626 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Cesar Chavez Intermediate
|
-61 |
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 |
4 |
59373 |
2457 |
- |
2485 |
= |
-28 |
* |
(109 |
/ |
382)
|
= |
-7.98952879 |
5 |
59374 |
2453 |
- |
2528 |
= |
-75 |
* |
(129 |
/ |
382)
|
= |
-25.32722513 |
6 |
59377 |
2487 |
- |
2552 |
= |
-65 |
* |
(144 |
/ |
382)
|
= |
-24.50261775 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Cesar Chavez Intermediate
|
-58 |
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 |
4 |
59623 |
2447 |
- |
2485 |
= |
-38 |
* |
(127 |
/ |
375)
|
= |
-12.86933331 |
5 |
59624 |
2489 |
- |
2528 |
= |
-39 |
* |
(117 |
/ |
375)
|
= |
-12.168 |
6 |
59625 |
2515 |
- |
2552 |
= |
-37 |
* |
(131 |
/ |
375)
|
= |
-12.92533332 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Cesar Chavez Intermediate
|
-38 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-55
|
-55
|
-61
|
-58
|
-38
|
-267.0 |
-53.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -29.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -77.4
For the lines, you have the data necessary to plot the chart.
Very last step
The percent of students getting a Free or Reduced Price Meal comes from the following sources: