Volume 4, Issue 2 (Summer 2010)
Graphing Single-Case Data in Microsoft Excel 2007
Anne F. Zaslofsky and Robert J. Volpe
ABSTRACT: An important component of the school-based practitioner’s role involves collecting, graphing, and analyzing quantitative data to evaluate student progress. This article highlights advantages of using computer spreadsheet programs for storing and graphing single-case data. Every few years Microsoft launches a new version of Excel. The most recent release was in 2007. This article outlines several new features of the most recent version of Excel as they relate to school-based practice. Several commonly used tasks are outlined, including graphing ABA and multiple baseline designs, applying linear trendlines, the use of templates, and inserting graphic displays into other programs including Microsoft Word and PowerPoint. Templates for these tasks will be made available online.