Sheets 4 Schools

I was back in Minnesota for the summer this year. The temperature really started to rise and I wondered if this was an anomaly, or if it was within the range of normal for July.  Then I wondered if temperatures were increasing. First I needed to get the data. A Google search for "Minnesota annual high temperature" led me to a site with the data I needed. <Example needed> Here I could use the IMPORTHTML function to pull the data to the sheet. There were actually two tables, so I needed to change the formula from 1 to 2. <Example needed> After importing the data, I copied it and pasted the values only. Then I could change the dates to year only (file>format>number), and moved the date column so it was to the left. From here, I was able to create a table. (file>insert>chart) Then, I thought I wanted the annual minimum temperature, so I repeated the process. My findings The high temperature for the years has somewhat remained stable, while the low temperat

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

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

This post was inspired by an article in Life Hacker . At the beginning of this school year, I had an interest in spreadsheets. I was also considered one of the more knowledgeable people in my school about them.  I was Googling how to do many of the more complicated formulas. I felt like I was moving too slowly and so I tried using AI to help me with those formulas I couldn't figure out. I remember when the AI boom hit. After I "discovered" ChatGPT, I found a site that would help you with Excel formulas. That site started charging to use it, so I tried using AI. ChatGPT is better at Google Sheets Formulas than Gemini There are many AI tools to choose from. I when I first started making this dashboard I started using Google's AI tool, Bard. I liked it, so I tried it with Google Sheets. I thought that since it is also a Google product it would but it was shocking to me how poor it was at handling Google Sheets formulas and solving problems I had.  I tried ChatGPT because

To be honest, I don't know the proper terminology. But, after spending about 4 hours working on this formula, I got it working. The problem I was trying to solve was that we had a spreadsheet that was being updated regularly with data, and we wanted to feed that data into a different spreadsheet.  I knew that. I could simply do this with IMPORTRANGE , which can get the data for each cell, but then I would have to create a formula for each entry. I wanted a single formula that matched the student name to the data. I knew from past projects that the INDEX and MATCH combination was probably something that I wanted to use. So I started playing around with it.  Student Name student ID gender grad year current grade DOB RTI reading level The particular data I wanted was the reading data.  In the end, ChatGPT helped me figure out that the formula would be something like the following. = VLOOKUP ( A7 , IMPORTRANGE ( "URL" , "SHEET!RANGE" ) , data COLUMN , FALSE )

Made with Craiyon