ISMG 2050: BUSINESS PROBLEM SOLVING
CU Denver Business School • Academic Course Directory
Direct access to all exercise specifications, case studies, and lab instructions. Refer to Canvas for official submission cutoff and grading policies.
Graded Homework Projects
- Homework 1: Animal Life Foundation (Workbook Mechanics & Calculations) Weeks 1–2
- Homework 2: Descriptive Statistics & Summary Reporting Weeks 1–2
- Homework 3: Central Sierra Insurance Projections (Logic & Formulas) Weeks 3–4
- Homework 4: College Cost Analysis (Financial Functions & Loan Amortization) Weeks 3–4
- Homework 5: Classic Gardens & Landscapes (Tables & Break-Even Analysis) Weeks 5–6
- Homework 6: Eller Financial Continuity Modeling Weeks 5–6
- Homework 7: American River Cycling Club (Multi-Sheet 3D Consolidation)
- Homework 8: Blue Lake Sporting Goods (Database Functions & Dynamic Arrays) Weeks 9–10
- Homework 9: Pool & Spa Oasis (Solver Optimization) Weeks 11–12
- Homework 10: Operations Directory (Power Query ETL) Weeks 11–12
- Homework 11: Tableau Intro & Interactive Visualizations Weeks 13–14
In-Class Practice Exercises
- Practice 01: Worksheet Mechanics & SUM
- Practice 02: Row & Column Averages
- Practice 03: Page Setup & Document Properties
- Practice 04: VLOOKUP & Absolute References
- Practice 05: Math Operators & Percentages
- Practice 06: Customer CSV Ingestion
- Practice 07: Page Setup & Scaling
- Practice 08: Professional Table Formatting
- Practice 09: PMT Loan Calculations
- Practice 10: Total Rows & Filtering
- Practice 11: Custom Currency Formats
- Practice 12: Print Scaling & Footers
- Practice 13: Quick Analysis & Break-Even Charting
- Practice 14: Multi-Sheet 3D Consolidation
- Practice 15: Custom Formats & Data Types
- Practice 16: SmartArt & Dynamic Hyperlinks
- Practice 17: Database Functions (DAVERAGE)
- Practice 18: INDEX & XMATCH Lookups
- Practice 19: Goal Seek & Scenarios
- Practice 20: Two-Variable Data Tables