We’re doing some strategic planning in Google’s Jamboard. I find it good for the live/interactive aspects of the conversation but when I was looking back over it, it was hard for me to read and organize in my head. I decided I wanted the text from the various sticky notes in a spreadsheet so that […]
This post is supporting a bunch of tweets going out for pressedconf22 on March 24. Why? The basic idea is that WordPress is good for taking care of the mechanics of writing on the Internet. It deals with users, logins, uploading media, writing to the database, etc. On the other hand, WordPress themes can feel […]
I’m working with Greg Pask to make a lab website. When I asked him for some visual inspiration he sent me two comic book covers by David Aja. That was a first! It’s driving me to do some interesting things in Illustrator for the first time. I’ve long promised myself I’d learn vector drawing but […]
The following is what I wrote for this year’s DLINQ Digital Detox. It was strange writing without footnotes. It’s also a lot less of my normal writing voice. I was writing for a bunch of strangers rather than you, my dear readers.1 It’s easy to use the web without thinking about it much. Modern processors, […]
Read More… from Detox Site – Energy-conscious website breakdown
This is for the Domain of One’s Own Roadshow workshop/conference thing. Reclaim stuff is always fun and I should have gotten this down earlier but I didn’t so I’m just trying to get down some ideas on assessment and data. I read it now and I’m kind of bored myself but overthinking the value of […]
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 […]
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
Origin Story The 2020 All Stars project1 is tied to the FotoFika site supporting photography faculty teaching online due to COVID. One of the concerns that came up in discussions was that this year’s graduating class wouldn’t be getting the personal connections that normally happen during exhibitions. That led to a discussion around Mike Mandel’s […]
I have someone who gathered a bunch of tweets for their research using Martin’s TAGS aggregator. She wanted to show all the avatars. Once I published the spreadsheet, here’s all the javascript needed to make that happen. It’s lightly annotated for your reading pleasure and the functioning codepen example is included below. See the Pen […]
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