How do I get an excel file that includes the Assessment Group heading and class?

Jump to solution
bruynent
Community Novice

Hi all, 

I am wanting to pull out some data in an excel file that includes:

  • all the courses from an active term
  • the teacher
  • the assignment group
  • the assignment 

How can I do this in Canvas? Any help would be greatly appreciated!

Kind regards, 

Tahnee

1 Solution
Alexandre_Sch
Community Contributor

Hi Tahnee, 

You will need to work with multiple reports to achieve ur need: 

First report: You can filter Multiple terms and a start/end date.

351552_pastedImage_1.png

Using the canvas course id, you can make a "VlookUp - excel" with other report that handle the Course and the Instructor/teacher that are designated for that

SIS Exports -> Enrollments -> You will get: 

351553_pastedImage_2.png

After doing the vlookup, you can filter the role/role_id to get only the teachers.

These reports can be found in: Admin - Configuration - Reports (ask for your admin if you don't have access to it).

Hope it helps!

Regards,

Alexandre S.

View solution in original post

0 Likes