Background Information & Instructions for Case Study #1
Applying Concepts and Sk
Background Information & Instructions for Case Study #1
Applying Concepts and Skills Using Electronic Spreadsheets
Skills Developed/Reinforced from Unit 2 in this Activity:
Spreadsheet
Formulas & Functions
Absolute v. Relative Addressing
FlashFill (new)
Conditional Formatting
VLookup
Filtering & Sorting (Tables)
Summary Statistics (Tables)
Logical Functions (SUMIF, COUNTIF)
Pivot Tables
Slicers (Pivot Tables)
Other Skills
Business problem definition
Written communication
Instructions to complete the activity:
Download and Review the detailed Case Study #1 Instructions (PDF) Download Case Study #1 Instructions (PDF)
Download and Review the associated Case Study #1 Slide Set (PPT) Download Case Study #1 Slide Set (PPT) or the PDF version Download PDF version of those slides
Download the starting workbook: CaseStudy#1-Starter (xlsx) Download CaseStudy#1-Starter (xlsx) provided on Canvas.
Complete the entire set of Case Study #1 activities as described in the detailed Instructions. When you are done, upload all of the required artifacts to this assignment folder.
Comments from Customer
Discipline: MIS (Crit Thinking Using Analytics)
