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

[Mills, Douglas G]

Thank you both Ray and Gerd,

The LC community comes through again!  Very helpful.

Doug

Douglas Mills
Director of Instructional Technologies
Department of Chemistry
University of Illinois
dmills at illinois.edu
(217) 244-5739







On 3/4/13 6:33 PM, "Raymond Batchelor" <batchelo at sfu.ca> wrote:

>Hi Doug,
>
>I can't comment on the spreadsheet, since I don't use it.  I prefer to do
>all weighted marks/grades calculations offline.  However, I use "Score
>Upload" resources to display textual info for students (such as letter
>grades or exam scores, with comments).  One can upload such text from a
>csv file, to either "Grade Info", or to "Comment", or to both.  These can
>be quite long strings and I often include simple html, such as <br /> to
>format what the student sees, quite nicely.
>
>I usually also upload either "points" or "partial credit factor".
>However, *after* the upload I invariably set the weight of the resource
>to "0" and maxtries to "-1".  This effectively removes that score from
>the "grade book" (i.e. from "Chart" and default spreadsheet), and
>suppresses any "Submit" buttons or system feedback, so that the student
>sees a clean page with just the Grade Info, and/or Comments.  Nonetheless
>the partial credit factor remains stored, so that I could, if I chose at
>a later date, reapply some weight for the purposes of any grade
>calculations or scores export.
>
>We use this to display, for example, Midterm Exam results, broken down in
>differing ways and with comments.
>We also use it to display complex marking scheme results for Lab Reports,
>or for a summary of all components contributing to, say, a Lab course.
>
>Ray
>
>
>----- Original Message -----
>From: "Douglas G Mills" <dmills at illinois.edu>
>To: "Discussion list for LON-CAPA users"
><lon-capa-users at mail.lon-capa.org>
>Cc: "Douglas G Mills" <dmills at illinois.edu>
>Sent: Monday, 4 March, 2013 14:47:35
>Subject: [LON-CAPA-users] Letter Grades in the Spreadsheet
>
>
>
>
>
>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
>_______________________________________________
>LON-CAPA-users mailing list
>LON-CAPA-users at mail.lon-capa.org
>http://mail.lon-capa.org/mailman/listinfo/lon-capa-users