COURSE TITLE/CODE : COMputer Application PACkage2 (COMPAC2)

COURSE CREDIT : Three (3) Units

PRE-REQUISITE : COMPAC1

COURSE DESCRIPTION :

This is an advanced computer course for business management students that introduce the database management concepts and basic database operations with the use of database software running in Windows environment. This course is also designed to provide students with a broad understanding of Internet, and how Information Technology (IT) and Information System (IS) can be applied in organizations and business environment to improve efficiency and effectiveness, and the competitive advantage.

COURSE OBJECTIVES:

At the end of the course, the students are expected to be able to:

Identify and predict trends in the field of computing: Comprehend the relevance and impact of new technology to society and its potential applications.

Explain the principles of a database management system.

Operate the database software; design and create simple databases.

Apply the concepts learned in a software development project, and generate a high quality written report using MS-Word summarizing the results of their research; present and defend the research paper using MS PowerPoint.

Showcase the results of their hard work; simulate a presentation to management of a recommend improvement that will help organization to be more effective.

Develop a Web Page using MS FrontPage.

Develop an understanding of information systems, their conceptual and technical foundations, users, components, mission and capabilities.

To build a basic understanding of the value and uses of information systems for business operations, management decision-making and strategic advantage; appreciate the competitive advantage can be achieved by managing an enterprise’s information system.

Prepare students to use the computer (information) in solving problems when they become managers.

COURSE OUTLINE

TOPIC

1.0 Review of COMPAC1

Course Requirements and Classroom/Computer Laboratory Policies, Advanced MS Excel Application (Working with Formulas, Performing Calculations with Functions, Applying Conditional Formatting [IF-THEN Statements], Filtering to Find Specific Information, Build an Excel Database)

2.0 Advanced INTERNET Concepts

WWW Terminologies, Understanding Web Page Connections, Intranet Concepts, Web Site Development Process (Planning and Creating a Web Site), Overview to MS Outlook

FrontPage Explorer Operations – Create a new FrontPage Web, Navigate through the FrontPage Explorer, Move between the FrontPage Explorer and the FrontPage Editor

FrontPage Editor Operators – Add and edit text using various styles, Insert images and make hotspots, Create Forms, Insert WebBot Components, Change the properties of pages

3.0 Introduction to System Analysis and Design

Introduction to Programming Concepts (Logic Formulation, Algorithm & Flow Charting), System Development Process Improvement (BPI) Concepts

4.0 Introduction to Database Concepts

Definition of a database and a database Management System (DBMS), Entity-Relationship Model (Basic Concepts and Terminologies, E-R Diagrams, Relational Database Design (Relational Database Language, Formal Query Language, Functional Dependencies and Normalization)

Introduction to Database Software

5.0 MS Access

Introduction to MS-Access, Basic Key Terms and their special functions, Creating and Modifying Tables, Designing Databases, Query Basics, Report Basics, Form Design

6.0 Trends in Computer Development

Technology and Society, Introduction to Information System, Theory of Management and Organizations, Management Information Systems, Related Computer Technologies, Overview to Business Process Reengineering (BPR), End-User Computing (EUC), Knowledge Work System (KWS), Decision Support System (DDS), Expert System (ES), Trends, Technologies, Tools

CULMINATING PROJECT: