Spreadsheet: ca0dca7a-02b2-44a1-a6e7-535eeb6251aa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Passing Muster Calculator
The Brookings Brown Center Task Group on Teacher Quality
 | Parameters to set | Fill in the blue cells with your values
STEP ONE (Exceptionality) | Target percentile of true value-added
STEP TWO (Tolerance) | Tolerance for errors of over-inclusion (default is .5)
STEP THREE (Full evaluation r) | Correlation of teacher-level total evaluation score from baseline year(s) with next year's teacher-level value-added for teachers for whom both value-added and non-valued added components are available |  | 0
STEP FOUR (Non value-added r) | Correlation of non value-added components of evaluation score from baseline year(s) with the next year's value-added scores for all teachers teachers used in step three |  | 0
STEP FIVE (Value-added r) | Correlation of teacher-level value-added score from baseline year(s) with next year's teacher-level value-added scores for all teachers used in step three.
STEP SIX | Number of current teachers subject to the same evaluation system used to calculate the correlation in step three
STEP SEVEN | Number of current teachers subject only to the non-value-added evaluation system (must be the same non value-added system that was used for the teachers for whom data are presented in step four | 600
 | % of persistent teacher value-added explained by the evaluation score | % of teachers eligible for identification | average value-added of eligible exceptional teachers (teacher SD units above average) | average value-added of non-exceptional teachers (teacher SD units above average)
Teachers with all components of evaluation score
Teachers with only non-valued-added components
Total number of eligible teachers
0.01
0.02
0.03
0.04
0.05
0.06
0.07
0.08
0.09
0.09999999999999999
0.11
0.12
0.13
0.14
0.15
0.16
0.17
0.18
0.19
0.2
0.21
0.2200000000000001
0.2300000000000001
0.2400000000000001
0.2500000000000001
0.2600000000000001
0.2700000000000001
0.2800000000000001
0.2900000000000001
0.3000000000000001
0.3100000000000001
0.3200000000000001
0.3300000000000001
0.3400000000000001
0.3500000000000001
0.3600000000000002
0.3700000000000002
0.3800000000000002
0.3900000000000002
0.4000000000000002
0.4100000000000002
0.4200000000000002
0.4300000000000002
0.4400000000000002
0.4500000000000002
0.4600000000000002
0.4700000000000003
0.4800000000000003
0.4900000000000003
0.5000000000000002
0.5100000000000002
0.5200000000000002
0.5300000000000002
0.5400000000000003
0.5500000000000003
0.5600000000000003
0.5700000000000003
0.5800000000000003
0.5900000000000003
0.6000000000000003
0.6100000000000003
0.6200000000000003
0.6300000000000003
0.6400000000000003
0.6500000000000004
0.6600000000000004
0.6700000000000004
0.6800000000000004
0.6900000000000004
0.7000000000000004
0.7100000000000004
0.7200000000000004
0.7300000000000004
0.7400000000000004
0.7500000000000004
0.7600000000000005
0.7700000000000005
0.7800000000000005
0.7900000000000005
0.8000000000000005
0.8100000000000005
0.8200000000000005
0.8300000000000005
0.8400000000000005
0.8500000000000005
0.8600000000000005
0.8700000000000006
0.8800000000000006
0.8900000000000006
0.9000000000000006
0.9100000000000006
0.9200000000000006
0.9300000000000006
0.9400000000000006
0.9500000000000006
0.9600000000000006
0.9700000000000006
0.9800000000000006
0.9900000000000007
0.999999
For the technical explaination of the calculator, see [NAME], S., Goldhaber, D., Loeb, S., Raudenbush, S., Staiger, D.O., and Whitehurst, G.J. (2011). Passing Muster: Evaluating Teacher Evaluation Systems, Washington, DC: The Brookings Institution.