Week 4 Excel

Week # 4 - Chapter # 3 Assignments

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.

Power Points are available in Blackboard Lectures and, video tutorials guiding you through the Learning part of each level of each chapter are available on youtube.com. See your course Syllabus for the link.

WATCH THE VIDEOS-- WATCH THE VIDEOS -- WATCH THE VIDEOS. Use the Chapter # 3 – Videos presentation to see the videos if you prefer. Let us get started: ==========================================================================================

NOTE: Create a Word Document named: 3-Essay-Chapter3-YourName for

all the essay parts (Answer questions).

Week # 4 - Chapter # 3 Assignments

Chapter # 3 - Level 1: Objectives  Understand the principles of effective data display (page 157)  Analyze various Excel chart types (page 161)  Determine appropriate uses for different chart types (page 163 - 164)  Modify the chart type and the chart source data (page 167 - 176)  Specify chart options, including chart and axis titles, legends, and data labels

Level One: LEARNING

The material covered the Case Scenario in Level 1 (pages 155-176) “Visualizing Data”. The CH03 Level 1 Figures.xlsx file in Lectures (Student Data Files Chapter Three or attached to your assignment) replicates all the Figures in this section so you can easily follow along with the textbook discussions

You should read learning material on pages 155-176 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 1: “Visualizing Data” Or use the link: https://www.youtube.com/watch?v=0sGfUAp5-

h4&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&index=7 Level One: PRACTICE:

Using the Week # 4 - Chapter 3 - Exercises.pdf Make the Exercise Ch3-1: Level 1 –Industry Trend Charts Post your completed file to Blackboard for review and grading. The file Name should be 3-1- Industry-Trends-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

==================================================================

Week # 4 - Chapter # 3 Assignments

Chapter # 3 - Level 2: Objectives  Examine the effectiveness of different chart sub-types  Evaluate the stacked and 100% stacked sub-types  Explore the Pie of Pie and Bar of Pie sub-types  Create various stock charts to display financial data  Clarify data with trend lines and moving averages

Level Two: LEARNING 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 Three or attached to your assignment) replicates all of the Figures in this section so you can easily follow along with the textbook discussions.

You should read the learning material covered on pages 177-194 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: Evaluating Chart Sub- Types Or use the link: https://www.youtube.com/watch?v=6UzJu90yMOo&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&

index=8

Level Two: PRACTICE

Using the Week # 4 - Chapter 3 - Exercises.pdf Make the Exercise Ch3-2: Level 2 – Customer Purchases Charts

Post your completed file to Blackboard for review and grading. The file Name should be 3-2- Consumer-Purchaser-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

==================================================================

Week # 4 - Chapter # 3 Assignments

Answer the following question in the Word Document 3-Essay-Chapter3-YourName Questions for Chapter 3:

1. List and describe the significance of each of Tufte’s five data graphics principles. (10 POINTS)

2. What are the different types of Charts exposure in the book, and give a brief description of each of them? (10 POINTS)

Let me know if there is anything you do not 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: 3-1-Industry-Trends-YourName.xlsx (40 points) 3-2-Customer-Purchaser -YourName.xlsx (40 points) 3-Essay-Chapter3-YourName (20 points)