How to Calculate Weighted Averages for Grades in Excel

Weighted average grades are a way for a teacher to place more importance on one assignment than another. For example, if a student scores 100 on a test worth 30 percent of his grade and 50 on a test worth 70 percent of his grade, then the 50 score will have a bigger impact than the 100 score on the final grade. You can use Microsoft Excel to quickly make these calculations.

1. Organization

Organize the groups of data that will help calculate your grade. Type "Grade" in cell A1, "Weight" in B1 and "Total Worth" in C1.

2. Insert Data

Type your grades in column A. For example, if you received a 95 and an 80, then type "95" in A2 and "80" in A3.

3. Insert Percentage

Type the weight each grade has in column B, next to its corresponding grade. In the example, if the first grade is worth 60% and the second grade is worth 40%, then type 60% in B2 and 40% in B3.

4. Calculations

Type "=A2*B2" in cell C2. This weights the grades. Copy and paste this formula next to each grade.

Type "=sum(" in column C after your last grade, then highlight all the cells that have a number in coumn C and hit the "Enter" key. The result that appears is your weighted average.