Association for Behavior Analysis International

The Association for Behavior Analysis International® (ABAI) is a nonprofit membership organization with the mission to contribute to the well-being of society by developing, enhancing, and supporting the growth and vitality of the science of behavior analysis through research, education, and practice.


43rd Annual Convention; Denver, CO; 2017

Workshop Details

Previous Page


Workshop #W83
Save Time in Microsoft Excel Automating Phase Change Lines and Labels, Selecting Date Ranges, and Creating Templates
Friday, May 26, 2017
4:00 PM–7:00 PM
Hyatt Regency, Mineral Hall E
Area: PRA/AUT; Domain: Service Delivery
CE Instructor: Neil Deochand, M.S.
NEIL DEOCHAND (Western Michigan University), CODY MORRIS (Western Michigan University )
Description: Excel is a widely used versatile tool, but it is not always user-friendly when meeting the unique needs of the behavioral practitioner. The drawing in of phase lines and repetitive typing of phase labels constitutes a laborious and repetitive task for behavior analysts. Few solutions have been offered to automating the phase labels, the descriptive text that accompanies a phase change line, despite their pervasive use in behavior analytic graphical displays. The purpose of this workshop is to offer an updated way (and free templates) to add phase change lines with their respective labels so they are updated in all graphs from a single cell in a worksheet, and teach attendees how to adjust their date ranges with minimal effort.
Learning Objectives: At the conclusion of the workshop, participants will be able to: (1) design and create clear graphical displays in Microsoft Excel; (2) use embedded elements for phase labels and phase change lines that stay fixed to the graph; (3) automatically update date ranges for all graphs; (4) create templates to save time.
Activities: Instructional activities: Video observation, small group breakout, supplemental materials in the form of templates will be provided Workshop objectives: Minimize drawing in elements to graphs which do not stay fixed to the graph when moved or updated. Reduce time taken to create a graphs using templates. Increase fluency graphing in Microsoft Excel.
Audience: Board Certified Behavior Analysts (BCBAs), Board Certified Assistant Behavior Analysts (BCaBAs), those seeking behavioral certification, psychologists, and any health care providers who track behavioral data. This workshop is for those who have some basic knowledge regarding the use of Excel for creating graphical displays.
Content Area: Practice
Instruction Level: Intermediate
Keyword(s): Excel®, graphing, phase change, single-subject design



Back to Top
Modifed by Eddie Soh