[LON-CAPA-admin] Excused Problems In Excel

Bynum, Lee Hamilton leebynum at illinois.edu
Thu Dec 7 10:17:01 EST 2017

Hello Again,

I hope I'm not veering into the realm of scam, but I have another update.

Using the "Clear Caches" button rather than the "Generate Chart" button appears to put the x's back into the Excel and CSV charts.  While this fixes the problem I'm looking to solve, I suspect that cached scores changing the spreadsheet values of excused problem parts is not the desired behavior.  I will be creating a bug report shortly and believe I know how to address the problem.

I suggest those using the Grade Assessment Chart spreadsheets use the "Clear Caches" button, especially for older homeworks that might have cached scores.


From: lon-capa-admin-bounces at mail.lon-capa.org [lon-capa-admin-bounces at mail.lon-capa.org] on behalf of Bynum, Lee Hamilton [leebynum at illinois.edu]
Sent: Wednesday, December 06, 2017 1:28 PM
To: list about administration and system updating
Subject: Re: [LON-CAPA-admin] Excused Problems In Excel

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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.lon-capa.org/pipermail/lon-capa-admin/attachments/20171207/985d178b/attachment.html>

More information about the LON-CAPA-admin mailing list