We had a textbook that had been created with Quarto1. The instructor wanted to put it online but restrict access to Middlebury people through SSO. The one option I got centrally (paste the individual files into a Google Site) was not optimal. While our Middlebury accounts are limited in Google, I thought I had enough […]
Category: Google
OpenStax to NotebookLM Workflow
Google put out several OpenStax textbooks in NotebookLM format. One of our faculty was interested in how that’d work in physics but that was not one of the options currently available. Looking at what was happening, it just looked like they chopped up the PDF into chapters and pre-generated some of the NotebookLM studio options. […]
Vibe Coding Google Script Example
There’s so much about how AI is for coding and that coding is a solved problem there. I am less sure, but I usually am. I see AI regularly returning an entirely wrong language, let alone providing good, secure, modern, and clean code. I keep messing around with it in various ways. Here is a […]
More French Budget Complexities
It’s always interesting to see how people do things in other places. Our school in France has a lot of non-standard things going on. This one is based on the idea that overtime and recuperation time (coming in late to make up for working longer) needs to balance out for each week that starts with […]
Logging Time: A Song as Old as Time
As always occurs in places I work, we are looking to better log how we spend out time1 I do think it’s good to reflect on how you spend your time as an individual and as an organization. It’s also nice to be able to present aspects of that data with qualitative elements to paint […]
Make a bunch of documents with Google Script
I’ve got a Google spreadsheet with the last name in column B and the email address in column D. My goal is to make a bunch of blank Google docs,name them in a pattern, share them with individual students, and put them in a particular folder. I decided to go ahead and write the document […]
Read More… from Make a bunch of documents with Google Script
Indelible Google Doc Journal Entries
About a month ago, I did round one of the form-to-Google-Docs scripting post. Since then, we’ve done some testing and things are working well. There was a desire to have the ability to rename documents. That required some rethinking. It’s also quite possible that the add commenter function wasn’t working. In any case, it had […]
Google Forms to Google Doc Journal Entries
A teacher requested the following for weekly journal submissions by students. Whatever is submitted is only viewable to the submitting student and the faculty member Submissions are not able to be edited after they are submitted (by the student) All of the submissions (for each student) can be viewed in one location by scrolling. (Something […]
Extracting data using regexextract in Google Sheets
One of our tools has usage data that ends up being three items on one line. Each line of data is something like this 1. email@middlebury.edu 123. The first number doesn’t matter. I want the email address and the last number (which indicates usage hours). In the old days, I’d have rigged something together using […]
Read More… from Extracting data using regexextract in Google Sheets
On the Fly Data Validation Values in Google Script
I’m helping the School in France do some payment logging. We have five different activity types with different payment increment rules . . . so if you’re teaching a class you have a minimum of 90 mins, a minimum step of 30, and a max of 150 mins. For Tutoring it’s 15 minute minimum, 15 […]
Read More… from On the Fly Data Validation Values in Google Script