Hi Sam
Thanks for clarifying, the table mdl_facetoface_signup_status has fields statuscode and grade
It looks like a fully attended session has status code of 100 and grade of 100
Partly attended has a status code of 90 and grade of 50
No Show has a status code of 80 and Grade of 0
Can you check this is the same values for you by taking some attendance and looking at the table as this may vary between versions.
Regards
Craig