Skip to content

Guest Post: Using Excel Teaching Videos at U. of Dayton

February 10, 2013

steve harrodDr. Steven Harrod is Assistant Professor of Operations Management at the University of Dayton. If you teach Excel modeling in your OM class, you will enjoy Steve’s detailed “how to” videos.

Videos are a great  way to help students learn the complexities of modeling in spreadsheets. Students can be overwhelmed when this material is presented live in lecture. Too often, students experience computer technical problems, and become lost in lecture while they attempt to fix their technical issue. These videos allow students to follow the lesson at their own pace, as they resolve problems such as installing add-ins (or even charging their battery!).

The first video supports Chapter 4, Forecasting. Titled “Creating an Exponential Forecast in Excel, Including Error Statistics” (http://youtu.be/uHy5tG1Rdvg), it walks
students through the process of formatting a spreadsheet, generating an exponential forecast, and calculating error statistics for that forecast. This video, and the others, was purposely recorded at a low screen resolution and high magnification, so that the visual clarity is high. The runtime for this video is 23 minutes.

The second and third videos are fundamentally linear programming exercises. “How to Create a Linear Programming Transportation Model” (http://youtu.be/RZX2bmoCzLI) is self-explanatory (runtime 14 minutes). Sharp eyed readers will recognize this as Problem 16 from Module B.

“Aggregate Planning on Microsoft Excel, Transportation Model” (http://youtu.be/m44gSMpb3Ic) is another transportation model, this time from Chapter 13, Aggregate Planning. This problem is “Planning Example 1” from the Heizer/Render text (Tables 13.2 and 13.3). This video is longer, at 36 minutes, because the data entry and model structure for the aggregate planning problem are more complex.

I hope you find these videos useful in your course presentation, and I welcome your comments at steven.harrod@udayton.edu.

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Supply Chain Management Research

Andreas Wieland’s supply chain management blog for academics and managers

better operations

Thoughts on continuous improvement: from TPS to XPS

%d bloggers like this: