Lightning Talk

Design of an Interprofessional Education Database for Use by Administrators, Faculty and Students Across Different Health Science Schools

Tuesday, October 20, 2020, 12:05 pm - 1:05 pm EDT
Sample video
Lightning Talk Presentation
Sample video
Lightning Talk Live Discussion Recording

The health science schools at the University of Michigan (U-M) have devoted considerable effort towards developing interprofessional education (IPE) offerings administered through the U-M Center for IPE to enable our student learners to learn about, from, and with each other so they are better prepared to achieve the quadruple aims in healthcare. As the number of IPE offerings has expanded, it has become increasingly challenging to manage information about our IPE offerings such as the type of experience offered, student learners involved, and IPE competencies addressed. Further, the information is not stored in a manner that enables ready visualization and reporting to our various stakeholders. We addressed this challenge by using informatics to design a database that captures essential data elements associated with each of our IPE offerings that are needed to visualize and report information specific to the needs of each of our constituent stakeholders - administrators, staff, faculty, and students - across all 10 of the U-M health science schools.


Our design work was informed by a set of constraints and the types of queries anticipated by stakeholders. Constraints included: (1) the database had to be easily maintained in spreadsheet format, and (2) each IPE offering had to be associated with a unique course identifier in the campus learning management system (Canvas) so that offering attributes could be associated with individual students, and, with IRB approval, with institutional student record data. We defined the data elements for each IPE offering needed to create data visualizations and reports for our various stakeholders using querying software (Tableau). To date, the database design is complete; we are now creating report and visualization formats for usability tests with stakeholders. In this talk, we will share the elements of our database that may be useful to others engaged in IPE.

Accreditation Details

In support of improving patient care, this activity is planned and implemented by The National Center for Interprofessional Practice and Education. The National Center for Interprofessional Practice and Education is accredited by the Accreditation Council for Continuing Medical Education (ACCME), the Accreditation Council for Pharmacy Education (ACPE), and the American Nurses Credentialing Center (ANCC) to provide continuing education for the healthcare team.

As a Jointly Accredited Provider, the National Center is approved to offer social work continuing education by the Association of Social Work Boards (ASWB) Approved Continuing Education (ACE) program. Organizations, not individual courses, are approved under this program. State and provincial regulatory boards have the final authority to determine whether an individual course may be accepted for continuing education credit. The National Center maintains responsibility for this course. Social workers completing this course receive continuing education credits.

This activity was planned by and for the healthcare team, and learners will receive Interprofessional Continuing Education (IPCE) credit for learning and change.

  • Physicians: This activity will be designated for CME AMA PRA Category 1 Credit(s)TM through ACCME.
  • Physician Assistants: NCCPA accepts AMA PRA Category 1 Credit(s)™ from organizations accredited by ACCME or a recognized state medical society.
  • Nurses: This activity will be designated for CNE nursing contact hours through ANCC.
  • Pharmacists and Pharmacy Technicians: This activity will be designated for CPE contact hours (CEUs) through ACPE.
  • Social Workers: This activity will be designated for social work continuing education credits through ASWB.
  • All health professionals: This activity was planned by and for the healthcare team, and learners will receive Interprofessional Continuing Education (IPCE) credit for learning and change.