I love the part of designing a website where you’re exploring initial ideas. You’ve got a general direction and it’s time to think through interesting things that might play into the visual design and the functional aspects of this thing that doesn’t yet exist. Somewhere around Rasmus Lerdof’s quote – “I actually hate programming, but […]
The goal of this project was to have students logging their practice on translation and a separate non-translation activity.1 It’s a neat idea and I proposed doing it via Google Forms/sheets because it was a really short timeline. Here’s a walkthrough of how it ended up with version two. It’s likely we’ll have a more […]
Read More… from Parallel Practice Logging in Google Forms/Sheets
In the time of APIs, python scrapers and other cool things, bookmarklets have fallen from favor but they still have uses and I still like them. For small jobs that you want to make accessible to people they are still really handy. In this scenario Middlebury has lots of ways to get roster information about […]
This is for a workshop with students on Saturday. It’s a revision of a thing Jeff and I did a way back in 2018. I think I’ve come up with some improved examples and I’ve revised a few things. The goal is to let any skill level start to see how spreadsheets can be useful […]
Every place I’ve ever worked we’ve ended up talking about paths to deal with support emails and follow ups. Generally there is an existing technology helpdesk support system but it is usually unpleasant to use and hard to customize.1 What we have currently at Middlebury is a fairly typical combination of things going on. We […]
I’m trying to document this idea better because I’ve had trouble communicating it in the way that I want as I’ve started my new job.1 A dog is a chihuahua is a great dane WordPress multisite is a thing but it’s a thing that can be as different as a chihuahua is from a great […]
Read More… from VCU: The Long Goodbye (Patterned but not Standard)
An odd request came in from a faculty member the other day. As part of their research they had 60 or so CSVs that they wanted combined horizontally. I have many ways to do it vertically but this was a new one. Each file was around 350KB so they weren’t huge and 60 isn’t a […]
Read More… from Horizontally Combine Many CSV Sheets in Google Sheets
My date titles continue to get blurrier. The range of stuff covered gets wider. VCU is moving any course with over 50 students to the online format. We’re supporting that move in a variety of ways. Our little R&D group is trying to answer the non-standard problems, questions, media desires. To some degree we are […]
Well not really but I’ll explain it anyway. Gravity to Google There are a number of plugins that tie Gravity Forms to Google Sheets but most (all?) of them rely on the ability to create an application to get authentication tokens. Many institutional accounts turn off that capability. VCU has turned that off. As a […]
Read More… from Monthly Reporting, A Gravity Forms to Google Forms Love Story
Origin Story I got a fairly dense Word document that needed to go online in way that people could more easily navigate. After checking it out, it appeared we had a large number of sections but we were lucky in that they were designated by H tags of various levels. Now I could have gone […]
Read More… from H Tags and Auto-Constructing an Anchor Index