Skip to Content
Search

COURSES

   

CMPT 119
Computer Applications in Business

3.0 Credits
College or University

Description

Computer Applications in Business provides an overview of the integrated software packages most often used in the workplace. By the end of this course, you will have a sound understanding of the basic features and business applications for the word processor, spreadsheet, database, and presentation software in your choice of either Microsoft Works Suite or Microsoft Office Professional packages.

This course will teach you the basics in how to use computers to communicate. In the process of completing this course, you will also learn how to problem solve and use the Help function and online tutorial assistance for your software. Finally, as this is an online course, you will learn about using the Internet and email.

Delivery Method

There is continuous enrolment for this course. Delivery is self-paced, allowing you the flexibility to proceed through the course according to your own schedule.

Prerequisites

None. Students will need access to a PC with full internet access and MS Office Professional (XP preferred) including Access database software or MS Works (the 2002 or newer Works 'Suite' with Word included is preferred). This course is not ideal for those using the MS Office 2007 version.

Exclusions

Students with credit for CMPT 109, 150 or a similar course may not take CMPT 119 for further credit.

Objectives

  • Answer questions regarding your computer's hardware, software, and basic operations.
  • Set up your computer for World Wide Web connection.
  • Use e-mail to send messages and file attachments.
  • Participate in on-line discussion groups.
  • Describe the types of documents created with a word processing program.
  • List the principal features of a word processing program.
  • Create and format a business letter.
  • Create and format a schedule containing a table.
  • Design either a textual or a visual message for a public audience.
  • Select and use style features to create new documents.
  • Use the Help system to answer questions and troubleshoot problems.
  • Describe the purposes of a spreadsheet and define its vocabulary.
  • Set up and analyse itemized lists of numbers, such as the various types of budgets or financial statements.
  • Perform and manipulate the calculations to achieve meaningful information.
  • Present the numerical data in the spreadsheet in a graphical format.
  • Conduct "what if" simulations of the numerical statements.
  • Import spreadsheet reports and charts into word processing and/or database documents.
  • Define the purpose of a database program.
  • Describe the components of a database.
  • Plan a simple two-table database.
  • Use wizards to enter and to search data, and to create a report.
  • Enter data in a form.
  • Merge data with a document.
  • Create mailing labels.
  • Analyse data in a database.
  • Privacy issues related to databases.
  • Plan a presentation.
  • Apply good design principles to a presentation.
  • Examine examples of a presentation.
  • Describe the purpose of presentation software.
  • Describe the components of a presentation.
  • Create a presentation outline.
  • Apply and modify a design template.
  • Add clip art and charts to a presentation.
  • Run a slide show.

Course Outline

  • Module 1: Using a Computer to Communicate
  • Module 2: Word Processing Basics
  • Module 3: Spreadsheet Applications
  • Module 4: Database Basics
  • Module 5: The Fundamentals of Computer Based Presentations
  • Module 6: Project Exam

Maximum Completion

30 weeks. CMPT 119 can however be accelerated and completed in 15 weeks or less provided students consistently devote 10 - 15 hours per week to the course.

Required Text and Materials

There are no texts or materials provided for this course (all content is online). Microsoft Office Professional (XP strongly recommended) including Access database software or MS Works Suite (2002 or newer with Word is strongly recommended) is the required software (TRU-OL does not provide either).

Additional Requirements

  • Anti-Virus software
  • QuickTime

Students are responsible for having a PC with full Internet access through an Internet Service Provider (ISP). The minimum requirement is a 56K connection speed, but high-speed Internet access is recommended (i.e. ADSL or cable modem).

Web students should refer to "Course Delivery Formats" in the TRU-OL Calendar or on the TRU-OL web site for computer requirements (see: http://www.tru.ca/distance/services/online_courses.html#web).

Tutor Information

The course Tutor provides support through WebCT mail, and can also be reached by phone.

Assessment

Formal assessment includes the assignments that are submitted to your tutor for grading and for which you receive marks. Formal assessment occurs for each module and the last module is the course project that makes up a considerable percentage of your final grade. Note that 5% of your final grade will be based on participation in on-line discussions.

Assignment Weighting and Specifications

Module 1 (Essay) 10%
Module 2 (Business Documents) 10%
Module 3 (Essay and Spreadsheet) 10%
Module 4 (Essay and Database) 10%
Module 5 (Presentation) 10%
Final Project 45%
Online discussion participation 5%
TOTAL 100%


(back to top)