[LON-CAPA-users] grading question

[Gerd Kortemeyer]

There's a function for that in the spreadsheet:

&SUMMAX(n ,range) - sum of the maximum n non-empty cells in range

So if you have 8 test scores listed in column D, and want to drop the  
worst score, you would do

&SUMMAX(7,'D*')

As always, we aim to please and guarantee 100% immediate satisfaction.

On Dec 1, 2005, at 3:25 PM, Nathan Schoenack wrote:

> Has anyone ever tried to use the spreadsheet or some other function  
> of LON-CAPA to implement a grading procedure that involves dropping  
> the worst test score for the semester?  I have a professor that  
> gives 4 tests but allows students to drop their worst test score.
>
> Nathan Schoenack
> IT Research Support Specialist
> NDSU Physics
> (701) 231-7047
> nathan.schoenack@ndsu.edu
>
>
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users