3 Ways to Calculate the Average of Grades in Letters

Table of contents:

3 Ways to Calculate the Average of Grades in Letters
3 Ways to Calculate the Average of Grades in Letters
Anonim

Unfortunately, there is no universal way to average grades. In fact, the calculation methods vary by country and institution, as some offer extra points for honorary classes and some use weights in the measurements. However, this article will attempt to describe the basic topic, along with two of the most popular methods of calculating grade averaging, giving a general idea in your particular case.

Steps

Method 1 of 3: Simple Average Calculation

Calculate GPA Step 1

Step 1. Find a gradation scale, maybe four points

Some schools use a four-point scale, where A equals 4, B equals 3, C equals 2, D equals 1, and F equals 0. If you are unsure of the usage in your school, ask the administration. In some places, for example, an A+ is worth more than the average A, in which case every point in the notebook counts.

Calculate GPA Step 2

Step 2. Collect your most recent notes by asking the teacher or administration

You can also find out what grades you got back on your scheduled projects, assignments, exams, etc.

Calculate GPA Step 3

Step 3. Write the point value for each note

Write the correct value next to each note using the four-point scale. So if you got an A- in class, take it as a 3, 67 (or 3, 7, or 4 - it all depends on the scale used by the school, but this example will use two decimal points).

Calculate GPA Step 4

Step 4. For each class, add up all your grade values ​​based on the numbers above

Let's say you received an A- in biology, a B+ in English, and an A+ in economics. You would have 3, 67 + 3, 33 + 4, 33 = 11, 33.

Calculate GPA Step 5

Step 5. Take this final value and divide it by the number of stories taken (in this case, 3)

11, 33/3 results in a grade point average of 3.77.

Method 2 of 3: Calculation of Average Weights in Credit Hours

Calculate GPA Step 6

Step 1. Set the appropriate scale value for each note

If you have an A- in a given subject, take it as 3, 67 in this example. Adjust each note in letter to its scalar value and write it next to the note, subtracting 0.33 for each note (eg, B+ = 3, 33, B = 3, B- = 2.67).

Calculate GPA Step 7

Step 2. Multiply the scalar value by the number of credits to get the grade points

The results will be shown in the chart below.

Calculate GPA Step 8

Step 3. Add the number of credits together with the total credits

In this example, the total number of credits is 15, 5.

Calculate GPA Step 9

Step 4. Add the points together with the total points

In this example, the total number of points is 45, 4.

Calculate GPA Step 10

Step 5. Divide the total points by the total credits

In this example, this would be represented by 45, 4 / 15, 5 = 2.92, your average credit hour weights.

Method 3 of 3: Calculating Average Grades in Excel

Periods and grades

Step 1. In column A, enter the periods or names of stories taken

In column B, enter the grades you want to factor into your average (this step will help you differentiate which grade you got in each class, but it is optional and can be skipped if you wish).

Grid values

Step 2. In column C, determine the numerical values ​​of the notes entered

These numbers will depend on the scale used by the school - this example comes to one decimal place, but many schools simply round the value to the next whole number. Also, if some of the stories are worth more credits than others, you'll need to figure out how to incorporate that weight into that part.

Equals sign

Step 3. Type an equals sign in the first cell of column D

All equations in Excel start with an equal sign, so you should use one whenever you want to do a new calculation.

=(C1

Step 4. Make an open parenthesis and click on the first value of your C column

The equation should now say =(C1.

=(C1 C2

Step 5. Add a plus sign and click on the second value in your C column

The equation should now say =(C1+C2.

all numbers

Step 6. Continue adding numbers from column C

When selecting all, close the parenthesis as shown here.

Divide by 6

Step 7. Divide this amount by the number of stories done

Simply do this using a slash (/) followed by the appropriate number.

End gpa

Step 8. Press the Enter key

You should result in a new number in column D, which will be the final value of your grade point average.

Tips

  • Some schools offer extra credit for honorary or advanced courses. In this system, add 1 point for each note between A and C-. However, don't do this for D or F grades.
  • Universities sometimes offer special tests for those who cannot calculate a grade point average due to the time between admission to high school and university. Ask management for more details.
  • Some colleges weigh grades based on hourly credits.
  • Note that some schools will calculate up to 2 decimals, while others up to 1. With 2 decimal points, an A- represents 3, 67 and a B+, 3, 33; with 1 decimal point, an A- represents 3, 7, and a B+, 3, 3. If you don't know which system your school uses, try both and see what the difference will be.
  • Some universities take seasonal and cumulative versions into account.

Popular by topic