Skip to main content
SpringerLink
Log in

A Field-Tested Task Analysis for Creating Single-Subject Graphs Using Microsoft® Office Excel

  • Original Paper
  • Published:
Journal of Behavioral Education Aims and scope Submit manuscript

Abstract

Creating single-subject (SS) graphs is challenging for many researchers and practitioners because it is a complex task with many steps. Although several authors have introduced guidelines for creating SS graphs, many users continue to experience frustration. The purpose of this article is to minimize these frustrations by providing a field-tested task analysis for creating SS graphs using Microsoft® Office Excel. Results from the field test are presented and the task analysis, which includes steps for creating a variety of SS graphs, is provided. The article includes various illustrations, a list of prerequisite skills, tips, and troubleshooting items.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1

Similar content being viewed by others

References

  • Alberto, P. A., & Troutman, A. C. (2006). Applied behavior analysis for teachers, 7th ed. Upper Saddle, NJ: Prentice Hall.

  • Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel. Journal of Applied Behavior Analysis, 31, 245–251.

    Article  Google Scholar 

  • Cooper, J. O., Heron, T. E., & Heward, W. L. (1987). Applied behavior analysis. Columbus, OH: Merrill.

    Google Scholar 

  • Hillman, H. L., & Miller, L. K. (2004). Designing multiple baseline graphs using Microsoft Excel. The Behavior Analyst Today, 5, 372–387.

    Google Scholar 

  • Horner, R. H., Carr, E. G., Halle, J., McGee, G., Odom, S., & Wolery, M. (2005). The use of single-subject research to identify evidence-based practice in special education. Exceptional Children, 71, 165–179.

    Google Scholar 

  • Journal of Applied Behavior Analysis. (2000). Manuscript preparation checklist. Journal of Applied Behavior Analysis, 32, 514.

    Google Scholar 

  • Moran, D. J., & Hirschbine, B. (2002). Constructing single-subject reversal design graphs using Microsoft ExcelTM: A comprehensive tutorial. The Behavior Analyst Today, 3, 179–187.

    Google Scholar 

Download references

Acknowledgments

We wish to thank Gloria Campbell-Whatley, David W. Test, and Wendy M. Wood for their kindness to allow us to solicit feedback from them and their students attending Spring 2005 courses of SPED 4270, 5270, and RSCH 7113/8113 at The University of North Carolina at Charlotte. Thanks also are extended to anonymous reviewers as well as a number of students for their constructive feedback on the manuscript.

Author information

Authors and Affiliations

  1. Department of Special Education and Child Development, College of Education, University of North Carolina at Charlotte, 9201 University City Blvd., Charlotte, NC, 28223, USA

    Ya-yu Lo

  2. Special Education Program, School of Physical Activity and Educational Services, The Ohio State University, 375A Arps Hall, 1945 North High Street, Columbus, OH, 43210, USA

    Moira Konrad

Authors
  1. Ya-yu Lo
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Moira Konrad
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ya-yu Lo.

 

 

figure a
figure 2
figure 3
figure 4
figure 5
figure 6
figure 7
figure 8
figure 9
figure 10
figure 11
figure 12
figure 13
figure 14
figure 15
figure 16
figure 17
figure 18
figure 19
figure 20
figure 21
figure 22
figure 23
figure 24

Rights and permissions

Reprints and permissions

About this article

Cite this article

Lo, Yy., Konrad, M. A Field-Tested Task Analysis for Creating Single-Subject Graphs Using Microsoft® Office Excel. J Behav Educ 16, 155–189 (2007). https://doi.org/10.1007/s10864-006-9011-0

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10864-006-9011-0

Keywords

Search

Navigation