Excel Help !
Sheet1
| A | 90 | Essay (4) | 20% | |||||||||
| B | 80 | Proj (3) | 30% | |||||||||
| C | 70 | Quiz (5) | 50% | Lowest quiz grade dropped | ||||||||
| D | 60 | |||||||||||
| Name | Essay 1 | Essay 2 | Essay 3 | Essay 4 | Proj 1 | Proj 2 | Proj 3 | Quiz 1 | Quiz 2 | Quiz 3 | Quiz 4 | Quiz 5 |
| Jones, Bill | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Smith, Pete | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
| Hart, Ellie | 88 | 91 | 87 | 78 | 88 | 99 | 89 | 90 | 85 | 75 | 85 | 90 |
| Toms, Bob | 65 | 71 | 68 | 66 | 55 | 45 | 67 | 70 | 72 | 68 | 82 | 56 |
| Jones, Len | 82 | 86 | 88 | 90 | 81 | 84 | 79 | 84 | 82 | 87 | 80 | 60 |