What I've Built

Projects

A closer look at my projects: what each one set out to do, how big it was, and what I did.

Screenshot of the skill gap dashboard showing summary numbers and key findings cards

July – September 2026 · Solo project

CCI Course-to-Career Skill Gap Dashboard

  • Python
  • SQL
  • SQLite
  • Streamlit
  • REST API

Goals & scope

  • Goal: find out whether FSU's College of Communication & Information (CCI) teaches the skills entry-level employers actually ask for.
  • Scope: all 117 CCI undergraduate courses compared against 1,120 job postings from the Adzuna API, across four career tracks and 32 skills.
  • Key finding: AI was the most-requested skill, yet only one CCI course names it.

My role

  • Solo project: I came up with the research question, chose the data sources, the job search terms, and the skills list, and checked the results for accuracy.
  • Built the Python + SQL pipeline and Streamlit dashboard with the help of AI coding tools, directing the design and verifying every finding against the data.
  • Decided what was safe to publish, sharing only a trimmed database without the job posting text.
Live dashboard Code on GitHub

The free dashboard host naps when it hasn't had visitors. If you see a sleep screen, click “Yes, get this app back up!” and it loads in about 30 seconds. On FSU Wi-Fi, the campus filter blocks the host and shows a privacy warning; open it on cellular data or off-campus Wi-Fi instead.

Slide 1 of 7. Title slide: Social Media Marketing, LIS 4480 final project presentation by Mariana Neri Sapori, Julia Ledo and Trentt Melton
1 / 7

Example posts

Instagram post on getinvolvedcci_fsu for a CCI Game Night on Wednesday, April 1, 6 to 8 PM in the iHub Pitch Room, sponsored by SHI International Corp. Instagram post on getinvolvedcci_fsu inviting students to join the CCI Relay for Life team, with an interest meeting on February 5 at 5 PM in iHub 125

Spring 2026 · Team of three · LIS 4480 IT Leadership

IT Leadership Social Media Marketing

  • Instagram
  • Content Calendar
  • Analytics
  • Team Leadership

Accounts: @getinvolvedcci_fsu · @alignfsu · @noleyourcampus
Our team managed them from January 19 to April 18, 2026. They're now run by another class, so newer posts aren't ours.

Goals & scope

  • Goal: grow three CCI-related Instagram accounts and raise awareness of and attendance at CCI events.
  • Scope: January 19 to April 18, 2026, across Align FSU (career info), Nole Your Campus (FSU spaces), and GetInvolvedCCI_FSU (student and university events), with at least 12 posts per account and a follower-growth target for each.
  • Result: every account reached the 12-post minimum. GetInvolvedCCI_FSU had the highest growth rate of the three, going from 498 to 599 followers (+101), with 18,895 views and 868 interactions.

My role

  • Co-led a three-person team that ran the campaign across all three accounts, using a shared content calendar to keep posting consistent.
  • Was mainly responsible for @getinvolvedcci_fsu: created and scheduled 13 posts promoting CCI events and opportunities.
  • Tracked follower growth, engagement, and reach, and used the results to guide what we posted next.
View presentation