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 |
2382521 |
2496 |
- |
2436 |
= |
60 |
* |
(66 |
/ |
382)
|
= |
10.36649214 |
| 4 |
2382524 |
2523 |
- |
2485 |
= |
38 |
* |
(66 |
/ |
382)
|
= |
6.56544502 |
| 5 |
2382525 |
2601 |
- |
2528 |
= |
73 |
* |
(66 |
/ |
382)
|
= |
12.61256544 |
| 6 |
2382528 |
2620 |
- |
2552 |
= |
68 |
* |
(64 |
/ |
382)
|
= |
11.39267016 |
| 7 |
2382529 |
2660 |
- |
2567 |
= |
93 |
* |
(61 |
/ |
382)
|
= |
14.85078526 |
| 8 |
2382532 |
2665 |
- |
2586 |
= |
79 |
* |
(59 |
/ |
382)
|
= |
12.20157062 |
| Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Yu (Alice Fong) 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 |
72755 |
2486 |
- |
2436 |
= |
50 |
* |
(66 |
/ |
389)
|
= |
8.48329045 |
| 4 |
72758 |
2524 |
- |
2485 |
= |
39 |
* |
(66 |
/ |
389)
|
= |
6.61696655 |
| 5 |
72759 |
2573 |
- |
2528 |
= |
45 |
* |
(66 |
/ |
389)
|
= |
7.63496141 |
| 6 |
72761 |
2617 |
- |
2552 |
= |
65 |
* |
(66 |
/ |
389)
|
= |
11.02827759 |
| 7 |
72764 |
2657 |
- |
2567 |
= |
90 |
* |
(64 |
/ |
389)
|
= |
14.80719789 |
| 8 |
72765 |
2674 |
- |
2586 |
= |
88 |
* |
(61 |
/ |
389)
|
= |
13.79948583 |
| Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Yu (Alice Fong) Elementary
|
62 |
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 |
74727 |
2487 |
- |
2436 |
= |
51 |
* |
(65 |
/ |
392)
|
= |
8.45663263 |
| 4 |
74730 |
2518 |
- |
2485 |
= |
33 |
* |
(66 |
/ |
392)
|
= |
5.55612242 |
| 5 |
74731 |
2561 |
- |
2528 |
= |
33 |
* |
(66 |
/ |
392)
|
= |
5.55612242 |
| 6 |
74734 |
2583 |
- |
2552 |
= |
31 |
* |
(66 |
/ |
392)
|
= |
5.21938773 |
| 7 |
74735 |
2651 |
- |
2567 |
= |
84 |
* |
(66 |
/ |
392)
|
= |
14.14285706 |
| 8 |
74737 |
2685 |
- |
2586 |
= |
99 |
* |
(63 |
/ |
392)
|
= |
15.91071422 |
| Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Yu (Alice Fong) Elementary
|
55 |
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 |
74902 |
2474 |
- |
2436 |
= |
38 |
* |
(65 |
/ |
395)
|
= |
6.25316456 |
| 4 |
74903 |
2524 |
- |
2485 |
= |
39 |
* |
(66 |
/ |
395)
|
= |
6.51645567 |
| 5 |
74906 |
2553 |
- |
2528 |
= |
25 |
* |
(66 |
/ |
395)
|
= |
4.17721518 |
| 6 |
74907 |
2592 |
- |
2552 |
= |
40 |
* |
(66 |
/ |
395)
|
= |
6.68354428 |
| 7 |
74909 |
2619 |
- |
2567 |
= |
52 |
* |
(66 |
/ |
395)
|
= |
8.68860756 |
| 8 |
74912 |
2690 |
- |
2586 |
= |
104 |
* |
(66 |
/ |
395)
|
= |
17.37721513 |
| Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Yu (Alice Fong) Elementary
|
50 |
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 |
75430 |
2468 |
- |
2436 |
= |
32 |
* |
(66 |
/ |
386)
|
= |
5.47150256 |
| 4 |
75431 |
2503 |
- |
2485 |
= |
18 |
* |
(63 |
/ |
386)
|
= |
2.93782383 |
| 5 |
75432 |
2561 |
- |
2528 |
= |
33 |
* |
(64 |
/ |
386)
|
= |
5.47150256 |
| 6 |
75433 |
2592 |
- |
2552 |
= |
40 |
* |
(65 |
/ |
386)
|
= |
6.73575128 |
| 7 |
75434 |
2618 |
- |
2567 |
= |
51 |
* |
(64 |
/ |
386)
|
= |
8.45595851 |
| 8 |
75435 |
2632 |
- |
2586 |
= |
46 |
* |
(64 |
/ |
386)
|
= |
7.62694297 |
| Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Yu (Alice Fong) Elementary
|
37 |
Last steps
Compute the average
| 2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
|
68
|
62
|
55
|
50
|
37
|
272.0 |
54.4 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 87.4
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: 21.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:
