2006-06-18 07:25:59 · 5 answers · asked by the_black_knight_1066 1 in Science & Mathematics ➔ Mathematics
=(AVERAGE(numerical grade))*percent of total grade
=(AVERAGE(numerical grade))*percent of total grade
=(AVERAGE(numerical grade))*percent of total grade
=(AVERAGE(numerical grade))*percent of total grade
=SUM(of all the above)
Example:
Exams 50% (84,51)......33.75
Labs 4% (10,10,10,10,10,10,10)....4.00
Lab Exam 6% (82)....4.92
Final 40% (76)...30.40
Grade 73.07
2006-06-19 19:40:54 · answer #1 · answered by Man 6 · 1⤊ 0⤋
What do you mean by "grade"?
If grade = school grade, then the answer is so:
There is none, unless you want to do some programming.
You need an IF statement for the A's B's C's and D's. Set A to 90, B to 75, C to 65, and D to 55.
Make another IF statement for + and -. This is pretty complex. IF(A1 = "A", IF(A2="+", A4 = A3+5), ELSE(A2="-", A4 = A3-5)), ELSE(IF(A2="+", A4 = A3+3), ELSE(A2="-", A4 = A3-3)),) or something like that.
2006-06-18 07:33:08 · answer #2 · answered by Anonymous · 0⤊ 0⤋
i don't understand your question:
You have a circle sector (or pie) and want to find out the percentage represented by it? Then you'll have 100%=360 degrees so gp=3.60*p where gp is grade percentage and p is the percent
example p=25%, gp=90
2006-06-18 07:31:24 · answer #3 · answered by mmaruseacph2 2 · 0⤊ 0⤋
I got my excel grade book by downloading it (for free) from microsoft templates. It's easy to set up and use. Sorry, it's sort of an indirect answer to your question.
2006-06-18 07:31:36 · answer #4 · answered by Robsthings 5 · 0⤊ 0⤋
It would be the same as figuring the percentage of any other series of numbers. You would have your input cells, add them together and divide by the total number of inputs.
Or try this link http://office.microsoft.com/en-us/templates/TC010183961033.aspx?CategoryID=CT063455541033
Thanks to Robusthings
2006-06-18 07:30:59 · answer #5 · answered by jgreaves 3 · 0⤊ 0⤋