To create this spread sheet I used google docs. I started by creating a form. As a classroom teacher it would have been easier to have the students fill out the form as their assessment, but since I was given the results of the assessment after is was taken already I filled out a form for each students answers. I set the form to automatically record the results onto an Assessment Spreadsheet . I then colored red the cells that contained the wrong answers to better see any specific pattern. I added under each question the concept the teacher was look for the students to have learned. When you take the results and graph them you can easily see patterns.
According to the results of the assessment and seeing it on the spreadsheet it is easy to see that question six is a topic the teacher is going to need to go back to before moving on. For the other concepts that students could revisit, you could use the results to place students into four groups of three. I would place them in the following groups:
Group One:
Zoran B.
Zirii G.
Zon D.
Group Two:
Zyntar C.
Zuitar F.
Zancy D.
Group Three:
Zinvis E.
Zup C.
Zhield H.
Group Four:
Zucy S.
Zorelda I.
Zamsung K.
In each of these groups there is one student the understood the different concepts assessed. The teacher could easily provide a group activity to the groups that addressed all the concepts and each group would be able to work together to teach each other the concepts that they might have missed on the assessment. Another way to group would be to put all the students that missed the same concepts in the same group and give them an activity to clarify their understanding. But I feel that the better option would be the first. It allows students to teach each other and makes sure all the concepts are covered.
I like how you have made the right and wrong so easily visible using the color red. It is really important as a teacher to see where you may need to go back to do some more work yourself. (It is also satisfying to see where you have allowed the children to excel!) I also think it was a good idea to group the students so that there is one "expert" in each group. That would help keep the whole group on track during the small group sessions. Did you use the conditional formatting function to highlight the cells red? (Not sure if that is what is called in GoogleDocs.) I love using that function in Excel because it makes the process of analyzing the data so much faster! Great spreadsheet!
ReplyDeleteI like your groupings and thought process regarding the learning that will need to take place. The only thing I might have done a bit differently is also see a percentage based column by student and question to see if any of them have mastered the concept so there would not need any more teaching needed. Most show mastery is 75%. I do like the idea of having an expert. Also, just by taking a test with one question of course would not demonstrate mastery of the standard. Normally it is a unit for each standard or a few together to demonstrate mastery.
ReplyDelete