Options for Youth-San Bernardino (Data source)
Source data for Options for Youth-San Bernardino
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 |
||
7 | 2042939 | 0 | - | 2567 | = | * | (7 | / | 140) | = | ||||
8 | 2042940 | 2434 | - | 2586 | = | -152 | * | (25 | / | 140) | = | -27.14285706 | ||
11 | 2042943 | 2480 | - | 2628 | = | -148 | * | (108 | / | 140) | = | -114.17142851 | ||
Step 4 | SUM Weighted Distance From Standard to get 2015 Difference From Standard for Options for Youth-San Bernardino | -141 |
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 |
||
7 | 62746 | 2442 | - | 2567 | = | -125 | * | (26 | / | 167) | = | -19.46107775 | ||
8 | 62748 | 2436 | - | 2586 | = | -150 | * | (32 | / | 167) | = | -28.7425149 | ||
11 | 62750 | 2469 | - | 2628 | = | -159 | * | (109 | / | 167) | = | -103.77844299 | ||
Step 4 | SUM Weighted Distance From Standard to get 2016 Difference From Standard for Options for Youth-San Bernardino | -152 |
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 |
||
7 | 64540 | 2434 | - | 2567 | = | -133 | * | (40 | / | 230) | = | -23.13043472 | ||
8 | 64542 | 2431 | - | 2586 | = | -155 | * | (58 | / | 230) | = | -39.08695652 | ||
11 | 64545 | 2494 | - | 2628 | = | -134 | * | (132 | / | 230) | = | -76.90434776 | ||
Step 4 | SUM Weighted Distance From Standard to get 2017 Difference From Standard for Options for Youth-San Bernardino | -139 |
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 |
||
7 | 64633 | 2441 | - | 2567 | = | -126 | * | (55 | / | 311) | = | -22.28295812 | ||
8 | 64635 | 2446 | - | 2586 | = | -140 | * | (79 | / | 311) | = | -35.56270088 | ||
11 | 64638 | 2488 | - | 2628 | = | -140 | * | (177 | / | 311) | = | -79.67845648 | ||
Step 4 | SUM Weighted Distance From Standard to get 2018 Difference From Standard for Options for Youth-San Bernardino | -138 |
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 |
||
7 | 65001 | 2441 | - | 2567 | = | -126 | * | (44 | / | 254) | = | -21.8267716 | ||
8 | 65002 | 2433 | - | 2586 | = | -153 | * | (60 | / | 254) | = | -36.14173222 | ||
11 | 65003 | 2501 | - | 2628 | = | -127 | * | (150 | / | 254) | = | -74.99999999 | ||
Step 4 | SUM Weighted Distance From Standard to get 2019 Difference From Standard for Options for Youth-San Bernardino | -133 |
Last steps
Compute the average
2015 | 2016 | 2017 | 2018 | 2019 | Sum | Average |
---|---|---|---|---|---|---|
-141 | -152 | -139 | -138 | -133 | -703.0 | -140.6 |
Compute the Upper Control Limit
Simply compute the standard deviation and multiply by 3 and add to the average:
Compute the Lower Control Limit
Simply compute the standard deviation and multiply by 3 and subtract from the average:
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:
2015 | 2016 | 2017 | 2018 | 2019 | |
---|---|---|---|---|---|
Percent | 86% | 84% | 83% | 83% | 69% |
Data source | 2015 data file | 2016 data file | 2017 data file | 2018 data file | 2019 data file |
San Bernardino City Unified school district County of San Bernardino
THIS chart shows what the school system "wants"
PLUS a "special" or "outside" cause of variation, parent education.
NOT what teachers want.
NOT what principals want.
NOT what parents want.
High Schools (Public) schools in San Bernardino City Unified (6)
Arroyo Valley High | Cajon High | Indian Springs High |
Pacific High | San Bernardino High | San Gorgonio High |