cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jacob_standish
Community Participant

Canvas API Calls using Google Apps Script

Home.pngSchedule.pngFood & Fun.pngPartners.pngHelp & FAQ.png

Tap/click map to enlarge

ic16_map_shavano_peak.png

Jacob Standish

Charlotte-Mecklenburg Schools - K12

Google Apps Script is an excellent platform to leverage API calls to Canvas. Learn how to use it to run actions from Google Spreadsheets and Forms like assigning users en masse to admin specific roles and sub-accounts to creating a way for teachers to create courses without affecting the SIS integration.

Comment and connect below
11 Replies
tim_hass
New Member

I hate I missed this session.  Just posting so I know when the video is ready.

Thanks for sharing your experience  @jacob_standish ​

emily_liepe
New Member

 @jacob_standish ​ thanks so much for your information in this session! It got me thinking about other uses and I was wondering if you or anyone else has had experience using this process for cross-listing?

I am thinking aloud here but trying to imagine a way to use the cross-listing and de-crosslisting API calls with Google apps scripts to create a form for teachers to use to select courses to cross-list. Would that be a good use case or are there other, better solutions? I've been brainstorming ways to help our teachers with this process and wanted to reach out and see if anyone has some good advice or experience to share?

Thanks so much!

-Emily

SHEBENE
Community Champion

The current chit chat is about the new interpretation of FERPA which makes crosslisting (in its current functioning) a violation. The new definition doesn't allow students to see the student roster of courses they aren't in which happens with crosslisting. I'm hoping that there's a new feature added to crosslisting that isolates the sections completely.

malgozzi1
New Member

The limit_privileges_to_course_section parameter on the enrollment API used to apply to teacher and TA enrollments only, but we've found it now applies to student enrollments as well. As described in the API: "Section-limited students will not see any users (including teachers and TAs) not enrolled in their sections." It has to be applied to each enrollment rather than the section or cross-listing as a whole, but if you're bulk uploading or looping through enrollments in a script, that should be easy enough to do.

In our current workflow, teachers select courses to cross-list from a list of courses they're teaching in a particular semester. That list is displayed on a web form that's generated dynamically after the teacher logs in. I'm sure you could write a script in Google Apps to cross-list courses once the form submitted, but I'm not sure if Google forms can be generated dynamically like that.

SHEBENE
Community Champion

Here's the FERPA discussion I was referring to. It sounds like the discussions still allow for viewing of other students even if the sections are marked as separate. Interesting topic though.

SHEBENE
Community Champion

emily_liepe
New Member

That's interesting, Neal! Thank you for the info!

-Emily

tim_hass
New Member

I have had trouble finding this session video in the Canvas Community or on the Canvas YouTube Channel.

Will this session video be posted?

Thanks in advance

jasond
Community Contributor

Hi All,

This is the Canvas course link to  @jacob_standish ​'s presentation.  The course contains the slide deck and the urls to used in the presentation.  The session was recorded, but it appears that  @biray ​ is still working on the content in order for it be uploaded.

Justin Ball​ from Atomic Jolt had another wonderful presentation on using the Canvas API and Google Docs at InstCon 2015.

I hope the links help!

biray
Community Champion

This session is available for viewing here:

biray
Community Champion

Sorry for the delay in uploading this conent,  @jasond ​. Somehow we missed this one Smiley Sad