Is there any way to see what courses tutors have access to in canvas

[ian10]

Hi

Wondering is ther any way of finding out what courses tutors/instructors have been added to?

Any clues.

[jerry_nguyen · Accepted solution]

@ian10 

If you have Admin access, please follow the guide here: 📔How do I view the enrollments for a user in an account? 

[jerry_nguyen · Accepted solution]

@ian10 

Yes there are multiple ways 🙂

- Manually doing VLOOKUP with Provisioning reports

To get the provisioning reports go to Admin -> Settings -> Reports. Then download the following reports

• Enrollments (This report will show all user enrollments within an account
• Courses (To map course name with Enrollments table using "canvas_course_id")
• Users (To map user name with Enrollments table using "canvas_user_id")

- Getting site-wide data using Canvas Data

Canvas Data 2 allows you to create custom reports. Using Canvas Data, with a single SQL query you can get a list of courses being assigned to all trainers

You might need to contact your CSM to enable Canvas Data 2 for you. 

Feel free to send me a PM if you need help setting up Canvas Data 🙂

[jerry_nguyen · Accepted solution]

@ian10 

If you have Admin access, please follow the guide here: 📔How do I view the enrollments for a user in an account? 

[ian10]

Hi Jerry

Thanks for that, I do have admin access to our system.  The big problem is we are looking to see what courses multile ututors/instructors have.

I understand the way your are looking at, but it is rather a labourious task to look at each user the way described in the article you linked.

Hoping there is an easier way 😊

[jerry_nguyen · Accepted solution]

@ian10 

Yes there are multiple ways 🙂

- Manually doing VLOOKUP with Provisioning reports

To get the provisioning reports go to Admin -> Settings -> Reports. Then download the following reports

• Enrollments (This report will show all user enrollments within an account
• Courses (To map course name with Enrollments table using "canvas_course_id")
• Users (To map user name with Enrollments table using "canvas_user_id")

- Getting site-wide data using Canvas Data

Canvas Data 2 allows you to create custom reports. Using Canvas Data, with a single SQL query you can get a list of courses being assigned to all trainers

You might need to contact your CSM to enable Canvas Data 2 for you. 

Feel free to send me a PM if you need help setting up Canvas Data 🙂

[ian10]

Hi Jerry

Thanks for the offer of help, appreciated.

Going to look at the Canvas Data 2 feature as it may be useful in the future.

We got the info using the provisioning report and some playing with the Vlookup.

Cheers

Ian

[ian10]

Hi Jerry

Thanks for the idea of doing the provision report and then doing a VLOOKUP on the CSV file.

Ian

[jerry_nguyen · Accepted solution]

If you don't want to do VLOOKUP or set up Canvas Data, there is another easier way by using Canvas API. You can enter a list of trainers into a spreadsheet, then write a script to iterate through each trainer and display the enrolled courses (Using Enrollments API endpoint). If you would like to go down this path, let me know and I can assist you with the script.