Week # 2 – Chapter # 5 Assignment This week we will see: Chapter 5 “Retrieving Data for Computation, Analysis, and Reference” We will cover Levels 1, 2 and 3. Level 1 Organize and evaluate data in vertical and horizontal lookup tables Examine the VLOOKUP and HLOOKUP function rules Retrieve data from a vertical lookup table Retrieve data from a horizontal lookup table Level 2 Analyze and retrieve data from multiple worksheets Look up data in a one-row or one-column range Use named range references in formulas Retrieve data from multidimensional tables Level 3 Prevent errors in data retrieval Nest lookup and reference functions to perform more complex calculations Choose a value or a range of values for analysis Retrieve data by matching the relative position of an item in a list Focus on the following functions: LOOKUP, HLOOUP, VLOOKUP, ISBLANK, INDEX and MATCH Let’s get started: ========================================================================================== Week # 2 – Chapter # 5 Assignment Chapter # 5 – Level 1: Objectives (Pages 282 – 299)  Organize and evaluate data in vertical and horizontal lookup tables  Examine the VLOOKUP and HLOOKUP function rules  Retrieve data from a vertical lookup table  Retrieve data from a horizontal lookup table Level One: LEARNING The material covered the Case Scenario in Level 1 (pages 283-297) “Reference and Lookup functions.” Focus in VLOOKUP and HLOOKUP functions. You should read learning material on pages 282-297 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 1: “Performing Basic Lookups to Calculate and Evaluate Data” Or use the link: https://www.youtube.com/watch?v=ALNiJqPN-lI&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&index=13 Level One: PRACTICE: Open the Week # 2 – Exercise 1 Document, make the Exercise 1: Level 1 – Order Form for Golf Balls Post your completed file to Blackboard for review and grading. The file Name should be W2-1-Golf-Orders -YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS) This assignment should be analyzed and posted for the Bb Collaborate Class Next Thursday at 6:00 pm ================================================================ Week # 2 – Chapter # 5 Assignment Chapter # 5 – Level 2: Objectives (Pages 299 – 314)  Analyze and retrieve data from multiple worksheets  Look up data in a one-row or one-column range  Use named range references in formulas  Retrieve data from multidimensional tables Level One: LEARNING The material covered the Case Scenario in Level 2 (pages 299-314) “Performing More Complex Lookups Involving Multiple Worksheets and Multidimensional Tables.” Focus in VLOOKUP, HLOOKUP and INDEX functions You should read learning material on pages 299-314 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 2: “Performing More Complex Lookups Involving Multiple Worksheets and Multidimensional Tables” Or use the link: https://www.youtube.com/watch?v=zGd8rA8QjE0&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&index=14 Level One: PRACTICE: Open the Week # 2 – Exercise 2-3 Document, make the Exercise 2: Level 2 – Order 2 Form for Golf Balls Post your completed file to Blackboard for review and grading. The file Name should be W2-2-Golf-Orders2 -YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (30 POINTS) This assignment will be analyzed in the Bb Collaborate Class Next Thursday at 6:00 pm and the Due date is the Thursday of Week # 3. ================================================================ Week # 2 – Chapter # 5 Assignment Chapter # 5 – Level 3: Objectives (Pages 316 – 344)  Prevent errors in data retrieval  Nest lookup and reference functions to perform more complex calculations  Choose a value or a range of values for analysis  Retrieve data by matching the relative position of an item in a list Level One: LEARNING The material covered the Case Scenario in Level 3 (pages 316-344) “Nesting Lookup and Reference Functions to Retrieve and Calculate Data.” Focus in VLOOKUP, HLOOKUP, INDEX, MATCH and IFBLANK functions You should read learning material on pages 316-344 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 3: “Nesting Lookup and Reference Functions to Retrieve and Calculate Data” Or use the link: https://www.youtube.com/watch?v=2WncfNJAsxM&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&index=15 Level One: PRACTICE: Open the Week # 2 – Exercise 2-3 Document, make the Exercise 3: Level 3 – Fishing Order Post your completed file to Blackboard for review and grading. The file Name should be W2-3-Fishing-Order-YourName.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (30 POINTS) This assignment will be analyzed in the Bb Collaborate Class Next Thursday at 6:00 pm and the Due date is the Thursday of Week # 3.