>>PRINT
Micro-Applications for Business
MICRO APPLIC
CLASS CODE: IS 140 CREDITS:  3
DIVISION: BUSINESS & COMMUNICATION
DEPARTMENT: INFORMATION SYSTEMS
GENERAL EDUCATION: This course fulfills a General Education - Basic Skills requirement.

CATALOG DESCRIPTION: Introduction to the use of microcomputers in business. Emphasis is on learning how to use spreadsheet and database applications to solve business problems.
DESCRIPTION: The use of microcomputers in business has become commonplace in almost every business and in most homes. People entering the business world today are expected to understand basic microcomputer concepts and have command of microcomputer applications for creating spreadsheets and database. This course is designed to teach a student how to use spreadsheets and database management applications to solve real business problems.
TOPICS: The development and implementation of Microsoft Excel spreadsheets and Microsoft Access databases to solve real business problems including the integration of these applications with word processing and world wide web documents.
OBJECTIVES: 1. Demonstrate the following skills using a
Spreadsheet
- Navigate to and enter data
- Format cells appropriately for different
number types, alignments, fonts, borders,
pattern and protection.
- Implement conditional formatting to meet task
objectives.
- Build formulas to solve arithmetic,
financial and statistical problems.
- Implement built-in functions including:
SUM, AVERAGE, MINIMUM, MAXIMUM, PRESENT,
VALUE, FUTURE VALUE, NUMBER OF PERIODS, RATE,
PAYMENT, PRINCIPAL PAYMENT, INTEREST
PAYMENT, IF, HORIZONTAL and VERTICAL LOOKUP
- Apply relative, absolute and mixed cell
references in formulas appropriately
- Create and modify charts of various types
including: Bari, Chart, Line, Pie, High–Low,
- Create and modify Pivot Tables (and charts)
- Create and using hyperlinks to connect to
Internet resources.
- Integrate with other applications including:
Object Linking and Embedding, Web Page
Publishing, 3-Dimensional cell referencing

2. Demonstrate the following skills using a
Database Management System
- Create and manage database tables
- Populate and edit data in a table.
- Implementing 1-to-1, 1-to-many and many-many
relationships.
- Create and manage queries including
filtered, matching, multiple matching,
reverse matching, calculations, logical o
operators and wildcards
- Create and manage forms based on tables and
queries
- Create and manage reports based on tables
and queries
REQUIREMENTS:
PREREQUISITES: Basic computer literacy including the use of a word processor and file managment. Be able to type at least 35 words a minute.
OTHER:
EFFECTIVE DATE: August 2002