Purchase Solution

Use Excel to track grades and calculate GPA

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Motivation

This tests some key elements of major motivation theories.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.