After the pandemic canceled our Winter Break travel plans for the second year in a row, this meant that my fiancée and I would have a lot more time on our hands than expected.
That, combined with some exceptionally dry knuckles, was just the excuse I needed to try my hand at a new electronics project. My goal was to answer the following question: How dry, actually, was the air in our apartment?
While I have had a definite fondness for (and occasional obsession with) computer programming since at least 6th grade, I’ve mostly gravitated more recently towards web development.
So for my final project of the summer, I decided to give actual app development one more chance by exploring the world of Swift and SwiftUI, two of Apple’s latest programming technologies.
The goal: build a watch app to help me track how much time is left in class!
Someone on Facebook was giving away a “late 2009” iMac with a busted graphics card. Getting that thing back into working condition sounded like a great way to kick off summer vacation!
Room 225 had never been a photography classroom, but something about a 28-year-old “memorandum” on darkroom chemicals seemed to capture the essence of that long-lost learning space.
As the ill-fated 2020 school year faded into memory, somehow I got it in my head that what I REALLY needed to do this summer was learn how to create a full-stack, single-page web application.
Imagine you have multiple tables of information, each serving a particular purpose, but one day, you need to somehow splice these tables together. Not only are those tables huge, but they’re not the same size, so copying and pasting the data would take forever.
What if there were a function that could do all of this for you?
What if I told you there IS a function that could do all of this for you?
I’m talking about VLOOKUP!
Let’s talk about mail merge, a technique for sending an email out to a large number of recipients while personalizing that message for each recipient. The simplest way to do a mail merge is in Microsoft Office, using a combination of Excel, Word, and Outlook.
I don’t always know why I care so much about certain things. But what I find out, time and time again, is that being able to recover and produce memories when someone needs them most is invaluable.
When I switched to all-digital rubrics a couple years ago, I wanted to reproduce the feel of writing on paper without actually using any paper.
One of the most important steps of planning a yearbook is seeing all the cool things that other yearbook staffs have done. So advisers throughout the country share “slides” with one another in the form of PDFs and JPEGs so that they can be included in presentations, galleries, and more.
This need to share work digitally has become even more pressing with the advent of COVID-19 since many of us are now facing significant delays in the printing and shipping of our books.
Exporting to PDF or JPEG isn’t that complicated for a single file, but the yearbook is made up of over 100+ files. On top of that, the printing plant breaks all of the documents’ image links when they send them back to me after processing. So I need to fix all those links, export the file, and then crop a whole bunch of technical garble off the bottom of the output over 100 times. (Ugh!)
This sounds like a job for automation!
Want to see how it’s done? Follow along!