Wednesday, July 05, 2023

cohort query on moodle

There was a request to identify each user in some courses and the status of course completion, where the users were part of a cohort in Moodle.

My reply was something like this.

We can search for users by cohort in
Site Administration --> Users --> (use a filter) Cohort ID contains -- <name of our cohort>

Then we get the list of the 28 users in that cohort.
I have copy-pasted that list to the
"CohortTR2023001" sheet of a Google spreadsheet,
where you can find that 16/28 of them have never logged in.

Progress of the other 12 can be found by filtering the "activity completion report" of the relevant courses to include only the users in the "Cohort TR2023001" sheet, like I have done for the t3 course in a Google sheet - but for the t3 course, none of this cohort seem to have completed any of the activities

Link dump:

https://moodle.org/mod/forum/discuss.php?d=345963
led to
https://docs.moodle.org/32/en/ad-hoc_contributed_reports#Cohorts_by_user

https://www.youtube.com/watch?v=JceuROs6b1w
(seems to have course completion as report source, which we don't have)

How to set up course completion
https://www.youtube.com/watch?v=WItBsqLLlyg
(OK for at least one course of this cohort of ours)
So, that shows Course Completion as part of the reports in the course.
For T3, there is "Activity Completion"
Downloading that as csv, then filter by cohort users in google sheets?

Because according to
https://moodle.org/mod/forum/discuss.php?d=418752
"cohorts isn't one of the filters specfied in the documentation"

More about cohorts - how to add a cohort
https://www.youtube.com/watch?v=RSe3UsE5TaA
Site Admin - Users - Cohorts - Assign button for our cohort => list of users.
But can't copy from there.

https://moodle.org/mod/forum/discuss.php?d=244963
"Cohort is one of the ways you can filter by"


No comments:

Post a Comment