Question

Please type!!

"I’m making your grades available to you via the course grade book. As many of you already know, you can use excel to calculate your weighted grade. For this discussion post, please compose a post that describes how you’d do that (calculate weighted grades). Remember that you may have a better understanding of how to do this than other students in the class, so please be as thorough as possible, don’t make assumptions that everyone knows everything you know."

Answer 1

Table Data:

Name	Test1	Test2	Quiz1	Quiz2	Homework1	Homework2	TEST AVERAGE AVERAGE(Test1:Test2)	Quiz Average AVERAGE(Quiz1:Quiz2)	Homework average AVERAGE(HW1:HW2)	Weighted Average 10% Homework 35% Quizzes 55% Tests 0.1*HomeworkAvg +0.35*QuizAvg+0.55*TestAvg	Weighted Grade IF K4>80 then A, IF K4>70 then B, ELSE C
Formula Used   -->>	AVERAGE(B5:C5)	AVERAGE(D5:E5)	AVERAGE(F5:G5)	0.1*J5+0.35*I5+0.55*H5	IF(K5>80,"A",IF(K5>70,"B","C"))
TOM	81	99	88	70	86	80	90	79	83	85.45	A
JERRY	78	86	80	90	77	70	82	85	73.5	82.20	A
BOB	98	77	70	91	69	69	87.5	80.5	69	83.20	A
MARIO	67	69	69	95	90	79	68	82	84.5	74.55	B
WINNY	48	60	79	79	89	80	54	79	84.5	65.80	C
MILLY	88	89	80	96	89	77	88.5	88	83	87.78	A

Working Screenshot:

Explanation:

For calculating H column we will use excel formula Average, which takes two argument, i.e. start and end value to calculate average.

Similarly we'll calculate Quiz Average, i.e I column and Homework Column, i.e J.

Then we'll calc Weighted Average, that will be 10% of Homework average, 35% of Quiz Avg and 55% of Test Avg making it total of 100%.

For which we use 0.1*HomeworkAverage + 0.35*QuizAvg +0.55*TestAverage.

On the basis of weighted Average we'll calc Weighted grade,

that if if weighted average is greater tha 80 than 'A', if between 70 and 80 then 'B' else 'C'.