3 of 3 people found this helpful
I'm assuming you're looking at the gradebook_grade table, the column descriptions aren't great unfortunately, it would be nice to get clarification what "Ready to Post" means:
I'm not sure how much you know about the Blackboard database, but I would suggest going a step further than the gradebook_grade table, into the attempt table, a very simplified representation of this linkage:
Using the attempt table as well can give you some nice information about multiple attempts, the 'average score' in the gradebook_grade table gives you exactly that, when you're using the attempt table, you've got access to information about when those multiple attempts happened, you could use that to track a student's performance over time, show min/max/avg or standard deviation.
I believe the difference between score and grade relates back to your grading scheme, a score might be, for example: 90. The possible marks might be 100. Going with an A,B,C,D,... scheme, a 90% would probably correspond to an 'A'. In this example, SCORE would be 90, and GRADE would be A.
I'm curious, have you looked into what you can get with grade information from the Blackboard API, rather than direct database queries?
Thanks Ashley Fisher for this useful info.
Well, we have looked in the database scheme and used the Support Tools > DB connect with pool and tried some queries.
This is what we have so far:
select gg.MANUAL_GRADE, gm.title, gg.exempt_ind from gradebook_grade gg
INNER JOIN gradebook_main gm ON gm.pk1=gg.gradebook_main_pk1
INNER JOIN course_main cm ON cm.pk1=gm.crsmain_pk1
INNER JOIN course_users cu ON gg.COURSE_USERS_PK1=cu.pk1
INNER JOIN users u ON cu.users_pk1=u.pk1
and cu.available_ind = 'Y'
and cu.row_status = 0
and u.user_id = 'testuser'
and u.available_ind = 'Y'
and cm.available_ind ='Y'
and cm.row_status = 0
and (MANUAL_GRADE is not null OR gg.exempt_ind='Y')
So far we have the manual override score and (if applicable) the exempt Y or N.
But we couldn't find the field where we can find the test and assignment scores, or at least some logic used by scoring.
Now we are looking into the Java API, we found the score (calculated by Bb) and the manual override score, but can not seem to find the Exempt function.
Any idea where we have to find it?
1 of 1 people found this helpful
I don't know about the Java API, but if you decide to look at the REST API, it has exempt.
We undertook some similar work to this last year. Exporting grades is a bit of a pain as you've discovered so I'll add another vote for going via a web service.