Category: Teaching

Module 5: Prescriptive Analytics and Optimization

Review:

  • Module 4

Presentation:

  • Video Lecture
  • Prescriptive analytics
  • Discrete mathematics
  • Supply chain network optimization
  • Inventory safety stock optimization

Assignment:

  • Create an industry-specific “Analytics” Bibliography
    • Choose an industry of interest (e.g., Sports, Health Care, Finance)
    • Find written resources (journal or news articles, books, etc) using library databases, search engines, etc.
    • List them and write a brief description of each resource
    • Here’s a Help Sheet on how to write an annotated bibliography
  • I recorded a video session with Librarian, Isabel Sotoluna for this assignment. Watch it!
More

Lesson 22: Data Science for Business

Review:

  • Retirement portfolio simulation

Presentation:

  • Zoom Recording
  • Data Science
    • Combination of statistics + programming with big data
    • Hot like computer software development in the 1990’s
    • Salaries are really high 

Assignment:

More

Lesson 21: Retirement Portfolio Simulation

Zoom Meeting Link

Review:

  • Remote Learning (thru end of semester)
  • Stock + Bond Simulation

Presentation:

Assignment:

  • Assignment 9
    • Complete the Stock Market (or Retirement Portfolio) Simulation
    • Due Mon Nov 16 at 11:59pm
    • Submit Here
  • Required Elements
    • 40-year time horizon
    • Simulation count, n=100
    • Ability to set/modify simulation parameters by changing cell values (not by editing formula)
      • initial balance
      • annual contribution
      • stock/bond % allocation
      • financial target, e.g., $1,000,000
    • Functional start button to launch automation of simulation
    • Display at end of simulation
      • probability (%) of reaching financial target
      • distribution of end balances on a histogram
      • calculation of Max, Min, Mean, Median and Standard Deviation of end balances
More

Module 4: Predictive Analytics and Simulation

Review:

  • Module 3
    • Discussion
    • Essays

Presentation:

Assignment:

  • Use the Stock and Bond Portfolio simulation
    • Allocate % Stocks vs Bonds
    • Enter Beginning Balance amount
    • Enter Annual Contribution amount
    • Enter Retirement Target amount
    • Run Simulation
    • Try different combinations and repeat
  • Essay Questions (~1-page per question)
    • Summarize your retirement savings expectations after experimenting with the simulation
    • How could you use a comparable simulation approach in your current business or later in your professional life?
More

Lesson 20: Stock Market Simulation

Review:

  • Election
  • Grading
  • Final Exam will take place during Finals week

Presentation:

Assignment:

  • Add a “fixed income” (bonds) component to your stock market simulation
    • Assume bond market returns are normally distributed
      • mean = 7.88%
      • standard deviation = 6.86%
    • Your “portfolio” allocation should be 60% stocks and 40% bonds
    • Stock market and bond market returns should be combined each year and then reallocated in the next year.
More

Lesson 19: Election Simulation

Review:

  • Election forecasting
  • Zoom on Thu
  • Assignments 8.1 and 8.2
  • Stock Market Simulation

Presentation:

Activity:

  • Incorporate electoral vote allocation in Maine and Nebraska
  • And/or use different polling averages from a preferred source
  • And/or use state specific margin of error quantities

Assignment:

  • Vote
More

Module 3: Predictive Analytics and Time Series Forecasting

Review:

  • Module 2

Presentation:

Assignment:

  • Reading
  • Essay
    • 1-2 page essay, similar to Module 2
    • There are several issues (all very short, mostly graphical)
    • Use these issues to summarize the impact of Covid-19 on the automotive aftermarket industry.
    • How good were the forecasts?
    • How could this series of articles be improved?
More