Remote Teaching of Publication-Quality, Single-Case Graphs in Microsoft Excel

Authors

Robert K. Lehardy, University of Nebraska Medical Center
Kevin C. Luczynski, University of Nebraska Medical Center
Stephanie Hood, Marquette UniversityFollow
Ciobha A. McKeown, University of Florida

Document Type

Article

Publication Date

Summer 2021

Publisher

Wiley

Source Publication

Journal of Applied Behavior Analysis

Source ISSN

0021-8855

Abstract

Microsoft Excel is ubiquitous, cost-effective, and can be used to create publication-quality single-case design graphs. We systematically replicated the GraphPad Prism video tutorial by Mitteer et al. (2018) to teach 24 master's students to create multiple-baseline graphs using Excel 2016. Students' mean accuracy on the multiple-baseline graph was 25% in pretraining, 86% with the video tutorial, and 96% with the review checklist. Next, students used the same video tutorial to create multielement and reversal graphs. Students' mean accuracy on the multielement graph was 93% with video tutorial and 94% with review checklist, and accuracy on the reversal graph was 82% with video tutorial and 94% with review checklist. Students reported moderate to high satisfaction with both training components. The results support scientist-practitioners using the video tutorial and review checklists to create three common graphs using Excel 2016, Excel 2019, and Excel Office 365.

Comments

Accepted version. Journal of Applied Behavior Analysis, Vol. 54, No. 3 (Summer 2021): 1265-1280. DOI. © 2021 Wiley. Used with permission.

Recommended Citation

Lehardy, Robert K.; Luczynski, Kevin C.; Hood, Stephanie; and McKeown, Ciobha A., "Remote Teaching of Publication-Quality, Single-Case Graphs in Microsoft Excel" (2021). Psychology Faculty Research and Publications. 521.
https://epublications.marquette.edu/psych_fac/521