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.)

Button to play video "Who is Dr. Jerz" Button to download video "Who is Dr. Jerz"

Business Analytics:

Here are two examples of videos from this MBA8150 course.

Course Introduction video (24 minutes.)

Button to play video "Course Introduction" Button to download video "Course Introduction"

Ch03 Lecture: Describing Data Numerically (24 minutes)

Button to play video "Ch03 Lecture: Describing Data Numerically" Button to download transcript SRT file Descriptive_Techniques.

Ch03 Excel: Descriptive Statistics (25 minutes)

Button to play video "Ch03 Excel: Descriptive Statistics" Button to download transcript SRT file Excel-Descriptive_Statistics.

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.)

Play video 'Ch01: Excel Productivity Calculator' Play video 'Ch01: Excel Productivity Calculator'

Using my Moodle Course Management System

This video shows students how to use Moodle for my courses.

Moodle Overview (27 minutes.)

Button to play video "Overview of Moodle" Button to download video "Overview of Moodle"

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.

Button to play video Button to download video