Cohort reports

Cohort reports

Ain Roesley - દ્વારા
Number of replies: 4

I've been given Manager role in my Institute's Moodle. One key concern from my stakeholders is that they want to be able to export a report of list of students and all the courses they are enrolled to and have complete or yet to be completed. 

I know you can do this at a course level. But that's every tedious if you have 20 courses. Can we do this at a users/cohorts level instead?

In reply to Ain Roesley

Re: Cohort reports

Elizabeth Dalton - દ્વારા

At this point, you will need to develop a report to summarize this information. You can write the report in PHP using the reports API, or use one of several tools, including:

Ad-Hoc Database Queries

Configurable Reports

Third party solutions like Intelliboard

Best wishes,

Elizabeth Dalton

In reply to Elizabeth Dalton

Re: Cohort reports

Ashwini Borole - દ્વારા
I am struggling to find cohort sync and course mapping. I wish to write SQL query to list down cohorts and courses for which cohort has been used during enrollment ( enrollment method: cohort sync)

Not able to find the table which has mapping of cohortid and courseid