Grade Me
Maintained by
Tyler Bannister, Logan Reynolds, James McQuillan
Shows a teacher all of the assignments and manual quiz questions (essays and file responses) that have been submitted, but not graded.
Comments
Comments are no longer open for new posts. Existing comments remain available to read.
we have tried to install grade me on Moodle 3.0 version
with ORACLE DB and during the installation we have received this error:
ORA-01408: such column list already indexed
CREATE INDEX q_blocgradme_id_ix ON q_block_grade_me (id)
Error code: ddlexecuteerror
For the same type of error (ORA-01408) we have found in the web site
http://www.techonthenet.com/oracle/errors/ora01408.php ,
This explanation:
You tried to create an index on a set of columns in a table, but you've already indexed this set of columns.
If we comment this line in install.xml
KEY NAME="id" TYPE="foreign" FIELDS="id" REFTABLE="grade_items" REFFIELDS="id" PREVIOUS="primary" NEXT="courseid"
the installation goes ahead.
Using Mysql installation in phpmyadmin we have found the following warning:
The indexes PRIMARY and mdl_blocgradme_id_ix seem to be equal and one of them could possibly be removed.
Can we just ignore this key or is it important for the functionality of GRADE ME?
There is a setting for the grademe block which will enable forums to be included.
I recently upgraded to moodle 3.0 and I also upgraded the grade_me block to the newest version; however, after doing this I was greeted by an old problem with the block.
What used to happen in 2.9 and is once again happening is when I click an assignment to be graded, the plugin redirects me to the wrong assignment instance. I think it has to do with the "&rownum=0". It always takes me to the first student enrolled in the course, rather than the student I clicked on.
As I mentioned, this happened a while ago in 2.9 as well, but an update to the plugin fixed this issue. I really love this plugin, so I hope that this can either get fixed or maybe that I did something wrong while updating the plugin.
Thanks in Advance
Jeroen
Incase anyone also wants Grade Me to ignore any hidden assignments I've amended the code in plugins/assign/assign_plugin.php to the following:
$query = ", asgn_sub.id submissionid, asgn_sub.userid, asgn_sub.timemodified timesubmitted
FROM {assign_submission} asgn_sub
JOIN {assign} a ON a.id = asgn_sub.assignment
JOIN {course_modules} cm ON a.id = cm.instance
LEFT JOIN {block_grade_me} bgm ON bgm.courseid = a.course AND bgm.iteminstance = a.id
LEFT JOIN {assign_grades} ag ON ag.assignment = asgn_sub.assignment AND ag.userid = asgn_sub.userid AND asgn_sub.attemptnumber = ag.attemptnumber
WHERE asgn_sub.userid $insql AND asgn_sub.status = 'submitted' AND a.grade <> 0 AND cm.module='22' AND cm.visible=1
AND (ag.id IS NULL OR asgn_sub.timemodified > ag.timemodified)";
So far from testing we think this is having the desired effect.
We have added the Grade Me block and use Groups and Groupings but it is displaying assignment submissions to all tutors - including those not allocated to that particular assignment. When a non-allocated tutor clicks on the link it does say ‘this is currently hidden’ but I would prefer if it didn’t show at all. Is there any way to solve this?
Fantastic plugin! Just wondering, is there a way to get it to ignore Assignments that have been hidden? Or another way from it to ignore certain assignments?
Thanks for the reply. Being able to include lessons in the plugin would be a great asset to me. As the plugins for differen activity types don't seem too difficult, I can hopefully build it myself. Did you look into it earlier? Is it hard(er than I expect)? If you have any pointers on the lesson DB structure or other tips, I would very much welcome them. Thanks a lot in advance!
The 3.0-specific version of Grade Me block has been published, and thank you for your comments - I will be checking through and filing tasks for us to fix any remaining issues.
Any help? Thank you!