My very first blog post when I set up this website in July of 2019 was about buying a brand…
For some reason, Schoology’s “Assessment” tool cannot tell you how many students picked an individual incorrect answer choice on a multiple choice question.
(This is particularly annoying because Schoology’s similar but older “Test/Quiz” tool CAN give you this information!)
Even though Schoology can’t summarize the results for you, the information is all there. We just need a way to process it.
Suppose you’ve asked someone for some information. You were hoping for a nice, neat table, but what they’ve sent you back is, well, messy. Maybe the columns aren’t broken up the way you expected. Or maybe you don’t even have any columns, and it’s just several rows of information pasted into an email.
If you need to sort your data, run a mail merge, or do anything useful with this information, you’re going to have to clean it up first. Fortunately, Excel has a tool for just this type of problem: Text to Columns.
Let’s take a look at how to use that tool along with the Find/Replace feature to organize a stubborn set of data.
Because we’re nerds, my fiancée and I like to keep track of our score every time we play Spirit Island, a fun but complicated cooperative strategy game. Calculating the score requires looking up a difficulty rating in a table, a fair bit of counting, and some math.
While none of that is especially hard to do, the process could go a bit quicker if most of the work (aside from the counting) could be done automatically.
As it turns out, this is a great job for Apple’s Shortcuts app!
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!