Name of Column (database field) | Sample Data | Description |
Query (q) | CHAVEZ | This is the name of the school or the query that selected the data |
group (label) | ISAT Mathematics | This is the name of the test or the composite group of tests |
subject (subject) | Math | This is the subject area of the test |
test (test) | ISAT | This identifies which test was given |
cohort (cohort) | 2014 | This is the year that this group of students will likely graduate from HS |
grade (gradelevel) | 8 | This is the current grade level of these students |
maxScore (maxscore) | 311 | This is the highest scale score achieved by these students |
minScore (minscore) | 200 | This is the lowest scale score achieved by these students |
avgScore (avgscore) | 267.275 | This is the average scale score achieved by these students |
year (year) | 2010 | This is the year the test was given |
#Tst (totalcount) | 80 | This is the total number (N) of students in this group |
%ME (pme) | 87.5 | This is the percentage meeting or exceeding state standards |
%AAAvg (paaavg) | 45 | This is the percentage at or above state average |
%ileAvgSS (percentileequivalent) | 44.4 | This is the percentile equivalent (based on all state scores) of the average scale score of this group |
Z-Score (zscore) | -0.141 | This is the number of standard deviations that the average scale score (avgscore) is from the normal, state-wide average (q23Score) |
stanineAvgSS (stanineequivalent) | 4.72 | This is the stanine equivalent (based on all state scores) of the average scale score of this group |
%BQ (q1pct) | 26.3 | This is the percentage of this group in the first quartile of all state test scores |
%2Q (q2pct) | 28.7 | This is the percentage in the second quartile |
%3Q (q3pct) | 28.5 | This is the percentage in the third quartile |
%TQ (q4pct) | 16.5 | This is the percentage in the fourth quartile |
%AW (awpct) | 2.5 | This is the percentage of this group on Academic Warning |
%Blw (blpct) | 10 | This is the percentage of this group Below Standards but not on Academic Warning |
%Mt (mtpct) | 68.8 | This is the percentage of this group who Meet the Standards but do not Exceed |
%Ex (expct) | 18.8 | This is the percentage of this group who Exceed the Standards |
%stn1 (s1pct) | 8.8 | This is the percentage of this group who are in the first stanine of all state test scores (Bottom 4%) |
%stn2 (s2pct) | 1.2 | This is the percentage of this group who are in the second stanine (Next 7% of state) |
%stn3 (s3pct) | 11.2 | This is the percentage of this group who are in the third stanine (Next 12% of state) |
%stn4 (s4pct) | 18.3 | This is the percentage of this group who are in the fourth stanine (Next 17% of state) |
%stn5 (s5pct) | 31.8 | This is the percentage of this group who are in the fifth stanine (Middle 20% of state) |
%stn6 (s6pct) | 13.3 | This is the percentage of this group who are in the sixth stanine (Next 17% of state) |
%stn7 (s7pct) | 14.1 | This is the percentage of this group who are in the third stanine (Next 12% of state) |
%stn8 (s8pct) | 1.2 | This is the percentage of this group who are in the eigth stanine (Next 7% of state) |
%stn9 (s9pct) | 0 | This is the percentage of this group who are in the nine stanine (Top 4% of state) |
#BQ (q1cnt) | 21 | This is the number of this group in the first quartile of all state test scores. |
#2Q (q2cnt) | 22.9 | This is the number in the second quartile |
#3Q (q3cnt) | 22.8 | This is the number in the third quartile |
#TQ (q4cnt) | 13.2 | This is the number in the fourth quartile |
#AW (totalwarning) | 2 | This is the number of this group on Academic Warning |
#Blw (totalbelow) | 8 | This is the number of this group Below Standards but not on Academic Warning |
#Mt (totalmeet) | 55 | This is the number of this group who Meet the Standards but do not Exceed |
#Ex (totalexceed) | 15 | This is the number of this group who Exceed the Standards |
s1cnt (s1cnt) | 7 | This is the number of this group who are in the first stanine of all state test scores (Bottom 4%) |
s2cnt (s2cnt) | 1 | This is the number of this group who are in the second stanine (Next 7% of state) |
s3cnt (s3cnt) | 9 | This is the number of this group who are in the third stanine (Next 12% of state) |
s4cnt (s4cnt) | 14.7 | This is the number of this group who are in the fourth stanine (Next 17% of state) |
s5cnt (s5cnt) | 25.4 | This is the number of this group who are in the fifth stanine (Middle 20% of state) |
s6cnt (s6cnt) | 10.7 | This is the number of this group who are in the sixth stanine (Next 17% of state) |
s7cnt (s7cnt) | 11.2 | This is the number of this group who are in the third stanine (Next 12% of state) |
s8cnt (s8cnt) | 1 | This is the number of this group who are in the eigth stanine (Next 7% of state) |
s9cnt (s9cnt) | 0 | This is the number of this group who are in the nine stanine (Top 4% of state) |
q12Score (q12) | 254 | This is the cutoff score at the 25th percentile score |
q23Score (q23) | 271 | This is the cutoff score at the 50th percentile score |
q34Score (q34) | 291 | This is the cutoff score at the 75th percentile score |
belowScore (belowscore) | 221 | This is the cutoff score between Academic Warning and Below Standards |
meetScore (meetscore) | 246 | This is the cutoff score between Below Standards and Meets Standards |
exceedScore (exceedscore) | 288 | This is the cutoff score between Meets Standards and Exceeds Standards |
s12Score (s12) | 231 | This is the cutoff score between the first and second stanine |
s23Score (s23) | 240 | This is the cutoff score between the second and first stanine |
s34Score (s34) | 251 | This is the cutoff score between the third and fourth stanine |
s45Score (s45) | 264 | This is the cutoff score between the fourth and fifth stanine |
s56Score (s56) | 279 | This is the cutoff score between the fifth and sixth stanine |
s67Score (s67) | 293 | This is the cutoff score between the sixth and seventh stanine |
s78Score (s78) | 308 | This is the cutoff score between the seventh and eigth stanine |
s89Score (s89) | 329 | This is the cutoff score between the eigth and nineth stanine |
q1deduct (q1deduct) | 1.97336647727273 | This is the number of tests at the first quartile cutoff score that are proportionally over the the 25% mark |
q2deduct (q2deduct) | 1.0344387755102 | This is the number of tests at the second quartile cutoff score that are proportionally over the the 50% mark |
q3deduct (q3deduct) | 0.224856779121579 | This is the number of tests at the third quartile cutoff score that are proportionally over the the 75% mark |
s1deduct (s1deduct) | 0 | This is the number of tests at the first stanine cutoff score that are proportionally over the the 4% mark |
s2deduct (s2deduct) | 0 | This is the number of tests at the second stanine cutoff score that are proportionally over the the 11% mark |
s3deduct (s3deduct) | 0 | This is the number of tests at the third stanine cutoff score that are proportionally over the the 23% mark |
s4deduct (s4deduct) | 0.329117259552041 | This is the number of tests at the fourth stanine cutoff score that are proportionally over the the 40% mark |
s5deduct (s5deduct) | 0.921271714192064 | This is the number of tests at the fifth stanine cutoff score that are proportionally over the the 60% mark |
s6deduct (s6deduct) | 0.241622149837133 | This is the number of tests at the sixth stanine cutoff score that are proportionally over the the 77% mark |
s7deduct (s7deduct) | 0 | This is the number of tests at the first stanine cutoff score that are proportionally over the the 4% mark |
s8deduct (s8deduct) | 0 | This is the number of tests at the seventh stanine cutoff score that are proportionally over the the 89% mark |
The reason there are decimals is to account for the fact that there are students just above and just below the given percentile may have the same scale score. So there is no clean break in determining the quartile or stanine boundary. To accomodate this in sub-populations, we look at the state data and take all students on the quartile or stanine cutoff score and assign a proportion to the lower quartile or stanine and the remainder (sometimes a decimal) to the next quartile or stanine. So in the sub-population we use this same proportion to distribute students who land on the quartile or stanine cutoff score, some student are counted towards the lower quartile/stanine and others to the next group. And often the result of the proportioning is a fraction of a student.
Composite scores agreggate scores from all the grades available. Each grade has a different cutoff score so we don't use the cutoff scores to calculate this. See below for a note on how they are calulated.
Compostites are calculated based on the counts in each quartile, stanine, and academic standard group. The counts are totaled among all the grade levels and tests in the composite group, then the quartile, stanine, and academic standard percentiles are calculated based on the totals. This is essentially a weighted average of all the percentiles in the target group.