populate the quick analysis tool in excel

Note that the flat lines are goals, so this template uses flat goals and adds phase lines.īut, what if there is a variable goal? No problem, here is an example of our table for variable goals with phase lines.Īnd below, you can see the variable goals with phase lines in action.Įxcel doesn’t accommodate putting in the phase lines very easily. The dotted lines separate different test periods. The first line separates the baseline from the other data. The phase lines, which you can see in action in the next graphic. This template table accommodates phase lines. Here is an example of our 8 shape template tab filled out with a lot of data for each shape.Īnd here is the ABA Excel graph with many shapes and data points–kind of an extreme example!

For the next template, we set up a table that will accommodate different shapes, including triangles, circles, squares, X’s, plus signs (+), stars, flat lines, and diamonds.īelow, you can see our 8 shape ABA Excel graph template in action.

In the field of Applied Behavior Analytics (ABA), sometimes many different shapes are needed to graph varying behaviors. These first 2 graphics are for flat goals, represented by the flat lines. The flat lines are the goals, and the other points are the behavior. The first set of points in the top left is the baseline. Then we created a Microsoft Excel graph that will update as the data is entered. We started with a table where Autism Parent Care team members can enter goals and data. We created a series of ABA Excel graph templates for Dr. There is no easy way to create ABA Excel graphs, particularly with things like phase lines, flat goals, variable goals, and graphing multiple shapes.

Jane Yip and her colleagues needed Microsoft Excel graphing templates to chart student behavior progress and to submit articles to scholarly journals. The Applied Behavior Analysis (ABA) industry uses a standardized graph format for presenting data in professional journals and textbooks. Autism Parent Care uses Applied Behavior Analysis (ABA) therapy to help children with autism overcome behavioral problems. Autism Parent Care is a school for children with autism.

Populate the quick analysis tool in excel