Monday, May 19, 2025

Structure Data

In our newsletter last week, there was a blurb on leaving teachers. It said their name, role, and how long they had worked at the school.

I am interested in odd things, so I wondered what the average number of years teachers stayed at this school.


I think aside from the amount of leaving staff for the size of the school, this is pretty usual. 

Then I started to add staff who have left in the past. Then I was wondering about current staff and now this is turning into an interesting personal project about how to structure data. 

I wanted to see what the average tenure of the teaching staff was, but then I could start asking questions about the max and minimum stay of teachers. 

I don't have the data for the reasons why teachers came or left, but that would be good to collect. 




Currently, I have teachers who have left and current teachers on different sheets, but I think they should all go on a single sheet with a dropdown for those who have left and stayed.

Monday, May 12, 2025

Filter Multiple Google Forms to a Single Sheet - Update Main Sheet as "Done"

Part of my goal in this Geometry unit was to collect more data on the students and ease the teacher load at the same time by automating the grading. 

I naturally thought of Google Forms.

We are two weeks into this unit, and (among other issues) I have a progress tracker that should show the teacher where students are and show the students where to pick up from.

I had this sheet with dropdowns that I could select to see where students were at. The problem was that:
  • It doesn't show the score,
  • It wasn't automatic.

With a little ChatGPT work, I got a formula using the FLATTEN formula. 


=IF(COUNTIF(FLATTEN('Lesson 4 Lesson Snap'!A:AC), A3), "Done", "")

This now gives me something that can automatically mark when students complete a lesson. I still have to go in to see what issues students have and where they need help.


Cross-posted to my main blog.