help me compute my grade

[jtillman]

I need to compute my grades.
I have a quiz average of 86 this is 20% of my final grade

I have a Midterm which is 80 this is 20 % of my grade

I have homework which is 70, this is 10% of my grade

And my final is 80, this is 30% of my grade.

Help!! I need a formula.

 

[Andrew Poulsom]

Don't you just need to multiply each score by its percentage weighting, and sum the results? That gives a score out of 80 (sum of percentages) in your scenario.

 

[plettieri]

It seems that a piece might be missing from your data.(if you have a 100% base to work with)...anyway as Andrew stated the calculation totals only 80%...this is how i would have set it up Were you looking for one formular to handle the entire operation?

Book1
	D	E	F	G	H	I	J
14		Quiz%	MTerm%	HW%	Final%	Other%	Total
15	Ratioweight	20%	20%	10%	30%		80%
16
17	Grade	86	80	70	80		316
18
19	Extended	17.2	16	7	24	0	64.2
Sheet1

hope this helps
pll

 

[Legacy 98055]

Where's the other 20%?
The above scores only account for 80% to your credit. I hope this isn't math class.