Category: Business

Crafting an Engaging Course Overview for Managerial Accounting and Finance

Opening video title "Welcome to BUS 306 Managerial Accounting and Finance." A collage of images in a circle; business meeting, shopping, pizza.
BUS 306 Course Overview opening title slide

Overview

For this project, I produced a two‑minute Course Overview video for BUS 306, a seven‑week online course in CUNY SPS’s Online Business program. My role was to guide the course developer, Professor Joseph Foy, through the scripting and production process. My approach was to help Prof. Foy shape the video into a concise and motivating “film trailer” for the course. A small challenge emerged when reading the first draft of the script. Prof. Foy used a Gen AI tool which created an unusual script format. Although well‑intentioned, this small deviation from past productions reinforced a key lesson: a strong video rests on a clear, focused script. The Gen AI version included several extra instructions and production notes, which needed to be removed in order to focus on delivering a clear, focused script.

Skills Gained

I worked with Prof. Foy to refine the script so it aligned with the video’s core purpose, and, as always, kept all design choices within Mayer’s 12 Multimedia Learning Principles. I cleaned and enhanced audio using Adobe tools, built visual sequences in a consistent template, and integrated context‑appropriate still images and stock footage. I revisited the first script that included the AI‑generated visual suggestions. This prompted an “a‑ha” moment: AI tools can give you ideas quickly, but you still need human judgment to make everything fit together. Throughout the project, I collaborated closely with Prof. Foy, incorporating feedback, and translating ideas into a polished, student‑ready resource.

Impact

This Course Overview addresses a persistent need in online learning: orienting students quickly and sparking early engagement. By framing the course around the experiential “Pizza Place Project,” the video helps students grasp not only what they will do, but why it matters. At time of writing, the video has yet to be seen by students in BUS 306, but Prof. Foy and other colleagues have praised the final product, noting its clarity, energy, and alignment with program goals. Once released, the video is expected to strengthen students’ first‑week experience and support OFDIT’s broader mission of elevating instructional quality across SPS.

Illustrating Excel’s IF Function Through Instructional Video Design

an animated gif of opening graphic animation
Video Excerpt: The Logic Behind the IF Function (no audio)

Overview

In this project, I collaborated with Professor Sandra Figueroa to clarify a concept that many CIS 101 students found confusing: the logic behind Excel’s IF function. My role began with instructional design, ensuring the script conveyed the concept with precision and simplicity. Although the technical content was straightforward, the challenge lay in helping novice learners grasp conditional logic. Through Prof. Figueroa’s expertise on the subject, we needed only a couple rounds of script review and discussion, we shaped an example that used a clear, everyday analogy to anchor the idea.

Skills Gained

I applied instructional design principles to refine the script, then shifted into media production—designing visual sequences in Prezi, creating simple animations, and editing audio and video components in Adobe Premiere. I used my understanding of multimedia learning to structure the narration and visuals so they reinforced one another without distraction. I also coordinated closely with Professor Figueroa throughout the process, adapting to her expectations and responding to the instructional needs of the course. The project sharpened my ability to translate abstract concepts into concrete visual experiences.

Impact

The final video addressed a clear pedagogical gap: students needed a more intuitive grasp of conditional logic before applying it in Excel. By pairing a relatable scenario with a structured visual explanation, the video improved comprehension and became a durable resource within the course. Positive feedback from colleagues and from Prof. Figueroa affirmed its clarity and instructional value. Its continued use over multiple semesters—well beyond the typical shelf-life for such media—demonstrates its effectiveness in supporting student learning at CUNY SPS.