Using Microsoft Excel® to Build a Customized Partial-Interval Data Collection System
- 145 Downloads
Using data to inform treatment decisions is a hallmark of behavior analysis. However, collecting the type of data that behavior analysts often require can be a labor-intensive and time-consuming task. Electronic data collection systems have been identified as a tool to alleviate some of the issues related to data collection, but many obstacles still exist. Current limitations of electronic data collection systems include cost, adaptability, ease of use, and compliance with privacy and security guidelines. The purpose of this article is to offer practitioners an alternative to buying an electronic data collection system by providing a task analysis on how to build customized electronic data collection systems using Microsoft Excel®. This task analysis is written for individuals with limited or no experience working with Excel® but may also be of utility to individuals fluent in Excel®. This task analysis is organized into three sections: (a) creating a basic electronic data collection table with dropdown menus and autofill features, (b) creating a timestamp for all data entered, and (c) creating automatically graphing displays of data.
KeywordsData collection integrity Data collection timelines Electronic data collection Excel®
Thanks to Dr. Wayne Fuqua and Dr. Heather McGee for providing feedback and suggestions in developing the first iteration of this electronic data collection system. Thanks to Nate VanderWeele, Kelsey Webster, Yisang Yang, Nicole Hollins, and Haley Hughes for their feedback on the task analysis.
Compliance with Ethical Standards
Conflict of Interest
The authors declare that they have no conflict of interest.
This article does not contain any studies with human participants or animals performed by any of the authors.
- Alvero, A. M., Bucklin, B. R., & Austin, J. (2001). An objective review of the effectiveness and essential characteristics of performance feedback in organizational settings (1985-1998). Journal of Organizational Behavior Management, 21(1), 3–29. https://doi.org/10.1300/J075v21n01_02.CrossRefGoogle Scholar
- Cooper, J. O., Heron, T. E., & Heward, W. L. (2007). Applied behavior analysis (2nd ed.). Columbus, OH: Merrill.Google Scholar
- Madsen, E. K., Peck, J. A., & Valdovinos, M. G. (2015). A review of research on direct-care staff data collection regarding the severity and function of challenging behavior in individuals with intellectual and developmental disabilities. Journal of Intellectual Disabilities, 20, 296–306. https://doi.org/10.1177/1744629515612328.CrossRefGoogle Scholar
- Najdowski, A. C., Chilingaryan, V., Bergstrom, R., Granpeesheh, D., Balasanyan, S., Aguilar, B., & Tarbox, J. (2009). Comparison of data-collection methods in a behavioral intervention program for children with pervasive developmental disorders: A replication. Journal of Applied Behavior Analysis, 42, 827–832. https://doi.org/10.1901/jaba.2009.42-827.CrossRefGoogle Scholar
- Rios, D., Kazemi, E., & Peterson, S. M. (2018). Best practices and considerations for effective services provision via remote technology. Behavior Analysis: Research and Practice.Google Scholar
- Sleeper, J. D., LeBlanc, L. A., Mueller, J., Valentino, A. L., Fazzio, D., & Raetz, P. B. (2017). The effects of electronic data collection on the percentage of current clinician graphs and organizational return on investment. Journal of Organizational Behavior Management, 37, 83–95. https://doi.org/10.1080/01608061.2016.1267065.CrossRefGoogle Scholar
- Tapp, J., Ticha, R., Kryzer, E., Gustafson, M., Gunnar, M. R., & Symons, F. J. (2006). Comparing observational software with paper and pencil for time-sampled data: A field test of interval manager (INTMAN). Behavior Research Methods, 38(1), 165–169. https://doi.org/10.3758/BF03192763.CrossRefGoogle Scholar