Set User Grade - Calculated in Grade Objects Log in a course with no grade book set up
I'm trying to create a data flow to determine which courses are actively using the grade book. I think I'm just going to filter out all categories, Final Calculated, and Final Adjusted grade objects, and then look at the latest actions logged to make sure that grades have been entered and not just grade items created and then never used.
I thought I could just do a left join with Grade Objects and Grade Objects Log since I thought that if a grade book had never been used in a course, there would be no actions logged in the Grade Objects Log data set. However, that doesn't seem to be the case.
Almost every course that just has the Final Calculated Grade and Final Adjusted Grade with no grades entered into the grade book still has Set User Grade - Calculated logged as an action on the Final Calculated Grade when the course was created. I also came across a handful of courses that had no actions logged at all, so that makes it more confusing.
So I'm wondering what exactly does Set User Grade - Calculated mean?
Réponses
-
Hey @Jennifer.Wagner3830,
Thanks for reaching out to us here at the Brightspace Community! The Set User Grade - Calculated option allows instructors to set a grade for a student based on a calculated formula, rather than manually entering a grade.
You can use a calculated grade item to display a user's cumulative achievement across multiple grade items. Unlike the calculated final grade, calculated grade items do not recognize grade category settings of the grade items they evaluate, such as exclusion or distribution options. They cannot belong to a category and they cannot contribute to the calculated final grade.
-
In the Grade Objects Log data set, why does Set User Grade - Calculated get logged as an action on the Final Calculated Grade in a grade book that has no grade items and has never been used?
The documentation for that data set says that it "returns a log of all changes to grades for each applicable user in the organization". If the instructor has never even set up the grade book in the course, then how can there be changes to grades in that course?
-
To make things more confusing, I've noticed that students will have a LastModified date logged in Grade Results as well, even when the gradebook has not been set up and there are no grades entered in the course.
If there are no grades in the course, I assumed that there would be no rows in Grade Results or Grade Objects Log for that OrgUnitId, but that is not the case. Some students have a date in Grade Results.LastModified while Grade Objects Log.Modified is null, and some students have identical dates in both Grade Results.LastModified and Grade Objects Log.Modified, on the Final Calculated Grade with the action of Set User Grade - Calculated. And sometimes in the same course, some students will not appear in either data set (which is what I expect if there are no grades).
Can anyone explain this discrepancy and what exactly is being logged in LastModified and Modified? (The dates do not match user enrollment or last course access dates either, btw)
-
Hi Jennifer,
Not sure if you resolved this yet. We recently used the Instructor Usage data set to track Grades and Assignment Usage. The data set gives the Number of Assignments, Number of Assignment Submissions Commented on, Number of Grade Items and Number of Graded Grade Items. The assumption being if Grade Items is greater than 2 the instructor is using the Grades tool (accounting for 2 default columns of Adjusted Final Grade and Calculated Final Grade).
