Cohort reports

Cohort reports

by 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?

Average of ratings: -
In reply to Ain Roesley

Re: Cohort reports

by Baba Tanqueray -

I have the same issue, going course by course is onerous and this is a regular report I must make to my superiors. How to expedite please.

Average of ratings: -
In reply to Ain Roesley

Re: Cohort reports

by 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

Average of ratings: -
In reply to Elizabeth Dalton

Re: Cohort reports

by 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
Average of ratings: -