Week%205-ACC381

# Week%205-ACC381 - CollegeofBusiness Information Systems...

This preview shows pages 1–7. Sign up to view the full content.

Name College of Business Information Systems Management / Accounting Information Systems Lab - Retrieving Data for Analysis Samantha Kleitsch / Lise Urbaczewski

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Today, we will set up and refer to a lookup table… When would we use this?? We might have ‘ranges’ of data, for example: - discounts for larger quantities - shipping rates based on speed of delivery - sales tax by state - grades determined by score! Property of L. Urbaczewski / S. Kleitsch
If we set up Excel using IF statements… We might need to use nested IF statements: - e.g. IF item type is A [or B or C….] IF quantity is less than X but greater than Y…. IF customer selects MI [ or IL, OH, …] IF grade is greater than 50 but less than 60…. Greater than… Bottom line, VERY confusing with lots of options (read: too many possibilities for errors!) Property of L. Urbaczewski / S. Kleitsch

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Determining the Grade (last populated column) – refer to the Grade Table… Property of L. Urbaczewski / S. Kleitsch
Grade Table tells us… The logic is pretty simple, right? Percentage: - 0% receives a grade of F - 60% receives a D - 70% C - 80% B - 93% A Note: the table is written in ascending order - what if it was in descending order? - what if it was not even sorted (i.e. random) Property of L. Urbaczewski / S. Kleitsch

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Focus Today: 1. Understand VLOOKUP and HLOOKUP 2. Analyze / retrieve data 3. Using multidimensional tables 4. **** PREVENTING ERRORS in data retrieval**** 5. Assignment 5, Create and use lookup tables to calculate totals Property of L. Urbaczewski / S. Kleitsch
This is the end of the preview. Sign up to access the rest of the document.