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 |
800388 |
2389 |
- |
2436 |
= |
-47 |
* |
(45 |
/ |
160)
|
= |
-13.21875 |
| 4 |
800389 |
2431 |
- |
2485 |
= |
-54 |
* |
(39 |
/ |
160)
|
= |
-13.1625 |
| 5 |
800392 |
2430 |
- |
2528 |
= |
-98 |
* |
(44 |
/ |
160)
|
= |
-26.95 |
| 6 |
800393 |
2439 |
- |
2552 |
= |
-113 |
* |
(32 |
/ |
160)
|
= |
-22.6 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Cesar Chavez Elementary
|
-76 |
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 |
25029 |
2404 |
- |
2436 |
= |
-32 |
* |
(61 |
/ |
182)
|
= |
-10.72527472 |
| 4 |
25030 |
2415 |
- |
2485 |
= |
-70 |
* |
(45 |
/ |
182)
|
= |
-17.30769229 |
| 5 |
25033 |
2467 |
- |
2528 |
= |
-61 |
* |
(36 |
/ |
182)
|
= |
-12.06593402 |
| 6 |
25035 |
2470 |
- |
2552 |
= |
-82 |
* |
(40 |
/ |
182)
|
= |
-18.02197796 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Cesar Chavez Elementary
|
-58 |
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 |
25525 |
2454 |
- |
2436 |
= |
18 |
* |
(36 |
/ |
160)
|
= |
4.05 |
| 4 |
25528 |
2418 |
- |
2485 |
= |
-67 |
* |
(58 |
/ |
160)
|
= |
-24.2875 |
| 5 |
25530 |
2423 |
- |
2528 |
= |
-105 |
* |
(41 |
/ |
160)
|
= |
-26.90625 |
| 6 |
25532 |
2485 |
- |
2552 |
= |
-67 |
* |
(25 |
/ |
160)
|
= |
-10.46875 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Cesar Chavez Elementary
|
-58 |
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 |
25553 |
2404 |
- |
2436 |
= |
-32 |
* |
(42 |
/ |
177)
|
= |
-7.59322032 |
| 4 |
25555 |
2437 |
- |
2485 |
= |
-48 |
* |
(40 |
/ |
177)
|
= |
-10.8474576 |
| 5 |
25557 |
2438 |
- |
2528 |
= |
-90 |
* |
(60 |
/ |
177)
|
= |
-30.5084745 |
| 6 |
25559 |
2464 |
- |
2552 |
= |
-88 |
* |
(35 |
/ |
177)
|
= |
-17.40112986 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Cesar Chavez Elementary
|
-66 |
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 |
25715 |
2384 |
- |
2436 |
= |
-52 |
* |
(32 |
/ |
159)
|
= |
-10.46540877 |
| 4 |
25716 |
2402 |
- |
2485 |
= |
-83 |
* |
(39 |
/ |
159)
|
= |
-20.35849049 |
| 5 |
25717 |
2439 |
- |
2528 |
= |
-89 |
* |
(38 |
/ |
159)
|
= |
-21.27044019 |
| 6 |
25718 |
2472 |
- |
2552 |
= |
-80 |
* |
(50 |
/ |
159)
|
= |
-25.15723264 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Cesar Chavez Elementary
|
-77 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
-76
|
-58
|
-58
|
-66
|
-77
|
-335.0 |
-67.0 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -40.0
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -94.0
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:
