5-2/3: Data Analysis and Tools

5-2: Data Analysis

Here is the link to my data sheet:

https://docs.google.com/spreadsheets/d/1Zc3HIXha4qNjZPfJMXx7S5HffjtGuitTtSjHBN7WUKo/edit?usp=sharing

Data Analysis: 
Upon looking at student data, some clear trends appear regarding standards. The first thing I noticed was that almost all students have a firm grasp on Standard 7! From there, I could see that Standard 1 and 2 have a large amount of students who have mastered them, but need some small group reteaching. Standard 6 shows the biggest area in need of reteaching because most of the students chose the wrong answer. I almost wonder if this question was worded differently than how they had been instructed or if the material was new to them. Standards 3-5 and 8-10 show about half of students mastering them. These standards may need to be continued in the classroom, with students who have shown mastery progressing to more challenging work.

My suggestions based on this testing data is that the teacher needs to group students based on areas of weakness. Within standards, he/she should work on pairing students who chose similar wrong answers to address the misconceptions or errors that led to that answer. The teacher also needs to look at standards with high error rates and think about reteaching the material with a different method to help students gain a better understanding.

5-3: Tools

The tool that I used was Google Sheets located in Google Drive. I like how easy it is to use and the fact that I would be able to share it with my partner teacher, so we can both access the information any time we need it. A strength of Google sheets is how simple the layout it. It is very user friendly and easy to edit and change.

I found that adding color made a huge difference to me. I used a different color for wrong answers to each question. This made it very easy for me to see which questions were more challenging to students quickly. It also helped me to focus in on who would need small group instruction for the different topics.

I feel that Google sheets would be a great way for student data to be shared among a team. My school currently emails Microsoft Excel sheets to each teacher for them to collect data and email back to the principal. By creating a spread sheet on Google sheets for each grade level and granting them access to it, I think we could make the process a lot more streamlined and save everyone some time and hassle!