Computer Applications I

Faculty
Commerce & Business Administration
Department
Office Administration
Course Code
OADM 1246
Credits
3.00
Semester Length
15 Weeks
Max Class Size
30
Method Of Instruction
Lecture
Lab
Typically Offered
To be determined
Campus
Online

Overview

Course Description
This course is a "hands-on" computer course. The students will develop a basic working knowledge of computers with emphasis on the operating system interface, word processing, spreadsheet, and email software. Students will apply the knowledge and use of these tools to solve problems encountered in an office environment. Students will be expected to integrate their learning and to incorporate the use of these tools in the production of professional documents that adhere to workplace standards.
Course Content

Module 1 - Operating System Interface

  1. Perform the four basic mouse operations and utilize keyboard shortcuts.
  2. Obtain online Help while using an application.
  3. Understand and use directory structures and paths in file management.
  4. Use a file manager to: identify directory structures and paths; select, copy and move one file or group of files or folders; create, rename and delete a file or folder.

Module 2  - Word Processing

  1. Create, save, preview, print, close, open, and edit a document.
  2. Proofread and correct all types of documents with the spelling and grammar checker, and thesaurus.
  3. Enhance documents with character, paragraph and global formatting features.
  4. Adjust margins and line spacing.
  5. Create headers and/or footers.
  6. Use and modify styles.
  7. Adjust page breaks and section breaks.
  8. Insert special symbols, bullets, and enumerations.
  9. Create custom tab settings.
  10. Create citations, and footnotes and/or endnotes.
  11. Create documents with the aid of wizards and templates.
  12. Create and use both autocorrect and autotext features.
  13. Insert, complete and format a table.
  14. Address and print preview envelopes and mailing labels.
  15. Use graphic features like colouring, shading, wordart, smartart, and page borders to enhance a document.
  16. Import, edit and format clip art and pictures, including setting text wrap options.
  17. Generate form letters and mailing labels.
  18. Design a newsletter utilizing columns and graphic elements.

Module 3 - Spreadsheet

  1. Create a simple report with an embedded chart.
  2. Create financial reports that facilitate both "what-if" analysis.
  3. Use SUM, AVERAGE, MAX, MIN and IF functions.
  4. Construct basic formulae (including a review of the order of operations).
  5. Use relative, absolute and 3-D referencing in building formulas.
  6. Create a variety of chart sheets.

Module 4 - Email 

  1. Compose, send, receive, forward and respond to email messages.
  2. Create, organize, store and print contact lists.
  3. Create meetings and appointments in online calendars.
  4. Display, print and work with calendars in assorted views.

 

Methods Of Instruction

A combination of lecture, demonstration, guided practice, web-based training, and self-paced lab assignment and simulation projects may be used. Active learning is an integral part of this course, and major emphasis will be placed on a "hands-on" environment to allow students to work both independently and collaboratively to learn and apply computer application skills and techniques.

Means of Assessment
MS Word Test(s)    30-50%
MS Excel Test(s)   20-25%
MS Outlook Test(s)   5-15%
Employability Skills   0-5%
Assignments   5-20%
Project(s)   10-25%
Total   100%

Note:  No single test can be worth more than 40%.

Learning Outcomes

The learner has reliably demonstrated the ability to:

  1. Use the operating system interface to perform basic software functions and to organize and manage directories and files effectively;
  2. Use email software to manage email communications, handle contacts, and schedule appointments and meetings;
  3. Use word processing software to produce a variety of business documents meeting industry standards for timely completion, correctness of content and format, and professional appearance;
  4. Use spreadsheet software capable of answering "what-if" questions to solve business problems;
  5. Use the computer as a decision-making and problem-solving tool;
  6. Produce business documents requiring the integration of word processing, spreadsheet, and email software.
Textbook Materials

Lambert, Joan and Curtis Fry.  Microsoft Office 2019 Step by Step, Latest Ed., Pearson: Microsoft Press

Or other textbooks and/or online tools as approved by the department.

Requisites

Prerequisites

No prerequisite courses.

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

Courses listed here are equivalent to this course and cannot be taken for further credit:

  • No equivalency courses

Requisite for

This course is not required for any other course.

Course Guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.

Course Transfers

Institution Transfer Details Effective Dates
There are no applicable transfer credits for this course.

Course Offerings

Winter 2021

CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
15115
Mon Wed
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Yip
Titus
Open
Online
This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
30
0
30
0
Days
Building
Room
Time
Mon Wed
12:30 - 14:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
15116
Mon Wed
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Yip
Titus
Open
Online
This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
30
0
30
0
Days
Building
Room
Time
Mon Wed
14:30 - 16:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
15117
Wed Fri
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Cordon
David
Open
Online
This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
30
0
30
0
Days
Building
Room
Time
Wed Fri
10:30 - 12:20