Projects – Alyssa Manchester

TA Office Hours Attendance System • 2025

Built an automated attendance system for teaching assistant (TA) office hours that streamlined student check-ins and centralized data tracking. TAs select their active shift and current project via a shared dashboard, while students check in by scanning a QR code linked to a Google Form. Form responses are automatically cleaned (trimmed and capitalized) and logged into a structured spreadsheet with columns for date, student, section, TA, question, and project. Separate tabs auto-filter attendance by TA, and dashboard stats (like unique student counts) update in real time.

View the Documents

CSVC Impact Consulting Fellowship • 2025

Worked with a team in the Impact Consulting Fellowship to help Olney Theatre Center find new ways to use its spaces and programs to bring in revenue. Collected and organized data on local venue rentals and education programs, and reviewed OTC’s past event and program records to spot underused spaces, busy seasons, and growth opportunities. Created recommendations for pricing, marketing, and new program ideas, and presented them to OTC leadership with visuals, projections, and clear action steps.

ENGL394 Adobe Portfolio • 2025

Built a professional Adobe Portfolio for ENGL394, curating three artifacts with polished contextual statements. I selected projects that balance technical, communication, and leadership skills: a BMGT301 attendance tracker, targeted beginner-friendly video editing instructions for CRCMC interns, and an interfraternal case competition presentation. I refined content through consistent tone, and clean layout choices so the site reads clearly and feels cohesive.

View the Adobe Portfolio

IMDB Top 1000 – Power BI Dashboard • 2025

I originally planned to showcase Tableau on my site, but losing access to the paid version pushed me to learn Power BI, so instead I built this end-to-end project. I cleaned the IMDB Top 1000 dataset in Excel (numeric gross income, tidy years, decade group), then designed an interactive Power BI report that opens with KPI cards and continues into Top-10 analysis, rating trends, a decade comparison of gross vs. average rating, and genre-by-decade breakdowns. The final section includes slicers so you can filter by genre or decade to explore the data from different angles.

View More · PDF

Interfraternal Case Competition – EV Investment Strategy • 2024

Led a team in the Smith School’s Interfraternal Case Competition to evaluate Tesla, BYD, and Toyota as long-term investments. We analyzed financials, debt, and EV adoption trends, then pulled our findings into a clear strategy brief and presentation. Our work earned 2nd place out of ~20 teams and strengthened my skills in leadership, research, and presenting to a large audience of peers and professionals.

Case Brief (PDF) · Slides (PDF)

DSP Recruitment Video – Editing Project • 2024

When applying for Delta Sigma Pi, I produced a video response to the prompt “Which reality competition would you be on, and why would you win?” With a two-day window during the school week, I storyboarded a short Lego Masters pitch and edited it in the style of a video essay. Techniques I used included 3D-angling images and text, a light grain for an old-TV look, on-beat cuts with playful music, highlights synced to narration, and a simple animated mouth rig on a still photo. Honestly I did alot more but you'll just have to watch to see.