The Excel file contains three worksheets. The first two show examples of students’ oral reading fluency (ORF) progress-monitoring data charted in the line graph. These are labeled “Example – Julia WCPM” and “Example – Dean WCPM.” You can use the third worksheet labeled “Line Graph to Use” to chart any student progress-monitoring data you are collecting. Copy this worksheet multiple times within the file to create charts for each student whose progress you are monitoring.
Here are steps to follow in case you need help creating line graphs using the file:
- At the top of the worksheet, in the first row labeled “Benchmark,” type in the goals or benchmarks for the assessment that you are using to progress monitor. Most assessments provide these goals/benchmarks at beginning of year (BOY-Sept.), middle of year (MOY-Jan.), and end of year (EOY-May). Or, you may have district-normed goals. Be sure to fill in all of the boxes across this row, or the line in the graph will have gaps.
- To see an example, look at the worksheet for Julia. The assessment’s BOY (Sept), MOY (Jan), and EOY (May) goals are 90, 103, and 115 words correct per minute (wcpm). To fill in the rest of the boxes, subtract the BOY goal from the EOY goal (115-90=25). Divide this number (25) by the total number of boxes from PM1 to May (15; 25/15=1.7). This gives you the average progress needed per time point (1.7 wcpm) to reach the EOY goal. Add this number across each time point (90+1.7=91.7; 91.7+1.7=93.4; etc.). (Note a bit of adjustment at the end of Julia’s example due to rounding up from 1.67.)
- In the next row labeled “Aim,” you will create an aim line for the student. This is the trajectory that a student needs to follow to move from where they are at BOY to the EOY goal. To create this line, start by putting in the student’s BOY score under “Sept” (Julia’s is 55.) Then, put in the EOY goal. (Julia’s is 115.) Again, be sure to fill in all of the boxes across this row, or the line in the graph will have gaps.
- To do this, follow the same steps as you did to create the benchmark line. Subtract the student’s BOY score from the EOY goal (115-55=60). Divide this number (60) by the total number of boxes from PM1 to May (15; 60/15=4). Add this number across each time point (55+4=59; 59+4=63; etc.)
- The third row will be the student’s actual scores. After each screening or progress-monitoring assessment, enter the student’s score. The graph will automatically draw a line to the new data point, and it will create a trend line to show if the student is on track to meet the EOY goal. You would like for the trend line to be in line with or above the aim line.
You can change the y-axis title, graph title, y-axis range/scale, line colors, etc. by double clicking on it.