Excel Exercise

Excel Exercise

Student GPA Calculator

Open a new Excel document. Save the file as [your initials] GPACalculation.

1. Add a table with the following columns – ID, Course Name, No. of Credits, Letter Grade, Grade Points, Quality Points, Total Quality Points.

2. Create title for worksheet. Center and merge it.

3. Enter at least five courses in this table with grade earned and number of credits.

4. Use the following grade & quality points references: A = 4 points, B = 3 points, C = 2 points, D = 1 point, F = 0 point.

5. Multiply the Quality Points by the Credits to get the Total Quality Points for each course. You need to use AutoSum to find this number.

6. Next two rows in this table should display the Total Number of Credits and Total Quality Points. You need to use AutoSum to find these two numbers.

7. Compute the GPA by dividing the Total Quality Points by the Total Number of Credits and display it as Cumulative GPA in the next row. You need to use AutoSum to find this number. This completes the table.

8. Name the worksheet GPA.