So for each cell (in the Total column) we will enter =SUM(Grade Cell * Weight Cell), so my first formula is =SUM (B2*C2), the next one would be =SUM (B3*C3) and so on. To find the grade, multiply the grade for each assignment against the weight, and then add these totals all up. So if homework is worth 25% of your grade, the weight would be 0.25. Calculate the running average Chart distributions of scores Print grade printouts for one student or everyone Weight grades Customize curve, excuse, and allow retakes Instructions in the grade tracker For Windows Excel 2007+ or Mac Excel 2011+ and last updated Aug 2020 for Excel's new formula engine for Office 365 and beyond. Pretty daunting, right? As mentioned earlier, when computing for the weighted average, you’ll have to multiply the values to their weights and add the products. Once we’ve completed entering this in, we need to add all these totals up in order to calculate the grade in the class.

Enhance Your Excel Skills With Expert-Led Online Video Tutorials - Start Today! So if homework is worth 25% of your grade, the weight would be 0.25.

Assigning weights to variables in excel