Main Content

Schedule

The schedule below outlines the topics we will be covering in this course, along with the associated time frames and assignments. Note that assignments are due based on Eastern Time (ET). This ensures that all students have the same deadlines regardless of where they live. All lesson assignments must be submitted by 11:55 PM (ET) on the last day of the timeframe indicated below for the lesson.

Lesson 1: Spreadsheet Basics
Lesson 1

Readings:
  • Lesson Commentary

Assignments:
  • Lab 1 - Excel Basics

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 2: Introduction to Markets
Lesson 2

Readings:
  • Lesson Commentary

Assignments:
  • Lab 2 - Demand and Supply Charts

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 3: Market Equilibriums
Lesson 3

Readings:
  • Lesson Commentary

Assignments:
  • Lab 3 - Goal Seeking Equilibriums & Adding Equilibrium Lines
  • Homework Assignment 1 - Supply and Demand Analysis According to Market

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 4: Demand and Supply Shifters
Lesson 4

Readings:
  • Lesson Commentary

Assignments:
  • Lab 4 - Analyzing the Effects of Demand and Supply Shifters
  • Homework Assignment 2 - Shifters and Estimating Demand

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 5: Cost Economics
Lesson 5

Readings:
  • Lesson Commentary

Assignments:
  • Lab 5 - Creating and Using Cost Sheets

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 6: Solving Resource Allocation Problems
Lesson 6

Readings:
  • Lesson Commentary

Assignments:
  • Lab 6 - Resource Allocation Problems

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 7: Economic Order Quantity
Lesson 7

Readings:
  • Lesson Commentary

Assignments:
  • Lab 7 - Economic Order Quantity Calculations
  • Homework Assignment 3 - Resource Allocation and EOQ

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 8: Accounting - Balance Sheets
Lesson 8

Readings:
  • Lesson Commentary

Assignments:
  • Lab 8 - Balance Sheets, Depreciations Schedules, and Amortized Loans
  • Exam 1

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 9: Income Statements
Lesson 9

Readings:
  • Lesson Commentary

Assignments:
  • Lab 9 - Income Statements
  • Homework Assignment 4 - Financial Statements and Analysis

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 10: Time Value of Money - Present Value
Lesson 10

Readings:
  • Lesson Commentary

Assignments:
  • Lab 10 - Time Value of Money #1 - Present Value

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 11: Future Value
Lesson 11

Readings:
  • Lesson Commentary

Assignments:
  • Lab 11 - Time Value of Money #2 - Future Value
  • Homework Assignment 5 - Juice Factory Investment Analysis

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 12: Basic Business Statistics
Lesson 12

Readings:
  • Lesson Commentary

Assignments:
  • Lab 12 - More Basic Statistics

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 13: Special Excel Data Analysis Tools
Lesson 13

Readings:
  • Lesson Commentary

Assignments:
  • Lab 13 - Specialized Excel Data Analysis Tools
  • Homework Assignment 6 - Data Analysis

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 14: Linear Regression
Lesson 14

Readings:
  • Lesson Commentary

Assignments:
  • Lab 14 - Linear Regression
  • Exam 2

All lesson assignments must be submitted by 11:55 PM (ET).
Lesson 15: Forecasting
Lesson 15

Readings:
  • Lesson Commentary

Assignments:
  • Lab 15 - Forecasting
  • Homework Assignment 7 - Forecasting

All lesson assignments must be submitted by 11:55 PM (ET).

Top of page