[LON-CAPA-users] Letter Grades in the Spreadsheet

[Gerd Kortemeyer]

Hi,

In the monster-spreadsheet, you can set up a Perl expression to do this. Say the total points are in A4

(A4>93?'A':(A4>84?'B':(A4> …)))

In uploading grades, you can use the grading comments to upload any text.

- Gerd.

On Mar 4, 2013, at 5:47 PM, "Mills, Douglas G" <dmills at illinois.edu> wrote:

> Hi All,
> 
> We haven't done much with the spreadsheet here before but are trying to see if we can use it in place of a vintage home-grown system we are fond of…  The instructor piloting this undertaking is not finding a way to be able to display midterm letter grades to his students. I've searched the Course Mangement manual and online help and also come up empty-handed. Is this something that can be done in the spreadsheet either by setting up a column to display letter grades based on a scale applied to a total column OR by importing letter grades from an external spreadsheet? Or some other means?  Thanks as always for your help!
> 
> Doug
> 
> Douglas Mills
> Director of Instructional Technologies
> Department of Chemistry
> University of Illinois
> dmills at illinois.edu
> (217) 244-5739
> 
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users