[LON-CAPA-admin] Excused Problems In Excel

Bynum, Lee Hamilton leebynum at illinois.edu
Wed Dec 6 14:28:23 EST 2017


Diving deeper, it looks like the excel and csv grade assessment charts and the html grade assessment charts are showing different things.  The spreadsheet versions are showing the computed points and the html version is replacing those points with characters in the case of things like excused problem parts.

The cases in which I am seeing x's in the spreadsheet grade assessments come from when the computed points are invalid for some reason.  I suspect those are caused by scores being logged prior to the problems being excused.

From: lon-capa-admin-bounces at mail.lon-capa.org [mailto:lon-capa-admin-bounces at mail.lon-capa.org] On Behalf Of Bynum, Lee Hamilton
Sent: Tuesday, December 5, 2017 3:43 PM
To: lon-capa-admin at mail.lon-capa.org
Subject: [LON-CAPA-admin] Excused Problems In Excel

Hi Everyone,

We have noticed that the grade sheets generated for Excel and CSV are placing 0's in the place of x's, most of the time.  In at least one problem a single student retained their excused x's in Chrome and Safari, but not Firefox.  The HTML grade sheets are working fine, so it feels as though something is going wrong with Spreadsheet::WriteExcel.

Is anyone else experiencing similar behavior?

Lee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.lon-capa.org/pipermail/lon-capa-admin/attachments/20171206/d7c3012d/attachment.html>


More information about the LON-CAPA-admin mailing list