I had a lot of trouble getting the cells to highlight in the same way that you demonstrated on the tutorial. I do not understand why but it did not work the same way on my computer. I did two separate sheets and a chart. One with all the students and all the tests and the other with just tests 6-10 and the students who fill below the average.
Analyze (discuss) your final data and chart in terms of student growth, exceptions, and what you might do as a classroom instructor as a result of these scores?
The average score for all the students tests 6-10 was 191.92. There were 12 students who fell below this average. When graphing their testing trends it became clear that all the students showed some level of growth. 8 out the 12 had risen above the class average by test 10. The one exception to this was Katherine who, although by test 10 had improved, did not follow the over all class trend. There was an extreme drop for Katherine on test 8.
If you need some assistance with the charting --- let me know and we can set up a time to chat.
ReplyDeleteMeanwhile, be sure to very carefully re-read the instructions to ensure you include all the analyzing/trends. You may wish to view the 4 student sample finished products.
Stephen --- job very well done. Looks terrific. Not sure why the data manipulation was different on your computer (or different from the video). If you'd like --- give me a call and we can work through it.
ReplyDelete