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 |
MedScSc (mss) | 241 | Median Scale Score |
%AAMed (paa50) | 38.4 | % at or above Median (which is equivalent to %AAAvg unfortunately, but different than %ileAvgSS which is more clearly named) |
%AA60th (paa60) | 22.4 | % at or above 60th percentile |
%AA68th (paa68) | 17.1 | % at or above 68th percentile |
cntaa50 (cntaa50) | 108 | count at or above median |
cntaa60 (cntaa60) | 88 | count at or above 60th percentile |
cntaa68 (cntaa68) | 74 | count at or above 68th percentile |