Canvas Data 2 - Dataset Field suggestions

[Jeff_F]

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?

[stimme · Accepted solution]

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

[Jeff_F]

@stimme  Yes, this does work -

IF CONTAINS([Comment], "This is a media comment") THEN 'Has Media'
ELSE "-"
END

The CD1 schema should probably note this in the description.  ;o)   https://portal.inshosteddata.com/docs#submission_comment_dim 

Additional data points for media would be useful.