CTL.SC4 Supply Chain Technology & Systems

Overview

This course was offered from January-March of 2017. It focused on the technology systems used in supply chains. The course begin with an introduction to databases. This included data modeling, database design, and SQL. It then moved on to machine learning algorithms (utilizing the Orange platform), and then concluded with a study of ERP (Enterprise Retail Planning) systems.

An interactive business simulation (The Fresh Connection) was also used over the course of this class to allow students to demonstrate key concepts learned in all of the classes, as they managed the components and business processes of a simulated supply chain. The simulation was a bit too complicated (IMHO), but it did provide some interesting ways to visualize and manage supply chain KPIs. For this reason, it is documented in detail on a separate page.

Course Content

Week 1 - Data Management 1

  • [Key Concepts](assets/sc4/KeyConcept - Week 1 and 2.pdf) (week 1 & 2)
  • Lesson 1 - Intro to Data Management ([pdf](assets/sc4/Week 1 - Lesson 1 - Intro to Data Management.pdf))
  • Lesson 2 - The Fresh Connection ([pdf](assets/sc4/Week 1 - Lesson 2 - The Fresh Connection.pdf))

Week 2 - Data Management 2

  • Lesson 1 - Data Modeling ([pdf](assets/sc4/Week 2 - Lesson 2 - Data Modeling.pdf))
  • Lesson 2 - Database Normalization ([pdf](assets/sc4/Week 2 - Lesson 2 - Normalization.pdf))

Week 3 - Data Management 3

  • [Key Concepts](assets/sc4/KeyConcept - Week 3.pdf)
  • Lesson 1 - Database Queries ([pdf](assets/sc4/Week 3 - Lesson 1 - Database Queries.pdf))
  • Lesson 2 - Database Queries, part 2 ([pdf](assets/sc4/Week 3 - Lesson 2 - Database Queries - part 2.pdf))
  • Recitation - MySQL ([pdf](assets/sc4/Week 3 - Recitation.pdf), [sql](assets/sc4/Week 3 - Recitation.sql)), script)

Week 4 - Prep for Midterm

(no content)

Week 5 - Midterm

(no content)

Week 6 - Machine Learning

  • [Key Concepts](assets/sc4/KeyConcept - Week 6 - Machine Learning.pdf)
  • Lesson 1 - Intro to Machine Learning ([pdf](assets/sc4/Week 6 - Lesson 1 - Intro to Machine Learning.pdf))
  • Lesson 2 - Machine Learning Algorithms ([pdf](assets/sc4/Week 6 - Lesson 2 - Machine Learning Algorithms.pdf))
  • Recitation - Orange ([pdf](assets/sc4/Week 6 - Recitation.pdf))

Week 7 - ERPs and Supply Chain Software Systems

  • [Key Concepts](assets/sc4/KeyConcept - Week 7.pdf)
  • Lesson 1 - Enterprise Resource Planning ([pdf](assets/sc4/Week 7 - Lesson 1 - Enterprise Resource Planning.pdf))
  • Lesson 2 - Supply Chain Modules ([pdf](assets/sc4/Week 7 - Lesson 2 - Periodic Review Policies.pdf))

Week 8 - Software Selection/Implementation and Technology Trends

  • [Key Concepts](assets/sc4/KeyConcept - Week 8.pdf)
  • Lesson 1 - Software Selection and Implementation ([pdf](assets/sc4/Week 8 - Lesson 1 - Software Selection and Implementation.pdf))
  • Lesson 2 - Technology Trends and Impacts ([pdf](assets/sc4/Week 8 - Lesson 2 - Technology Trends and Impacts.pdf))

Week 9 - Prep for Final Exam

(no content)

Week 10 - Final Exam

(no content)