Computer Applications II

Faculty
Commerce & Business Administration
Department
Office Administration
Course Code
OADM 1346
Credits
3.00
Semester Length
4 x 15 = 60 hrs.
Max Class Size
30
Method Of Instruction
Lecture
Lab
Typically Offered
To be determined
Campus
Coquitlam

Overview

Course Description
This course is a "hands-on" computer course. The students will build on their working knowledge of computers while developing new skills in using spreadsheets, presentation software, databases, and PDF editors. 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 - Presentation Software [2]

  1. Create and edit the text of a presentation.
  2. Add animation and transition effects to a presentation.
  3. Add and format clip art, pictures, shapes, smartart, video and audio in presentations.
  4. Insert and format a table and chart in presentations.

Module 2 - Databases [5]

  1. Create a relational database with multiple tables.
  2. Modify and update tables while establishing validation rules.
  3. Establish and use input masks.
  4. Perform a variety of queries and generate related forms and reports.
  5. Create, modify, print and save forms.
  6. Create, modify, print and save reports.
  7. Create a form with a sub-form.
  8. Create and use a lookup field.
  9. Create and use a calculated field.
  10. Add controls to both forms and reports.

Module 3 - Spreadsheets [4]

  1.  Solve problems involving the PMT, FV, AND, OR, VLOOKUP, HLOOKUP, IFERROR, COUNTIF, SUMIF, and AVERAGEIF functions.
  2. Work with large spreadsheets--freeze panes, hide rows/columns.
  3. Use relative, absolute, and mixed references.
  4. Create, format and filter a spreadsheet table.
  5. Create, filter and sort a PivotTable and related PivotChart.
  6. Link cells in multiple worksheets.
  7. Link multiple workbooks.
  8. Use conditional formatting.
  9. Use defined names in formulas.
  10. Protect contents of worksheets and workbooks and create an application utilizing a macro.

Module 4 - PDF Editors [3]

  1. Create a PDF document from various sources.
  2. Arrange, insert and delete PDF document pages.
  3. Edit and format PDF document text and images.
  4. Add, modify, arrange and format bookmarks.
  5. Create, resize and align links.
  6. Add notes, text and drawing markups.
  7. View, organize and summarize comments.
  8. Create, format and modify fillable forms.
  9. Create, format and modify multimedia presentations.

 

Methods Of Instruction

A combination of lecture, demonstration, guided practice, web-based training, and self-paced lab assignments 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
PowerPoint Test         10-15%
Access Test   25-30%
Excel Test   15-25%
PDF Test   15-20%
Assignments       5-10%
Project(s)   5-15%
Total   100%
Learning Outcomes

The learning 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 database software to create and maintain tables in a relational database, and routinely retrieve information by performing queries to generate a variety of forms and reports;
  3. Use presentation software to produce slideshows that include clip art, pictures, shapes, smartart, tables, charts, video, and audio, and animates both text and graphics;
  4. Use spreadsheet software to solve a variety of business problems requiring mathematical solutions;
  5. Use a PDF editor to produce a variety of business documents meeting industry standards for timely completion, correctness of content and format, and professional appearance;
  6. Use the computer as a decision-making and problem-solving tool; and
  7. Produce business documents requiring the integration of all applications found in a typical office suite.
Textbook Materials

Zimmerman, Beverly B., Zimmerman, S. Scott, and Katherine T. Pinard. New Perspectives on Microsoft PowerPoint, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Adamski, Joseph J. and Kathleen T. Finnegan. New Perspectives on Microsoft Access, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Parsons, June Jamrich, Oja, Dan, Ageloff, Roy and Patrick Carey. New Perspectives on Microsoft Excel, Introductory, Latest Ed., Nelson Education: Course Technology Cengage Learning.

Adobe Acrobat: Classroom in a Book. Latest Ed., Adobe Press.

Skills Assessment Manager (SAM), Latest Ed., Nelson Education: Course Technology Cengage Learning.

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

Requisites

Prerequisites

Corequisites

No corequisite courses.

Equivalencies

No equivalent 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

There aren't any scheduled upcoming offerings for this course.