## WeBWorK Main Forum

by Danny Glin -
Number of replies: 6
Is there a way to import grades from a non-Webwork assessment into Webwork? Since around here for some courses all assessments but the midterm and final are completed in Webwork, one of our profs was asking if midterm grades could be entered into Webwork, thus he would not have to keep a separate gradebook.
I know there is moodle integration, but the University here supports blackboard, so we won't be using another course management system. Maybe the answer is to see how the blackboard integration comes along..
Danny

by Michael Gage -

If you want a full featured gradebook you need to use Moodle integration (or Blackboard -- which is in alpha test stage).

However, you can do what you want in WeBWorK alone. It is a bit of a hack, but it works for me.

First use excel or some other spreadsheet app to create a .csv (comma separated variable) file with the relevant grades.

In my case I usually download all the homework grades using the WeBWorK scoring tools to a .csv file. Import this into excel. Add the midterm and final grades and do any additional calculations for the grade and then export the result into a file called report_grades.csv

It is important to call this file report_grades.csv. In addition to grades this file also has columns corresponding to the studentLogin and the studentID.

Upload this file using the File Manager to the "scoring" directory
courseName/scoring (this is at the same level as the courseName/template directory that you see first in the File Manager)

Now the contents of this file (or rather the row that applies to them) will appear when ever the students look at their Grades (link in the left hand margin). If I remember correctly the "key" is the studentID number rather than the studentLogin but I'd make sure not to touch either column when adding the midterm and final grades. You can also use this report_grades.csv file together with the "Email students" feature to mail a report of individual grades to the student.

The procedure is a bit fussy (I'm the main person to use it as far as I know) but it goes pretty fast once you are used to it.

Here are some further references
http://webwork.maa.org/wiki/Sending_Email

Hope this helps while you are waiting for Blackboard integration.

-- Mike

by Lars Jensen -
Hi Mike,

This didn't work for me. I did what you say below:

So I added an extra "Test" column at the end of the homework scores, and adjusted the "summary" and "%score" columns in accord, then renamed the file to report_grades.csv. Nothing new showed up under student grades, neither under the student's account, nor in the instructor's gradebook. I only see the same homework scores. I tried to delete some header rows/columns in the spreadsheet and upload again, but it changed nothing.

Did I miss something? Any ideas? It might be helpful if you could attach a template report_grades.csv example file?

Thanks,
Lars.

by Michael Gage -
Hi Lars,

Looking through the references (especially the second link below) again:

The procedure is a bit fussy (I'm the main person to use it as far as I know) but it goes pretty fast once you are used to it.

Here are some further references
http://webwork.maa.org/wiki/Sending_Email

I find that the merge file needs to be named report_grades_data.csv  and the message file which accepts the merge data is named report_grades.msg.  I'm afraid that I conflated the two when I wrote the original post.

The references also acknowledge that the documentation on this feature is nearly non-existent -- mainly because it has not been widely used. That's also why it is fussy -- the file names and so forth are all hardwired into the code.

The most explicit reference I have been able to find is from the scoring page help reference (the little yellow question mark):