[LON-CAPA-users] grading question

[Todd Ruskell]

Nathan,

On Thursday 01 December 2005 03:49 pm, Nathan Schoenack wrote:
> 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
As Gerd said, you will probably have to have uploaded the test scores using 
Score Upload Form.  But before I try to answer this one, I'll suggest you 
read the spreadsheet section of the course coordinator manual.  The reason I 
can't answer it right now is because there are three levels of spreadsheet:  
The resource spreadsheet, which feeds into the student spreadsheet, which 
feeds into the course spreadsheet, and until you read up and can clarify, 
there are lots of different, possible answers.  
 
> 2. can I import the total homework score into a cell?
I think you'll have to add up the scores from the individual homeworks.

> 3. is there any "getting to know the spreadsheet" documentation
> available?

Yes, the Course Coordinator manual has a complete section on the spreadsheet.  
Speaking from experience, spreadsheets can be a bit "interesting" getting 
started, and making your way through the three separate levels of 
spreadsheets.  However, to me it has turned out to be very much worth it, as 
now my students always have instant access to my gradebook.

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

-- 
Dr. Todd Ruskell
Lecturer, Department of Physics              Office:  Meyer Hall 326
Colorado School of Mines                     Phone: 303-384-2080
1523 Illinois Street                         Fax: 303-273-3919
Golden, CO 80401