This week for your project you will learn how to make a simple line graph in Excel.
First, you will watch a video of how to make a simple line graph including a review of the parts of a basic line graph, and then you will create your own simple line graphs using sample scenario data provided.
STEP 1: Now, you will learn how to make a simple line graph. Here is a video to walk you through the process.
See link on M4 Project page
STEP 2: Next, create your own graphs using the. Data from the following scenarios:
Remember to include on your graphs: [REFER TO COOPER CHAPTER 6 PPS. 127-128)]
- Horizontal axis
- Vertical axis
- Axis labels
- Condition change lines
- Condition labels
- Data points and data path
- Breaks in the lines that connect one data point to the next phase change
- A figure caption containing your intervention method (the independent variable) and what you measured (the dependent variable)
Graphing Data Exercises
SCENARIO 1:
Graph the 5 days of interval data. Again, be sure to label all parts of the graph correctly. When creating this graph, think about what would be easily reported. This could be either number of intervals per day or the percent of intervals per day.
Student – Matthew
Behavior – amount of on-task
“+” - means there was an occurrence of on task for the whole interval.
“O” – means there was no occurrence of on task across whole interval
Day 1
1 + 2 0 3 0 4 + 5 + 6 0
7 0 8 0 9 + 10 + 11 + 12 +
13 + 14 0 15 0 16 0 17 + 18 +
19 + 20 + 21 + 22 + 23 0 24 +
Day 2
1 0 2 0 3 0 4 0 5 + 6 0
7 0 8 0 9 0 10 + 11 + 12 +
13 0 14 + 15 + 16 + 17 + 18 +
19 + 20 0 21 0 22 0 23 0 24 0
Day 3
1 + 2 + 3 + 4 + 5 + 6 +
7 + 8 0 9 0 10 + 11 0 12 +
13 + 14 0 15 0 16 + 17 + 18 +
19 0 20 0 21 0 22 + 23 0 24 0
Day 4
1 + 2 + 3 0 4 + 5 + 6 +
7 0 8 0 9 0 10 + 11 + 12 0
13 + 14 + 15 + 16 + 17 + 18 0
19 + 20 + 21 + 22 0 23 0 24 0
Day 5
1 + 2 + 3 + 4 + 5 + 6 +
7 + 8 + 9 + 10 + 11 + 12 +
13 + 14 + 15 + 16 + 17 + 18 +
19 0 20 0 21 0 22 + 23 + 24 +
SCENARIO 2:
Mr. Smith used a PLACHEK data collection method to assess the number of times that all of his language class students were working on their assignments. So, at the end of 3-minute intervals, he looked up from his desk and counted the number of students (out of 10) who were touching or looking at their work. Thus, he was able to check 10 different times during each 30-minute class. On Monday, all students were working only 7 of the 10 checks. On Tuesday, this number increased to 8, but lowered to 5 on Wednesday. However, on Thursday and Friday, all students were working on a total of 10 and 2 checks, respectively.
Please graph the number of observations on which all students were working each day. Carefully and clearly label each axis.
SCENARIO 3:
Graph the raw data. Pay careful attention to the change in opportunities across the dates. When there are not equal opportunities to respond for each session, you would consider graphing the percent of opportunities so that you can compare data across sessions. Don’t forget to label all parts of the graph.
Student – Marcus
Behavior – answering questions when called upon by the teacher.
Date # questions answered # times called upon by teacher
1/19 5 10
1/20 3 6
1/21 0 5
1/24 1 7
1/25 4 5
Finally, upload your completed assignment to the M4 Assignment.
Sample Solution