What This Document Is
This document is a practical exercise guide for students enrolled in Fundamentals of Computers (BCA 101) at Creighton University. Specifically, it focuses on applying Microsoft Excel functions – HLOOKUP, VLOOKUP, and LOOKUP – to solve common data analysis problems. It presents three practical exercises, followed by two additional Excel practicals, each with a specific scenario and instructions for using Excel formulas to arrive at a solution.
Why This Document Matters
This guide is essential for students learning to leverage Excel for data manipulation and analysis, a core skill in many introductory computing and MIS courses. It’s designed to reinforce theoretical concepts through hands-on application, preparing students for more complex data analysis tasks. It’s typically used as a graded assignment to assess a student’s ability to apply lookup functions in a practical context.
Common Limitations or Challenges
This document provides the *problems* and the *starting point* for solutions, but it does not offer comprehensive Excel training. Students are expected to already understand the basic syntax and functionality of HLOOKUP, VLOOKUP, and LOOKUP. It also doesn’t cover error handling or more advanced Excel features. The document assumes a working knowledge of Excel’s interface and data entry.
What This Document Provides
The full document includes:
* Three practical exercises focusing on calculating grades and bonuses using HLOOKUP and VLOOKUP.
* A further two practical exercises involving calculating bill amounts using LOOKUP and applying conditional logic with IF statements for calculating results and grades.
* Example data sets for each exercise.
* The expected formulas to be used for each calculation.
This preview *does not* include the complete solutions to the exercises, nor does it provide detailed explanations of the underlying Excel concepts. It only outlines the scope and content of the full practical guide.