My department is using Moodle Moodle 2.9.4+ (Build: 20160225) for our courses. We have been beta-testing outcomes assessment at the course and program level. We are now ready to implement learning outcomes assessment across all of our courses. However, in the process, our standard program learning goals have been reworded and our scale has been modified.
Since I cannot edit an outcome that is in use, I want to be able to notify instructors (or our IT admin) to remove the beta-tested outcomes from their assignments and courses. However, from Site Administration > Grades > Outcomes I can only see that 21 assignments in 23 courses have the outcomes attached. I cannot see which 23 courses, and I am not interested in sorting through all of our courses to find them.
Is there an easy way to obtain a list of these 23 courses? I will accept database queries as an easy solution so long as I can get some guidance on how write said query.