/ Single-Case Design Graphs

Excel lessons

Build it in Excel

Seven lessons take you from a blank worksheet to a figure ready for submission. Choose the graph you want to make, and every lesson shows its data, cell ranges, and axis values, with Windows and Mac instructions, numbered steps, and a picture exported from Excel at each stage.

Instructions for:

Finished reversal design graph with four labeled phases. The finished multielement functional analysis graph with a borderless legend listing Play, Attention, Demand, Tangible, and Alone.
The reversal (ABAB) design graph you will build in Lessons 1–4.Tier 1 (Participant 1) of the multiple baseline graph, built in Lessons 1–4. Lesson 5 stacks it with the other tiers.

Lessons

Lessons 1 to 4 build the core skills on one reversal (ABAB) design graph, starting with the top tier (Participant 1) as a full-size chart. Lessons 5 and 6 apply the same skills to other designs, so you can skip them for this graph. Lesson 7 takes the figure into your manuscript or class paper.Lesson 5 copies that tier for each participant and joins the tiers with a stepped phase-change line. Lesson 6 covers other designs, so you can skip it. Lesson 7 takes the figure into your manuscript or class paper.Lesson 5 covers multiple baseline graphs, so you can skip it. Lesson 6 recaps the settings your design needs, for when you graph your own data, and Lesson 7 takes the figure into your manuscript or class paper.

Before you start