Below are a series of screenshots that show you the steps in creating a graph using Microsoft Excel. Your second homework assignment calls for you to submit baseline data, a graph with your baseline data for problem and replacement behavior, and a goal and two objectives focusing on the data you gathered. The sample below focuses only on one problem behavior, but you can generalize the info and create a separate graph for the replacement behavior.
First, you will need to open Microsoft Excel and select the "New Workbook" option. This should take you to a blank workbook page.
In the sample to the left, I have entered the meaning of the numbers on the first line of the first column...labeled, "Out of Seat." Notice that the entries for each session are on the first colum. Also notice the I highlighted (click on A2 and drag to B9) all of the numbers on the first column, while avoiding the out of seat title (if you do, it will mess up your graph). I also highlighted the second column, and went a three lines below the last entry in the first column. The additional column and rows are for those of you interested in earning extra credit on this assignment...I will talk about this later.
Next, I select the "Chart Wizard" button on the top of the toolbars. It's the icon with the magic wand on top of a chart.
A Pop up window appears and it prompts you to select the appropriate type of graph. You will select line graph (second box on first column) and proceed to press the "Next" button.
The next screen that comes up has two buttons on top, one is the "Data Range" and the other is the "Series" button. Select the "Series" button and proceed to enter the lable for the what the data points mean...in my example, I have labeled the first series as OUT OF SEAT. I have left the second series alone.
The next screen that appears is the chart titles menu. Proceed to enter the chart title for your graph. In my example, I labeled it, "Out of Seat Behavior." The next dialogue box is the X axis, this will always be labeled, "Sessions." The third entry will be for the Y axis...always adding meaning to the numbers presented in graph. In my example, I labeled it, "Average Number of Times per 2hr. Observation." In this scenario, I conducted observations that were 4 or 6 hour observation...because, not all observations were of the same duration, I could not graph total out of seat behavior per observation (this would result in higher totals for the days in which I observed 6 hours). Graphing the average number of times per 2 hour observation allowed me to present data that was consistent across all observation sessions. Proceed to select the "Next" button.
The next window presents options on how you want to save the graph. You will select the button that saves the graph in a new sheet. That way, the graph appears as a new tab in your workbook and it also is not a popup on your data workbook. Click on the "Finish" button.
Finally, the graph appears on as a new sheet. Notice at the bottom of the workbook, that the graph now has it's own tab. The graph that I am presenting here looks a bit different than the one that is yours. I accomplished this by changing some simple items on it. For example, you will notice that the background on your graph is gray...also, your graph area has a gray outline. To eliminate this, double click on the graph area, this will cause a dialogue box to appear. Change the border color to white and the area color to white...select "enter" and the background and outline will become white. Next double click on any of the horizontal lines on the graph...select "white" as the color for those lines...and suddenly, your graph will no longer show the horizontal lines. At this point, your graph is acceptable for submitting with your Homework #2 assignment.Don't forget to save your workbook so that you can come back to it later, if you elect to submit 3 additional intervention data points for extra credit on the final project.
Practice with some made up data so that you can become comfortable with all options on making graphs using Excel.
1 comment:
In terms of filling out the forms for HWK#2, our student is not supposed to have a "serious behavior" as defined by CA Ed Code, therefore do we check "other pervasive maladaptive behavior"? And if so, are we still conducting a BIP or a BSP? Also, on the second form (Functional Assessment sheet) for the Additional Baseline Data Anaylsis section I know we are supposed to check that we used other data collection forms (the one we made) but are we also supposed to check Functional Observation Form? If anyone can provide some clarification that would be helpful.
Post a Comment