Computer Applications and Office Administration
Con-Ed Header

For Office Administration and Computer Applications course inquiries, call (519) 972-2711 (Windsor) or (519) 354-9100, ext. 3260 (Thames.)

Business Computer Applications Certificate

10 courses required MIC 111 Computer Applications I
OR OAG 170 Professional Computer Applications I

MIC 211 Computer Applications II
OR OAG 270 Professional Computer Applications II

MIC 310 Word Processing Techniques
MIC 410 Computer Presentation Techniques
MIC 510 Spreadsheeting Techniques
MIC 610 Database Techniques

PLUS 4 General Business Electives

Microsoft Office 2013

For Computer courses, it is recommended that you obtain a USB Flash Drive (memory stick) prior to the start of the course and bring it to the first class. Some of these courses may also recommend the purchase of online assessment software for training and/or testing purposes.

PROFESSIONAL COMPUTER APPLICATIONS I (OAG 170) and PROFESSIONAL COMPUTER APPLICATIONS II (OAG 270) can be found under Office Administration.

COMPUTER BASICS
GENC 102
To provide users with a basic introduction to the world of computers. Topics included are computer terminology, an introduction to Windows, Microsoft Word and Excel. The course will be hands-on to give the maximum amount of computer experience. 1 unit of credit.
FALL
Windsor 050 5426 Sep 19-Nov 7, Tue, 6:00P-8:30P $148.90 (tuition $132.00, materials $16.90)
Chatham 550 5427 Sept 21-Nov 9, Thu, 6:00P-8:30P $148.90 (tuition $132.00, materials $16.90)
WINTER
Windsor 050 1897 Jan 16-Mar 6, Tue, 6:00P-8:30P $148.90 (tuition $132.00, materials $16.90)
Chatham 570 1898 Jan 20-Mar 10, Sat, 9:00A-11:30A $148.90 (tuition $132.00, materials $16.90)
Chatham 550 1136 Jan 18-Mar 8, Thu, 6:30P-9:00P $148.90 (tuition $132.00, materials $16.90)
COMPUTER CONCEPTS/WORD FOR WINDOWS
MIT 105
This course is designed to provide an introduction to computers and the word processing environment. In a hands-on environment, students will be exposed to the basic operation of a computer using Microsoft Word. Emphasis will be placed on configuring Word, document creation, formatting techniques, using Word tools, tables, fields, and object linking and embedding. 3 units of credit. Text extra.
FALL
Chatham 550 5453 Sep 18-Dec 11, Mon, 6:00P-9:30P $277.20
WINTER
Windsor 050 1162 Jan 18-Apr 5, Thu, 6:00P-9:30P $277.20
COMPUTER PRESENTATION TECHNIQUES
MIC 410
This course builds on the Microsoft PowerPoint 2013 software introduced in Professional Computer Applications I. This intermediate level course focuses on the effective impacting of your audience with powerful presentation graphics. Working with electronic presentations and text, creating speaker’s notes and handouts, adding clip art, graphs and organizational charts will be covered in depth. In addition, advanced features, such as adding transitions, creating colour schemes and linking to other applications will also be explored. 3 units of credit. (Note: Students must have MS Office 2013 software for online computer courses.) Pre-requisite: MIC 111 or OAG 170. Text extra.
FALL
Online 065 5409 Sep 18-Dec 9 $326.20 (includes $49.00 access fee)
WINTER
Windsor 050 1115 Jan 16-Apr 3, Tue, 6:00P-9:30P $277.20
DATA BASE TECHNIQUES
MIC 610
This course builds on the Microsoft ACCESS software introduced in Computer Applications II. This intermediate level course allows the student to develop and understand a database in detail based on the Microsoft Office application Access. Students will study the relational database concepts necessary to create and implement proper file designs. In a Hands-On environment, students will use Microsoft Access to create data tables, data queries, build custom forms, create reports, use macros, wizards and the switchboard manager. 3 units of credit. (Note: Students must have MS Office 2016 software for online computer courses.) Pre-requisite: MIC 211 or OAG 270. Text extra.
WINTER
Online 065 1117 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
INTRODUCTION TO SPREADSHEETS USING MS EXCEL
MIT 123
This course provides the student with an intermediate-level hands-on experience using the Microsoft Excel spreadsheet application software. Students will focus on building basic competency in the use of Microsoft Excel. Students will also create and enhance a variety of spreadsheets and workbooks of increasing complexity to manipulate data for a variety of uses. Emphasis is on practice to achieve mastery level in each competency taught within the course. In-class Simulation Labs are a major component of the course syllabus. Text extra.
FALL
Windsor 050 5500 Sep 21-Nov 23, Thu, 6:00P-9:00P $198.00
WINTER
Chatham 550 1232 Jan 15-Mar 26, Mon, 6:00P-9:00P $198.00
SPREADSHEETING TECHNIQUES
MIC 510
This course builds on the MICROSOFT EXCEL 2013 software introduced in Professional Computer Applications II. This intermediate level course reviews worksheet basics, building formulas, formatting, editing, graphics, printing and presenting the results of electronic spreadsheets. Areas of focus will include financial, statistical and what-if analysis, innovative chart and graph techniques, managing information in lists including macros using Visual Basic for application, hyperlinks, scenario manager, sorting and filtering a worksheet database, pivot tables, creating a data map, integrating applications with the clipboard and object linking and embedding (OLE.) 3 units of credit. (Note: Students must have MS Office 2016 software for online computer courses.) Pre-requisite: MIC 211 or OAG 270. Text extra.
FALL
Online 065 5410 Sep 18-Dec 9 $326.20 (includes $49.00 access fee)
WINTER
Windsor 050 1116 Jan 17-Apr 4, Wed, 6:00P-9:30P $277.20
WINDOWS COMPUTER APPLICATIONS
MIC 125
This introductory course in computer applications provides you with a foundation of general computer skills in Microsoft Office Computer Fundamentals, WORD, POWERPOINT and EXCEL. A significant component of the course will be the development of your ability to use online and computer assisted learning. No prior computer experience is assumed. 3 units of credit. Text extra.
FALL
Chatham 550 5499 Sep 20-Dec 11, Wed, 6:00P-9:30P $277.20
WINTER
Windsor 050 1231 Jan 18-Apr 5, Thu, 6:00P-9:30P $277.20
WORD PROCESSING TECHNIQUES
MIC 310
This course builds on the Microsoft Word 2013 software introduced in Professional Computer Applications I. This intermediate level course focuses on the more advanced features of working with tables, fields, macros and Object Linking & Embedding (OLE.) Your ability to create, edit, format and print professional looking documents will be further enhanced. Using the thesaurus, checking grammar and spelling, using pre-formatted templates, adding graphics including ClipArt and WordArt and working with multiple documents and forms will combine to increase your word processing power. 3 units of credit. (Note: Students must have MS Office 2013 software for online computer courses.) Pre-requisite: MIC 111 or OAG 170. Text extra.
FALL
Windsor 050 5408 Sept 21-Dec 7, Thu, 6:00P-9:30P $277.20
WINTER
Online 065 1114 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)

General Interest Computer Courses

INTRO EXCEL FOR WINDOWS-BASIC
GNR 630N
Aimed at the new user, this 6 hour seminar provides an introduction to the basic commands, functions and capabilities of the Windows version of the Excel spreadsheet package. Topics include creating and updating worksheets, moving and copying data, using simple formulas to perform calculations and printing spreadsheets. Please bring a storage device to class.
FALL
Chatham 570 5765 Sept 23, Sat, 9:00A-4:00P $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
WINTER
Chatham 570 1375 Jan 20, Sat, 9:00A-4:00P $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
EXCEL FOR WINDOWS – ADVANCED
GNR 627N
This workshop gives participants the opportunity to explore the advanced features of this popular Windows based spreadsheet. The aim is to help you to fine-tune your skills as you learn about managing large worksheets, using database features (creating, sorting, querying and pivot tables) working with formulas and functions, linking worksheets and working with ranges. You will also explore how to better present your worksheets using AutoFormat to achieve professional results. Please bring a storage device to class.
FALL
Chatham 570 5769 Sept 30, Sat, 9:00A-4:00P $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
WINTER
Chatham 570 1308 Jan 27, Sat, 9:00A-4:00P $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
INTRO TO WORD BASICS
GNR 35082N
This workshop will provide you with hands-on training in the basic fundamentals of using Word 2013. You will learn how to open, create, edit, save, format, preview and print your documents. Also, how to use proofing tools such as spelling and thesaurus.
WINTER
Chatham 570 1406 Jan 20, Sat, 9:00A-4:00P $96.05 (Tuition $80.00, materials $5.00, HST $11.05)

Office Administration

Completion of the following courses provides the student with the Office Administration– General Post-Secondary Certificate (also offered during the day). Students completing the certificate may enroll in the Office Administration – Health Services Post-Secondary Diploma program offered during the day or complete the classes in the evening.

OFFICE ADMINISTRATION GENERAL CERTIFICATE

12 courses required ACC 145 Accounting for the Office Assistant
BUS 108 Introduction to Canadian Business
COM 103 Business Communications I
OAG 110 Language Fundamentals
OAG 125 Administrative Procedures
OAG 150 Administrative Documents I
OAG 160 Essential Business Calculations
OAG 170 Professional Computer Applications I
OAG 230 Business Computing and the Internet
OAG 250 Administrative Documents II
OAG 270 Professional Computer Applications II
ELECTIVE One elective course ending in the letter G from the Humanities/Social Sciences section. Example: SSC 110G
ACCOUNTING - OFFICE ASSISTANT
ACC 145
An introductory course offering a working knowledge of accounting records and procedures. The accounting cycle is covered along with financial statements. 3 units of credit. Text extra.
FALL
Windsor 050 5510 Sep 19-Dec 5, Tue, 6:00P-9:30P $277.20
WINTER
Online 065 xxxx Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
Chatham 550 1243 Jan 15- Apr 9, Mon, 6:00P-9:30P $277.20
ADMINISTRATIVE DOCUMENTS I (KEYBOARDING)
OAG 150
Basic skills in touch keyboarding; vertical, horizontal, block and spread centering; basic letter styles, tabulations and reports will be covered in this course. Emphasis will be placed on the production of mailable copy. 3 units of credit. Text extra.
WINTER
Windsor 050 1236 Jan 16-Apr 3, Tue, 6:00P-9:30P $277.20
Chatham 550 1237 Jan 15-Apr 9, Mon, 6:00P-9:30P $277.20
ADMINISTRATIVE PROCEDURES
OAG 125
This course examines automated office systems and procedures in a business environment. The topics covered are: information processing and integrated office automation, telephone techniques, meetings and conference planning, correspondence procedures and records management, time management skills financial management, mail and postal services, data and reference research, and using computerized forms and simulations. 3 units of credit. Text extra.
FALL
Chatham 550 6292 Sep 21-Dec 7, Thu, 6:00P-9:30P $277.20
WINTER
Windsor 050 1235 Jan 17-Apr 4, Wed, 6:00P-9:30P $277.20
BUSINESS COMMUNICATIONS I
COM 103
This course fosters the development of written communication skills necessary for business students. Students learn to analyze an intended audience, determine purpose, and apply the appropriate business communication format including letters, email, memos, instant messages, and proposals. Critical reading skills are also developed. Students review Standard English grammar, sentence structure, and paragraph construction. 3 units of credit. Text extra.
FALL
Chatham 550 5577 Sep 20-Dec 6, Wed, 6:00P-9:30P $277.20
BUSINESS COMPUTING AND THE INTERNET
OAG 230
This course builds skills related to the applied use of the internet and computing technology in a networked environment. A strong focus will be on the development of intermediate level word processing concepts utilizing MS Word. Students will complete labs and assignments that reflect current business requirements for professional office assistants in the workplace and begin to integrate data between MS Office applications. 3 units of credit. Pre-requisite: OAG 170. (Note: Students must have MS Office 2013 software for on-line computer courses) Text extra.
FALL
Online 065 5509 Sep 18-Dec 9 $326.20 (includes $49.00 access fee)
WINTER
Windsor 050 1240 Jan 18-Apr 5, Thu, 6:00P-9:30P $277.20
Chatham 550 1241 Jan 17-Apr 4, Wed, 6:00P-9:30P $277.20
ESSENTIAL BUSINESS CALCULATIONS
OAG 160
A two-part course designed to give the student practice in analyzing and solving business problems, manually and with the aid of an electronic calculator. Part one consists of a review of basic arithmetic fundamentals and functions. Part two consists of practical business applications in banking, merchandising, interest, consumer finance and payroll. 3 units of credit. Text extra.
FALL
Windsor 050 5505 Sep 25-Dec 11, Mon, 6:00P-9:30P $277.20
Chatham 550 5504 Sep 18-Dec 11, Mon, 6:00P-9:30P $277.20
INTRODUCTION TO CANADIAN BUSINESS
BUS 108
This course is designed to introduce the student to the fundamentals of the Canadian business system. Students will develop an understanding of the basic practices of business and become familiar with common business terminology. The knowledge and skills learned in this course can be applied directly to many business situations and will provide a solid foundation for business activities and future business courses. 3 units of credit. Text extra.
FALL
Windsor 050 5373 Sept 18-Dec 11, Mon, 6:30P-10:00P $277.20
WINTER
ONLINE 066 1080 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
LANGUAGE FUNDAMENTALS
OAG 110
This course is designed to improve the student’s basic grammar skills. The course will cover the various parts of speech, sentence construction, punctuation, capitalization, meanings of words, and use of numbers. Specific emphasis will be given to language fundamentals that are important in the business office. This course is designed to improve the student’s basic grammar skills. Various parts of speech, sentence construction, punctuation, spelling, and meanings of words will be covered. 3 units of credit. Text extra.
FALL
Windsor 050 5502 Sep 21-Dec 7, Thu, 6:00P-9:30P $277.20
Chatham 550 5501 Sep 20-Dec 6, Wed, 6:00P-9:30P $277.20
WINTER
Online 065 1233 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
PROFESSIONAL COMPUTER APPLICATIONS I
OAG 170
The purpose of this course is to build computer skills designed for the office professional. In this introductory level, students will be introduced to basic computer terminology, Windows operations including use of Microsoft Explorer, as well as basic functionality in WORD and POWERPOINT applications. Emphasis is on practice to achieve mastery level in each competency taught within the course. In-class Simulation Labs are mandatory and form a major component of the course syllabus. A major focus in the labs will be to identify how these applications can be used within the professional office setting to maximize efficiency in documentation creation and management. Students will also be introduced to various methods for effective proof-reading and the integration of WORD and POWERPOINT for use within a modern automated environment. 3 units of credit. Text extra.
FALL
Windsor 050 5508 Sept 20-Dec 6, Wed, 6:00P-9:30P $277.20
Windsor 070 5507 Sept 23-Oct 28, Sat, 9:00A-4:30P $277.20
Chatham 550 5506 Sept 19-Dec 5, Tue, 6:00P-9:30P $277.20
WINTER
Windsor 050 1238 Jan 16-Apr 3, Tue, 6:00P-9:30P $277.20
Windsor 070 1239 Jan 20-Feb 24, Sat, 9:00A-4:30P $277.20
PROFESSIONAL COMPUTER APPLICATIONS II
OAG 270
The purpose of this course is to build on the professional office skills introduced in Professional Computer Applications I. Students will focus on building basic competency in the professional use of Microsoft EXCEL and Microsoft ACCESS to create a variety of business documents. Emphasis is on practice to achieve mastery level in each competency taught within the course. In-class Simulation Labs are mandatory and form a major component of the course syllabus. A major focus in the labs will be to identify how these applications can be used within the professional office setting to maximize efficiency in documentation creation and management. Students will also be introduced to the concept of selecting the appropriate tool for a specific office task. Pre-requisite: A good working knowledge of computers. 3 units of credit. Text extra.
FALL
Windsor 050 5511 Sept 19-Dec 5, Tue, 6:00P-9:30P $277.20
Windsor 070 5512 Nov 4-Dec 9, Sat, 9:00A-4:30P $277.20
WINTER
Windsor 050 1244 Jan-Apr 3, Tue, 6:00P-9:30P $277.20
Windsor 070 1246 Mar 3-Apr 14 Sat, 9:00A-4:30P $277.20
Chatham 550 1245 Jan 16-Apr 3, Tue, 6:00P-9:30P $277.20

Office Medical Courses

OFFICE ADMINISTRATION ASSISTANT - MEDICAL CERTIFICATE 8 courses required OAH 300 Medical Typing and Theory Techniques
OAH 301 Electronic Medical Records, Billing and Administrative Documents
OAH 302 Health Services Office Management
OAH 303 Medical Terminology I
OAH 304 Medical Transcription I
OAH 400 Pharmacology & Safety Systems in Health Service Offices
OAH 401 Medical Terminology II
OAH 402 Medical Transcription II
OFFICE ADMINISTRATION – HEALTH SERVICES DIPLOMA Requirements: OFFICE ADMINISTRATION GENERAL CERTIFICATE
  OFFICE ADMINISTRATION ASSISTANT - MEDICAL CERTIFICATE

Plus the following courses:

OAH 305 Social Relations, Ethics and Legislation in the Health Service Office
OAH 403 Internship*
Elective (2) Two elective courses ending in the letter G from the Humanities/Social Sciences section. Example: SSC 110G
NOTE: *All OAH 3xx courses must be completed before doing the internship.
  Please call 972-2727 ext. 4048 by Oct 30, 2017 to set up the Internship.
MEDICAL TERMINOLOGY I
OAH 303
This course is designed for the applied health professional, and is one of 2 parts. It begins with medical word parts - prefixes, suffixes, root words, and combining forms. The structure and function of each of the body systems will be studied along with its associated terminology, pathological conditions, clinical tests, surgical procedures, laboratory procedures, and abbreviations. Emphasis will be placed on correct spelling and the ability to decide if a word makes sense in context. 3 units of credit. (Online $318.22 includes $49.00 access fee) Text extra.
FALL
Windsor 050 5613 Sep 20-Dec 6, Wed, 6:00P-9:30P $277.20
Online 065 5614 Sep 18-Dec 9 $326.20 (includes $49.00 access fee)
WINTER
Online 065 1058 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
MEDICAL TERMINOLOGY II
OAH 401
This advanced course is a continuation of Medical Terminology I, whereby the student currently comprehends the structure and breakdown of the terminology, enabling the student to concentrate solely on the function of additional body systems being studied along with its associated terminology, pathological conditions, clinical tests, surgical procedures, laboratory procedures, and abbreviations. Emphasis will be placed on correct spelling and the ability to decide if a word makes sense in context. Pre-requisite: OAM 312/OAH 303. 3 units of credit. Text extra.
FALL
Online 065 5616 Sep 18-Dec 9 $326.20 (includes $49.00 access fee)
WINTER
Online 065 1060 Jan 15-Apr 7
MEDICAL TRANSCRIPTION I
OAH 304
A beginning course in medical machine transcription in which students are introduced to typical medical reports which will correlate as much as possible with the topics being covered in the Medical Terminology course. Emphasis will be placed on spelling and the application of transcription techniques learned in the Medical Typing and Theory Techniques course. Students will be exposed to a variety of accents in the dictation. Pre-Requisite: OAM 300 or OAM 412 and a minimum typing speed of 30 wpm. 3 units of credit. Text extra.
FALL
Windsor 050 5615 Sep 21-Dec 7, Thu, 6:00P-9:30P $277.20
MEDICAL TYPING & THEORY TECHNIQUES
OAH 300
This course introduces students to medical keyboarding speed development and review typing theory with applications in medical letters, tables, manuscripts from print and handwritten copy. The student will be introduced to medical keyboarding techniques in the following areas: punctuation, capitalization, number usage, metrics, medical symbols, abbreviations and word endings. Instruction and practice will be given in the proper keyboarding formats for charts, consults, reports, operations, medical forms and prescriptions, agendas, meeting minutes, as well as resume and job search skills development. 4 units of credit. Text extra.
FALL
Windsor 050 5612 Sep 18-Nov 27, Mon, Wed, 6:00P-9:00P $396.00
PHARMACOLOGY & SAFETY SYSTEMS IN HEALTH SERVICE OFFICES
OAH 400
This is an introductory course in Pharmacology. The student will learn commonly used medications and their actions and basic side effects. 2 units of credit. Text extra.
WINTER
Online 065 1059 Jan 15-Apr 7 $326.20 (includes $49.00 access fee)
learn something new this fall!

Register early to make sure you get into the course you want!

Start and end dates are indicated beneath each course description.

Questions? Call:
519-972-2711 (Windsor) or 519-354-9100 (Chatham) or
1-800-387-0524 (toll-free) or send an E-mail to: coned@stclaircollege.ca.

Registration Info:

Campus Locations:

Windsor

South Campus 2000 Talbot Rd. W. Windsor

Chatham

Chatham Campus 1001 Grand Ave. W. Chatham

Leamington

South Essex Community Council 215 Talbot St. E. Leamington

Online

Online Delivery

Distance

Distance Learning by paper-based correspondence

Like us on Facebook