I calculate grades in a similar fashion usually throwing out the lowest =
quiz score and one of the labs as well. Using Excel simply use the MIN =
function to subtract the lowest value of a list from the sum of the same =
list and then divide by one less than the total number of scores. For =
example, if I had 11 lab scores in row B columns 10 through 20, I would =
write the function (SUM(B10:B20)-MIN(B10:B20))/10 to calculate the =
average lab score. =20
I also use the IF function to assign a letter grade after the overall =
score is determined.
Brian Oliver
-----Original Message-----
From: Daniel L. MacIsaac [SMTP:macisaac@bohr.phy.nau.edu]
Sent: Friday, December 12, 1997 6:03 PM
To: phys-l@atlantis.uwf.edu
Cc: danmac@bohr.phy.nau.edu
Subject: Grading & EXcel
Req for Excel expert assistance:
I usually grade the best 15 of 20 activities; best 2 of 3 midterms; best
13 of 14 labs etc to avoid giving makeups. Problem is, at the end of =
semester
I have to then manually pick these 'best' grades out of the records.
Is there an Excel wiz out there who knows how to write Excel functions?? =
I'd
like to acquire or get assistance with producing a BestNof function. =
This
function would allow me to set a cell range and an integer. The =
function
should return the sum of the best N scores of the selected cells (the=20
sum of the highest N values in the range of cells). =20
Anyone know how to do this or know someone who knows how to do this?