Canvas Data 2 - Dataset Field suggestions

Jump to solution
Jeff_F
Community Coach
Community Coach

Hello - I've received three requests to report on faculty use of media comments as submission feedback. As we are aware, CD1 does not have data points for media comments.  Upon review of the upcoming CD2 schema, I see submission_comments columns for media_comment_id and media_comment_type but no additional metadata about media is listed.  And so I'd like to suggest a field for media duration in format such as hh:mm:ss .  This will enable better reporting on how media is used.

The CD2 schema - 
https://docs.google.com/spreadsheets/d/1axjhLwPY4N16SAf61-X8xj3kSg_Ey-PXvcsUTtojRoo/edit#gid=1473158...

 

What additional data fields would be helpful?

 

1 Solution
stimme
Community Coach
Community Coach

Hey Jeff, Sorry if this is old news, but the CD1 submission_comment_dim table does have comment = "This is a media comment." for media comment records. This might be useful for your report in the short term. - Sam

View solution in original post

0 Likes