Friday, November 4, 2011

#8 Google spread sheet & class data

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.

1 comment:

  1. Terrific effort, Jacob.
    I'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? ____

    ReplyDelete