Page 642 -

INTEGRATING BUSINESS WITH TECHNOLOGY

By completing the projects in this text, students will be able to demonstrate business knowledge, application
software proficiency, and Internet skills.These projects can be used by instructors as learning assessment
tools and by students as demonstrations of business, software, and problem-solving skills to future employers.
Here are some of the skills and competencies students using this text will be able to demonstrate:

Business Application skills: Use of both business and software skills in real-world business applications.
Demonstrates both business knowledge and proficiency in spreadsheet, database, and Web page/blog creation
tools.
Internet skills: Ability to use Internet tools to access information, conduct research, or perform online
calculations and analysis.

Analytical, writing and presentation skills: Ability to research a specific topic, analyze a problem, think
creatively, suggest a solution, and prepare a clear written or oral presentation of the solution, working either
individually or with others in a group.

Business Application Skills

BUSINESS SKILLS SOFTWARE SKILLS CHAPTER
Finance and Accounting
Financial statement analysis Spreadsheet charts Chapter 2*

Spreadsheet formulas Chapter 10
Spreadsheet downloading and formatting
Pricing hardware and software Spreadsheet formulas Chapter 5
Technology rent vs. buy decision Spreadsheet formulas Chapter 5*
Total Cost of Ownership (TCO) analysis
Analyzing telecommunications services and costs Spreadsheet formulas Chapter 7
Risk assessment Spreadsheet charts and formulas Chapter 8

Retirement planning Spreadsheet formulas and logical functions Chapter 11
Capital budgeting Spreadsheet formulas Chapter 14
Chapter 14*

Human Resources
Employee training and skills tracking Database design Chapter 13*
Database querying and reporting
Job posting database and Web page Database design Chapter 15
Web page design and creation
Manufacturing and Production
Analyzing supplier performance and pricing Spreadsheet date functions Chapter 2
Database functions
Data filtering
Inventory management Importing data into a database Chapter 6
Database querying and reporting
Bill of materials cost sensitivity analysis Spreadsheet data tables Chapter 12*
Spreadsheet formulas

Sales and Marketing
Sales trend analysis Database querying and reporting Chapter 1

MIS13_InteriorSpread Global.indd 2 1/17/2013 2:37:14 PM