This is my first post so please be gentle with me if I am posting in the wrong place. I am a tutor of 1st year Engineering students at Curtin Uni in Perth Australia. In several of our subjects we have rubrics set up and as you would expect when under time constraints etc you occasionally miss marking a section of the rubric for a submission. I've tried all sorts of things in SmartViews to try and identify these submissions. For example, say, section 3 of a report has not been marked, I want it to show up on some sort of smart view. For the life of me, I can't. Am I missing something here?
I know there is a report somewhere, the Unit Coordinator occasionally uses it, that shows how many sections of each rubric have been marked, For example, 100 submissions, section A, 100 marked, section B, 98, section C 100, hence two reports haven't been fully marked. It is then a laborious task to find out which, all the tutors checking their work. Surely there must be a way of IDing these incomplete reports? If memory serves me correctly, there is the ability to do SQL queries somewhere in the system. I know SQL so if I have to resort to that, that would be fine.
Any thoughts would be greatly appreciated,