Computer Applications and Office Administration
Con-Ed Header

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

NOTE: 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. Also, 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. $140.20 (tuition $128.20, materials $12.00)
FALL
WINDSOR 050 5000 Sep 20-Nov 8, Tue, 6:00P-8:30P
CHATHAM 550 5240 Oct 6-Nov 24, Thu, 6:00P-8:30P
LEAMINGTON 077 4997 Sep 21-Nov 9, Wed, 6:30P-9:00P
WINTER
WINDSOR 050 1415 Jan 17-Mar 7, Tue, 6:00P-8:30P
WINDSOR 070 1262 Feb 4-Mar 25, Sat, 9:00A-11:30P
CHATHAM 550 1071 Feb 23-Apr 13, Thu, 6:30P-9:00P
LEAMINGTON 077 1263 Jan 18-Mar 8, Wed, 6:30P-9:00P
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. $269.22 Text extra.
FALL
CHATHAM 550 4575 Sep 19-Dec 12, Mon, 6:00P-9:30P
WINTER
WINDSOR 050 1207 Jan 19-Apr 6, Thu, 6:00P-9:30P
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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
ONLINE 565 4423 Sep 19-Dec 9
WINTER
WINDSOR 050 1148 Jan 19-Apr 6, Thu, 6:00P-9:30P
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 2013 software for online computer courses.) Pre-requisite: MIC 211 or OAG 270. $318.22 ($269.22 + $49.00 access fee) Text extra.
WINTER
ONLINE 565 1199 Jan 16-Apr 7
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. $192.30 Text extra.
FALL
WINDSOR 050 5361 Sep 22-Nov 24, Thu, 6:00P-9:00P
WINTER
CHATHAM 550 1320 Jan 16-Mar 27, Mon, 6:00P-9:00P
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 2013 software for online computer courses.) Pre-requisite: MIC 211 or OAG 270. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
ONLINE 565 4917 Sep 19-Dec 9
WINTER
WINDSOR 050 1018 Jan 18-Apr 5, Wed, 6:00P-9:30P
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. $269.22 Text extra.
FALL
CHATHAM 550 4598 Sep 21-Dec 7, Wed, 6:00P-9:30P
WINTER
WINDSOR 050 1342 Jan 19-Apr 6, Thu, 6:00P-9:30P
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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
WINDSOR 050 5078 Sep 22-Dec 8, Thu, 6:00P-9:30P
WINTER
ONLINE 565 1196 Jan 16-Apr 7

General Interest Computer Courses

BASICS OF THE MAC
GNR 1206N
Participants will be introduced to a variety of applications for the Macintosh computer. These will include File Management, Advanced Finder Techniques, Application Basics, System Preferences, iPhoto and iTunes. Publishing and multimedia presentations will be covered using Pages and Keynote applications. $316.40 (tuition $280.00, HST $36.40)
WINTER
WINDSOR 075 2108 Jan 18-Apr 5, Wed, 6:00P-9:00P
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. $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
FALL
CHATHAM 570 5321 Oct 15, Sat, 9:00A-4:00P
WINTER
CHATHAM 570 2095 Feb 25, Sat, 9:00A-4:00P
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. $98.31 (Tuition $80.00, materials $7.00, HST $11.31)
FALL
CHATHAM 570 4427 Oct 22, Sat, 9:00A-4:00P
WINTER
CHATHAM 570 1605 Mar 4, Sat, 9:00A-4:00P
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. $96.05 (Tuition $80.00, materials $5.00, HST $11.05)
WINTER
CHATHAM 570 1980 Feb 4, Sat, 9:00A-4:00P

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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
WINDSOR 050 4600 Sep 20-Dec 6, Tue, 6:00P-9:30P
WINTER
ONLINE 065 1322 Jan 16-Apr 7
CHATHAM 550 1216 Jan 16-Apr 10, Mon, 6:00P-9:30P
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. $269.22 Text extra.
WINTER
WINDSOR 050 1272 Jan 17-Apr 4, Tue, 6:00P-9:30P
CHATHAM 550 1123 Jan 16-Apr 10, Mon, 6:00P-9:30P
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. $269.22 Text extra.
WINTER
WINDSOR 050 1030 Jan 18-Apr 5, Wed, 6:00P-9:30P
CHATHAM 550 1246 Jan 19-Apr 6, Thu, 6:00P-9:30P
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. $269.22 Text extra.
FALL
WINDSOR 050 1202 Sep 19-Dec 12, Mon, 6:30P-10:00P
CHATHAM 550 4508 Sep 21-Dec 7, Wed, 6:00P-9:30P
WINTER
WINDSOR 050 1271 Jan 18-Apr 5, Wed, 6:30P-10:00P
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) $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
ONLINE 065 5131 Sep 19-Dec 9
WINTER
WINDSOR 050 1170 Jan 19-Apr 6, Thu, 6:00P-9:30P
CHATHAM 550 1214 Jan 18-Apr 5, Wed, 6:00P-9:30P
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. $269.22 Text extra.
FALL
WINDSOR 050 4446 Sep 19-Dec 12, Mon, 6:00P-9:30P
CHATHAM 550 4696 Sep 19-Dec 12, Mon, 6:00P-9:30P
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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
WINDSOR 050 XXXX Sep -Dec , Mon, 6:30P-10:00P
WINTER
ONLINE 065 1347 Jan 16-Apr 7
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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
WINDSOR 050 4591 Oct 12-TBD, Wed, 6:00P-9:30P
CHATHAM 550 4811 Sep 21-Dec 7, Wed, 6:00P-9:30P
WINTER
ONLINE 065 1271 Jan 16-Apr 7
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 Outlook, 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. Integration of Word and PowerPoint for use within a modern automated environment is also introduced. 3 units of credit. $269.22 Text extra.
FALL
WINDSOR 050 5283 Sep 21-Dec 7, Wed, 6:00P-9:30P
WINDSOR 070 5128 Sep 24-Oct 29, Sat, 9:00A-4:30P
CHATHAM 550 4629 Sep 20-Dec 6, Tue, 6:00P-9:30P
WINTER
WINDSOR 050 1335 Jan 17-Apr 4, Tue, 6:00P-9:30P
WINDSOR 070 1092 Jan 21-Feb 25, Sat, 9:00A-4:30P
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. $269.22 Text extra.
FALL
WINDSOR 050 4991 Sep 20-Dec 6, Tue, 6:00P-9:30P
WINDSOR 070 4593 Nov 5-Dec 10, Sat, 9:00A-4:30P
WINTER
WINDSOR 050 1399 Jan 16-Apr 10, Mon, 6:00P-9:30P
WINDSOR 070 1031 Mar 4-Apr 8, Sat, 9:00A-4:30P
CHATHAM 550 1297 Jan 17-Apr 4, Tue, 6:00P-9:30P

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, 2016 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. $269.22 (Online $318.22 includes $49.00 access fee) Text extra.
FALL
WINDSOR 050 5011 Sep 21-Dec 7, Wed, 6:00P-9:30P
ONLINE 565 4932 Sep 19-Dec 9
WINTER
ONLINE 565 1281 Jan 16-Apr 7
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. $269.22 (Online $318.22 includes $49.00 access fee)
FALL
ONLINE 565 4414 Sep 19-Dec 9
WINTER
WINDSOR 050 1345 Jan 18-Apr 5, Wed, 6:00P-9:30P
ONLINE 565 1187 Jan 16-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 I 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. $269.22 Text extra.
FALL
WINDSOR 050 4657 Sep 22-Dec 8, Thu, 6:00P-9:30P
MEDICAL TRANSCRIPTION II
OAH 402
An advanced course in medical transcription. Students will be expected to transcribe error-free copies of letters, reports, consults, operations, histories, examinations, etc., in correct formats. A variety of accents will be used in dictation. Pre-Requisite: OAM 335 or OAM 226. 4 units of credit. $384.60 Text extra.
WINTER
WINDSOR 050 1191 Jan 16-Mar 27, Mon, Wed, 6:00P-9:00P
MEDICAL TYPING & THEORY TECHNIQUES
OAH 300
Medical keyboarding speed development; typing theory review 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. Pre-Requisite: OAM 312 and a minimum typing speed of 30 wpm. 4 units of credit. $384.60 Text extra.
FALL
WINDSOR 050 5375 Sep 19-Nov 28, Mon, Wed, 6:00P-9:00P
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. $192.30 (Online: $241.30 includes $49.00 access fee) Text extra.
WINTER
ONLINE 565 1309 Jan 16-Apr 7
learn something new this winter!

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