[#MDL-14840] Cannot import grades when using non-numeric scale

Moodle

Cannot import grades when using non-numeric scale

Created: 15/May/08 05:52 AM Updated: 09/Oct/08 02:56 AM

Component/s:

Gradebook

Affects Version/s:

1.9

Fix Version/s:

1.9.3

File Attachments:

None

Image Attachments:

1. customScaleGradesErr.gif
(42 kb)

2. screenshot-1.jpg
(156 kb)

Issue Links:

Duplicate

This issue is duplicated by:

~~MDL-15022~~ Not possible to upload non-numeric grades into assignments e.g. pass, fail.

Relates

This issue has a non-specific relationship to:

MDL-16832 normalise hadnling of spaces in scale definition

Participants:	Daljeet Soor, Dan Marsden, Jamie Tinley, Martin Dougiamas, Mike Corb, Mike McDermott, Mohammed Abdulaziz, Nathan Cobb, Petr Škoda and Teresa Gibbison
Security Level:	None

Description

« Hide

I cannot import grades when I am using a non-numeric Scale. I have a scale with 3 items (Not Attempted, Attempted, Completed). These are the steps I have taken to import the grades:
   1. Graded one student
   2. Exported the file to CSV
   3. Altered the exported file to include the other student's grades
   4. Import the modified file
   5. Throw my hands in the air when reading the error message 'Supplied grade is invalid'

This error also occurs when using the Satisfactory/Not Satisfactory standard scale although using numeric scales works a treat.

Attached is the error I am getting with other screen shots of the Custom scale I was using at the time and file import preview screen. I have found a temporary work-around as outlined below but that is not really ideal
   1. Change the grading in each Moodle assignment to be out of 3
   2. Alter the csv file to have the grades 1, 2 & 3 (3=being Completed; 2=Attempted & 1=Not Attempted)
   3. Import the file
   4. Change the grading in each Moodle assignment back to your custom scale

All

Comments

Change History

Version Control

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Mike McDermott - 27/May/08 11:57 PM

I have exactly the same problem. It is really important to get this fixed.

Set a scale as Pass, Fail, Distinction etc.

Try to upload these grades from csv and it is not possible, Upload 1,2,3 etc, and it will come out as Pass, Fail, Distinction. That causes confusion.

The grades in the CSV file need to be exactly the same as they appear in the course. Obviously if a grade has not been set up in the scale, it should not then be possible to upload it.,

[ Permlink | « Hide ]

Mohammed Abdulaziz - 28/May/08 05:33 PM

Am also experiencing the same problem...

Yes if the scale is "complete" or "not complete" then it is ok to use the numeric scale on the CSV as there are only 2 choices of grades.

But if the scale exceeds 12 or 14 level of grades then it's not practical to use the numeric scale within CSV.

Any solutions to this problem

[ Permlink | « Hide ]

Daljeet Soor - 28/May/08 05:33 PM

Grade Book Help Required!?

The CSV file being is the most easiest way to upload grades, obviously if different assignments use different scales- it is going to be ever so confusing to know that numeric inputs equal a possible assigned text orientated grade.

Can the grade entered via the CSV file not correspond to the scales applied by each assignment?

[ Permlink | « Hide ]

Nathan Cobb - 28/May/08 06:13 PM

I have the same problem. I don't think I can add much to previous comments. Pretty much everything here relies on a non-numerical scale. Any way of resolving this would be greatly appreciated.

[ Permlink | « Hide ]

Martin Dougiamas - 28/Jun/08 10:30 AM

Hi Petr, can we make this a priority? (either you or Nicolas)

[ Permlink | « Hide ]

Petr Škoda - 04/Jul/08 02:56 PM

[ Permlink | « Hide ]

Petr Škoda - 05/Jul/08 04:49 AM

fixed in cvs,
I have also added option to use tabs and there is also an option for backwards compatibility
please test and reopen if needed

thanks for the report

[ Permlink | « Hide ]

Jamie Tinley - 07/Jul/08 04:48 AM

Hi Petr,

I see you solved it but I don't understand the solution - is this an update in moodle 1.9? Or a fix we can add? I assume you mean CSV not cvs, yes? please explain how to obtain your solution. Thanks, James

[ Permlink | « Hide ]

Petr Škoda - 07/Jul/08 05:56 AM

no cvs is a place where we store the source code, you have to install latest 1.9.1+ daily build, update from cvs or wait for the 1.9.2 (which should be released later this week) :-)

[ Permlink | « Hide ]

Mike Corb - 14/Aug/08 01:07 PM

If you create a grade scale as per the help instructions, separating the keywords with a comma and a space, the import will fail due to the stored scale having a space prepended to each keyword, eg when pasting in from the help text the string "Disappointing, Not good enough, Average, Good, Very good, Excellent!"

This is because of this line in grade/import/csv/index.php, approx line 382 :
$scales = explode(',', $scale->scale);

Returns " Excellent!" instead of "Excellent!"

So when the following line runs, " Excellent!" with a prepended space is not found.
$key = array_search($value, $scales);

[ Permlink | « Hide ]

Dan Marsden - 14/Aug/08 01:11 PM

Re-opening bug as Per mikes comments above - Petr - can we please trim the array vars returned by the explode before doing the array_search?

thanks!

:-)

Dan

[ Permlink | « Hide ]

Mike McDermott - 26/Aug/08 10:35 PM

As per the comments above, the gradebook has been changed so it will accept uploaded non-numeric grades. However there is still one slight flaw. If you upload a grade it will go through, to the final grade but the Grade still shows a numerical format. (with the range as well, e.g. 11/11) This will confuse our lecturers. As some will upload and some will enter manually (where it still reads pass, merit, distinction) then this will cause a problem.

Please see the screenshot - the 11/11 was uploaded while the others were entered manually.

[ Permlink | « Hide ]

Petr Škoda - 09/Oct/08 02:56 AM

trimming committed, the displaying on grader report is a different issue not related to this, please file a new report if needed
thanks everybody!