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

Gerd Kortemeyer korte at lite.msu.edu
Mon Mar 4 17:52:24 EST 2013


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

More information about the LON-CAPA-users mailing list