Data Assessment

               When doing the data organization there were a few things that I was hoping to put into the table. As a teacher I wanted to see the correct answer as well as what each individual student answered. I also wanted to know how each student actually scored percentage wise as well as the percent of students who got the correct answer when taking the quiz.  By having all this information it gives the teacher options for grouping the students. The teacher can look at the individual students or at the individual questions. With having the topics for the questions the teacher can also look at how they are related and other options for teaching the information. 
                 When I created the table I added a few color coding items to help identify the correct and incorrect answers. If the teacher were to give the same quiz and change the student answers in the table the color would change accordingly. If the answer entered matches the correct answer at the top of each column the the letter will turn blue and the box background will turn green. If the answer entered is anything else then the letter will turn red and the box background will turn light red. By not only coloring the letter but also the background the correct and incorrect answers really stand out against the rest of the table. Unfortunately there was not easy way to calculate the percentages fro the students and questions but I also took a moment to format these so that if the percentage was a 60% or better the color of the background changed to purple and below 60% turned bright red. 
                 This information could not only be used to create groups for the students but it can also be a starting point for conversations with the technology integrator. There can be a conversation about the topics that might need more attention and how the teacher can integrate technology into that lesson. The teacher can also start a discussion with their students. The conversation could take place through something like blogger, where the students could comment about what they found difficult in the different topics. This conversation could also help the teacher make groups for the students. 

ANALYSIS: 
        When looking at the grid there were a few things that stood out to me as a teacher. There are certain questions that all students seemed to struggle on and there were questions that all the students did very well with. There were also students that overall did well with the quiz as well as the other end of the spectrum. It is important to look at both of these trends when analyzing the data. There are a few things that can be taken from this information. I personally would have liked to have seen the options for the students so we could also analyze what the choices were and if there was something in the answers as well as if there was a common mistake in the thought process of students. 
            From the information we did have it was clear that questions 3, 4, 5, and 6 could really use some review. Why that review needs to take place in up for discussion but a teacher could have students work at stations that focus on these four questions. Students could spend a day or more rotating through different activities that focus on these four topics. This would allow students to get the review needed with some variety. If after the next version of this is given there are still issues then the questions should be reviewed carefully as well as some more one-on-one look at the students who are still struggling. 
            When grouping students I would pair students based on their grades. There are 6 students who you would really like to see improve and 6 students that received at least a 70%. It would be interesting to group students so that the students are working to tutor students who are struggling. This would have to be done at a higher level where students have the maturity to do this activity. Otherwise grouping students by their performance may be more difficult. You could group students into the two groups and work with the lower group on the material while the other group works on some enrichment material for the same topics. 

Data Assessment