Community Reports

Jon Miron

March 20, 2023 17:54

IN THIS ARTICLE
Points Report
Data Dictionary (for Overview Points Report)
Member Report
Data Dictionary
Community Report
Data Dictionary

For purposes of research, monitoring, and posterity, we supply Community- and Member-level CSVs containing over 125 combined columns of data. Using these CSVs, researchers can precisely measure how many Posts and Comments students are viewing, how many hyperlinks students have clicked, how many students have been at-mentioned, how many videos have been shared, and so on.

We encourage researchers to use these CSVs to perform independent efficacy studies. We also encourage those with coding experience to import these CSVs (along with the data dictionaries in this article) into Python or R for supplementary data manipulation and visualization. If your findings are interesting, surprising, and/or particularly robust, let's talk! We pride ourselves on our evidence-based, empirically-informed digital pedagogy, and we're keen to recalibrate our recommendations in light of new data. Do reach out at clientsuccess@yellowdig.com.

Points Report

To download a detailed log of each Community Member's activities (e.g., Posting, Commenting, Reactions received/given, etc.), select Data -- Reports -- Points Report (from the left navigation pane) and click the Download Detailed Points Log button. To download a basic report with each student's total Yellowdig points and Participation Grade, click the Download Points Summary button.

💡Client Success Tip

Suppose you are unable to configure grade passback for your Learning Management System. In that case, you may be able to upload the Overview Points Report (which can be generated by clicking the "Download Points Summary" button) to your LMS gradebook at the end of the term. This will allow you to post students' Yellowdig grades to your gradebook with minimal manual effort.

Screenshot depicting Points Report tab

In addition, you can see detailed logs of each student's activities by clicking the Show Log button. Finally, you can manually add or subtract points to a single student or all at a time by selecting them and clicking the +/- Adjust Points button as depicted in the screenshot below.

Screenshot depicting Points adjustment

Note: Points can also be awarded/deducted for a particular past date regardless of the current grading period. Points attributed to the past date will be counted in excess of the weekly point max.

Data Dictionary (for Overview Points Report)

overview_point_report_dict = {
  'user/username': 'Username of member',
  'user/firstname': 'First name of member',
  'user/lastname': 'Last name of member',
  'user/primary-email': 'Primary email address of member',
  'Total Points Earned': 'Cumulative Yellowdig point total. Can exceed Total Point Goal for Community.',
  'Participation Grade': 'Current Yellowdig grade of member (as percentage). Cannot exceed 100%.'
}

Member Report

To produce a Member Report for your Community, select Data -- Reports (from the left navigation pane). Go to Member Report and select CLICK HERE TO GENERATE REPORT. Use the arrow keys to move left and right across the table. Click on the column names to sort by column. To export the Member Report to CSV, select CLICK HERE TO DOWNLOAD AS CSV.

CSV contains one row for each Community Member, 35 columns, and counting.

Screenshot depicting Member Report tab

Data Dictionary

member_dict = {
  'user_id': 'unique Yellowdig user identifier; appears only in URL',
  'user_username': 'unique Yellowdig user identifier; surfaced to end-user in platform',
  'user_first_name': 'first name',
  'user_last_name': 'last name',
  'user_email': 'primary email address',
  'community_role': {'instructor': 'created Community', 'facilitator': 'admin, not creator', 'student': 'member, not admin or creator'},
  'total_number_of_logins': 'number of LTI launches into Community',
  'total_number_of_friends_followed': 'number of Members of this Community that this Community Member follows',
  'total_number_of_friend_followers': 'number of Members of this Community that follow this Community Member',
  'total_number_of_student_friends_followed': 'number of student Members of this Community that this Community Member follows',
  'total_number_of_student_friend_followers': 'number of student Members of this Community that follow this Community Member',
  'total_number_of_posts': 'number of posts authored',
  'total_number_of_comments_given': 'number of comments authored',
  'total_number_of_comments_received': 'number of comments received from other Community Members on posts authored',
  'total_number_of_posts_with_accolades': 'number of posts authored that received at least one accolade',
  'total_number_of_comments_with_accolades': 'number of comments authored that received at least one accolade',
  'total_number_of_posts_with_reactions': 'number of posts authored that received at least one reaction',
  'total_number_of_comments_with_reactions': 'number of comments authored that received at least one reaction',
  'total_number_of_orphan_posts': 'number of posts authored that received no comments',
  'total_number_of_at_mentions_given': 'number of times user @mentioned another Community Member; multiple @mentions to the same Member in the same post or comment count as just one @mention',
  'total_number_of_at_mentions_received':'number of times user was @mentioned by another Community Member; multiple @mentions from the same Member in the same post or comment count as just one @mention',
  'total_number_of_instructor_post_reads': 'number of posts authored by Community Owner or Facilitator that user marked as read',
  'total_number_of_student_post_reads': 'number of posts authored by student Member that user marked as read',
  'total_number_of_instructor_post_views': 'number of posts authored by Community Owner or Facilitator that user viewed',
  'total_number_of_student_post_views': 'number of posts authored by student Member that user viewed',
  'total_number_of_hyperlinks_shared': 'number of hyperlinks shared in posts and comments',
  'total_number_of_hyperlink_clicks': 'number of hyperlinks shared in posts and comments that user clicked; multiple clicks on the same hyperlink count as only one click',
  'total_number_of_images_shared': 'number of images uploaded',
  'total_number_of_drawings_shared': 'number of drawings created via Draw tool',
  'total_number_of_videos_shared': 'number of videos uploaded or captured inside platform',
  'total_post_word_count': 'total number of words in authored posts',
  'total_comment_word_count': 'total number of words in authored comments',
  'total_number_of_deleted_posts': 'total number of authored posts that have been deleted',
  'total_number_of_deleted_comments': 'total number of authored comments that have been deleted',
  'lti_grade': 'grade most recently passed back to LMS'
}