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 |
339014 |
2430 |
- |
2436 |
= |
-6 |
* |
(68 |
/ |
223)
|
= |
-1.82959641 |
4 |
339017 |
2453 |
- |
2485 |
= |
-32 |
* |
(54 |
/ |
223)
|
= |
-7.74887891 |
5 |
339018 |
2449 |
- |
2528 |
= |
-79 |
* |
(53 |
/ |
223)
|
= |
-18.77578472 |
6 |
339021 |
2504 |
- |
2552 |
= |
-48 |
* |
(48 |
/ |
223)
|
= |
-10.33183853 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Starr Elementary
|
-39 |
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 |
10101 |
2420 |
- |
2436 |
= |
-16 |
* |
(74 |
/ |
243)
|
= |
-4.87242797 |
4 |
10103 |
2452 |
- |
2485 |
= |
-33 |
* |
(69 |
/ |
243)
|
= |
-9.37037036 |
5 |
10105 |
2482 |
- |
2528 |
= |
-46 |
* |
(51 |
/ |
243)
|
= |
-9.65432098 |
6 |
10108 |
2538 |
- |
2552 |
= |
-14 |
* |
(49 |
/ |
243)
|
= |
-2.82304526 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Starr Elementary
|
-27 |
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 |
10430 |
2452 |
- |
2436 |
= |
16 |
* |
(55 |
/ |
239)
|
= |
3.68200837 |
4 |
10431 |
2457 |
- |
2485 |
= |
-28 |
* |
(75 |
/ |
239)
|
= |
-8.78661087 |
5 |
10434 |
2477 |
- |
2528 |
= |
-51 |
* |
(57 |
/ |
239)
|
= |
-12.16317987 |
6 |
10435 |
2551 |
- |
2552 |
= |
-1 |
* |
(52 |
/ |
239)
|
= |
-0.21757322 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Starr Elementary
|
-17 |
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 |
10441 |
2441 |
- |
2436 |
= |
5 |
* |
(45 |
/ |
224)
|
= |
1.00446429 |
4 |
10444 |
2473 |
- |
2485 |
= |
-12 |
* |
(57 |
/ |
224)
|
= |
-3.05357142 |
5 |
10445 |
2472 |
- |
2528 |
= |
-56 |
* |
(66 |
/ |
224)
|
= |
-16.49999999 |
6 |
10448 |
2523 |
- |
2552 |
= |
-29 |
* |
(56 |
/ |
224)
|
= |
-7.25 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Starr Elementary
|
-26 |
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 |
10522 |
2466 |
- |
2436 |
= |
30 |
* |
(57 |
/ |
210)
|
= |
8.14285713 |
4 |
10523 |
2486 |
- |
2485 |
= |
1 |
* |
(50 |
/ |
210)
|
= |
0.23809524 |
5 |
10524 |
2478 |
- |
2528 |
= |
-50 |
* |
(40 |
/ |
210)
|
= |
-9.5238095 |
6 |
10525 |
2540 |
- |
2552 |
= |
-12 |
* |
(63 |
/ |
210)
|
= |
-3.6 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Starr Elementary
|
-5 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-39
|
-27
|
-17
|
-26
|
-5
|
-114.0 |
-22.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: 13.2
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -58.8
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: