Explore BrainMass
Share

Explore BrainMass

    Use Excel to track grades and calculate GPA

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

    I want to create a worksheet to track my grades and GPA. What formulas and/ or functions might I use? Explain why I chose the specific formula and/or function.

    These are some of my classes,and grades.

    Accounting for Non-Accounting Major-------D+
    Marketing-------------C
    Academic Strategies for the Business Professional-----------B
    Survey of Mathematics-------------D
    Introduction to Management---------A-
    Human Resource Management---------------C+

    GPA TABLE

    A 93-100% 4.0
    A- 90-92% 3.7
    B+ 87-89% 3.3
    B 83-86% 3.0
    C+ 77-79% 2.3
    C 73-76% 2.0
    C- 70-72% 1.7
    D+ 67-69% 1.3
    D 60-66% 1.0

    © BrainMass Inc. brainmass.com October 10, 2019, 3:09 am ad1c9bdddf
    https://brainmass.com/business/business-math/use-excel-to-track-grades-and-calculate-gpa-408885

    Solution Preview

    Open excel. I'll get you started with the attached:

    There are numerous ways to do this, but I figure I'll start with the simplest concept. A grade is an average. In order to equate that to a letter, you can tell excel that "IF" it meets this condition it's this grade.

    Most important. Decide on the structure. Since you don't specify, I assume you're only looking at this term. My thought would be ...

    Solution Summary

    Excel spreadsheet to get you started tracking your grades in excel. You can view formulas and replicate them practicing and learning excel.

    $2.19