[LON-CAPA-users] grading question

[Nathan Schoenack]

Ok, that leads me to ask about the basics of the spreadsheet:

1. how do I import a particular test score into a spreadsheet cell
2. can I import the total homework score into a cell?
3. is there any "getting to know the spreadsheet" documentation  
available?

-Nathan

On Dec 1, 2005, at 2:51 PM, Gerd Kortemeyer wrote:

> 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
>
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>

Nathan Schoenack
IT Research Support Specialist
NDSU Physics
(701) 231-7047
nathan.schoenack@ndsu.edu