Compute Weighted Grades in Excel 2016

Edited by Djinu, Alexander Avdeev, Eng

You're watching VisiHow. In this video, we'll show how to calculate weighted grade-point averages for a group of students.

Calculate Weighted Grades In Excel.mp4-canvas115 043265.jpg

Ad

Steps

  1. 1
    We include students' names in the first column
    .
    Then, we have "Quiz 1" through "Quiz 3", "Midterm", and "Final". The quizzes are worth 10% of the final grade. The midterm is worth 30% of the final grade. The final is worth 40% of the final grade.
    Calculate Weighted Grades In Excel.mp4-canvas10 438819.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help
  2. 2
    To calculate the final grade, what we do is we press "="
    .
    We type in the formula: "SUMPRODUCT()" (we use parentheses).
    Calculate Weighted Grades In Excel.mp4-canvas36 277079.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help
  3. 3
    We highlight the first row of the student's grades
    .
    Calculate Weighted Grades In Excel.mp4-canvas41 908618.jpg
    Was this step helpful? Yes | No | I need help
  4. 4
    Then, we press ","
    .
    Calculate Weighted Grades In Excel.mp4-canvas44 089618.jpg
    Was this step helpful? Yes | No | I need help
  5. 5
    Then, we highlight the weighted numbers
    .
    Calculate Weighted Grades In Excel.mp4-canvas47 609618.jpg
    Was this step helpful? Yes | No | I need help
  6. 6
    It is important to make sure that the student's grades have a relative reference
    .
    When we fill down, the next row will be used to generate the formula numbers.
    Calculate Weighted Grades In Excel.mp4-canvas55 415682.jpg
    Was this step helpful? Yes | No | I need help
  7. 7
    For the weighted averages, we want to make sure that these are absolute references
    .
    So, we add "$" in front of the letter and the number to make them "$C$1" and "$G$1" in this video. Whenever we fill down, the formula will always refer to the "Weight" row. In this video, "SUMPRODUCT" will basically multiply 75 by 0.1, 35 by 0.1, etc., and then add the product of those numbers. In this case, it will be 7.5+3.5+3.5+etc.
    Calculate Weighted Grades In Excel.mp4-canvas70 373977.jpg
    Was this step helpful? Yes | No | I need help
  8. 8
    Once we get all of these numbers added up, we want to divide those by the total number of the weights
    .
    We'll use "SUM", add a parenthesis, and select the top section, adding in the dollar sign in front of the letters and the numbers to make sure that these are absolute references. We close the formula and press "Enter". In this video, the final grade for Billy Bob will be 58.
    Calculate Weighted Grades In Excel.mp4-canvas117 241676.jpg
    Was this step helpful? Yes | No | I need help
  9. 9
    We can fill the "Grade" column down
    .
    We do it by left-clicking at the bottom of the cell and simply dragging it down to get the final grades for both Suzy Q and Mike Holmes.
    Calculate Weighted Grades In Excel.mp4-canvas132 408592.jpg
    Was this step helpful? Yes | No | I need help
    Advertisement

This has been a tutorial on how to calculate weighted averages using Microsoft Excel. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Compute Weighted Grades in Excel 2016

Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

APA (American Psychological Association)
Compute Weighted Grades in Excel 2016. (2016). In VisiHow. Retrieved Mar 29, 2017, from http://visihow.com/Compute_Weighted_Grades_in_Excel_2016

MLA (Modern Language Association) "Compute Weighted Grades in Excel 2016." VisiHow, visihow.com/Compute_Weighted_Grades_in_Excel_2016 Accessed 29 Mar 2017.

Chicago / Turabian VisiHow.com. "Compute Weighted Grades in Excel 2016." Accessed Mar 29, 2017. http://visihow.com/Compute_Weighted_Grades_in_Excel_2016.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Ask the author

Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 119,000 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Compute Weighted Grades in Excel 2016"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Alexander Avdeev, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 459 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No