Semester Grade Predictor : Sheet1

1 | How well do you need to score on your final exam? | |||||
---|---|---|---|---|---|---|

2 | ||||||

3 | Note: Make a copy (File > Make a copy) if this spreadsheet was shared with you. | |||||

4 | ||||||

5 | Enter your first nine weeks grade: | Enter your second nine weeks grade: | In order to earn this semester grade... | ...you will need to earn this grade on the final exam. | ||

6 | 79 | 80 | A | 147 | Impossible. | |

7 | A- | 132 | Impossible. | |||

8 | B+ | 122 | Impossible. | |||

9 | B | 97 | This is mathematically possible. | |||

10 | B- | 82 | This is mathematically possible. | |||

11 | C+ | 72 | This is mathematically possible. | |||

12 | C | 47 | This is mathematically possible. | |||

13 | C- | 32 | This is mathematically possible. | |||

14 | D+ | 22 | This is mathematically possible. | |||

15 | D | -3 | Impossible. | |||

16 | D- | -18 | Impossible. | |||

17 |