Explore BrainMass
Share

Use Excel to track grades and calculate GPA

This content was STOLEN 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 25, 2018, 5: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
See Also This Related BrainMass Solution

Mixed Methods

This Assignment builds on your knowledge base as you analyze the appropriateness of mixed-methods designs for research and evaluation purposes. Choose two of the three articles assigned for this module. As you read your chosen articles, critique and analyze each study to gain proficiency in understanding the particular mixed-method approach you are reading about. Analyze the appropriateness of each methodology for research and evaluation based on the main mixed-methods strategies discussed in the Creswell reading: sequential, concurrent, and transformational. For example, if you are reading the article that uses a sequential strategy, you might spend some time reviewing Creswell Chapter 10 (pages 208-213), as well as investigating online resources via the Walden University Library and Google Scholar. You may wish to consult your Instructor for guidance on appropriate resources for further investigation.

Write a 4- to 5-page paper comparing the core research components of the studies you chose, making sure to analyze the following for each article:
•The overall mixed-methods strategy or design
•The strategy or design selected for this study
•The problem statement
•The purpose of the study
•The research questions which addressed the quantitative data and those which addressed the qualitative data (if stated)
•The sample and sampling technique used for both the quantitative and qualitative methods
•The data collection and analytic techniques employed. Describe these in detail. ◦The quantitative data collection techniques used
◦The qualitative data collection techniques used
◦Whether the way the data were collected corresponded with the mixed-method strategy used (for example, whether the data were in fact collected sequentially or concurrently)
◦How quantitative data were analyze
◦How qualitative data were analyzed
◦How the quantitative and qualitative data analyses were used to explain the findings

•Ethical issues which might exist with this study and why

View Full Posting Details