Assignments

Homework accounts for of the final grade. Late submissions lose 1 point per day.

• Lab 1 — Excel Basics with Product Inventory Week 2 · due Sunday of Week 2, 23:59

  Master essential Excel formulas — SUM, AVERAGE, COUNTIF, SUMIF, IF, VLOOKUP — and the difference between relative and absolute cell references.

• Lab 2 — Data Import & Cleaning with Store Sales Orders Week 4 · due Sunday of Week 4, 23:59

  Import CSV and Excel data using Power Query, apply transformations to fix data types, duplicates, inconsistent values, and missing data, then load a clean table to a worksheet.

• Lab 3 — Exploratory Data Analysis & PivotTables Week 6 · due Sunday of Week 6, 23:59

  Perform descriptive analysis and build PivotTables to detect patterns, compare segments, and produce a summary that answers specific research questions.

• Lab 4 — Data Visualization & Dashboard Week 8 · due Sunday of Week 8, 23:59

  Create five targeted charts addressing specific analytical questions, then assemble them into an interactive dashboard controlled by slicers.

• Lab 5 — Statistical Analysis & Regression Week 11 · due Sunday of Week 11, 23:59

  Apply correlation, simple regression, and a hypothesis test to project data using the Excel Analysis ToolPak; interpret results in plain language.