Hi all, I was looking for a way to see how many tests were deployed this semester that use forced completion. We have tons of courses that are created via course copy, so they will include dormant assessments using FC. That makes me think I need to link my current query
select cm.course_id, count(ca.pk1) as fcassessments from bb_bb60.course_assessment ca, bb_bb60.course_main cm, BB_BB60.COURSE_TERM ct where ca.crsmain_pk1 is not null and ca.CRSMAIN_PK1 = cm.pk1 and ct.CRSMAIN_PK1 = cm.PK1 and force_completion_ind = 'Y' and ct.TERM_PK1 in (select pk1 from BB_BB60.TERM trm where trm.sourcedid_id = '201810') group by cm.course_id ;
to grade center columns... Has anyone done this? Is there a simpler way?