Explore BrainMass

Explore BrainMass

    Excel GPA

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com March 5, 2021, 1:54 am ad1c9bdddf


    Solution Summary

    The Excel file contains all of the formulas, computations and graphs required.