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

 | Student Name: | AA, Test
EXAM NAME | TestScore ID | Score | Percentile | Letter Score
5th grade Math Diagnostic MWEP | 438
6th grade Math Diagnostic MWEP | 180
7th grade Math Diagnostic MWEP | 441
AP Art History | 283
AP Biology | 316
AP Calculus AB | 315
AP Calculus BC | 314
AP Chemistry | 313
AP Chinese Language & Culture | 312
AP Comp Government & Politics | 300
AP Computer Science | 311
AP Comuter Science AB | 310
AP English Language | 307
AP English Literature | 306
AP Environmental Science | 305
AP European History | 304
AP French Language | 303
AP French Literature | 302
AP German Language | 301
AP Human Geography | 298
AP Italian Language & Culture | 297
AP Japanese Language & Culture | 296
AP Latin Literature | 295
AP Latin, [NAME] | 294
AP Macroeconomics | 309
AP Microeconomics | 308
AP Music Theory | 293
AP Physics B | 292
AP Physics C | 291
AP Psychology | 290
AP Spanish Language | 289
AP Spanish Literature | 288
AP Statistics | 287
AP Studio Art | 286
AP Us Government & Politics | 299
AP US Hitory | 285
AP World History | 284
Algebra II Readiness MWEP | 67
Algebra Readiness MWEP | 63
American College Test (ACT)
ACT Composite Score | 14
ACT English | 12
ACT Math | 10
ACT Reading | 11
ACT Science | 13
ACT Writing (Optional) | 28
California High School Exit Exam (CAHSEE)
CAHSEE-Language Arts | 186
CAHSEE-Math | 187
California High School Proficiency Examination (CHSPE) |  |  |  |  | ???
California Placement Test 4 (CPT4 – by ERB)
CTP4-Verbal Reasoning | 188
CTP4-Vocabulary | 189
CTP4-Reading Comprehension | 190
CTP4-Writing Mechanics | 191
CTP4-Writing Concepts and Skills | 192
CTP4-Quantitative Reasoning | 193
CTP4-Math 1 & 2 | 194
California Standardized Testing and Reporting (STAR)
STAR-English Lang. Arts | 181
STAR-Math | 182
STAR Science | 384
STAR-Reading CAT/6 | 183
STAR-Language CAT/6 | 184
STAR-Math CAT/6 | 185
STAR-Spelling CAT/6 | 379
Calculus Readiness MWEP | 64
Curriculum Embedded Reading Assessment (CERA)
Degrees of Reading Power (DRP)
DRP-Raw Score | 385
DRP-Percentile | 86
DRP-Independent Reading Level | 83
DRP-Instructional Reading Level | 84
DRP-Frustration Reading Level | 85
General Education Development (GED)
GED Average | 318
GED Language Arts | 195
GED Language Arts, Writing | 196
GED Math | 197
GED Science | 198
GED Social Studies | 199
GED Standard Score Total | 317
GED Status | 256
Geometry Readiness MWEP | 65
Graduate Management Admissions Test (GMAT)
GMAT Analytical Writing | 561
GMAT Quantitative | 558
GMAT Total | 560
GMAT Verbal | 559
Graduate [NAME] (GRE)
GRE Analytical Writing | 557
GRE Quantitative | 556
GRE Verbal | 546
GRE Biochem, Cell & Molecular Biology | 547
GRE Biology | 548
GRE Chemistry | 549
GRE Computer Science | 550
GRE Lit in English | 551
GRE Math | 552
GRE Physics | 553
GRE Psychology | 554
High School Placement Test (HSPT)
Basic Skills-Language | 203
Basic Skills-Math | 202
Basic Skills-Reading | 201
Basic Skills-Total | 200
Cognititive Skills-Verbal | 205
Cognititive Skills-Quantitative | 206
Cognititive Skills Total | 204
Battery Composite | 319
Independent School Entrance Exam (ISEE)
ISEE-Verbal Reasoning | 434
ISEE-Reading Comprehension | 435
ISEE-Quantitative Reasoning | 436
ISEE-Math Achievement | 437
Iowa Test of Basic Skills (ITBS)
ITBS Reading | 207
ITBS Language | 208
ITBS Math | 209
ITBS Core Total | 210
ITBS Social Studies | 211
ITBS Science | 212
ITBS Sources of Information | 213
ITBS Composite | 214
Law School Admissions Test (LSAT) | 555
Math Analysis Readiness MWEP | 66
Medical College Admissions Test (MCAT)
MCAT Biological Sciences | 542
MCAT Physical Science | 541
MCAT Total Score | 545
MCAT Verbal Reasoning | 543
MCAT Writing Sample | 544
Pre-Algebra Readiness MWEP | 20
Pre-SAT (PSAT)
PSAT-Critical Reading | 215
PSAT Writing Skills | 217
PSAT-Math | 216 |  |  |  | Date of test with best overall national percentile ------v
Overall National Percentile | 382
San Diego Quick Reading Assessment
[NAME] | 380 |  |  |  | The overall national will automatically put in the best score, so that formula hasn't changed.
[NAME] Reading Level | 82 |  |  |  | I added a formula to pull the date of the best test and changed the formula for all the sections so that it would search based on overall best score & the date of it.
[NAME] | 381
Scholastic Assessment Test (SAT I) – Reasoning
SAT I-Critical Reading | 16
SAT I-Math | 17 |  |  |  | << I don't want highest section score unless it was part of the highest overall test. In this case I would want the scores from 10/26/2008, even though the student had a higher Writing & Essay score on the other date.
SAT I-Writing | 18
SAT I-Essay | 383
SAT II - Biology E/M | 268
SAT II - Chemistry | 269
SAT II - Chinese with Listening | 271
SAT II - English Literature | 263
SAT II - French | 272
SAT II - French with Listening | 273
SAT II - German | 274
SAT II - German with Listening | 275
SAT II - Italian | 279
SAT II - Japanese with Listening | 281
SAT II - Korean with Listening | 282
SAT II - Latin | 280
SAT II - Math Level 1 | 266
SAT II - Math Level 2 | 267
SAT II - Modern Hebrew | 278
SAT II - Physics | 270
SAT II - Spanish | 276
SAT II - Spanish with Listening | 277
SAT II - US History | 264
SAT II - World History | 265
Secondary School Admissions Test (SSAT)
SSAT Quantitative | 221
SSAT Reading | 222
SSAT Total Score | 219
SSAT Verbal | 220