HS | SC | IEP | N | Sums | SC | IEP | N | Avg |
Xavier | 26 | 26 | 0 | 0 | 1 | 3 | ||
CCA | 9 | 9 | 0 | 0 | 1 | 3 | ||
PPSD | 1 | 22 | 23 | 0 | 0.04 | 0.96 | 2.96 | |
PSDA | 1 | 21 | 22 | 0 | 0.05 | 0.95 | 2.95 | |
PATS | 1 | 3 | 20 | 24 | 0.04 | 0.13 | 0.83 | 2.79 |
PICS | 19 | 40 | 266 | 325 | 0.06 | 0.12 | 0.82 | 2.76 |
SCA | 3 | 6 | 33 | 42 | 0.07 | 0.14 | 0.79 | 2.71 |
OIHS | 3 | 4 | 21 | 28 | 0.11 | 0.14 | 0.75 | 2.64 |
KHS | 10 | 27 | 89 | 126 | 0.08 | 0.21 | 0.71 | 2.63 |
YHS | 16 | 20 | 67 | 103 | 0.16 | 0.19 | 0.65 | 2.5 |
CSDA | 3 | 1 | 9 | 13 | 0.23 | 0.08 | 0.69 | 2.46 |
KSC | 2 | 1 | 6 | 9 | 0.22 | 0.11 | 0.67 | 2.44 |
Mizpah | 3 | 8 | 11 | 22 | 0.14 | 0.36 | 0.5 | 2.36 |
Ohwa | 2 | 3 | 5 | 10 | 0.2 | 0.3 | 0.5 | 2.3 |
NICHS | 7 | 8 | 14 | 29 | 0.24 | 0.28 | 0.48 | 2.24 |
YSDA | 2 | 3 | 5 | 0.4 | 0 | 0.6 | 2.2 | |
Berea | 10 | 5 | 9 | 24 | 0.42 | 0.21 | 0.38 | 1.96 |
PLHA | 19 | 12 | 7 | 38 | 0.5 | 0.32 | 0.18 | 1.68 |
CHS | 178 | 50 | 40 | 268 | 0.66 | 0.19 | 0.15 | 1.49 |
SNHS | 66 | 16 | 7 | 89 | 0.74 | 0.18 | 0.08 | 1.34 |
Weno | 87 | 18 | 8 | 113 | 0.77 | 0.16 | 0.07 | 1.3 |
NCHS | 9 | 1 | 1 | 11 | 0.82 | 0.09 | 0.09 | 1.27 |
Sums: | 440 | 225 | 694 | 1359 | 0.32 | 0.17 | 0.51 | 2.19 |
=IF(OR(AND(OR(AND(
Structure>=22;Reading>=27);Sum Of Structure + Reading>=49);Composition (or projected composition)>1);AND(Stucture>=16;Reading>=20;Composition (or projected Composition)>5));3;IF(AND(Structure>=16;Readng>=20;Composition>0);2;1))Where:
Structure = 22 corresponds to a TOEFL structure score of
469.38
Structure = 16 corresponds to a TOEFL structure score of
399.93
Reading= 27 corresponds to a TOEFL reading score of
466.27
Reading= 20 corresponds to a TOEFL reading score of
402.22
Sum of structure + reading = 49 is equivalent to a 470 average of
the reading and structure score using the function:
=10*((1.158*Structure+21.47)+(0.915*Reading+21.92))/2
=ROUND(0.1258*
Average of structure and reading-0.1929;0)because the average had the highest correlation to the composition score of r = 0.7434.
HS | 1 | 2 | 3 | 4 | 5 | 6 | Sum | 1 | 2 | 3 | 4 | 5 | 6 | Avg |
Xavier | 5 | 21 | 26 | 0% | 0% | 0% | 0% | 19% | 81% | 5.81 | ||||
CCA | 3 | 3 | 3 | 9 | 0% | 0% | 33% | 33% | 0% | 33% | 4.33 | |||
PSDA | 7 | 5 | 9 | 1 | 22 | 0% | 0% | 32% | 23% | 41% | 5% | 4.18 | ||
SCA | 8 | 22 | 11 | 1 | 42 | 0% | 0% | 19% | 52% | 26% | 2% | 4.12 | ||
KHS | 1 | 8 | 43 | 43 | 25 | 6 | 126 | 1% | 6% | 34% | 34% | 20% | 5% | 3.80 |
Pni Police | 8 | 12 | 3 | 23 | 0% | 0% | 35% | 52% | 13% | 0% | 3.78 | |||
PICS | 1 | 18 | 113 | 144 | 40 | 9 | 325 | 0% | 6% | 35% | 44% | 12% | 3% | 3.71 |
CSDA | 2 | 4 | 3 | 4 | 13 | 0% | 15% | 31% | 23% | 31% | 0% | 3.69 | ||
YHS | 4 | 14 | 36 | 18 | 25 | 6 | 103 | 4% | 14% | 35% | 17% | 24% | 6% | 3.62 |
OIHS | 3 | 9 | 13 | 3 | 28 | 0% | 11% | 32% | 46% | 11% | 0% | 3.57 | ||
PATS | 1 | 3 | 8 | 7 | 4 | 1 | 24 | 4% | 13% | 33% | 29% | 17% | 4% | 3.54 |
YSDA | 3 | 2 | 5 | 0% | 0% | 60% | 40% | 0% | 0% | 3.40 | ||||
KSC | 3 | 4 | 2 | 9 | 0% | 33% | 44% | 22% | 0% | 0% | 2.89 | |||
Berea | 2 | 5 | 14 | 3 | 24 | 8% | 21% | 58% | 13% | 0% | 0% | 2.75 | ||
Ohwa | 1 | 4 | 3 | 1 | 1 | 10 | 10% | 40% | 30% | 10% | 10% | 0% | 2.70 | |
NICHS | 3 | 12 | 10 | 4 | 29 | 10% | 41% | 34% | 14% | 0% | 0% | 2.52 | ||
Mizpah | 3 | 11 | 7 | 1 | 22 | 14% | 50% | 32% | 0% | 5% | 0% | 2.32 | ||
SNHS | 33 | 24 | 25 | 7 | 89 | 37% | 27% | 28% | 8% | 0% | 0% | 2.07 | ||
PLHA | 8 | 22 | 6 | 2 | 38 | 21% | 58% | 16% | 5% | 0% | 0% | 2.05 | ||
CHS | 125 | 85 | 34 | 17 | 4 | 1 | 268 | 47% | 32% | 13% | 6% | 1% | 0% | 1.83 |
Weno | 56 | 30 | 17 | 10 | 113 | 50% | 27% | 15% | 9% | 0% | 0% | 1.83 | ||
NCHS | 5 | 5 | 1 | 11 | 45% | 45% | 0% | 9% | 0% | 0% | 1.73 | |||
Sum: | 243 | 249 | 362 | 319 | 135 | 49 | 1359 | 18% | 18% | 27% | 23% | 10% | 4% | 3.00 |
High School | 90 | 95 | 98 | 100 | 101 | p10x | Avg |
Xavier | 23% | 8% | 35% | 27% | 8% | 35% | 96.69 |
CCA | 56% | 11% | 0% | 33% | 0% | 33% | 93.89 |
PSDA | 50% | 0% | 23% | 27% | 0% | 27% | 94.55 |
Ohwa | 80% | 0% | 0% | 20% | 0% | 20% | 92 |
PATS | 42% | 8% | 33% | 17% | 0% | 17% | 94.75 |
PICS | 53% | 11% | 21% | 14% | 1% | 15.4% | 93.74 |
KHS | 66% | 11% | 8% | 13% | 2% | 15.1% | 92.71 |
PPSD | 83% | 9% | 0% | 9% | 0% | 9% | 91.3 |
SCA | 79% | 7% | 7% | 7% | 0% | 7% | 91.64 |
YHS | 81% | 5% | 9% | 4% | 2% | 6% | 91.54 |
CHS | 97% | 2% | 0% | 0% | 0% | 1% | 90.17 |
Weno | 96% | 4% | 1% | 0% | 0% | 0% | 90.25 |
PLHA | 95% | 5% | 0% | 0% | 0% | 0% | 90.26 |
Mizpah | 95% | 5% | 0% | 0% | 0% | 0% | 90.23 |
KSC | 100% | 0% | 0% | 0% | 0% | 0% | 90 |
NCHS | 100% | 0% | 0% | 0% | 0% | 0% | 90 |
CSDA | 92% | 0% | 8% | 0% | 0% | 0% | 90.62 |
OIHS | 86% | 11% | 4% | 0% | 0% | 0% | 90.82 |
YSDA | 80% | 20% | 0% | 0% | 0% | 0% | 91 |
NICHS | 97% | 0% | 3% | 0% | 0% | 0% | 90.28 |
SNHS | 94% | 4% | 1% | 0% | 0% | 0% | 90.31 |
Berea | 96% | 0% | 4% | 0% | 0% | 0% | 90.33 |
Overall | 77% | 6% | 9% | 7% | 1% | 8% | 91.79 |