Course

Productivity Software and Client Support

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course code
CSIS 1140
Credits
3.00
Semester length
15 Weeks X 4 Hours per Week = 60 Hours
Max class size
35
Method(s) of instruction
Lecture
Lab
Seminar
Course designation
None
Typically offered
To be determined

Overview

Course description
In this course, the student develops mastery of advanced MS-Office features. Integration of data from different MS-Office applications will be covered. The student will learn about software support functions in an office setting and trouble-shooting techniques. Basic Help Desk support functions will be introduced and put into practice.
Note: Students who have received credit for CISY 1410 will not receive further credit for CSIS1140.
Course content
  • Word processing software:
    • Table of content,
    • mail-merge,
    • newsletter,
    • and other advanced functions.
  • Spreadsheet software:
    • linking worksheets,
    • database management,
    • pivot table,
    • and other advanced functions.
  • Database management software:
    • table structure,
    • combo boxes,
    • switchboard,
    • and other advanced functions.
  • Presentation graphics software:
    • slide master,
    • customized slide presentation,
    • and other advanced functions.
  • Integration of different MS-Office documents by using object-linking embedding technique
  • E-mail and online support techniques:
    • customized task list,
    • instant messaging,
    • and other advanced functions.
  • Help Desk user support:
    • Introduction to the support industry
    • Telephone communication skills
    • Dealing with difficult customer-service situations
    • Ethics in the workplace
    • Other related topics
  • Tools, Problem Solving, and Processes
    • Tools and technologies for the support center
    • Creativity and problem-solving
    • Process integration
    • Other related topics
Learning activities

Lecture, seminar, role playing, "hands on" exercises in the computer lab

Means of assessment
Assignments (Minimum: 4) 20% - 30%
Quizzes (1–4) 10% - 20%
Midterm Examination 25% - 30%
Final Examination 25% - 30%
Total         100%

Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.

Learning outcomes

The student will be able to:

  • use advanced features of an integrated software package including word processing, spreadsheet, database, presentation graphics;
  • communicate online by using e-mail; manage an e-mailbox;
  • diagnose and solve common problems by using problem solving techniques;
  • develop and practice effective techniques in customer and help desk support.
Textbook materials

Textbooks and Materials to be Purchased by Students

Shelly, Cashman. Microsoft Office 2003 Advanced Concepts and Techniques. Latest edition.  Course Technology

Requisites

Prerequisites

CSIS1110 or CISY1110 or approved equivalent

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

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.

(Current)

Course Transfers

These are for current course guidelines only. For a full list of archived courses please see https://www.bctransferguide.ca

Institution Transfer details for CSIS 1140
Alexander College (ALEX) ALEX CPSC 1XX (3)
Camosun College (CAMO) CAMO COMP 156 (3)
Capilano University (CAPU) CAPU PSEL 1XX (3)
Kwantlen Polytechnic University (KPU) KPU CPSC 1XXX (3)
Langara College (LANG) LANG BCAP 1XXX (3) or LANG CSIS 1XXX (3)
Simon Fraser University (SFU) No credit
University of British Columbia - Vancouver (UBCV) No credit
University of the Fraser Valley (UFV) UFV CIS 110 (3)
University of Victoria (UVIC) UVIC CSC 105 (1.5)

Course Offerings

Winter 2025