Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo
back to search

Computer Applications II

Course Code: OADM 1346
Faculty: Commerce & Business Administration
Department: Office Administration
Credits: 3.0
Semester: 4 x 15 = 60 hrs.
Learning Format: Lecture, Lab
Typically Offered: TBD. Contact Department Chair for more info.
course overview

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.

course prerequisites

OADM 1246 or OADM 1256

curriculum 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 schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.


If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.