Wednesday, October 7, 2009

Analyzing Student Data in a Spreadsheet

I recently did a student data analysis using a spreadsheet. Excel is the most difficult thing for me to work with, but to each his own. Once I learned the tools, though, it was exciting to use them. Although Excel overwhelms me, the functions of it are truly awesome and extremely useful!



Based on my graph it seems like Renee, Walter, and Queen are significantly below average, and need focused individual instruction to catch up. Katherine, Eric and Charlie are closer to averagethan the previous three, but need to be pushed in order to reach it. The rest of the students, Dan, Anais, Thrugood, and Jason, are very close to the average, and may just need some extra help after school to easily reach the average. This may be only 15-30 mins a day to get them caught up.
One significant trend with test 6-8 was that besides two of them, most of the below average students are improving their test scores.Which is hopeful!

2 comments:

  1. I appreciated your observations on students close (and not so close) to the 'average'. Also, please take a few moments to analyze the TRENDS over tests 6 through 10 --> what do you notice? _____

    ReplyDelete
  2. One significant trend with test 6-8 was that besides two of them, most of the below average students are improving their test scores.Which is hopeful! I also added this information to the main page. :)

    ReplyDelete