Identifying the course to which students in an appointment group belong

[j_p_t_m_gelisse]

I am running a course with 450+ students, who belong to three different courses (and Canvasses) , but the content and exam of the courses are the same for all students. To organize an exam inspection, I have set up an appointment group in which the students from the 3 courses can enroll simultaneously (bij choosing multiple course calendars). Now I would like to identify for each student who has enrolled for the inspection, to which course he or she belongs. Is this possible in Canvas?

Any help/suggestion appreciated!

John

[jerry_nguyen · Accepted solution]

@j_p_t_m_gelisse 

It's not visible through the UI interface. However, you can achieve this in 2 ways

• Using built-in Enrolments Provisioning report

This report will list all student/teacher course enrolments, you can then use this list and simply do a VLOOKUP in Excel against your appointment booking list.

You can ask your admin to run this report for you from the account setting -> Reports -> Provisioning

• Using Canvas API

This method is more advance in which you will need to write a program to request data from Canvas API (E.g. easiest is to write a VBA code in Excel). 

First, you can get a list of registered students via this endpoint https://canvas.instructure.com/doc/api/appointment_groups.html#method.appointment_groups.groups , then iterate each student in the list to get enrolment data through this endpoint https://canvas.instructure.com/doc/api/enrollments.html#method.enrollments_api.index and display the data on the spreadsheet