Coach teachers in and model effective use of technology tools and resources to systematically collect and analyze student achievement data, interpret results, and communicate findings to improve instructional practice and maximize student learning
Spreadsheets were an important part of my classroom data collection repertoire. To meet standard ISTE-C 2h I want to talk about how I used data as a teacher and how technology allowed me to easily collect, analyze and communicate that data to improve student learning. All of the teachers at my grade level collaboratively used Google spreadsheets. For each math test, we created a shared spreadsheet that included all teachers and all students to see trends in classrooms and across the grade level. Using these spreadsheets, teachers were able to collect and analyze student achievement data across an entire math unit. Additionally, we combined spreadsheet data to track student progress over time with summative and formative assessments to demonstrate student learning. The data we collected was used to support evidence of growth for student growth goal data.
The benefit of these math spreadsheets was that I was able to closely track both individual and whole class progress over time and could intervene when necessary with individual or groups of students.
As a coach I have encouraged buildings to use a spreadsheet to track student behavior across the school. This has helped them consistently track behavior to provide evidence and updates to parents, classroom teachers and special education teachers. Behavior tracking also maximizes student learning because patterns can be observed on a larger scale since multiple adults are collecting data efficiently on one student or a group of students in a school.
Students also benefit from learning how to track their own progress with a tool like a spreadsheet. I found that self-reflection and goal setting is a skill 4th grade students need to develop over time. I looked into different tools that might be suited to help students do that in my post Empowering Students to Set and Achieve Learning Goals for Improved Outcomes. One barrier I encountered with elementary students was many products require an email and for each student to have an account. Instead, I found that using a district approved and adopted tool with students might be the easiest and most efficient process. Using your district’s equivalent to a tool like Google Docs or Sheets would allow for students and teacher to track progress over time.
For more on how I have met ISTE-C 2h see my complete post Empowering Students to Set and Achieve Learning Goals for Improved Outcomes