About

samuel-vanhorne
Samuel Van Horne
Rank:
Community Novice
Title:
Joined:
Feb 29, 2016 8:33:05 AM
Posts:
11
Solutions:
0
Likes Received:
42
Bio:
An amazing Instructure Community member

Most Liked Posts

That's right--and if the table is sorted by course_id>user_id>timestamp>session_id then you just need to use the timestamps in the first and last row of each unique session_id (per studen...
Likes: 5
Ryan,I think one way to do this is to determine the period in which you are counting the number of times a user has logged in to a course. That might be more difficult than it sounds. But it seems lik...
Likes: 5
I think it depends on how Canvas Data can help you answer a question you have or augment some kind of early-warning system that you might be using. It's useful to have a guiding question so that w...
Likes: 5
I was curious about my question so I went digging...Session_id is unique for each timestamp_day value in requests--it's the session for someone's daily activity across Canvas. Thus, you could ...
Likes: 4
When will the 'TBD' values be corrected in the information about the pseudonym_dim table? https://portal.inshosteddata.com/docs#pseudonym_dim
Likes: 4

Most Recent Posts

Hi Jeff,We are still new at this, but there has been some work with the Canvas LMS before that you can look up. I recommend looking up the work of people like Mimi Recker and Andrew Walker, who have s...
Mar 15, 2017 2:47:20 PM
Hi Lance,I'm not aware of how to use the API--our database is hosted by Unizin in the Amazon cloud. I misunderstood what you meant by "outcomes". I thought you were talking about assignmen...
Jul 14, 2016 6:41:05 PM
Can you be more specific about the outcome you are looking for? We use Canvas Data to go in the opposite direction (that is, use assignment_dim to find the assignments and then submission_dim to find ...
Jul 14, 2016 11:12:08 AM
Hello,I share your confusion, but Instructure (in the schema) says that the description of "last_request_at" is "TBD," so the schema is not of much help here. I do think that the value...
Jul 14, 2016 11:00:48 AM
I was curious about my question so I went digging...Session_id is unique for each timestamp_day value in requests--it's the session for someone's daily activity across Canvas. Thus, you could ...
Jul 6, 2016 12:01:33 PM

Latest Badges

25 Likes Received

25 Likes Received

Earned: 2024-01-05

First Like Received

First Like Received

Earned: 2024-01-05

Instructure Community: 7 Year

Instructure Community: 7 Year

7 Years with Instructure Community

Earned: 2024-01-03

Instructure Community: 6 Year

Instructure Community: 6 Year

6 Years with Instructure Community

Earned: 2024-01-03