Business Driven Technology

B R I E F TA B L E O F C O N T E N T S

Units:
1. Achieving Business Success
Chapter 1: Business Driven Technology
Chapter 2: Identifying Competitive Advantages
Chapter 3: Strategic Initiatives for Implementing Competitive Advantages
Chapter 4: Measuring the Success of Strategic Initiatives
Chapter 5: Organizational Structures That Support Strategic Initiatives
2 Exploring Business Intelligence
Chapter 6: Valuing and Storing Organizational Information—Databases
Chapter 7: Accessing Organizational Information—Data Warehouses
Chapter 8: Understanding Big Data and Its Impact on Business
3 Streamlining Business Operations
Chapter 9: Enabling the Organization—Decision Making
Chapter 10: Extending the Organization—Supply Chain Management
Chapter 11: Building a Customer-Centric Organization—Customer Relationship Management
Chapter 12: Integrating the Organization from End to End—Enterprise Resource Planning
4 Building Innovation
Chapter 13: Creating Innovative Organizations
Chapter 14: Ebusiness
Chapter 15: Creating Collaborative Partnerships
Chapter 16: Integrating Wireless Technology in Business
5 Transforming Organizations
Chapter 17: Developing Software to Streamline Operations
Chapter 18: Methodologies for Supporting Agile Organizations
Chapter 19: Managing Organizational Projects

BUSINESS PLUG-INS
B1 Business Basics
B2 Business Process
B3 Hardware and Software Basics
B4 MIS Infrastructures
B5 Networks and Telecommunications
B6 Information Security
B7 Ethics
B8 Operations Management
B9 Sustainable MIS Infrastructures
B10 Business Intelligence
B11 Global Information Systems
B12 Global Trends

TECHNOLOGY PLUG-INS
T1 Personal Productivity Using IT
T2 Basic Skills Using Excel
T3 Problem Solving Using Excel
T4 Decision Making Using Excel
T5 Designing Database Applications
T6 Basic Skills Using Access
T7 Problem Solving Using Access
T8 Decision Making Using Access
T9 Designing Web Pages
T10 Creating Web Pages Using HTML
T11 Creating Gantt Charts with Excel and Microsoft
Project

Apply Your Knowledge Projects
Glossary
Notes
Index

The overall goal of the Technology Plug-Ins is to provide additional information not covered in the text such as personal
productivity using information technology, problem solving using Excel, and decision making using Access. These plug-ins
also offer an all-in-one text to faculty, avoiding their having to purchase an extra book to support Microsoft Office. These
plug-ins offer integration with the core chapters and provide critical knowledge using essential business applications, such
as Microsoft Excel, Microsoft Access, and Microsoft Project with hands-on tutorials for comprehension and mastery. Plug-
Ins T1 to T12 are located in McGraw-Hill Connect at http://connect.mheducation.com.
Plug-In Description
T1. Personal Productivity
Using IT
This plug-in covers a number of things to do to keep a personal computer running effectively
and efficiently. The topics covered in this plug-in are:
■ Creating strong passwords.
■ Performing good file management.
■ Implementing effective backup and recovery strategies.
■ Using Zip files.
■ Writing professional emails.
■ Stopping spam.
■ Preventing phishing.
■ Detecting spyware.
■ Threads to instant messaging.
■ Increasing PC performance.
■ Using antivirus software.
■ Installing a personal firewall.
T2. Basic Skills Using
Excel
This plug-in introduces the basics of using Microsoft Excel, a spreadsheet program for data analysis, along with
a few fancy features. The topics covered in this plug-in are:
■ Workbooks and worksheets.
■ Working with cells and cell data.
■ Printing worksheets.
■ Formatting worksheets.
■ Formulas.
■ Working with charts and graphics.
T3. Problem Solving Using
Excel
This plug-in provides a comprehensive tutorial on how to use a variety of Microsoft Excel functions and features
for problem solving. The areas covered in this plug-in are:
■ Lists
■ Conditional Formatting
■ AutoFilter
■ Subtotals
■ PivotTables
T4. Decision Making Using
Excel
This plug-in examines a few of the advanced business analysis tools used in Microsoft
Excel that have the capability
to identify patterns, trends, and rules, and create “what-if” models. The four topics covered
in this plug-in are:
■ IF
■ Lookup
■ Goal Seek
■ Solver
■ Scenario Manager
T5. Designing Database
Applications
This plug-in provides specific details on how to design relational database applications. One of the most
efficient
and powerful information management computer-based applications is the relational database. The
topics covered in this plug-in are:
■ Entities and data relationships.
■ Documenting logical data relationships.
■ The relational data model.
■ Normalization.
T6. Basic Skills Using Access
This plug-in focuses on creating a Microsoft Access database file. One of the most efficient
information management computer-based applications is Microsoft Access. Access provides a powerful
set of
tools for creating and maintaining a relational database. The topics covered in this plug-in are:
■ Create a new database file.
■ Create and modify tables.
T7. Problem Solving Using
Access
This plug-in provides a comprehensive tutorial on how to query a database in Microsoft Access. Queries are
essential for problem solving, allowing a user to sort information, summarize data (display totals, averages,
counts, and so on), display the results of calculations on data, and choose exactly which fields are shown. The
topics in this plug-in are:
■ Create simple queries using the simple query wizard.
■ Create advanced queries using calculated fields.
■ Format results displayed in calculated fields.
T8. Decision Making Using
Access
This plug-in provides a comprehensive tutorial on entering data in a well-designed form and
creating functional reports using Microsoft Access. A form is essential to use for data entry and a report is an effective
way to present data in a printed format. The topics in this plug-in are:
■ Creating, modifying, and running forms.
■ Creating, modifying, and running reports.
T9. Designing Web Pages This plug-in provides a comprehensive assessment into the functional aspects of web design. Websites
are
beginning
to look more alike and to employ the same metaphors and conventions. The web has now become
an everyday thing whose design should not make users think. The topics in this plug-in are:
■ The World Wide Web.
■ Designing for the unknown(s).
■ The process of web design.
■ HTML basics.
■ Web fonts.
■ Web graphics.
T10. Creating Web Pages Using
HTML
This plug-in provides an overview of creating web pages using the HTML language. HTML is a system of codes
that you use to create interactive web pages. It provides a means to describe the structure of text-based information
in a document—by denoting certain text as headings, paragraphs, lists, and so on. The topics in this
plug-in are:
■ An introduction to HTML.
■ HTML tools.
■ Creating, saving, and viewing HTML documents.
■ Apply style tags and attributes.
■ Using fancy formatting.
■ Creating hyperlinks.
■ Displaying graphics.
T11. Creating Gantt Charts
with Excel and
Microsoft Project
This plug-in offers a quick and efficient way to manage projects. Excel and Microsoft Project are great for managing
all phases of a project, creating templates, collaborating on planning processes, tracking project progress,
and sharing information with all interested parties. The two topics in this plug-in are:
■ Creating Gantt Charts with Excel.
■ Creating Gantt Charts with Microsoft Project.