Posts

Showing posts from June, 2024

Highlight a Cell with a Change

This is not exactly what I wanted to do, but I think it might be useful nonetheless.  A while back I saw that Ben Collins had a sheet where the rows and columns would have a highlight wherever the cursor was. Since this is the summer of doing, I wanted to replicate that.  Well, I didn't, but I was able to make a sheet that highlights the last cell that was changed. I wonder what a spreadsheet that showed the last three changes - as a gradient - might look like. Anyway, the file is below. https://docs.google.com/spreadsheets/d/1PP0VK9WbOjufLXrdrFEbrv4TQ3xwdlLK0t4JQBt03dI/copy

Visualizing Student Support Data with Google Sheets

Image
In the beginning I joined the [formerly-called] SEN team last year. The team was using anecdotal records for their data collection. The issue was that it was kind of a black box -immediately I wondered how I would know if the strategies I was using with students in my care were helping them reach their goals. Last year, I helped the team reimagine some ways to collect data on student behavior through the use of rubrics, checklists, and goal trackers. We also had teachers write anecdotal notes about students while observing their behavior. This year, the school created a new position, inclusion support coordinator. The first thing she did when she came in was to ask how we could collect data from teachers more easily. I was elated to hear this and suggested we use a Google Form that could be easily bookmarked to the browser, so that's what we did. She pushed teachers to use it when they suspected academic or behavioral issues with students. We also did away with the former ways of c