Use the query below when you want to find the grades for a student. The ‘Actual Grade’ is what they earned from their attempt, when the system automatically graded their assessment or exam. The ‘Manual Entry’ is any modification made to that grade by an instructor entity.
u.user_id as 'Student',
gbm.title as 'Assignment',
gbl.grade as 'Actual Grade',
gbg.manual_grade as 'Manual Entry',
gbl.attempt_creation as 'Attempt'
from gradebook_grade as gbg
join course_users as cu on gbg.course_users_pk1 = cu.pk1
join users as u on cu.users_pk1 = u.pk1
join gradebook_main as gbm on gbg.gradebook_main_pk1 = gbm.pk1
join course_main as cm on gbm.crsmain_pk1 = cm.pk1
join gradebook_log as gbl on gbm.pk1 = gbl.gradebook_main_pk1 AND u.pk1 = gbl.user_pk1
where (cm.course_id) = 'ENGL-1301-052IN-FA2013' and u.user_id = 'aclark13'
order by u.user_id asc, gbm.title asc