Creating a Student Lookup in Google Sheets

By Thomas Hammerlund -
The idea of a student lookup system has been rattling around in my head for a few years. I started this in Google Data Studio, but Data Studio started changing and I couldn't keep up. Data Studio became Looker and now four years later, it looks completely different than it did.

I have been playing with Google Sheets for a few years, and when I came to our Sheet with PYP student data, I could see that some of the data, like reading levels, was something that was outdated for most students on one sheet, but on another was kept up-to-date (EAL).


The original sheet

I started with the reading data and found that I could use VLOOKUP to connect the above sheet to the EAL sheet. The formula I used pulled the reading data from the EAL sheet and keeping our sheet updated. I also started looking for other pieces of information I could keep updated with a formula. 

This got the ideas flowing and I put my homeroom teacher hat on. I wondered what I would want to see as a homeroom teacher for a student. 

I started with a student name that would bring up strategies and goals for a student.



This was good, but then I wanted to expand it to filter between PYP, MYP, and DP. Then I wanted to know other information about the student like the number of submissions they had, reading level, language phase for MYP/DP, and a link to their support plan. I came up with this:

The updated sheet

I can see that I am not done with this - I would like to add the current number of absences, EAL goals and strategies, and something else that slipped my mind, but it is a start. 

Popular posts from this blog

My Biggest Regret

By Thomas Hammerlund -
Image
via Google Search I don't like to ruminate , but I do catch myself wishing I could have done things differently in the past. It was the first month into a coaching position that was new to both me and the school. I was asked for some ideas for math ... I had some, but I also had an awesome math book. I am embarrassed to admit what I did next - I went to this teacher's room, handed the book over, and said something like, "Read this. It's good." No offer to come in. No observation. This issue didn't have anything to do with tech and I was a technology coach after all. If I could do it over I would go in and observe. Then I would meet with the teacher. I would then go through the book and pick a few (3-4 perhaps) of the ideas out and make a menu from which the teacher could choose. I would brainstorm ideas along with the teacher how to make it work. I would then offer to model or co-teach a lesson. That's what I would do now anyway. I want ...
Read more

Take Advantage When Opportunities Arise

By Thomas Hammerlund -
Image
In her book, The Power of Inquiry, Kath Murdoch has a chart of what inquiry teachers do. One of those things is to link investigation to authentic contexts (p. 21). This has been a focus of mine for this current unit. The phrase jumped out at me because I missed out on one such opportunity about five years ago , and I have probably missed out on many opportunities since then, but I have always thought about that missed chance. Hopefully, regretting that missed chance has helped me be more confident in taking risks with my teaching and looking for opportunities when they arise. The other day I may have caught the opportunity. The Junior High was having a Pancake Bake Sale fundraiser, but it was during recess time. The schedule worked out so that Grade 1 had class during this time. My students were not too pleased with this development and I got an earful coming up the stairs. We are currently looking at opinion writing, so I decided to try to make a connection to our wr...
Read more

9 P's of Digital Citizenship by Vicki Davis

By Thomas Hammerlund -
Image
This was a good webinar about keys to digital citizenship by the cool cat teacher herself, Vicki Davis. I have tried before of writing out my notes to books and other learnings, but I wanted to try something new. So instead, I made an A3 infographic that I can print and refer back to. Feel free to take it and modify it. Download this template
Read more