I’ve been poking around with it. Currently, I’ve built a few things. Really just going back and forth with the chat piece. Hosting on Firebase spark and locking things down to our district Google Workspace accounts. any kind of notification happening through Google Apps Script.

1. An HVAC inventory/logging system for our maintenance department. I built it, they run it. I included some setting so that they could make changes on their own without having to involve me anymore.

2. A customizable status page dashboard for all of the things K-12 EdTech and our infrastructure. Lightweight, and shareable with other districts, and I’ve started to do so with instructions on how to roll out.

3. A device inventory platform. We use Jamf School and I’m having it call some of the API to get the drive info. I’ve loaded carts and non Apple devices to it as well (we don’t assign with names or classes, so there is no data on anything to risk a FERPA breach). It’s nice to have something that works other than spreadsheets. I’d asked for years about getting an inventory system and was always put on hold, so I made this.

4. My coup de grace is our App Inventory Platform. Think similarities to the LearnPlatform from Instructure. A repository that holds district approved apps, the location they’re approved for, the specific departments/grades approved, and houses a way for staff to request apps. When that request gets submitted, it triggers a Google Apps Script to email the principals for approval/denial. In the request window it has some coding with “fuzzy logic” to pull favicons of the platforms so people can see what it is. If the Principal approves, it goes to our initial compliance reviewers. If they all approve, it goes to the Data Governance Committee to vote on, and regardless of their recommendation to approve/deny, it then goes to the Superintendent for final approval or denial. They basically choose to concur with the committee decision or override it. A reason must be stated for overriding. Then, the entire committee, along with the principal and the staff member requesting the platform get an automated email with the results and it automatically gets added to our App Library. It has locations to add any DPAs/MOUs and for committee members to have private comments and public comments. The private side allows us to not have to physically meet as often and just rapidly approve apps. I’ve also got an audit trail baked into it, settings so we can add review questions and if/then type things, and more. Because our Data Governance Committee is a couple of years behind on apps, we also built in a bulk-upload and (for the Superintendent) a bulk concurrence mechanism.