When people think of Excel, they typically think of spreadsheets, budgets, dashboards, and data analysis. But Excel’s grid can also be used as a surprisingly effective canvas for creating pixel art and simple animations. As a fun experiment, I built a nighttime city skyline entirely from Excel cells. The buildings are made of colored cells, […]
Category: Education
Multi-Leg Route & Proportional Journey Mapping
In this post, I share my method of creating charts in Excel to visualize multi-leg journeys with time-proportions and icons using data. Once the structure is in place, they are scalable and data can be updated without ever needing to manually create any designs or artwork. A quick video intro to this article (more details […]
Learning Tool: Flashcards
This is a subset of testing required for earning the Washington State Food Handler/Food Worker Card. This app demonstrates a learning aid using Flashcards. This was created in Knowt editor. Clicking on the right side of the card, flips the card revealing the answer. Clicking on the left side of the reveal card reverts back […]
Branching Scenario in Instructional Design: Food Safety
A multi-branch scenario learning content created in opensource H5P platform for proper food handling as required for food serving establishments in Washington state (part of the testing required for earning the Washington State Food Handler/Food Worker Card). It demonstrates: Decisions, and consequences, and conditional branchings. Also employs conditional media format presentation (images, videos). Format: Decision-making […]
Hotspots, Markers Learning: Dishwashing Procedure
This is a subset of testing required for earning the Washington State Food Handler/Food Worker Card. The quiz was created in opensource H5P platform for proper dishwashing procedure for food establishments in Washington state. Demonstrates: Hotspots or markers on images feature. Format: Exploratory learning. Ungraded. For more Instructional Design demos, click here.
Interactive Quiz: Safe Food Handling
A quiz created in opensource H5P platform for TCS (temperature control safety) foods. This is a subset of testing required for earning the Washington State Food Handler/Food Worker Card. It demonstrates various content types: Multiple choice (single answer, multiple answers), True/False, Fill-in-the-blank, Drag-and-drop words, Drag-and-drop images. Keeps scoring, checks answer on each quiz, Show Solution […]
An Online Memory + Quiz App: Gamified
This is a subset of testing required for earning the Washington State Food Handler/Food Worker Card. This app (runs in any browser and device) demonstrates a quick memory game combined with a test of knowledge built by me using opensource platform H5P, then ported to a standalone HTML5 page. It tests your knowledge of proper […]
Understanding Step Charts (and creating them in Excel, Python)
Step charts are suitable for showing fluctuating or irregular values over time. There’s no built-in Step chart type in Excel, so most people use a Line chart instead, which is not really ideal or sometimes accurate (I’ll explain that below). With proper data shaping, it’s possible to create Step charts in Excel. In this post, […]
What generation are you, what does it mean?
Generational names and their time ranges help to identify and categorize people born within specific periods, often characterized by unique experiences, cultural trends, and societal changes. In this post, I share its brief history and an interactive embedded program where you can find out about your or anyone else’s generation details. History of naming generations […]
Excel…and Romance?
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]