CREATING SINGLE-SUBJECT DESIGN GRAPHS IN MICROSOFT EXCEL™ 2007

• Published in: Journal of applied behavior analysis Vol. 42; no. 2; pp. 277 - 293
• Main Authors: Dixon, Mark R., Jackson, James W., Small, Stacey L., Horner-King, Mollie J., Lik, Nicholas Mui Ker, Garcia, Yors, Rosales, Rocio
• Format: Journal Article
• Language: English
• Published: Oxford, UK Blackwell Publishing Ltd 01.06.2009; Society for the Experimental Analysis of Behavior
• Subjects: Accuracy; Adult; Agreements; Applied Behavior Analysis; Behavior Patterns; Behavioral Science Research; Biological and medical sciences; Cells; Check Lists; Computer Graphics; Computer processing; Computer Software; Computer-Assisted Instruction; Data analysis; Evaluation; Female; Fundamental and applied biological sciences. Psychology; Graduate Students; graphing; Graphs; Higher Education; Humans; Independent sample; Likert scale; Likert Scales; Male; Psychological Patterns; Psychology. Psychoanalysis. Psychiatry; Psychology. Psychophysiology; Psychometrics. Statistics. Methodology; single-subject design; Software; Software reviews; Software upgrading; Spreadsheets; Statistics. Mathematics; Task Analysis; Task Performance and Analysis; technology; User-Computer Interface; Case study; Statistical method; Graphics; single-subject design; graphing; Computer; computer software; Software; technology
• ISSN: 0021-8855; 1938-3703; 1938-3703
• DOI: 10.1901/jaba.2009.42-277

Over 10 years have passed since the publication of Carr and Burkholder's (1998) technical article on how to construct single‐subject graphs using Microsoft Excel. Over the course of the past decade, the Excel program has undergone a series of revisions that make the Carr and Burkholder paper somewhat difficult to follow with newer versions. The present article provides task analyses for constructing various types of commonly used single‐subject design graphs in Microsoft Excel 2007. The task analyses were evaluated using a between‐subjects design that compared the graphing skills of 22 behavior‐analytic graduate students using Excel 2007 and either the Carr and Burkholder or newly developed task analyses. Results indicate that the new task analyses yielded more accurate and faster graph construction than the Carr and Burkholder instructions.