Spencer Ord | Project and AI Portfolio

Additional work

Other Projects

Project One

Portfolio Website

Project summary

What I built

Figuring out the best way to share my projects, thinking abilities, and AI usage was an exciting adventure. A trusted career advisor recommended creating a website, so I began by studying other portfolio websites. After collecting the features I found the most engaging, I used AI to create the website in a human in the middle style of development. This gave me a chance to reflect on what I've learned through my endevours, which was invaluable.

AI uses

How AI helped

GitHub Copilot's plan and agent features helped turn my rough mockup into working HTML and CSS, speed up layout iteration, and clean up structure as the site grew. I used it as a building partner while keeping the content, project choices, and final visual direction under my control.

TOOLS: GitHub Copilot • ChatGPT • Perplexity

Project Two

Automated Weekly Placement Reports

Project summary

What I built

At my BCC job, I built an automated reporting system that sends weekly placement reports every Friday. The system creates both a leadership report covering every BCC program and individual program reports for career directors, tracking full-time and internship placement data, class size, seeking status, and overall placement rate. A daily runner checks active cohorts, updates the right Excel workbooks with SQL-backed data, handles special program cases, and prepares the emails for the correct audience. These 15 reports saved my team 2+ hours a week, aligned career directors with leadership, and gave my data team week-by-week historical data.

How AI helped

Most of the project was built by me. ChatGPT helped me identify useful tools and libraries, compare implementation options, and refine individual functions as I worked through the code.

Product experience

I managed requests from about 15 full-time employee stakeholders and decided which needs were worth implementing in the code or report. For example, my boss wanted data visualizations, but Excel did not automate them cleanly, so I chose to create monthly visualizations by hand instead.

Project Three

ECEn 225 Doorbell Lab

Project summary

What I built

I built a Raspberry Pi doorbell that boots into a welcome screen, responds to a joystick button press, captures a photo, and sends the image to a server so it can be saved to a website. The project also includes a hidden menu for taking pictures, applying filters, and managing files, which gave me a chance to connect embedded software, device input, and simple networking into one complete system.

Technical skills

Tools and systems

Raspberry Pi C programming GPIO input Camera capture TCP sockets pthread threads systemd service File I/O

Project Four

How to Script Tasks using Python

Project summary

What I built

I created a beginner-friendly walkthrough that teaches how to turn repetitive work into a Python script, then schedule it to run automatically. The guide walks through a real example using CSV data, email delivery, and Windows Task Scheduler, so someone with little scripting experience can still follow the full process from setup to automation.

Technical skills

Communication strengths

Technical writing Plain-language guidance Teaching beginners Process breakdowns Step-by-step instructions Audience awareness Translating technical ideas Documentation