Josephine's Individual GPA Problem

Josephine has been dreaming. She pictures herself at the University of Maryland as a undergraduate student
Create an Excel Spreadsheet showing Josephine's Individual GPA as shown in the Excel File below. Suppose that Josephine earned a C in CPSP 218 and an A in PHIL 140, how would his GPA change?
| Tom's Individual GPA Calculation | |||||
| Course | Credit | Grade | Quality Points | GPA | |
| BMGT 201 | 3 | A | 12 | 56/17=3.29 | |
| PHIL 140 | 3 | B | 9 | ||
| HIST 113 | 3 | C | 6 | ||
| BMGT 220 | 3 | A | 9 | ||
| CPSP 218 | 1 | A | 4 | ||
| ECON 201 | 4 | A | 16 | ||
| Total | 17 | ||||
| A = 4 Quality Points | |||||
| B = 3 Quality Points | |||||
| C = 2 Quality Points | |||||
| D = 1 Quality Points | |||||