Sunday, February 12, 2012

Analyzing Student Data in a Spreadsheet

Many of the assignments in this course introduced me to something new and exciting.  I was somewhat familiar with spreadsheets, but learned a lot of new and useful information that I can implement in my classroom.  I was surprised to find out that it is not very difficult to take existing data and analyze and chart the information.  This tool will be very useful in the classroom.
Here is a link: Analyzing Student Data




Analyzing the data that is presented:
It is obvious to note that there is significant progress from pre to post test for almost all students.  In regards to the one student (Joel) who did worse, it is important to point out that he scored very high pre-test.  It is possible that his absences could have played a role in him scoring less the second time around.  Class time and having the material presented to the class made a impact on the test scores.  I think it is important to stress to students that attendance is important, but we can also look to social media to reach our students to catch them up on class activities.  Recent assignments like screenr, yodio, and class blogs will be useful for students that miss class time due to illness.

1 comment:

  1. Looks like everything came together for you in this project in that it wasn't too much of a stretch to acquaint yourself with Google Sheets as compared to Excel. This productivity tool seems to add more robust features every month, and with the sharing and collaborative components makes it my choice over Excel for the past 3 years. Keep experimenting and we'll see what you think as time goes on.

    ReplyDelete