/ Single-Case Design Graphs

Overview › Build it in Google Sheets › Lesson 6

Lesson 6 of 7About 15 minutes

Alternating treatments, multielement, and changing criterion

These designs use the same line chart you already know. Each needs one or two extra settings in Google Sheets: joining points across blank cells, a different point shape for each condition, labels or a legend that name the conditions, or dashed criterion lines.

You will be able to

  • Join each condition’s points across blank cells in an alternating treatments or multielement graph, and give each condition a point shape that can be told apart in black and white.
  • Name the conditions with labels beside their paths or with a legend, and explain which one Google Sheets allows for each design.
  • Add dashed criterion lines and criterion labels to a changing criterion graph.
Instructions for Google Sheets in a web browser

Your graph doesn't need this lesson. Lesson 6 is for alternating treatments, multielement (functional analysis), and changing criterion graphs. The graph you chose, Reversal (ABAB), has none of these extra settings. Go on to Lesson 7: Download and place the figure.If you haven't yet, stack your tiers in Lesson 5: Multiple baseline graphs, then go on to Lesson 7: Download and place the figure. Building one of those graphs instead? Choose it in the Graph box above so every lesson shows its steps, or go straight to its section: alternating treatments, multielement, or changing criterion.

Lessons 3 and 4 already covered these steps for your graph. They walked you through each one with your practice data and pictures. This lesson collects the settings and checks that are specific to each design in one place, so you can check your work or build the next graph from your own data. Your section: Alternating treatments design. Your section: Multielement design (functional analysis). Your section: Changing criterion design.

Alternating treatments design

The finished alternating treatments design graph in Google Sheets, with a solid phase-change line at session 4.5, the phase labels Baseline and Alternating Treatments centered over each phase above the data, and the labels Treatment A and Treatment B beside their data paths.
Baseline, then two treatments alternated across sessions. Each condition is one continuous path with its own point shape, and a label beside each treatment's path names it.

Practice data: practice-atd-data.xlsx, 16 sessions in A1:D17.

Give each condition its own column, just like a phase. During the alternating phase, each session's value goes in the column for the condition run that session. Each condition's column now has blank cells between its values.

ABCD
1SessionBaselineTreatment ATreatment B
2–51–42.1 … 2.3
651.2
761.9
872.0
980.8
1090.6
Treatment A and Treatment B take turns, so each column has gaps between its values. The practice file continues to session 16 in row 17.
  1. Build the chart as usual. Select A1:D17, insert a line chart, and tick Use column A as labels, as in Lesson 2. Format it as in Lesson 3, with rate settings on the vertical axis: Min -1, Max 3, Major step 1, and format code 0;;0, so the labels are whole numbers. The practice rates peak at 2.5. Set the horizontal axis from 0 to 18, the first multiple of 2 past session 16, with a step of 2, and hide session 0 with the format code 0;;.
  2. Join each condition across its blank cells. A blank cell breaks a line, so each treatment would show as short pieces and lone points. In Customize›Chart style, tick Plot null values. The setting applies to every series in the chart. The Baseline path still stops at the phase change, because its column has no later values to join.
  3. Give each condition a different point shape. Google Sheets has no open (hollow) points, so use shapes. In Customize›Series, make every line black with 7px points (Apply to all series), then choose each treatment and set its Point shape and Point size: Treatment A Square, 8; Treatment B Triangle, 9. Baseline stays a 7px circle. Type 8 or 9 in the Point size box; squares and triangles look smaller than a circle of the same size.
Gaps (Sheets' default)
The alternating treatments chart before joining: the baseline is one path, but Treatment A and Treatment B break into short colored pieces and lone dots.
Before: each treatment breaks wherever its column has a blank cell.
Joined
The same chart after Plot null values and black series: Treatment A is one continuous black path of squares and Treatment B one continuous black path of triangles. Baseline uses circles.
After steps 2 and 3: one continuous black path per condition, each with its own point shape.

A path still breaks, or drops to zero? Look at the cell where it happens. A cell that only looks empty may hold a space or other text. Select it and press Delete to empty it.

  1. Add the phase-change line and the labels. Follow Lesson 4. The helper headings go in E1:G1 (Phase lines, Phase labels, Label text). Leave row 18 empty; the helper rows run from row 19 to row 24. The practice data change phase once, after session 4: 4.5 in A19:A20, with -1 and 3 in E19:E20. The label rows, 21 to 24, hold Baseline at 2.5 and Alternating Treatments at 10.5, both at 3.5, then the two treatment names. Set the data range to A1:G24, add Phase lines and Phase labels as series, and raise the vertical axis Max to 4 with the format code [>3]"";[<0]"";0, which hides the 4 label.
  2. Name the treatments beside their paths, not with a legend. A Google Sheets legend lists every series and can’t leave one out, so it would also list Phase lines and Phase labels. The last two label rows put the words Treatment A (at 11 and 0.85) and Treatment B (at 8.5 and 2.15) just above their own paths, as part of the Phase labels series. APA style allows labeling data paths directly instead of using a legend. For your own data, put each name close to its own path, where it covers no point or line of the other.

More than one phase change? Plot null values joins every series across its blank cells, the helper series included. The practice graph has a single phase-change line, so that changes nothing. If your own alternating treatments graph has a second phase change, such as a final best-treatment phase, check that the two phase-change lines stand apart. If they are joined, put the second line's two values in a column of its own and add that column as its own series.

Check your alternating treatments graph

Then read the graph. Do the two treatment paths separate clearly, with little or no overlap, across the whole alternating phase? See what experimental control looks like in an alternating treatments design.

Multielement design (functional analysis)

The finished multielement functional analysis graph in Google Sheets, with a legend across the top of the plot listing Play, Attention, Demand, Tangible, and Alone.
Five rapidly alternating conditions with no phase changes. Each condition has its own point shape, and a legend across the top of the plot names them.

Practice data: practice-fa-data.xlsx, 25 sessions in A1:F26.

  1. One column per condition. Put session numbers in column A and one condition in each of columns B to F: Play, Attention, Demand, Tangible, and Alone. Type each session's rate under the condition run that session, so every row has exactly one rate. Type 0 for a session with no responding. Leave a cell blank only when that condition was not run in that session.
ABCDEF
1SessionPlayAttentionDemandTangibleAlone
210
320.9
432.5
540.6
650.2
763.1
870.1
The first seven sessions. Session 1 had no responding in Play, so its cell holds 0, not a blank. The practice file continues to session 25 in row 26.
  1. Insert and format the chart. Select A1:F26, insert a line chart with Use column A as labels, and format it as in Lesson 3. On the vertical axis, set Min -1, Max 5, Major step 1, and format code 0;;0, so the labels are whole numbers. The practice rates peak at 3.6, so a maximum of 5 keeps the highest point well below the top of the plot. Set the horizontal axis from 0 to 26, one more than the last session, with a step of 2, and hide session 0 with 0;;.
  2. Join each condition across its blank cells. Tick Plot null values in Chart style, exactly as in step 2 of the alternating treatments design. Every condition's column has blanks between its values, so without this setting all five conditions show as lone dots.
  3. Use five shapes. Make every line black with 7px points, then give each test condition its own shape: Attention Square 8, Demand Triangle 9, Tangible Diamond 9, and Alone Star 10. Play, the control condition, stays a 7px circle. Sheets has no open points, so shape is the only way to tell the conditions apart in black and white. Whatever shapes you choose, keep them the same across all your figures.
  4. Skip the phase-change lines and phase labels. All five conditions alternate within one phase, so there is nothing to separate or name, and the graph needs no helper rows. The legend identifies the conditions instead.
  5. Turn the legend on. In Customize›Legend, set Position to Inside and Text color to black. The legend lists the conditions in column order, so the practice file puts the control condition, Play, first. To change the order, move the columns before you insert the chart. Whatever order you choose, use it in every figure.

Zero rates stay visible. With the floating zero from Lesson 3, sessions with no responding sit on the 0 line, just above the horizontal axis, instead of on it.

Check your multielement graph

Then read the graph. Is responding in any test condition consistently higher than in the Play (control) condition, with little overlap? See Functional analysis: differentiated or not?

In the practice graph, Demand is clearly highest, at 2.5 to 3.6 responses per minute. Attention (0.8 to 1.1) and, at a lower level, Tangible (0.3 to 0.6) are also above Play (0 to 0.1) in all five cycles, with no overlap. Alone stays low (0.1 to 0.3) and overlaps Play at 0.1. Because each test condition is compared with Play, not just with the highest condition, this graph suggests escape plus attention, and possibly tangible: multiple control worth following up.

Changing criterion design

The finished changing criterion design graph in Google Sheets, with solid phase-change lines at sessions 5.5, 8.5, 13.5, 16.5, and 20.5, dashed criterion lines at 12, 20, 16, 26, and 30, and the phase labels Baseline, 12 min, 20 min, 16 min, 26 min, and 30 min centered over each phase, above the data.
A baseline, then subphases with a dashed horizontal line at each criterion level.

Practice data: practice-cc-data.xlsx, 23 sessions in A1:G24.

Why the subphases differ. The practice subphases last 3, 5, 3, 4, and 3 sessions, the criterion changes by different amounts (+8, −4, +10, and +4 minutes), and it steps back down from 20 to 16 minutes for a while. When behavior follows changes like these, time alone can’t explain them (see how the design shows control). The helper rows work the same for any subphase lengths and criteria: each criterion line spans exactly its own subphase.

  1. One column per subphase. Put Baseline, Phase 1, Phase 2, Phase 3, Phase 4, and Phase 5 in B1:G1, so the data path breaks at every criterion change. Select A1:G24, insert a line chart with Use column A as labels, and format it as in Lesson 3. On the vertical axis, set Min -5, Max 40, Major step 5, and format code 0;;0. The practice data peak at 31 minutes. Set the horizontal axis from 0 to 24, one more than the last session, with a step of 2, and hide session 0 with 0;;.
  2. Type the helper rows. Follow Lesson 4. The headings go in H1:K1: Phase lines, Phase labels, Label text, and Criterion. Leave row 25 empty. Rows 26 to 39 draw five phase-change lines at 5.5, 8.5, 13.5, 16.5, and 20.5, each from -5 to 40, with a separator row between lines. Rows 40 to 45 hold the labels Baseline, 12 min, 20 min, 16 min, 26 min, and 30 min at 3, 7, 11, 15, 18.5, and 22, all at 42.5. Rows 46 to 59 draw the criterion lines, shown below. Keep the phase-change lines solid.
  3. Make the criterion rows. Each criterion line is two rows. Column A runs from half a session before the subphase's first session to half a session after its last, and Criterion holds the criterion both times. For a criterion of 12 during sessions 6–8: 5.5 and 8.5 in column A, with 12 and 12 in column K. A separator row, with a position in column A and column K left empty, keeps one line from joining the next.
AK
465.512← 12 min, sessions 6–8
478.512
488.5← separator
498.520← 20 min, sessions 9–13
5013.520
5113.5
5213.516← 16 min, sessions 14–16
5316.516
5416.5
5516.526← 26 min, sessions 17–20
5620.526
5720.5
5820.530← 30 min, sessions 21–23
5923.530
Each pair of rows with a criterion is one line. Each line starts at its subphase's phase-change line and ends at the next one; the last ends half a session after session 23.
  1. Add the helper series. In the chart editor's Setup tab, set the Data range to A1:K59 and press Enter. Then use Add Series three times: Phase lines, Phase labels, and Criterion. Add the labels' words from Label text and format the lines and labels as in Lesson 4, Part B. Raise the vertical axis Max to 45, with the format code [>40]"";[<0]"";0.
  2. Make the criterion lines dashed. In Customize›Series, choose Criterion. Set Line color to black, Line dash type to the dashed line (third in the list), and Line thickness to 1px. Dashing keeps the criterion visibly different from the data path and the solid phase-change lines. All five criterion lines are one series, so this one setting dashes them all.

Changed a criterion? Edit its two cells in column K and its label in column J. The dashed line and the label move with the numbers.

Check your changing criterion graph

Then read the graph. Does responding shift to each new criterion soon after it changes and stay near it until the next change? See what experimental control looks like in a changing criterion design.