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.
Method 1 of 3: Simple Average Calculation
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.
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.
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).
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.
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
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).
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.
Step 3. Add the number of credits together with the total credits
In this example, the total number of credits is 15, 5.
Step 4. Add the points together with the total points
In this example, the total number of points is 45, 4.
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
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).
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.
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.
Step 4. Make an open parenthesis and click on the first value of your C column
The equation should now say =(C1.
Step 5. Add a plus sign and click on the second value in your C column
The equation should now say =(C1+C2.
Step 6. Continue adding numbers from column C
When selecting all, close the parenthesis as shown here.
Step 7. Divide this amount by the number of stories done
Simply do this using a slash (/) followed by the appropriate number.
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.
- 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.