This week we cover Chapter 3 “Determining Effective Data Display with Charts” where we will take a Marketing example and use Excel to Analyze Trends in the Sporting Goods Industry. We will cover Levels 1 and 2 only.
The Assignment has three parts – Each part has four steps.
Part A:
Read the Chapter Introduction and Case Scenario on page 155. Read this page very carefully. It is important that you clearly understand what the Chapter material is all about – otherwise you will just be putting numbers in cells.
Part B:
- Study (LEARN) the material covered in Level 1: Visualizing Data on pages 156 to 175. The CH03 Level 1 Figures.xlsx file in Lectures (Student Data Files Chapter 3) replicates all of the Figures in this section so you can easily follow along with the textbook discussions. Also watch the youtube.com tutorial.
- PRACTICE what you learned in the first part by completing the Steps to Success: Level 1 exercise starting on page 176. The starting workbook: Trends.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 3)
The file Name should be 4-1- Industry Trends.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
- APPLY what you have learned to a new business marketing situation by completing the Level 1 Case Problem on page 209 of your textbook. The starting workbook Indiana.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 3)
The file Name should be 4-2- Indiana Travel.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
- Write a short essay on what you have learned in Level 1 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR RVIEW AND GRADING (10 POINTS)
Part C:
- Study (LEARN) the material covered in Level 2: Evaluating Chart Sub-Types on pages 177 to 194. The CH03 Level 2 Figures.xlsx file in Lectures (Student Data Files Chapter 3) replicates all the Figures in this section so you can easily follow along with the textbook discussions. Also watch the youtube.com tutorial
- PRACTICE what you learned in the first part by completing the Steps to Success: Level 2 exercise starting on page 195. The starting workbook: Purchases.xlsx can be found in Lectures – (Student Data Files Chapter Three).
The file Name should be 4-3- Consumer Purchaser.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
- APPLY what you have learned to a new business marketing situation by completing the Level 2 Case Problem on page 209 of your textbook. The starting workbook Invest.xlsx needs to be downloaded from Lectures – (Student Data Files Chapter 3)
The file Name should be 4-4-Investment Performance.xlsx
POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)
- Write a short essay on what you have learned in Level 2 and how you could apply this to other business situations. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (10 POINTS)
Evaluation:
Open the 4-Ch3-Student-Evaluation-Form.xlxs file and evaluate all your work comparing with the solution that you will find in Course Document – Week 4 Chapter 3 Answer Files.
Rename the evaluation file adding your name as:
4-Ch3-Student-Evaluation-Form-YourName.xlxs
A Power Point review of Chapter 3 is posted in Lectures
Let me know if there is anything you don’t understand — the earlier the better.
==================================================================
Let me know if there is anything you don’t understand — the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.
The solution files that you need to attach are:
4-1- Industry Trends.xlsx
4-2- Indiana Travel.xlsx
4-3- Consumer Purchaser.xlsx
4-4-Investment Performance.xlsx
4-Essay-Week4-YourName.docx (With the short essays on what you learned in each Level)
4-Ch3-Student-Evaluation-Form-YourName.xlxs