trying to compute grade for a class

xtac

New Member
Joined
Jul 9, 2005
Messages
5
Hi all,

I am pretty new at excel, I juse use it for inventory but not to its powerfull ways, I just use the layout, I have no idea how to use the formula, but anyway I got here last time with a grade compute, heres what I would like it to do


I have 3 test grades, that constitute for 81% of the grade, highest grade being a 27

I have 4 different tasks that count as 19% % of the grade, highest being an (a) so i guess its numerical value of 4 would be good?

If someone could pass on a formula for this id jump in joy because i hate trying to figure out my grade doing all these diff types of numbers over and over, and i thought excel would do its job.

thanks in advance
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
There are a couple approaches, but usually what you really need to know is the total possible number of points, and of course your scores. The percetages are not needed they are just informational. You add up all your scores tests and tasks alike and then divide them by the possible number of points. That will result in your grade percentage. The formula for such a thing would look like =Sum(A2:A8)/B2 assuming your grades and tasks are in Range A2 through A8 and your possible points are in B2
 

Watch MrExcel Video

Forum statistics

Threads
1,118,017
Messages
5,569,640
Members
412,284
Latest member
Daibear
Top