Spreadsheet Applications for Business

Exercise Content

1. 
   

   Week # 6 – Exercises Chapter # 7

   This week we cover Chapter 7 “Organizing Data for Effective Analysis”

   • Level 1: main focus is on working with data, especially large amounts of it. You can import data stored in a text file or a database
   • Level 2: look at ways to manage large amounts of data by using Tables and a PivotTable.

   We will cover Levels 1 and 2.
   1- Open Week # 6 – Chapter 7 – Assignment .pdf document, save it, and follow the directions.

   2- Open Week # 6 – Chapter 7 – Exercises.pdf save it to do the exercises
   

   3- Open Chapter # 7 – Lecture save it to use the information of the presentation
   

   
   4- Open Chapter # 7 – Video – Level 1-2 to see the video of Levels 1 & 2 of chapter 7.******************************* LEVEL 1 ************************************************************* You should read the learning material covered on pages 427-449 that is covered in the video Chapter # 7 – Level 1 video

   
   

   Using the Week # 6 – Chapter 7 – Exercises.pdfMake the Exercise 7-1: Level 1 – Sports Wear Retailers

   
   ******************************* LEVEL 2 *************************************************************You should read the learning material covered on pages 450-472 that is covered in the videoChapter # 7 – Level 2 video (Pivot Tables)

   Using the Week # 6 – Chapter 7 – Exercises.pdfMake the Exercise 7-2: Level 2 – Analyzing Manager Performance at Home Station.Use the initial Data File

   
   

   1. 
      
      Extra Credit:In the Course Document Folder, there is a folder Data Analysis Tool that shows how to use the Data Analysis Tool in Excel.Apply any Data Analysis Tool to one of the exercises of the chapter and let me know what tool you applied and submit the result.
      Note: It is required to use the Data File provided in the assignment. If you use an Old data File or Old file with a Creation Date that is not in the current term will not be accepted and graded with zeroes.

   Sales.accdb