AnsweredAssumed Answered

Current Force Completion Tests?

Question asked by kd0043639 on Mar 22, 2018
Latest reply on Mar 30, 2018 by lc32244

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?