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

[bruynent]

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

[Alexandre_Sch · Accepted solution]

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.

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: 

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.

[Stef_retired]

 @Alexandre_Sch ‌

What a great answer you gave! Thanks for being so helpful to your fellow community members, especially in these difficult times. Please check your direct messages for a small token of our appreciation. :0)

Thanks again for all that you do and keep up the good work!

Sincerely,

Canvas Community Team

[Alexandre_Sch]

Hey 😃 

Helping is the better way i know to learn more about Canvas o/ 

Regards,

Alexandre S.

[Stef_retired]

That's awesome,  @Alexandre_Sch ‌; it's definitely how I learn best.