Using the student grade data given to compute the Grade Point Average (GPA):
a.) Enter a formula in cell E2 which multiplies the Credits times the 4 Point Scale, this product gives Quality Points. Fill the formula down.
b.) Sum the Credits and the Quality Points.
c.) Compute the GPA by dividing the quality points by the credits. The GPA is a "weighted average" since each grade is weighted by how many credits the class is worth.
d.) Create a column chart of Quality Points.
The Excel file contains all of the formulas, computations and graphs required.