Spreadsheet: 59157d1259620489-pulling-test-score-based-on-date-not-highest-score-test-scores-report-11-30-09-fs
Sheet: Paste

Student Name | Student id | [studenttest] grade Level | Test Date | Test ID | [test] name | Test Section ID | Test Section Name | Alphascore | Score | Percent score
AA, Test | 1401 | 11 | 2008-08-29 00:00:00 | 9 |  | 215 | Critical Reading | 1 | 15 | 80
AA, Test | 1401 | 11 | 2008-08-29 00:00:00 | 9 |  | 216 | Mathematics | 2 | 15 | 90
AA, Test | 1401 | 11 | 2008-08-29 00:00:00 | 9 |  | 217 | Writing Skills | 3 | 10 | 0
AA, Test | 1401 | 11 | 2008-08-29 00:00:00 | 9 |  | 382 | Overall National Percentile | 4 | 0 | 80
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 10 | ACT Math -Total | 3a | 399 | 388
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 11 | ACT Reading - Total | 4a | 499 | 488
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 12 | ACT English - Total | 2a | 299 | 288
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 13 | ACT Science | 5a | 599 | 588
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 14 | ACT - COMPOSITE SCORE | 1a | 199 | 188
AA, Test | 1401 | 11 | 2009-02-17 00:00:00 | 7 |  | 28 | ACT Writing (optional) | 6a | 699 | 688
AA, Test | 1401 | 11 | 2008-05-26 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 630
AA, Test | 1401 | 11 | 2008-05-26 00:00:00 | 8 |  | 17 | SAT Math |  | 550
AA, Test | 1401 | 11 | 2008-05-26 00:00:00 | 8 |  | 18 | SAT Writing |  | 800
AA, Test | 1401 | 11 | 2008-05-26 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 9
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 9 |  | 215 | Critical Reading |  | 49 | 53
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 9 |  | 216 | Mathematics |  | 51 | 56
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 9 |  | 217 | Writing Skills |  | 43 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 9 |  | 382 | Overall National Percentile |  | 0 | 51
AA, Test | 1401 | 11 | 2008-06-15 00:00:00 | 10 |  | 263 | SAT II - English Literature |  | 550 | 38
AA, Test | 1401 | 11 | 2008-07-03 00:00:00 | 63 |  | 82 | Instructional Reading Level (Grade) |  | 6 | 0
AA, Test | 1401 | 11 | 2008-07-03 00:00:00 | 63 |  | 380 | Independent Reading Level (Grade) |  | 5 | 0
AA, Test | 1401 | 11 | 2008-07-03 00:00:00 | 63 |  | 381 | Frustrational Reading Level (Grade) |  | 7 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 181 | English - Language Arts |  | 7 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 181 | English - Language Arts |  | 0 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 182 | Mathematics |  | 0 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 182 | Mathematics |  | 7 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 183 | Reading - CAT/6 |  | 49 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 183 | Reading - CAT/6 |  | -5 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 184 | Language - CAT/6 |  | -8 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 184 | Language - CAT/6 |  | 87 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 185 | Math - CAT/6 |  | 57 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 185 | Math - CAT/6 |  | -5 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 379 | Spelling - CAT/6 |  | 93 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 379 | Spelling - CAT/6 |  | -8 | 0
AA, Test | 1401 | 11 | 2005-01-01 00:00:00 | 215 |  | 384 | Science |  | 0 | 0
AA, Test | 1401 | 11 | 2008-08-26 00:00:00 | 215 |  | 384 | Science |  | 0 | 0
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 207 | Reading |  | 5 | 42
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 208 | Language |  | 4 | 29
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 209 | Mathematics |  | 5 | 53
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 210 | CORE Total |  | 4 | 39
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 211 | Social Studies |  | 5 | 52
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 212 | Science |  | 5 | 44
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 213 | Sources of Information |  | 4 | 38
AA, Test | 1401 | 11 | 2007-09-06 00:00:00 | 221 |  | 214 | COMPOSITE |  | 5 | 42
AA, Test | 1401 | 11 | 2008-06-15 00:00:00 | 232 |  | 266 | SAT II - Mathematics Level 1 |  | 520 | 22
AA, Test | 1401 | 11 | 2008-06-15 00:00:00 | 242 |  | 276 | SAT II - Spanish |  | 450 | 9
AA, Test | 1401 | 11 | 1997-06-29 00:00:00 | 249 |  | 283 | AP - Art History |  | 4 | 0
AA, Test | 1401 | 11 | 2008-08-11 00:00:00 | 267 |  | 301 | AP - German Language |  | 3 | 0
AA, Test | 1401 | 11 | 1997-06-29 00:00:00 | 272 |  | 306 | AP - English Literature |  | 3 | 0
AA, Test | 1401 | 11 | 2008-10-26 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 800
AA, Test | 1401 | 11 | 2008-10-26 00:00:00 | 8 |  | 17 | SAT Math |  | 800
AA, Test | 1401 | 11 | 2008-10-26 00:00:00 | 8 |  | 18 | SAT Writing |  | 600
AA, Test | 1401 | 11 | 2008-10-26 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 10
aa, tester | 1519 | 11 | 2002-12-02 00:00:00 | 7 |  | 11 | ACT Reading - Total | 20 | 15 | 20
aa, tester | 1519 | 11 | 2002-12-02 00:00:00 | 7 |  | 10 | ACT Math -Total | 24 | 17 | 32
aa, tester | 1519 | 11 | 2002-12-02 00:00:00 | 7 |  | 13 | ACT Science | 24 | 17 | 22
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 14 | ACT - COMPOSITE SCORE | 1b | 122 | 133
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 12 | ACT English - Total | 2b | 222 | 233
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 10 | ACT Math -Total | 3b | 322 | 333
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 11 | ACT Reading - Total | 4b | 422 | 433
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 13 | ACT Science | 5b | 522 | 533
aa, tester | 1519 | 11 | 2009-02-17 00:00:00 | 7 |  | 28 | ACT Writing (optional) | 6b | 622 | 633
aa, tester | 1519 | 11 | 2002-12-02 00:00:00 | 7 |  | 28 | ACT Writing (optional) |  | 0 | 0
aa, tester | 1519 | 12 | 1997-06-29 00:00:00 | 249 |  | 283 | AP - Art History |  | 4 | 0
aa, tester | 1519 | 12 | 1997-06-29 00:00:00 | 272 |  | 306 | AP - English Literature |  | 3 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 214 | COMPOSITE |  | 5 | 42
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 210 | CORE Total |  | 4 | 39
aa, tester | 1519 | 11 | 2008-05-26 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 630 | 85
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 181 | English - Language Arts |  | 345 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 208 | Language |  | 4 | 29
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 184 | Language - CAT/6 |  | 667 | 0
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 185 | Math - CAT/6 |  | 615 | 0
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 182 | Mathematics |  | 316 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 209 | Mathematics |  | 5 | 53
aa, tester | 1519 | 11 | 2008-05-26 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 0 | 0
aa, tester | 1519 | 11 | 2008-05-26 00:00:00 | 8 |  | 17 | SAT Math |  | 550 | 61
aa, tester | 1519 | 11 | 2008-06-27 00:00:00 | 214 |  | 180 | Percent Score |  | 65 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 207 | Reading |  | 5 | 42
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 183 | Reading - CAT/6 |  | 630 | 0
aa, tester | 1519 | 11 | 2008-05-26 00:00:00 | 8 |  | 18 | SAT Writing |  | 520 | 59
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 9 |  | 215 | Critical Reading |  | 49 | 53
aa, tester | 1519 | 11 | 2008-06-01 00:00:00 | 10 |  | 263 | SAT II - English Literature |  | 550 | 38
aa, tester | 1519 | 11 | 2008-06-01 00:00:00 | 232 |  | 266 | SAT II - Mathematics Level 1 |  | 520 | 22
aa, tester | 1519 | 11 | 2008-06-01 00:00:00 | 242 |  | 276 | SAT II - Spanish |  | 450 | 9
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 9 |  | 216 | Mathematics |  | 51 | 56
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 9 |  | 382 | Overall National Percentile |  | 0 | 51
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 384 | Science |  | 0 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 212 | Science |  | 5 | 44
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 211 | Social Studies |  | 5 | 52
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 221 |  | 213 | Sources of Information |  | 4 | 38
aa, tester | 1519 | 3 | 2005-03-21 00:00:00 | 215 |  | 379 | Spelling - CAT/6 |  | 676 | 0
aa, tester | 1519 | 11 | 2008-08-26 00:00:00 | 9 |  | 217 | Writing Skills |  | 43 | 0
Aaaa, [NAME] | 1643 | 7 | 2002-12-01 00:00:00 | 7 |  | 11 | ACT Reading - Total | 20 | 15 | 20
Aaaa, [NAME] | 1643 | 7 | 2002-12-01 00:00:00 | 7 |  | 10 | ACT Math -Total | 24 | 17 | 32
Aaaa, [NAME] | 1643 | 7 | 2002-12-01 00:00:00 | 7 |  | 13 | ACT Science | 24 | 17 | 22
Aaaa, [NAME] | 1643 | 7 | 2002-12-01 00:00:00 | 7 |  | 28 | ACT Writing (optional) |  | 0 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-08-10 00:00:00 | 279 |  | 313 | AP - Chemistry |  | 0 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-05-26 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 630 | 85
Aaaa, [NAME] | 1643 | 7 | 2008-07-03 00:00:00 | 63 |  | 381 | Frustrational Reading Level (Grade) |  | 7 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-07-03 00:00:00 | 63 |  | 380 | Independent Reading Level (Grade) |  | 5 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-07-03 00:00:00 | 63 |  | 82 | Instructional Reading Level (Grade) |  | 6 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-05-26 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 0 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-05-26 00:00:00 | 8 |  | 17 | SAT Math |  | 550 | 61
Aaaa, [NAME] | 1643 | 6 | 2008-06-27 00:00:00 | 214 |  | 180 | Percent Score |  | 65 | 0
Aaaa, [NAME] | 1643 | 7 | 2008-05-26 00:00:00 | 8 |  | 18 | SAT Writing |  | 520 | 59
Aaaa, [NAME] | 1643 | 7 | 2006-08-04 00:00:00 | 9 |  | 215 | Critical Reading |  | 49 | 53
Aaaa, [NAME] | 1643 | 7 | 2008-06-01 00:00:00 | 10 |  | 263 | SAT II - English Literature |  | 550 | 38
Aaaa, [NAME] | 1643 | 7 | 2008-06-01 00:00:00 | 232 |  | 266 | SAT II - Mathematics Level 1 |  | 520 | 22
Aaaa, [NAME] | 1643 | 7 | 2008-06-01 00:00:00 | 242 |  | 276 | SAT II - Spanish |  | 450 | 9
Aaaa, [NAME] | 1643 | 7 | 2006-08-04 00:00:00 | 9 |  | 216 | Mathematics |  | 51 | 56
Aaaa, [NAME] | 1643 | 7 | 2006-08-04 00:00:00 | 9 |  | 382 | Overall National Percentile |  | 51 | 0
Aaaa, [NAME] | 1643 | 7 | 2006-08-04 00:00:00 | 9 |  | 217 | Writing Skills |  | 43 | 0
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 194 | Mathematics 1 & 2 w/ CR2 | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 193 | Quantitative Reasoning | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 190 | Reading Comprehension with CR/2 | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 188 | Verbal Reasoning | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 189 | Vocabulary | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 192 | Writing Concepts and Skills | 1 | 1 | 1
AAASFM, Test Student | 1420 | 8 | 2009-02-09 00:00:00 | 217 |  | 191 | Writing Mechanics | 1 | 1 | 1
AAASFM, Test Student | 1420 | 5 | 2006-07-19 00:00:00 | 7 |  | 14 | ACT - COMPOSITE SCORE |  | 33 | 0
AAASFM, Test Student | 1420 | 5 | 2006-07-19 00:00:00 | 7 |  | 12 | ACT English - Total |  | 33 | 0
AAASFM, Test Student | 1420 | 5 | 2006-07-19 00:00:00 | 7 |  | 10 | ACT Math -Total |  | 33 | 0
AAASFM, Test Student | 1420 | 5 | 2006-07-19 00:00:00 | 7 |  | 11 | ACT Reading - Total |  | 33 | 0
AAASFM, Test Student | 1420 | 5 | 2006-07-19 00:00:00 | 7 |  | 13 | ACT Science |  | 33 | 0
AAASFM, Test Student | 1420 | 6 | 2006-07-24 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 700 | 0
AAASFM, Test Student | 1420 | 6 | 2006-07-24 00:00:00 | 8 |  | 17 | SAT Math |  | 700 | 0
AAASFM, Test Student | 1420 | 6 | 2006-07-24 00:00:00 | 8 |  | 18 | SAT Writing |  | 700 | 0
aaStudent, Test High | 2143 | 10 | 2008-12-15 00:00:00 | 9 |  | 215 | Critical Reading |  | 750 | 95
aaStudent, Test High | 2143 | 10 | 2008-12-15 00:00:00 | 9 |  | 216 | Mathematics |  | 550 | 60
aaStudent, Test High | 2143 | 10 | 2008-12-15 00:00:00 | 9 |  | 382 | Overall National Percentile |  | 0 | 80
aaStudent, Test High | 2143 | 10 | 2008-12-15 00:00:00 | 9 |  | 217 | Writing Skills |  | 750 | 95
 | 476 | 10 |  |  |  |  |  |  |  | 94
 | 476 | 10 |  |  |  |  |  |  |  | 94
 | 476 | 10 |  |  |  |  |  |  |  | 80
 | 476 | 10 |  |  |  |  |  |  |  | 80
 | 476 | 10 |  |  |  |  |  |  |  | 91
 | 476 | 10 |  |  |  |  |  |  |  | 91
 | 476 | 10 |  |  |  |  |  |  |  | 99
 | 476 | 10 |  |  |  |  |  |  |  | 99
 |  |  |  | 8 = SATs