Making Learning Visual

Data Collection

On Friday, I spent time collaborating with a colleague of mine. We were looking closely at a recent Writing Post Assessment for Narrative Writing. We were looking for trends in the comments I had written to students. This information would help us form small group instruction.

As we analyzed the data (scores) and the comments I had written, we were also looking for whether or not students had improved. This required us to look at the Elementary Assessment Spreadsheet data. From the spreadsheet, my colleague and I were able to see if students’ scores had improved from their pre-assessment scores.

While we were collecting all of this data, we were adding some notes to a Google Keep note that helped us organize small groups and notice patterns. Then, I wondered if putting this information into an infographic might be helpful and more effective for us. So, I decided to give it a try!

Writing Post Assessment Infographic (Including a link because I am having issues inserting a document)


Having this visual of the data that was found from the assessment, is useful in many ways. First, I can see the percentage of students whose score either went up or stayed the same. This allows me to see the students I need to target in small group instruction. The bar graph at the bottom represents patterns that were noticed in the post-assessment comments. I can look at this infographic and see how well my students did as well as areas that still need to be reinforced.

I also think an infographic like this is helpful because it organizes all the data in one place whereas before I was looking at several documents (Elementary Assessment Data Spreadsheet, Google Keep notes, rubric comments, and a Google Doc with information that was gathered on students’ writing). In the future, I would still need to gather information from these resources, but putting it all together helped me organize all of the information in one spot as well as share it with my support teachers.

Support Tool

Having a visual representation of the data collected from the Writing Assessment is one easy way to share information with the teachers who work with my students; especially the EAL and writing push-in teachers. By sharing this infographic, the teachers working with my students will also know what skills they can reinforce and which students still need more support. This allows us all to collaborate and meet the needs of the students in an effective manner.

This spreadsheet of a Post-Assessment for Reading allows me to see which students still need support and in which areas they need support in. The color coding was done using Conditional Formatting in Google Sheets.

In the future, I might not go as far as making an infographic of this type of information. Although it was kind of fun to see it in the formate, I think I would be able to get the same information by using conditional formatting in Google Sheets. I’ve done this before with pre and post-assessment data and the conditional formatting commands I used allowed me to see a color-coded document showing student growth. This was an easy way to see which students still needed support.

Using visuals is not only useful for students. There are so many ways teachers can use visuals to improve their teaching practices. Making data visual is just one-way teachers can use the information they collect from students useful.


Author: Andrea Goodrich

I am an international educator working in Hanoi, Vietnam. I have been working overseas for the past 13 years. I started my career in a bilingual school in Guayama, Puerto Rico as a fifth and sixth-grade reading teacher. Then I moved to Guayaquil, Ecuador, and taught fourth grade for two years. While living in Ecuador, I met my husband and we moved to Seoul, South Korea together. In Seoul, I taught fifth grade for two years and then moved into a literacy specialist role. We are now teaching in Hanoi, Vietnam with our two Korean rescue dogs.

4 thoughts on “Making Learning Visual”

  1. Hi Andrea,
    Wow! I thought your info graphic looked awesome!! I thought your use of contrast made the graphics really pop and the information was easy to follow. I liked how you said you and classroom teachers would be able to use this info graphic to target specific skills that students are ready to develop further. I also appreciated how you mentioned the benefits of compiling information into one place. That is something I am still working on as we have some information on paper while some is stored digitally. I am in the process of trying to put all student data in one, easy to reference document but it is definitely a work in progress!

    1. Thanks Simon. At my school, we have an assessment document (Google Sheet) we enter data into for reading, writing, and math assessments. This allows us to see everything in one place. It also allows you to see if students are making growth across the year as well. It’s easier to see these things when the data is in one place.

      Thanks for your comment!

  2. Hi Andrea!
    I really liked how you made the student data into your infographic. What a great (and different) way to quickly see the patterns in the data. I especially found the part about how many students are meeting grade level expectations a great visual with the number of people colored in. I had always wondered how other people made cells in Sheets automatically change to a color based on what was typed into the cell – now I know, thanks to the link to the blog about conditional formatting that you included. Have you ever used a Google Form and conditional formatting in Google Sheets together? The blog post you linked mentions this and I was wondering how it would look in practice.

    1. Hi Erika, thanks for your comment. I have used a Google Form to collect student data in a Google Sheet. It worked out really well and it was a quick easy way to collect data from my students and see it in a visual way. Color coding is a quick way to see who still needs extra support. I often use Alice Keeler’s blog when learning how to use new tech skills. I find her blog to be really helpful!

Comments are closed.