Excel for data visualization in academic health sciences libraries: a qualitative case study
DOI:
https://doi.org/10.5195/jmla.2020.749Keywords:
Data Visualization, Microsoft Office, Library Outreach, Library Instruction, Data Services, Data, Data Analysis, Qualitative Studies, Qualitative Case StudiesAbstract
Background: Data visualization is a growing topic of discussion and area of educational programming in health sciences libraries. This paper synthesizes information on eight institutions’ experiences in offering Excel-focused data visualization workshops with the goal of providing an overview of the current state of educational offerings in this area.
Methods: Semi-structured interviews were conducted by phone and email with librarians at institutions that offer Excel-focused workshops, which were identified by reviewing the websites of Association of Academic Health Sciences Libraries members and the 2019 Medical Library Association annual meeting program.
Results: Librarians from six institutions were interviewed, online class materials from one institution were reviewed, and information from the author’s institution was included, resulting in a total of eight institutions. Educational offerings in Excel-focused data visualization ranged from one workshop to five workshops in a series, which typically first presented information for beginners and then progressed to more advanced data visualization skills. Regarding motivations for offering these workshops, librarians stated that they were committed to providing instruction in software programs that were already familiar to users. Workshop evaluations, when available, were generally positive.
Discussion: Because of its widespread availability and usage, Excel offers a compelling opportunity for providing hands-on data visualization instruction in health sciences libraries.References
LaPolla FWZ. Excel-evate: developing a data visualization workshop in Excel. Presented at: MLA ’19, 119th Annual Meeting of the Medical Library Association; Chicago, IL; May 7, 2019.
Brandenburg M, Joque J. Contextualizing visualization in library services. In: Federer L, ed. The Medical Library Association guide to data management for librarians. Lanham, MD: Rowman & Littlefield; 2016. p. 139–50.
Brandenburg MD, Garcia-Milian R. Interinstitutional collaboration for end-user bioinformatics training: Cytoscape as a case study. J Med Libr Assoc. 2017 Apr;105(2):179–84. DOI: http://dx.doi.org/10.5195/jmla.2017.224.
Federer L. CE503: Introduction to data analysis and visualization with R. Presented at: MLA ’18, 118th Annual Meeting of the Medical Library Association; Atlanta, GA; May 2018.
Federer LM, Joubert DJ, Davis M. Expanding and enhancing library data and GIS services: implementing an information visualization service. Presented at: MLA ’15, 115th Annual Meeting of the Medical Library Association; Austin, TX; May 2015.
Patridge E, Vaidhyanathan V, Hoover B, Gotschall T, Beard L, Bardyn TP. Establishing a successful data visualization service: lessons from the field. Presented at: MLA ’19, 119th Annual Meeting of the Medical Library Association; Chicago, IL; May 7, 2019.
Schwabish P. Policy Viz [Internet]. Schwabish P [cited 24 Oct 2019]. <https://policyviz.com/>.
Knaflic C. Storytelling with data: a data visualization guide for business professionals. Hoboken, NJ: Wiley; 2015.
Evergreen S. Evergreen data [Internet]. Evergreen S [cited 22 Oct 2019]. <https://stephanieevergreen.com>.
Association of Academic Health Sciences Libraries. Member institutions [Internet]. The Association [cited 22 Oct 2019]. <https://www.aahsl.org/member-institutions#/>.
Bruns D, Bruns L. Excel Jet [Internet]. Bruns D, Bruns L [cited 22 Oct 2019]. <https://exceljet.net/>.
Ragon B. Alignment of library services with the research lifecycle. J Med Libr Assoc. 2019 Jul;107(3):384–93. DOI: http://dx.doi.org/10.5195/jmla.2019.595.
National Academies of Sciences, Engineering, and Medicine. Reproducibility and replicability in science. Washington, DC: National Academies Press; 2019. 218 p.
Rethlefsen ML, Lackey MJ, Zhao S. Building capacity to encourage research reproducibility and #MakeResearchTrue. J Med Libr Assoc. 2018 Jan;106(1):113–9. DOI: http://dx.doi.org/10.5195/jmla.2018.273.
Microsoft. Quick start: create a macro [Internet]. Microsoft [cited 22 Oct 2019]. <https://support.office.com/en-us/article/quick-start-create-a-macro-741130ca-080d-49f5-9471-1e5fb3d581a8>.
Knowles MS, Holton EF III, Swanson RA. The adult learner: the definitive classic in adult education and human resource development. London, UK: Routledge; 2015.
