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.