Faculty at Indiana University’s world-renowned Kelley School of Business present this essential introductory guide to the role of computers and other information technologies in business. Like the text for its sister course, K201, Computers in Business: K204 highlights include instruction and applied practice in two of the most widely used commercial software packages: Microsoft Access and Microsoft Excel. This volume, however, presents even more challenging applications and projects for honors students. Students learn, via hands-on examples, many of the powerful tools contained in these two platforms, with emphasis on how to analyze real business problems to help make important decisions.
|Publisher:||Indiana University Press|
|Edition description:||New Edition|
|Product dimensions:||8.50(w) x 10.90(h) x 1.20(d)|
About the Author
Kelley School of Business Faculty
Read an Excerpt
Computers in Business K204
By Kelley School of Business Faculty
Indiana University PressCopyright © 2016 Kelley School of Business Faculty
All rights reserved.
* Research & Exploration: Course Structure, Navigating Course Resources
* In-Depth Case Application: Course Logistics, Course Files
* Review Problems: Understanding Course Structure and Policies
* Understand the goals of this class and how the class will be structured.
* Use Canvas to access important class resources.
* Access your K204 files in Box.
* Understand the importance of maintaining backup files.
* Identify a strategy for keeping copies of course files and assignments.
Research & Exploration
For K204 lab, the only required book is this K204 e-book. However, you will at times find it necessary and extremely beneficial to use additional online resources such as the IU Knowledge Base, Microsoft Office Support, and video tutorials on YouTube, among others.
Each chapter in this e-book comprises three distinct sections:
Research & Exploration
This section contains information on various concepts and methods as well as hands-on exercises that will help you prepare for each class. Students who do not prepare for each class will have extreme difficulty keeping up during class.
In-Depth Case Application
This section builds on the concepts and methods covered in the Research & Exploration section. It consists of hands-on exercises led by the instructor and is centered on Premiere Foods, a locally sourced and organic grocery store.
Students who miss class must work through this section before returning to class. However, because instructors provide explanations, concepts, methods, and other important discussions in class, simply working through this text is not intended to be a substitute for regularly attending class.
This section provides you with hands-on exercises to complete on your own so that you can practice the concepts and methods covered in the two sections preceding it. Completing the review problems after each class is essential to mastering the materials and doing well in the course.
Course Resources and Syllabus
K204 is a challenging course for many. The first step to doing well is to become familiar with the course structure and policies by reading the syllabus. You will also want to familiarize yourself with all of the resources available, such as where to find important announcements, get free K204 help, earn extra credit, locate graded assignments files, and more.
1. Log into Canvas, then locate your K204 Lab section.
2. Explore the Canvas site until you find the link to the course syllabus.
3. Read the syllabus, then further explore the site.
Activating your Box at IU Account
Throughout the semester, you will be responsible for many different files associated with this course. We will place all the files you need to get started in your IU Box account during the first week of classes. All IU students and faculty and staff members get unlimited free storage space on Box at IU to store anything they wish. This storage space isn't just for K204 – you can use it to store, share, and access photos, music, videos, and so forth from anywhere.
1. To activate your Box at IU account, simply log on using your IU username and passphrase.
Your Box at IU account will be automatically created the first time you log into Box at IU. Here you can upload, download, and share files. For more information on how to use IU Box, read this IU Knowledge Base article.
In-Depth Case Application
Who Is In Your Lab Classroom?
Responsible for the class, office hours, and grades.
Teaching Assistant (TA)
Typically runs the computer, answers questions, and manages the peer tutors. TAs are paid undergraduate students who have served as a peer tutor in the past.
Students who did exceptionally well in K204 and are invited to come back as volunteers in the classroom. Peer tutors help answer student questions and also help students who fall behind during class. Some sections have as many as six peer tutors. Peer tutors begin offering tutoring during week 2.
The lab component of K204 teaches Microsoft Access and Microsoft Excel. Microsoft Office 2016 for Windows is required and is the only acceptable software for this course. This software is installed on all PCs in (Student Technology Center (STC) computer labs and can also be downloaded to a personal PC from IUware using the Office 365 link.
If you are going to use your personal computer, it is your responsibility to make sure you have the necessary software installed. Check the K204 syllabus for more detailed information.
What About Using a Mac?
None of the Macintosh operating systems or Microsoft Office versions for Mac is acceptable. You may install Windows on a Macintosh either as the only operating system or as a dual-boot option. Using Boot Camp Assistant, you can partition your hard drive and install Windows and MS Office on your Macintosh computer so that you can complete K204 assignments.
If you wish to use your Mac for K204 but do not want to partition the hard drive, you can use IUanyWare. IUanyWare is a client virtualization service available to IU students, faculty, and staff. With IUanyWare, you can use a web browser or mobile app to run certain IU-licensed software applications without having to install them on your computer or mobile device. All you need is a high-speed Internet connection.
For more information on how to set up and use IUanyWare, read this JU, Knowledge Base article.
Authorize Cloud Storage Services
Cloud Storage is easy to set up and to use. Simply authorize your storage accounts, after which they'll show up just like a hard drive within any virtual app though IUanyWare or on any lab computer.
1. Go the IU Cloud Storage Configurator at https://cloudstorage.iu.edu.
2. Click Login; if prompted, type your IU username and passphrase.
3. Click Login again, or press Enter.
4. Click the arrow to the right of the Box cloud storage option, then click Authorize.
5. In the page that opens, click Grant access to Box to authorize access to all files stored in your Box at IU account.
6. Repeat steps 4 and 5 for any other preferred cloud storage options.
Once this has been done, you will be able to access your K204 files on a Mac or on other devices using IUanyWare. Additionally, when you log into any PC in an STC computer lab, you will be able to access all your Box files under This PC.
Accessing Your K204 Files in Box
If you are officially enrolled in the course and have activated your Box at IU account as instructed in the Research & Exploration section, then you will find that many of the K204 files you will need have already been uploaded to your Box at IU account.
1. Log onto https://box.iu.edu using your IU username and passphrase.
Alternatively, if you have authorized your IU account to access your Box at IU files and are in an STC computer lab, you can double-click This PC and then double-click the Box drive located under Network Locations.
2. Locate and open the My Courses folder.
3. Locate and open the current semester folder, then open the K204 Files folder.
4. Browse the folder structure to locate the PowerPoint slides summarizing the course.
5. Locate files needed for the next class.
6. Locate the Knowledge Check files.
You must take good care of your files. You must not allow another student to have access to your files. If you allow another student access to your files, academic misconduct charges will be sought.
If you have taken K204 before, you cannot turn in old files. Please make sure to keep old and new files separate.
Backing Up Your Files
Box at IU has a version management feature that automatically creates backups of your files each time you upload a new version. This can be very useful in the event of a file's becoming damaged, a computer's becoming lost or damaged, or a file's being accidentally deleted. This feature also allows you to revert to an earlier version of a file if needed.
1. To access the version history of a file, click the version number, located in the small red box underneath the filename.
2. The Version History box can be used to download previous versions of a file or override the current version with an earlier version.
It is your responsibility to manage all your course files. Although you are not required to use Box at IU, you may find this and other features useful.
Additional IT Help
The IU Wells Main Library at 10th and Jordan has a University Information Technology Services (UITS) Computing Support Help Desk that gives all IU students free computer help. It's located on the first floor behind the coffee stand. You can even bring your laptop or other computing device in to the IU experts (bring your IU ID card, too). They can help answer your questions about IU Cloud Storage, IUanyWare, installing Windows on a Mac, getting the correct version of MS Office installed, and so forth.
You can also contact UITS tech support by phone 24/7 at (812) 855-6789, chat with tech support live at http://ithelplive.iu.edu, or e-mail tech support at firstname.lastname@example.org.
Review Problem 1
It is extremely important that you be fully aware of course expectations and policies. After locating and reading the syllabus, exploring the K204 Canvas site, reviewing the Research & Exploration and In-Depth Application sections of this book, and reviewing the PowerPoint slides presented on the first day of class, you should be able to answer the following questions:
1. What are the dates for all four K204 exams?
2. What free resources are available to help you with K204?
3. What are graded projects, lab checks, and knowledge checks?
4. Which version of Microsoft Office is required?
5. If you plan on using your Mac for the course, what are your only two options?
6. What is the policy on sharing course files?CHAPTER 2
* Research & Exploration: Understand the Purpose of Relational Databases
* In-Depth Case Application: Organize Graded Projects, Understand Database Basics
* Review Problems: Sort on One Field, Sort on Multiple Fields, Solve a Business Problem, Knowledge Check 1
* Research terms using the define: operator.
* Understand relational database objects and concepts.
* Understand the structure of the database used in lab.
* Understand how to access and manage graded project files.
Research & Exploration
Databases play an integral role in the world – at work, in school, and in our personal lives. However, most people know very little about what databases are and how they work. Database design theory and development can get complicated, so let's begin by obtaining a basic definition of a database.
Go to your preferred search engine and type the following:
Using define: before your search term will narrow search results to those found among online glossaries and encyclopedias. This can be a good way of exploring what the consensus is on a term's meaning. Run the search. Look over the first page or two of results.
Now that you have a basic understanding of what a database is, the next step is to understand why you would want to use one. Read this Knowledge Base article that explains the benefits of using a relational database.
By now you should know the basic definition of a database and have some notion of why databases are useful. However, you may discover that in many organizations around the world, people use Excel to manage their data when they should be using Access. Read Using Access or Excel to manage your data to understand when each software application is appropriate.
Last, much of the terminology associated with databases may be confusing. So that you can speak about databases, read the Overview section of the following article: Learn the structure of an Access database.
In K204, we will use one company's database as our teaching file to illustrate database concepts. To fully understand the examples used in class, it is important that you have some background information on the company and the structure of its database.
Premiere Foods started as a small monthly newsletter written and distributed as a hobby by a few organic food aficionados. Their informal product reviews soon grew popular with friends and then with friends of friends, and they eventually began a small organic local and healthy foods grocery store.
Eventually they took their nonperishable foods online. Word of mouth (along with attention to quality) made the website popular.
In addition to an online business, Premiere Foods now has stores in Indiana and Illinois. Its customers are environmentally conscious and very loyal, and sales are strong.
You will be working to understand and improve upon a database that contains data related to 2015 sales to customers who registered to be Premiere "members" and receive special product discounts. (Note: this database does not contain all Premiere's sales, nor even all sales for 2015, and it does not attempt to represent all business functions.)
Premiere Database Precautions
For many of you, this is your first time working with a database. Be aware that there are a few precautions you must take to ensure you do not lose any work that you complete throughout the first half of the course:
* Always be sure that your database is saved to your computer before working on it. If you are using https://box.iu.edu or another cloud storage service, be sure to download the file to the computer and then open the downloaded copy.
Databases require access to your computer's resources and will not operate properly if opened directly from any cloud storage service, including Box at IU, Google Drive, or OneDrive.
Once you have finished working on the database file and before you log off the computer, be sure to upload the updated version of the database file back to your cloud storage service, USB flash drive, or so forth. This will ensure that you always have access to the most up-to-date version of your database.
Browse the Database
Spend a few minutes opening the database tables and examining the data in them.
1. Log onto Box at IU, then navigate to the K204Files folder, located in the My Courses folder.
2. Download the Premiere.accdb file, located in the Access folder, to your computer.
3. Open the downloaded database file.
First of all, recognize that this database tracks sales revenue (not employee hours worked, accounts payable, or any number of other things for which a business might use a database).
The tblProduct table contains the items carried in the store or in the online catalog. The tblMember table contains personal information about customers who have enrolled in the Member Club. The tblTransaction table is a record of sales receipts printed, with each transaction representing one receipt. Notice that there is also a table called tblTransactionDetails. Open and examine the contents of each of these tables, reflecting on the articles you read in the Research section, and then consider the answers to the following questions:
* Why does MemberID appear in the tblTransaction table when this table is intended to store information only about the transactions?
* What are some of the unique identifiers you discovered in the tables?
* Why do you think the database designer chose to use two tables to store transaction information?
* What is the name for the database object that stores the data?
* How could you find out what a customer owed for each transaction?
In-Depth Case Application
Managing Course Files
You are responsible for maintaining all your files for this class. Let your lab instructor or TA know if you have any questions after completing this exercise.
Creating a Folder to Organize Graded Projects
1. Log into Box at IU.
2. Navigate to and open the K204Files folder located inside the My Courses/Current Semester folder.
3. Open the Graded Projects folder. There should already be folders inside for all the graded projects except GP1.
4. Click +New, then select Folder to create a new folder inside Graded Projects.
5. Name the folder GP1, then click Okay.
Creating a Subfolder to Back Up Graded Projects
1. Open the GP1 folder you just created.
2. Inside the GP1 folder, create another folder and name it done(backup).
Each of the 9 GP folders now has a done(backup) folder inside. As you complete and submit each graded project, place a copy of your project file in this folder, making sure not to open or modify it after the deadline. This will ensure that you have a completed backup copy of your work in case your submitted file is lost or corrupted.
Downloading the Graded Project Files
1. Using the Edge browser, log onto Canvas, then go to your K204 lab section. Click Files in the left navigation, then click Graded Projects.
2. Locate and click the K204 GP 1 link.
3. Click the Download link, then click Run.
4. In the self-extracting archive dialog box, click the  button.
5. Navigate to the Desktop. Click OK, then click Extract.
Excerpted from Computers in Business K204 by Kelley School of Business Faculty. Copyright © 2016 Kelley School of Business Faculty. Excerpted by permission of Indiana University Press.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.
Table of Contents
Chapter 1 | K204 Introduction
Chapter 2 | Access Introduction
Chapter 3 | Importing Data, Keys, and Relationships
Chapter 4 | Data Types and Basic Field Settings
Chapter 5 | Data Entry, Lookup Fields, and Field Properties
Chapter 6 | Basic Select Query Design, Criteria, and Total Row
Chapter 7 | Concatenation, Calculated Fields, and Aggregate Functions
Chapter 8 | Parameter Query and Query on Queries
Chapter 9 |Query Wizard, and Action Queries
Chapter 10 | The IIF Function and Intro to Forms
Chapter 11 | Mulitple Page and Navigation Forms
Chapter 12 | The Power of Excel
Chapter 13 | Cell Referencing and Named Ranges
Chapter 14 | Conditional Aggregate and Date Functions
Chapter 15 | Financial Analysis
Chapter 16 | Logical Functions
Chapter 17 | Compound Nested IFs
Chapter 18 | Data Retrieval: VLOOKUP, HLOOKUP, MATCH
Chapter 19 | Data Retrieval: INDEX and MATCH
Chapter 20 | Spreadsheet Models and Data Tables
Chapter 21 | Data Validation
Chapter 22 | Working with Text Data
Chapter 23 | Tables and Charts
Chapter 24 | PivotTable and Power View Reports
Box at IU
Reports in Access
Automating Tasks with Macros
Chapter 26 | Database Planning and Assessing Data Needs
Chapter 27 | Design Theory and Normalization
Chapter 28 | Structuring Data in the Database
Chapter 29 | Advanced Reports
Chapter 30 | Advanced Forms and Macros