Level Up 412

Build a first tech project you can explain

Turn a simple events list into a spreadsheet project with a clear question, a source record and one reusable output.

Three illustrated blocks for source material, a completed task and an explanation.

Your first tech project can fit in one sheet. Pick a question with a clear answer and produce something another person could check. Here is an exercise you can complete in a spreadsheet without having to write code.

Choose a question you can test

Suppose you want to find which of several community events starts at or after 6 p.m. and is free to attend. Use a short practice list you made yourself or a handful of public event listings. Keep the first version to eight or ten records. The exercise is about the process, so document what each row means before you add more.

Make the records comparable

  • Create columns for event name, date, starting time, listed cost and source.
  • Keep one event per row and use the same date and time format everywhere. If an event has two independent sessions, decide whether each session needs its own row.
  • Leave an unknown price as “Check with organizer.” Use zero only where the listing actually says it is free.
  • Filter for the confirmed free events that start at or after your cutoff. Open the sources for the rows that remain and check your work.

A simple test helps. Add a made-up event with no price and a 7 p.m. start to a separate practice copy. It should remain outside the confirmed free list. If it appears in the result, the filter is treating missing information like zero.

Finish with a one-minute explanation

Write the question, the source you used, one thing you cleaned and one case you could not verify. Save a copy of the working sheet, then export a view as PDF or take a screenshot of the result if you want to show it. Remove private information before sharing. That short explanation is the useful part of a portfolio example because a reader can follow your choices.

For more practice or help with a spreadsheet, see the Pittsburgh learning directory.