top of page

Multimedia Production

Recognizing the self-directed nature of adult learners and the importance of intuitive design, I've leveraged my extensive background in multimedia production, honed through master's and doctoral coursework using tools like Camtasia, iMovie, Audacity, and AI to design learning experience for diverse learners. 

 

Arduino Robotics Learning RoadMap

​​

Alt text: Arduino Robotics Learning Roadmap

​

Arduino Learning Roadmap was a multimedia learning tool built in Obsidian to help adult learners to learn what is Arduino and how to program it. I started with Gemini Deep Research to come up with a roadmap document by using prompt engineering techniques. The initial AI-generated roadmap served as a foundational blueprint, which was then refined to ensure that the learning objectives were well-defined and that the content was organized in a way that promotes understanding and retention. 

 

While the initial roadmap created by Gemini was text-based, the visualization in Obsidian's graph view introduces a visual representation of the learning pathways and relationships between concepts, aligning with the multimedia principle that people learn better from words and pictures than from words alone. This visual element can aid understanding by presenting information in a spatial and interconnected manner. Furthermore, the roadmap serves as a foundation upon which multimedia elements like explanatory videos, interactive simulations of Arduino circuits, and code demonstrations could be easily integrated at each stage, catering to different learning styles and enhancing engagement and retention, as suggested by multimedia learning theories for adult learners.

 

Adult learning theories significantly influenced the road map design by recognizing the unique characteristics and needs of beginner adult learners. Learners can easily download the roadmap I created to start their own learning journey and take notes on Obsidian by themselves. This design is based on adult learner's desire for autonomy and self-direction. By providing a clear, organized, and resource-rich pathway, the roadmap aims to reduce cognitive load and foster a sense of accomplishment, crucial elements in motivating adult learners new to Arduino robotics.​

​

​​​​​

​

SQL Tutorial published on YouTube

Drawing upon established adult learning theories, my recent endeavors have focused on creating effective learning experiences. To address a critical gap in SQL education, I'am developing a series of YouTube tutorials aimed at demystifying complex SQL concepts, acknowledging the identified difficulty learners face in this area and the scarcity of high-quality and accessible resources.

 

This tutorial guides learners through the process of setting up a local Oracle Database Free environment using Docker containers, connecting to it via SQL Developer, and installing the Oracle Database Sample Schemas (version 23c) for making queries.

​

Alt text: This is a Youtube tutorial on SQL 

Description

  • Target Audience: Beginner to intermediate SQL learners, database administrators, and developers who want to learn how to set up an Oracle Database Free environment for practice and development.

  • Learning Objectives:

    • Successfully deploy Oracle Database Free in a Docker container.

    • Connect to the database using SQL Developer.

    • Install and utilize the Oracle Database Sample Schemas 23c.

    • Gain hands-on experience with SQL and database administration tasks.

  • Delivery Method: Video tutorials with screen recordings, voice-over explanations

  • Tools Used: Docker Desktop, SQL Developer, Oracle Database Free Docker image, Oracle Database Sample Schemas 23c scripts.

​​

Specific Content Breakdown:​

  • Part 1: Docker Deployment of Oracle Database Free:

    • Provides step-by-step instructions for pulling the Oracle Database Free Docker image.

    • Explains how to run the Docker container with appropriate port mappings and environment variables.

  • Part 2: Connecting SQL Developer:

    • Guides learners through downloading and installing SQL Developer.

    • Explains how to create a new database connection in SQL Developer, specifying the correct connection details (hostname, port, service name, credentials).

    • Demonstrates basic SQL Developer functionalities, such as the SQL Worksheet and Schema Browser.

    • Troubleshooting Connection Problems.

  • Part 3: Installing Oracle Database Sample Schemas 23c:

    • Provides instructions on downloading the Oracle Database Sample Schemas scripts.

    • Explains how to execute the scripts in SQL Developer to create the sample schemas (e.g., HR).

    • Demonstrates how to explore the sample schemas and query the data.

    • Explaining the benefit of using sample schemas for learning.​​

​

Reflection and Rationale

​

I aimed to bridge the gap between theoretical SQL knowledge and practical application by providing a clear, step-by-step guide to setting up a functional Oracle Database environment. I encountered challenges in simplifying complex technical concepts for beginners and ensuring compatibility across different operating systems.

 

The tutorial promotes active learning by encouraging learners to build their own database environment. Learners are not passively consuming information but actively constructing their knowledge through hands-on practice. This aligns with constructivist principles, emphasizing that learning is most effective when learners create their own understanding. Besides, the content is broken down into manageable chunks to minimize cognitive overload. Each video focuses on a specific task, reducing the amount of information learners need to process at once. The step-by-step approach and clear explanations help reduce extraneous cognitive load.

bottom of page