a1222679
Community Contributor
Activity Feed
My Posts
Post Details Date Published Views Kudos

Student Group Creator User_ID

I use Canvas flat file data for all manner of reporting within our institution.  I've recently been looking into student groups and one thing I'd like to know is who created the groups.  It...

06-30-2020

568

0

Student and Resource Weekly Data

Not a question so much as an issue I'd like to raise.  When I looked at weekly activity and selected a particular week the student data was filtered to that week but the resource use data rem...

09-12-2019

244

1

Quiz Override

I have a request/suggestion..   ASSIGNMENT_DIM has a VISIBILITY field which tells me whether the original version of an assignment is valid to any users following an override or if only the o...

05-24-2018

288

0

Filtering for Course Q&A Discussion Forums in Canvas Data

I’ve been trying to separate the ‘Course Q&A Discussion Forum’ discussions from the others by using DISCUSSION_TOPIC_TITLE in the DISCUSSION_TOPIC_DIM.  This works in the majority of cases b...

01-28-2018

574

0

Course Workflow State Changes

Is there a way to find out when a course changed states?  I'd like to know when published courses were published if that was possible.  I'm trying to workout the actual lifespan of cour...

11-14-2017

1362

1

Embedded Video

I'm looking for a way to identify courses within Canvas that have embedded video content.  I've tried using the 'body' field in the wiki_page_dim table but this only shows the first 250 characte...

06-05-2017

471

0

Multiple Due Date Assignments

I've noticed that assignments with multiple due dates show 'null' in the Due_At column of the Assignment_Dim table.  In my query builder I've joined Assignment_Dim.Assignment_ID=Course_Dim.Assig...

03-22-2017

902

3

Wiki Page Data

I'm trying to get information relating to all of the wiki pages contained within a course from the Canvas data.  Looking at the wiki and wiki page dimensions I get only 1 wiki per course.  ...

02-02-2017

1487

3

Page View Query

I'm trying to get page view statistics for all students in all courses from the Canvas data and presume that I would need to interrogate the requests table in some way.  So far I haven't been ab...

01-11-2017

745

1

Is there any way to discern when a course was published (became 'available')?

I'm looking at the Course Dimension table from the Canvas data but can't find this info.  Does anyone know if it is available somewhere?

01-10-2017

1274

5

Active Student Enrollment List

Does anyone know of a way to create a list of active enrolled students at a specific previous date? Thank you in advance for your help.

12-22-2016

1030

2

ECHO360 Exports and Canvas Data

I'm wondering how I can link Echo360 exports csv's with my Canvas data files in a visualisation tool.  The unique values in the export are the Canvas User ID and the Email Address columns. ...

11-30-2016

358

0

File Count Userscript

I installed Canvas-Files-Get_Files.user.js and Greasemonkey and ran it to count the files in a course.  The result was... This course has these file counts: 217 application/pdf ...

10-06-2016

437

3

Edited Courses

I'm new to working with this data and wondered where I might find information about which courses have been edited and when.  I'm looking at edits to things like Quizzes, Discussions, Wikis and ...

09-19-2016

674

3

View All Posts
My friends
Community Statistics
Posts 65
Solutions 3
Kudos given 23
Kudos received 108
Member Since ‎08-25-2016