Tap to unmute

Calculate Weighted Average Grades for a Class of Students

  Рет қаралды 12,798

Six Minutes. Smarter.

Six Minutes. Smarter.

Күн бұрын

Use basic formulas in Excel to calculate the class grade for each student using a weighted average structure. Categories of class activities (assignments, quizzes, and exams) are each worth a certain percentage towards the final class grade.
Demo file: / 32281699

Пікірлер: 12
@chrismattson1787
@chrismattson1787 2 жыл бұрын
I've been looking for exactly this formula for years. Thanks!
@MoeinEsther
@MoeinEsther 6 ай бұрын
only if you calculate everything over 100 point . what if different categories has different Max point ? (Ex: assignments score from 20 and all assignments take 20% of the final grade)
@heathershearer1799
@heathershearer1799 5 ай бұрын
Thank you! This video was helpful--you presented everything simply and clearly. ⭐
@FernandoCantillo
@FernandoCantillo Жыл бұрын
Thank you so much for such a great and easy way to create a grade spreadsheet. Made my job much easier.
@bahaykatay2008
@bahaykatay2008 3 жыл бұрын
Hi nc work, how did you do your background?
@LuisFernando-yd3mx
@LuisFernando-yd3mx 2 жыл бұрын
Then if you wanted the overall grade of the whole class would you sum their individual weighted average row totals then divide by the number of students?
@andreaaroche2737
@andreaaroche2737 3 жыл бұрын
Hi! Question, if you change the weight of the assignment 40%, to a different number when the formula is already prepare, are the calculations going to still be correct or not for the Grade.
@SixMinutesSmarter
@SixMinutesSmarter 3 жыл бұрын
Yes. Since the formula refers to the cells containing the weights, the calculations will still be accurate. Of course, the total weight still needs to equal 100% so adjusting one category weight will require adjusting at least one other category.
@fanjing38
@fanjing38 3 жыл бұрын
Thank you for such an efficient presentation!!
@yanireestrada1080
@yanireestrada1080 2 жыл бұрын
Thank you, excellent!
@mugabimuhammad5069
@mugabimuhammad5069 5 жыл бұрын
thanks bro
@mugabimuhammad5069
@mugabimuhammad5069 5 жыл бұрын
thanks bro
COCC Tech Tip - Mail Merge Email Feedback
4:00
Six Minutes. Smarter.
Рет қаралды 708
How to calculate weighted grades
8:58
Rhett Allain
Рет қаралды 20 М.
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
Conditional Weighted Average Formula in Excel
7:14
Adventures in CRE
Рет қаралды 38 М.
How to calculate students grades in Excel
14:46
AdjoTech
Рет қаралды 101 М.
How to Build a Simple Gradebook in Excel
12:29
Excel Yourself
Рет қаралды 7 М.
Calculating weighted grades
8:32
Evan Evans
Рет қаралды 133 М.
Weighted Averages in Excel (project 1 help)
5:18
Becky Moening
Рет қаралды 23 М.
Create Mailing Labels in Word Using Mail Merge from Excel
5:54
Six Minutes. Smarter.
Рет қаралды 141 М.
How to Calculate Weighted Average Inventory - Fast!
6:14
Accounting University
Рет қаралды 101 М.
Excel Grade-book & Feedback For Students
14:40
Paul Rogers
Рет қаралды 33 М.
Why Your Brain Sabotages Your Goals (and How to Fix It)
11:56
Productive Peter
Рет қаралды 36 М.
How to Calculate Weighted Average of Marks
15:11
Anil Kumar
Рет қаралды 65 М.
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19