I would also love this feature to. My TA's "have" to use a more functional gradebook that does reports and many other gradebook features, but if I was able to import grades, I could have them doing grades once, instead of double duty!!!
Ideally it would be nice to have a seriously functional gradebook here. spreadsheet views, simple report generations for individuals and course students, etc.
It would be great if you have time to check that out and give us some feedback.
Importing grades has some of the same sort of issues that the central grades table has:
- since Moodle is built on the concept that modules handle grades, that modules may change grades and grades may be based on calculations of the modules (average scored quizzes, lessons, etc.) importing grades or setting grades manually raises the question of priority: if a grade is set manually in an external file or central table is the the module then locked out of changing it?
- and if so, how (technically) to accomplish this when the modules are designed to control their own grades?
- some graded items give feedback: eg assignment, essay questions in lesson, the student is told here is your points and feedback, then later the points change via a manual action of the teacher or ta, how is the feedback handled to let the student know why their first grade was later changed?
I know this would be benefitial in large classes when students come to the prof for points after going to the TA, sometimes trying to get points back twice. If the Prof changed the grade w/ a note, then if the TA went in s/he'd see that the student had already gotten the points back. This also helps when trying to remember if you had updated a score or not.
I'm very excited about the gradebook redesign stuff going on, but in the near term, I really need upload capabilities as soon as possible. Can anyone point me to a recent, working version of such upload code? Girishan, would you be willing to share again? Thanks!
(and hi, Solomon!)
The import file format looks like this:
Here ### in the first line should be replaced by the assignment number into which you are uploading the grades. If you click on the assignment link the url will look like: http://yourmoodlesite/mod/assignment/view.php?id=###
You also need to make a few modifications to your course/grades.php
file (make a backup first). Add the line:
right before the line:
$strgrades = get_string("grades");
Also right after the line:
print_single_button("grades.php", $options, get_string("downloadtext"));
add the following lines:
echo "</td></tr><tr><td colspan=\"2\">\n".
"<form method=\"post\" enctype=\"multipart/form-data\" action=\"grades.php\">\n".
"<input type=\"submit\" value=\"Import Grades\">".
"<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"get_max_upload_file_size()\">\n".
"<input type=\"hidden\" name=\"id\" value=\"$course->id\">".
"<input type=\"file\" name=\"gradefile\" size=30>\n".
The next line (in the original grades.php) after these newly added lines should be:
Make sure that you use a plain text editor to edit grades.php, NOT a word processor.
I placed import_grades.php in the courses folder and modified grades.php as outlined above.
I bring up the grade book and the buttons for import and selection of a file are now present. I then determined the assignment number and created a file that looks like this:
I can select the file but when I try to import the file, I'm told that the module is incorrect.
I figured I was doing something wrong.
I'll give it another try tomorrow using the the id from the mysql database. I guess that means I need to finally get around to learning how to use phpMyAdmin to find the outside event and the ID number.
"Outside events" is a separate resource module and will show up in the gradebook. Still, if the only module one can import to is an assignment, I'll modify my classroom exam scores to fit the assignment module. Given the fact that the "Outside events" module does not sort alphabetically for score entry, I'll likey be happier after making the change.
I'll let you know how it turns out and thanks for the help. I guess that what people say at the U of Akron about OSU faculty is not true afterall.
Suggest you all make your suggestions on the thread referenced below. GradeBook2 is being worked on aggressively right now. The issue of grade importation (from what I recall) has been discussed in different places in the different forums at Moodle.org, so it is something many are interested in. Myself, included.
Gradebook 2 into Moodle 1.5
I think that including your thoughts on this matter would be good because it is an important tool for a gradebook.