Ways to View Large Data Sets

If there is a legitimate business need, ORRS can provide access to training records for larger groups of users. Some of the trade-offs are listed below. 

Pros & Cons of Report Options

• Request learners submit their transcripts or certificate of completion to you

  Ability LMS allows users to print individual certificates of completion for training provided at MSU or a full transcript of all courses (which include imported records of AVMA and CITI completions). You can request your students email or print these for you.

  • Pro - You can have unique RCR requirements (in addition or in lieu of Grad School standard).
  • Pro - If records don't properly import into Ability system, your students can submit their own documentation directly from CITI Programs, other vendor, their academic course, or a note from their PI.
  • Pro - You can use your own spreadsheets or databases to record completions. 
  • Pro - You can use this option in addition to any other options listed here. 
  • Con - Can be time-consuming or difficult to manage large student groups.
• Email Reports Sent to Unit

  Based on a data point (e.g. manager, department code, academic major, job title), reports can be sent periodically. You will need to work with the training support desk to determine the type of report that fits your need. 

  • Pro - You do not need to have the group added to your Manager People list mixed in with your subordinate employees.
  • Pro - You do not need to remember to check on student status.
  • Con - You cannot assign or remove an RCR track from individual students
  • Con - You cannot run impromptu reports yourself on the group.
• Proxy for another Manager(s)

  Manager/supervisors may request another user be given access to their existing subordinate list to assist with assignment and tracking of training for the supervisor.

  A user such can serve as a proxy to a unit head or for several PIs at once. In those cases, the training helpdesk can assist with filtering reports to focus on specific manager teams. 

• FlexiGroup(s)

  FlexiGroups are lists of users based on a data point(s) such as academic major code, department, manager, job title...).

  The Office of Research Regulatory Support has limited resources for creating and maintaining large team lists. Instead, we recommend creating a Flexigroup that automatically updates. For example, if someone leaves MSU, they are automatically dropped from your group. As students are accepted into a major, they are added to the group.

  Further, we can assist in automating the assignment of required training (tracks) using Flexigroups. 

  • Pro - You can add and remove an RCR track to a student individually.
  • Pro - You can run impromptu reports yourself on the group or all groups at once. 
  • Pro - You can still elect to have an RCR (or other track) auto-assigned to that group.
  • Con - The new group list will be added to your Manager People list and mixed in with your subordinates or other pre-existing team.
• Enterprise Data Warehouse (EDW)

  If your unit requires large data sets to update other enterprise software system, you may request access to LMS data in the Enterprise Data Warehouse. See Getting Access

  • Data transfer schedules