Business Data Analysis (Past Materials)
Students may find materials used in BUSI 201 Business Data Analayis in the past on this page.
Lecture Notes & Workbooks: Fall 2023
- Lecture Note #01 & Workbook #01: Excel Basics Part 1
- Lecture Note #02 & Workbook #02: Excel Basics Part 2
- Lecture Note #03 & Workbook #03: Excel Basics Part 3
- Lecture Note #04 & Workbook #04: Excel Basics Part 4
- Lecture Note #05 & Workbook #05: Excel Basics Part 5
- Lecture Note #06 & Workbook #06: Excel Basics Part 6
- Lecture Note #07 & Workbook #07: Excel Basics Part 7
- Workbook #08: Review of Functions
- Lecture Note #09 & Workbook #09: Filtering and Sorting
- Lecture Note #10 & Workbook #10: Conditional Formatting Part #1
- Lecture Note #11 & Workbook #11: Conditional Formatting Part #2
- Lecture Note #12 & Workbook #12: Introduction to Bar Charts and Formatting Charts
- Lecture Note #13 & Workbook #13: Line Charts and Combos
- Lecture Note #14 & Workbook #14: Scatterplots, Histograms, Pie Charts, Maps
- Lecture Note #15 & Workbook #15: Pivot Tables Part #1
- Lecture Note #16 & Workbook #16: Pivot Tables Part #2
- Lecture Note #17 & Workbook #17: Pivot Tables Part #3
- Lecture Note #18 & Workbook #18: Pivot Tables Part #4
- Lecture Note #19 & Workbook #19: What-If Analysis
- Lecture Note #20 & Workbook #20: Power Query Part #1
- Lecture Note #21 & Workbook #21: Power Query Part #2
Quizzes: Fall 2023
- Quiz #1 (Fall 2023)
- Quiz Workbook #1 (Fall 2023)
- Answer Key #1 (Fall 2023)
- Quiz #2 (Fall 2023)
- Quiz Workbook #2 (Fall 2023)
- Answer Key #2 (Fall 2023)
- Quiz #3 (Fall 2023)
- Practice Quiz #3 (Fall 2023)
- Quiz Workbook #3 (Fall 2023)
- Answer Key #3 (Fall 2023)
- Quiz #4 (Fall 2023)
- Quiz Workbook #4 (Fall 2023)
- Answer Key #4 (Fall 2023)
Final Exam: Fall 2023
- Practice Final (Fall 2023)
- Practice Final Workbook (Fall 2023)
- Answer Key for Practice Final (Fall 2023)
- Final Exam (Fall 2023)
- Final Exam Workbook (Fall 2023)
- Answer Key for Final Exam (Fall 2023)