Spreadsheet: 213935d1360690852-vlookup-and-sumif-help-btec-database-no-names
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Chem 2A |  | Chem 2B | Chem 2C | Chem 2D | Phys 3A |  |  | Phys 3B |  | Phys 3C |  | Biol 4A |  |  | Biol 4B |  | Biol 4C
Name | Sex | SEN | FSM | Year 10 class | End of Year Test Score | End of  Year  Percentage | End of KS3 Exam | End of KS3 Teacher Assement | FFTD | 33% HIGHER | Task 1 - Properties of Reactive Elements (DISTINCTION) | Task 2 - Why Don't Things Fall Apart (DISTINCTION) | Task 1 - What's Your Special Power? (DISTINCTION) | Task 1 -  How Fast is Your Reaction? (DISTINCTION) | Task 1 - How does our Earth and its environment get damaged? (DISTINCTION) | Task 1 - What's a Half-Life? (DISTINCTION) | Task 2 - The Good and Bad of Using Isotopes (DISTINCTION) | Task 3 - Nuclear Energy (DISTINCTION) | Task 1 - How do we make Electricity (MERIT) | Task 2 - Pylons Everywhere! (DISTINCTION) | Task 1 - What's Out There? (MERIT) | Task 2 - The Changing Universe (DISTINCTION) | Task 1 - Who's Who? (PASS) | Task 2 - Who's Eating Who (MERIT) | Task 3 - Genes and the Environment (DISTINCTION) | Task 1 - How We Affect the Ecosystems (DISTINCTION) | Task 2 - Recycling - Is This the Answer and Is it Working? (DISTINCTION) | Task 1 - Why are you [NAME]? (PASS) | Task 2 - Coughs and Colds, Mumps and [NAME] (DISTINCTION) | Points Total
 | M |  |  | BTEC
 | F | A | N | BTEC | 45 | 48.38709677419355 | 5 | 5 | C | B | Di | Di |  |  |  | Di | Di | Di |  |  |  |  | P | M | M
 | M | A | N | BTEC | 41 | 44.08602150537634 | 4.7 | 5 | D | C | M | P |  |  |  | P | M | P |  |  |  |  | P | M | M
 | F | A | N | BTEC | 31 | 33.33333333333333 | 4 | 4 | C |  | M | M |  |  |  |  |  |  |  |  |  |  | P | P | P
 | F | N | N | BTEC | 51 | 54.83870967741935 | 5.3 | 5 | C |  | M | M |  |  |  |  |  |  |  |  |  |  | P | M
 | F | P | N | BTEC | 24 | 25.80645161290322 | 3 | 4 | E | D | P | P |  |  |  | Di | M | P
 | M | P | Y | BTEC | 47 | 50.53763440860215 | 5 | 5 | C |  | M | P |  |  |  | Di | M | M |  |  |  |  | P | M | P
 | F | N | N | BTEC | 42 | 45.16129032258064 | 4.7 | 5 | C
 | M | N | N | BTEC | 46 | 49.46236559139785 | 5 | 5 | C
 | F | N | N | BTEC | 47 | 50.53763440860215 | 5 | 5 | D | C
 | M | N | N | BTEC | 44 | 47.31182795698925 | 4.7 | 4 | D | C | Di | Di
 | F | N | N | BTEC | 48 | 51.61290322580645 | 5 | 5 | C |  | M | M |  |  |  | Di | M |  |  |  |  |  | P | M
 | M | N | N | BTEC | 52 | 55.91397849462365 | 5.3 | 5 | C |  | Di | Di |  |  |  | Di | M | P |  |  |  |  | P | M
 | F | N | N | BTEC | 32 | 34.40860215053764 | 4 | 4 | D | C |  |  |  |  |  | Di | M |  |  |  |  |  |  | M
 | M | P | N | BTEC | 39 | 41.93548387096774 | 4.3 | 4 | D |  | M | M |  |  |  | P | P | P |  |  |  |  | P | P
 | F | N | N | BTEC | 38 | 40.86021505376344 | 4.3 | 4 | D |  | P | P |  |  |  |  |  |  |  |  |  |  | P | P
 | F | N | Y | BTEC | 53 | 56.98924731182796 | 5.3 | 5 | C | B | Di | Di |  |  |  | Di | Di | P |  |  |  |  | P | M | P
 | F | N | N | BTEC | 39 | 41.93548387096774 | 4.3 | 5 | C |  | M | P |  |  |  |  |  |  |  |  |  |  | P | P | P
 | F | P | N | BTEC | 44 | 47.31182795698925 | 4.7 | 5 | C
 | F | N | N | BTEC | 45 | 48.38709677419355 | 5 | 5 | C |  | Di | Di |  |  |  | Di | Di | P
 | M | N | Y | BTEC | 44 | 47.31182795698925 | 4.7 | 5 | C |  | Di | Di |  |  |  | Di | M |  |  |  |  |  | P | M | P
 | F | N | N | BTEC | 50 | 53.76344086021505 | 5 | 5 | C | B | Di | Di |  |  |  | Di | Di | P |  |  |  |  | P | M
 | F | N | N | BTEC | 50 | 53.76344086021505 | 5 | 5 | B |  | Di | Di |  |  |  | Di | Di |  |  |  |  |  | P | M
 | F | N | Y | BTEC | 32 | 34.40860215053764 | 4 | 4 | D