Community

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
j_p_t_m_gelisse
New Member

Identifying the course to which students in an appointment group belong

Jump to solution

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

 

Labels (1)
0 Kudos
1 Solution

Accepted Solutions
jerry_nguyen
Community Contributor

@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

 

 

View solution in original post

1 Reply
jerry_nguyen
Community Contributor

@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