These are examples of my lecture videos. The first one is an example of how I present my background to students. It is titled "Who Is Dr. Jerz." The next two are from my Business Analytics course and illustrate how I lecture about a topic, and the show students how to apply what they learned using Microsoft Excel. The last example is from my Operations Management course, also illustrating a lecture about a topic, and then following it with applying what was learned using Microsoft Excel.
As you watch these videos, you might notice that the "content-per-time" is very high. I carefully produce these videos to squeeze the most information into the shortest amount of time. This approach benefits the students. When I cover these topics live in the classroom, they usually take around one and a half hours to present. Videos, of course, offer students the ability to review material quickly for better understanding.
My videos should play well on any computer, tablet, or smartphone.
Who is Dr. Jerz
This video provides students with some information about myself. I believe that it is always good to know something about the professor's background so that one better understands his perspective about a topic.
Who is Dr. Jerz (12 minutes.)
Here are two examples of videos from this MBA8150 course.
Course Introduction video (24 minutes.)
Ch03 Lecture: Describing Data Numerically (24 minutes)
Ch03 Excel: Descriptive Statistics (25 minutes)
Operations Management: Excel - Productivity Calculator
This lecture video shows students some of the basics of using Microsoft Excel with the goal of producing a "productivity calculator." This video reinforces lecture concepts.
Ch01: Excel Productivity Calculator (24 minutes.)
Using my Moodle Course Management System
This video shows students how to use Moodle for my courses.
Moodle Overview (27 minutes.)
Ad-hoc Video Example
This video is an example of how I answer student's questions using real-time video production, as opposed to my carefully edited videos.
In class, we had some discussion about "named ranges" versus B:B type referencing. Here are some of my thoughts about these referencing alternatives.