I had a good time re learning how to use a spread sheet. In high school I had some experience using the Microsoft Excel program but never with Google Spreadsheet. I love Google and I love it even more with a the tool they called Spreadsheet. To define Goggles Spreadsheet, I would say you can save a ton of time and energy when collecting and organizing data, a great tool in analyzing numbers and to see progress. I started by setting up my own spread sheet and copying the raw data to my new sheet. From there I just followed the videos step by step and linked and embedded.
I had the great experience of learning how to use a spreadsheet!
Link to spread sheet & data
The data shown below are the scores of the students who were struggling during the first part of the semester. I took the last 5 weeks of test scores to see if improvement was evident. We do see that the test average does go up in the last couple of weeks. Test 6 had a test average of 161.33 on the test while on Test 10 had a average of 191.83. The student most improved was Vincent, Test 6 he had a score of 175 compared to Test 10 he had a score of 215, giving him a difference of 40 points. While Scott was the least improved, improving only 10 points between Test 6 and Test 10.
As a result of these test scores, I would seek out the students who had minimal gain and ask them about the material. I would then figure out what other ways can I express this material in such a way that they will be able to relate to it. I would then offer some strategies as to how they can study for the material so that will will also stick with them in the long run.
Terrific effort, Jacob.
ReplyDeleteI'd like you to reconsider one question: Is a line graph (trends) the appropriate graph type for the layout you have; or might one wish to switch the x-y data so the TESTS are on the x-axis? ____