software

I am trying to use excell to calculate grades for the end of the term,
however I am not sure how to do this. I am using a percentage to calculate
but can not get an average score or overall score. For example I enter the
grades and 20% is for exams, 30% to final exam and 50% for term assignments.


Assuming your cells for Exams=A1; Final Exam=A2; Term Assig.=A3 all you
need to do is:

=(A1*.2) (A2*.3) (A3*.5)--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528180If the numeric grades are laid out with exam scores in A1, term assignments
in A2, and Final exam in A3, then put the 20%, 50%, and 30% in cells B1:B3,
your formula would be

=sumproduct(A1:A3,B1:B3)

quot;Spring coulterquot; wrote:

gt; I am trying to use excell to calculate grades for the end of the term,
gt; however I am not sure how to do this. I am using a percentage to calculate
gt; but can not get an average score or overall score. For example I enter the
gt; grades and 20% is for exams, 30% to final exam and 50% for term assignments.

Also checkout:

office.microsoft.com/en-us/te...455541033.aspx
--
Gary's Studentquot;Spring coulterquot; wrote:

gt; I am trying to use excell to calculate grades for the end of the term,
gt; however I am not sure how to do this. I am using a percentage to calculate
gt; but can not get an average score or overall score. For example I enter the
gt; grades and 20% is for exams, 30% to final exam and 50% for term assignments.