Lehardy Robert K, Luczynski Kevin C, Hood Stephanie A, McKeown Ciobha A
University of Nebraska Medical Center's Munroe-Meyer Institute.
Department of Psychology, Marquette University.
J Appl Behav Anal. 2021 Jun;54(3):1265-1280. doi: 10.1002/jaba.805. Epub 2021 Feb 1.
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.
微软Excel软件无处不在,性价比高,可用于创建具有出版质量的单病例设计图表。我们系统地复制了米特尔等人(2018年)的GraphPad Prism视频教程,以教授24名硕士生使用Excel 2016创建多基线图表。学生在多基线图表方面的平均准确率在预训练时为25%,观看视频教程后为86%,使用复习清单后为96%。接下来,学生们使用相同的视频教程创建多元素图表和反转图表。学生在多元素图表方面的平均准确率在观看视频教程时为93%,使用复习清单时为94%;在反转图表方面,观看视频教程时的准确率为82%,使用复习清单时为94%。学生对这两个培训部分的满意度为中度到高度。结果支持科学家-从业者使用该视频教程和复习清单,通过Excel 2016、Excel 2019和Excel Office 365创建三种常见图表。