Rate of ImprovementProgramming Microsoft Excel to Graph Rate of Improvement: Fall to Winter*Open Microsoft Excel*Setting Up Your SpreadsheetIn cell A1, type 3rdGrade ORFIn cell A2, type First SemesterIn cell A3, type School WeekIn cell A4, type BenchmarkIn cell A5, type the Student’s Name (Swiper Example)Labeling School WeeksStarting with cell B3, type numbers 1through 18going across row 3 (horizontal).Numbers 1 through 18 represent the number of the school week.You will end with week 18 in cell S3.Note: You may choose to enter the date of that school week across row 2 to easily identify the school week.Entering Benchmarks (3rdGrade ORF)In cell B4, type 77. This is your fall benchmark.In cell S4, type 92. This is your winter benchmark.Entering Student Data (Sample)Enter the following numbers, going across row 5, under corresponding week numbers.Week 1 – 41Week 8 – 62Week 9 – 63Week 10 – 75Week 11 – 64Week 12 – 80Week 13 – 83Week 14 – 83Week 15 – 56Week 17 – 104Week 18 – 74Graphing the DataHighlight cells A4 and A5 through S4 and S5Follow Excel 2003 or Excel 2007 directions from here(Excel 2003)Across the top of your worksheet, click on “Insert”In that drop-down menu, click on “Chart”Your chart wizard will appear. Click on “Line”1
Rate of ImprovementMake sure the icon is highlighted with the description that reads “Line with markers displayed at each data value”Click “Next”Make sure there you have a mark next to “Rows”Click “Next”You can add a Chart Title, and label your X-Axis (School Weeks) and Y-Axis (WPM)Click “Next”Decide if you want your graph as an “object in” or “as new sheet”Click “Finish”Your graph will appear (Excel 2007)Click “Insert”Find the icon for “Line”Click the arrow below “Line” which will open a drop-down menu of 6 graphicsClick on “Line with markers”Your graph appears within your spreadsheetGraphing the TrendlineOn your graph, right click on any one student data point
You've reached the end of your free preview.
Want to read all 6 pages?
- Spring '18
- Dr. Moez