The correct way to calculate the final average of a subject depends on several factors. For this, it is necessary to know the weight that assignments, assessments and class participation have in the final grade. The easiest way to find such information is to consult the syllabus provided by the teacher. Once you have identified the amount of work, their respective weights and grades, it will be easy to calculate the final grade.
Method 1 of 4: Calculating Simple Averages Manually
Step 1. Write the notes
Find the grades you received for the materials that will be evaluated. Depending on the school, grades can be found on the internet. If this is not an option, talk to the teacher or check the assignments and assessments. Record all notes on paper so you can refer to them later.
If participation grades are included in the final average, you will have to ask your teacher what grade you got
Step 2. Write down all possible points
Consult the syllabus for this information. Teachers use various systems to determine final averages, the two most common being points or percentages. In any case, record the total possible points in a second column next to the column of grades you received.
- In a points system there is a maximum number of points that can be earned, meaning each job has a specific number of points assigned to it. For example, a specific subject may have 200 points available divided into four works that can be worth a maximum of 50 points each. (4x50=200).
- In systems involving percentages, each job will be worth a specific percentage of the grade. These percentages total 100%. For example, you may have four assignments, each worth 25% of the grade. (4x25=100).
- Note that in the examples given, each of the works has the same weight in the matter, even if the numbers are different.
Step 3. Add the columns together
Do this if the entries are rated as a percentage or as a point. Add all the values in the first column and write the total obtained below and repeat the process for the second column.
- For example, let's say you have five graded activities for a story. Two were tests worth twenty points each and two were tests worth ten points each. The final activity was a job worth five points.
- 20+20+10+10+5= 65. This is the total number of possible points for this story.
- Now add up the notes. Let's say you got 18/20 on the first test, 15/20 on the second test, 7/10 on one of the tests, 9/10 on the second test, and 3/5 on the job.
- 18+15+7+9+3= 52. This is the total number of points you got.
Step 4. Calculate the mean
Divide the total number of points earned by the total number of points available to get the percentage grade. In other words, divide the number you wrote down under the first column by the number you wrote down under the second.
Step 5. Multiply the decimal number obtained by 100
In order to obtain a note that is more similar to the ones you are used to, it is necessary to convert the decimal number into a percentage. Another way to do this is to shift the decimal point two places to the right.
- 52/65= 0.8 or 80%
- To move the decimal point two places to the right, add some zeros to the number (like this: 0.800). Now move the decimal point two places to the right. This will give: 080.0. Remove the excess zeros and you'll have 80. That means your grade on this subject will be 80.
Step 6. Determine the equivalent grade in the scoring system
You will need to understand the grading scale adopted in order to calculate the final grade. Some schools use letters (eg A, B, B-, etc.), while others use dots (eg 4.0, 3.5, 3.0, etc.). Scales relate to the total number of points possible in a subject and the grades achieved in percentage.
These scales can vary from one school to another. For example, some schools may use plus and minus signs in conjunction with grades while others may not. Some use a ten-point scale (eg, any note between 90 and 100 is A, any note between 80 and 89 is B, and so on). Others may use seven-point scales (eg, 97-100=A, 93-96=A-, 91-92=B+, etc.). This can also vary according to each teacher's preferences
Method 2 of 4: Calculating Weighted Averages Manually
Step 1. Identify the weights of the bills
This means that some grades have more participation than others in the final grade. For example, the final grade can be composed of 30% participation, four tests worth 10% each, and a final exam worth 30%. Figuring out how the participation and test grades affect the final grade, as they are three times higher than the grades for each test, is the trickiest part.
- Check the syllabus or ask the teacher for the weight of each grade.
- In high school it is common for more advanced classes to have a higher weight than classes of medium difficulty. Check the weight of each subject carefully so as not to calculate anything wrong.
Step 2. Multiply the percentage weight by the grades
To make organizing easier, write your grades and total possible points in separate columns. Only then multiply each number by its percentage weight. Record these numbers in a new column.
Example: if the final exam is worth 30% of the total grade and you got 18/20, multiply 30 by 18/20. (30 x (18/20) = 540/600)
Step 3. Add the numbers for the new column
Once you've multiplied each of the grades by its respective percentage, add up the total number of points you've earned and the total number of possible points. Divide the sum of the weighted grades by the total possible points.
- Example: Work 1 = 10%, Work 2 = 10%, Test 1 = 30%, Test 2 = 30%, Participation = 20%. Your grades: Work 1= 18/20, Work 2= 19/20, Test 1= 15/20, Test 2= 17/20, Participation = 18/20.
- Work 1: 10 x (18/20) = 180/200
- Work 2: 10 x (19/20) = 190/200
- Test 1: 30 x (15/20) = 450/600
- Test 2: 30 x (17/20) = 510/600
- Participation: 20 x (18/20) = 360/400
- Total grade: (180+190+450+510+360) ÷ (200+200+600+600+400), or1690/2000 = 84.5%
Step 4. Compare the percentage grade to the grading scale
Once you find the percentage grade, taking into account the weighted average, compare the percentage grade to the subject's grading system. For example, A=93-100, B=85-92, etc.
It is common for teachers to round up grades. For example, an 84.5% grade may be rounded to 85%
Method 3 of 4: Calculating Simple Averages with Spreadsheets
Step 1. Open a new spreadsheet
Open a new file in your operating system's spreadsheet software. Type a title above each column to keep it organized. Use the first column to type the name of the activities, the second for your grades, and the third for total possible points.
For example, columns can be named as: Activities, Grades, High Grade
Step 2. Enter the data
Write the name of each of the assessments in the first column. Then enter the respective grades in the second column and finally enter the total number of possible points. If the grade is calculated with base percentage, it means that the total possible points will be 100.
Step 3. Add the values in columns two and three
Type “TOTAL” at the end of the column labeled “Activities”, and then click the cursor in the cell beside it, just below the last note entered. Type “=sum(” and then select the first note in the column and drag the cursor over all the notes recorded in the column. Release the mouse button and close the parenthesis. The cell will look like this: =sum(B2:B6).
- Repeat the process in the third column.
- You can also manually type in the cells you want to add. For example, if you verify that the values you want to sum are in cells B2, B3, B4, B5, and B6, type “=sum(B2:B6)”.
Step 4. Divide the total obtained from the grades by the total possible points
Keep the cursor on the same row as the totals and select the fourth column cell. Type the equality symbol followed by parentheses: “=(“Then select the sum of grades, type a slash, select the sum of the total possible points and close parentheses: “=(B7/C7) “
Hit Enter and you're done! The total should appear automatically
Step 5. Change the decimal number to a percentage
This can easily be done in spreadsheets. Move the cursor to the next column. Type the equal sign, parenthesis, select the calculated decimal note, type an asterisk, type the number 100, and then close the parenthesis. Typing will look like this: “=(D7*100)”
Hit Enter to view the result
Step 6. Compare the final percentage grade to the grading scale
Now that you know your final grade, compare it to the subject's grading scale to identify the corresponding letter (eg A, B-, D+, etc.). If it is a numerical scale (3.75, 2.5, 1.0, etc.), you must multiply the decimal total by the maximum grade.
For example, if your percentage note is equal to 0.82 and the maximum note of the scale is four, multiply the decimal note by four to get your note within the scale
Method 4 of 4: Calculating Weighted Averages with Spreadsheets
Step 1. Open a new spreadsheet
Open a new file in your operating system's spreadsheet software. Type a title above each column to keep it organized. Use the first column to enter the name of the activities, the second for your grades, and the third for total possible points.
- For example, columns can be named as: Activities, Grades, Maximum grades, Weighting factors, Weighted grades.
- Enter the data. Now just enter activity names and values for grades, maximum grades, and weighting factors.
Step 2. Multiply the grades by the weighting factor
This will give you the weighted notes that make up the total note. For example, if your grade on an exam that corresponds to 30% of the final grade was 87, type an equals sign followed by parentheses, select the cell corresponding to the grade, type asterisk and 30%. In writing, the formula should look like this: “=(B2*30%)”
Step 3. Add the weighted notes
Choose the cell where you want the weighted endnote to appear. Type the equal sign, sum, parentheses, select the cells where the weighted partial notes are, close parentheses and press the enter key. In writing, the formula will look like this: “=sum(B2:B6)”
Step 4. Compare the final weighted grade to the subject's grading scale
After calculating the weighted partial grades and adding them, compare the final weighted grade to the subject grade scale to identify the letter (eg, A, B-, D+, etc.) or number (3.75, 2.5, 1.0, etc.) corresponding to the note.
- Save the assignments and proofs to calculate the averages later. Also, keeping them can be useful in case you need to discuss the final grade with the professor at the end of the semester.
- To calculate the partial grade instead of the final one, just replace the partial grades by the grades of homework, tests, projects, etc.
- All instructions given that contain quotes must be used without quotes. For example, if the statement indicates typing the expression “=sum(B2:B6)”, you should suppress the use of quotation marks.
- Use all notes.
- Use the notes registered in the newsletter. Don't use the semester notes, just the partial ones.
- For curiosity, below you find the grading scales used by the well-known GPA system in the United States. The national scale system is similar but varies depending on the educational institution.
- A, 90-100, 4.0
- B, 80-89, 3.0
- C, 70-79, 2.0
- D, 60-69, 1.0
- F, 0-59 0.0
- A, 93-100.00, 4.00
- A−, 90-92, 3.67
- B+, 87-89, 3.33
- B, 83-86, 3.0
- B−, 80-82, 2.67
- C+, 77-79, 2.33
- C, 70-76, 2.0
- D, 60-69, 1.0
- F, 0-59, 0.0