A drop-down menu will appearClick on “Add Trendline”Click on or mark “Linear”Follow Excel 2003 or 2007 versions(Excel 2003)There are two tabs at the top of your wizard, click on “Options”Check the box next to “Custom”Then type in a label for your trendline such as Rate of ImprovementBelow that section, check the box next to “Display equation on chart”(Excel 2007)In the section below the trendline type, mark next to “Custom”Then type in a label for your trendline such as Rate of ImprovementBelow that section, mark next to “Display equation on chart”...for both versionsClicking on the equation will highlight a box border around the equationClicking on the edge of that border allows you to drag the equation to a different place on the graph so you can see it betterGraphing Expected Rate of ImprovementOn your graph, right click on one of the benchmark data pointsClick on “Add Trendline” and follow the same steps as before except label your new line Expected Rate of Improvement2
Rate of ImprovementCalculating Needed RoIIn cell T3, type Needed RoIClick on cell T5In the fxline (at top of sheet) type this formula =((S4-B5)/18)Then hit enterYour result should read: 2.83333...This formula simply subtracts the student’s actual beginning of year (BOY) benchmark from the expected middle of year (MOY) benchmark, then dividing by 18 for the first 18 weeks (1stsemester).Calculating Actual RoI - BenchmarkIn cell U3, type Actual RoIClick on cell U4In the fxline (at top of sheet) type this formula =SLOPE(B4:S4,B3:S3)Then hit enterYour result should read: 0.8825...This formula considers 18 weeks of benchmark data and provides an average growth or change per week.Calculating Actual RoI - StudentClick on cell U5In the fxline (at top of sheet) type this formula =SLOPE(B5:S5,B3:S3)Then hit enterYour result should read: 2.5137...
You've reached the end of your free preview.
Want to read all 6 pages?
- Spring '18
- Dr. Moez