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 |
957891 |
2368 |
- |
2436 |
= |
-68 |
* |
(95 |
/ |
412)
|
= |
-15.67961163 |
4 |
957892 |
2392 |
- |
2485 |
= |
-93 |
* |
(114 |
/ |
412)
|
= |
-25.7330097 |
5 |
957895 |
2413 |
- |
2528 |
= |
-115 |
* |
(113 |
/ |
412)
|
= |
-31.54126206 |
6 |
957896 |
2457 |
- |
2552 |
= |
-95 |
* |
(90 |
/ |
412)
|
= |
-20.7524271 |
Step 4 |
SUM Weighted Distance From Standard to get
2015 Difference From Standard for Gil Garcetti Learning Academy
|
-94 |
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 |
30306 |
2369 |
- |
2436 |
= |
-67 |
* |
(122 |
/ |
430)
|
= |
-19.00930231 |
4 |
30309 |
2399 |
- |
2485 |
= |
-86 |
* |
(96 |
/ |
430)
|
= |
-19.19999992 |
5 |
30310 |
2413 |
- |
2528 |
= |
-115 |
* |
(109 |
/ |
430)
|
= |
-29.15116278 |
6 |
30313 |
2447 |
- |
2552 |
= |
-105 |
* |
(103 |
/ |
430)
|
= |
-25.15116272 |
Step 4 |
SUM Weighted Distance From Standard to get
2016 Difference From Standard for Gil Garcetti Learning Academy
|
-93 |
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 |
30872 |
2379 |
- |
2436 |
= |
-57 |
* |
(109 |
/ |
439)
|
= |
-14.15261955 |
4 |
30874 |
2399 |
- |
2485 |
= |
-86 |
* |
(116 |
/ |
439)
|
= |
-22.72437357 |
5 |
30876 |
2426 |
- |
2528 |
= |
-102 |
* |
(102 |
/ |
439)
|
= |
-23.69931658 |
6 |
30878 |
2434 |
- |
2552 |
= |
-118 |
* |
(112 |
/ |
439)
|
= |
-30.10478351 |
Step 4 |
SUM Weighted Distance From Standard to get
2017 Difference From Standard for Gil Garcetti Learning Academy
|
-91 |
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 |
30919 |
2364 |
- |
2436 |
= |
-72 |
* |
(99 |
/ |
397)
|
= |
-17.95465994 |
4 |
30920 |
2406 |
- |
2485 |
= |
-79 |
* |
(108 |
/ |
397)
|
= |
-21.49118386 |
5 |
30923 |
2429 |
- |
2528 |
= |
-99 |
* |
(100 |
/ |
397)
|
= |
-24.93702763 |
6 |
30924 |
2455 |
- |
2552 |
= |
-97 |
* |
(90 |
/ |
397)
|
= |
-21.98992435 |
Step 4 |
SUM Weighted Distance From Standard to get
2018 Difference From Standard for Gil Garcetti Learning Academy
|
-86 |
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 |
31095 |
2382 |
- |
2436 |
= |
-54 |
* |
(131 |
/ |
406)
|
= |
-17.42364529 |
4 |
31096 |
2429 |
- |
2485 |
= |
-56 |
* |
(96 |
/ |
406)
|
= |
-13.24137926 |
5 |
31097 |
2426 |
- |
2528 |
= |
-102 |
* |
(98 |
/ |
406)
|
= |
-24.62068962 |
6 |
31098 |
2479 |
- |
2552 |
= |
-73 |
* |
(81 |
/ |
406)
|
= |
-14.5640394 |
Step 4 |
SUM Weighted Distance From Standard to get
2019 Difference From Standard for Gil Garcetti Learning Academy
|
-70 |
Last steps
Compute the average
2015 |
2016 |
2017 |
2018 |
2019 |
Sum |
Average |
-94
|
-93
|
-91
|
-86
|
-70
|
-434.0 |
-86.8 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average: -59.8
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average: -113.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: