Program Description

The six-month Office Administration & Employment Training Certificate Program provides students with an essential computer, communication, administrative, and job search skills.  In addition to acquiring technical skills in computer applications, students will learn the roles and responsibilities of the office professional.  Students will learn to compose and format business documents; become the office “go-to person” for communication and information management:  to manage time, tasks, emails, databases and filing systems.  Students also network as a class with many employers, practice interview and speaking skills, work as office employees in a four-week practicum. 

Students will be proficient in the following aspects of office administration: 

  • Microsoft Office Business Suite:  Word, Excel, Access, PowerPoint, Outlook, and OneNote
  • Composing and formatting business documents, spreadsheets, and charts
  • Managing and maintaining data and information; handling relational databases
  • Researching, designing and delivering presentations
  • Computer maintenance and troubleshooting problems
  • Setting up electronic and visible filing systems
  • Maintaining to do lists and schedules and clearly relaying and tracking information
  • Organizing meetings and producing the meeting notice, agenda, meeting log, and minutes
  • Working as a cooperative team member and developing interpersonal / professional/ conflict resolution/ emotional intelligence/ self management and control techniques.
  • Developing an assertive voice through voicing thoughts and opinions, leading groups and delivering presentations in a cooperative comfortable setting. 


Please review the https://moodle.necvancouver.org/pluginfile.php/594/coursecat/description/OAET%20Monthly%20Calendar%202022-2023%20FINAL.pdf?time=1665523486423


This course addresses the role and responsibilities of the Administrative Assistant, and helps students to develop their organizational and professional skills. Projects include setting up and

managing filing, mailing and purchasing systems; handling meetings; managing switchboard reception and business equipment; and using the Internet for ordering, making traveling arrangements, and planning conferences.

The focus of this course is to develop job search strategies for finding suitable practicum placements and for finding and keeping employment. It will help you plan your professional deportment for practicum, and develop the professional attitude needed to keep employment. Areas to be covered in the course include self-assessments, goal setting, planning, organizing, career/job research, ethics and confidentiality issues, resume and cover letter production, application forms, and the interview process.

This course reinforces basic typing skills through beginning with the basic keyboard drills to revising and formatting documents, and interpreting proofreader's marks. Daily exercises for accuracy and timings for speed are provided to assist students to develop their skills to a required speed of 45 WPM. Emphasis will be placed on producing accurate and correctly formatted documents, business letters, memos, envelopes and minutes.

This course introduces students to the basics of character and paragraph formatting in Microsoft Word, and advances to the creating of newsletters, forms, flyers, tables, business cards and more.  Practice in all standard business documents ensures the ability to produce error free and correctly formatted letters, memos templates and reports.  Students will master Word efficiency tools such as shortcuts, macros, auto text, auto correct, thesaurus, templates, search and replace, and mail merge.


Students will develop in-depth knowledge of Windows Operating System, Microsoft Outlook, OneNote, and PowerPoint.  

In Windows, students will set-up and maintain an electronic filing system, change computer settings and learn computer maintenance techniques.

In Outlook, students will learn to organize email messages; schedule meetings and appointment; maintain contact information and distribution lists; handle tasks and import and export information to and from Outlook.   

In OneNote, students will create notes that can include text, tables, pictures, and drawings in binder like files, organizing the notes in separate tabs and managing the information as needed according to the project they are working on. 

Students will prepare effective PowerPoint presentations and use computer graphics in posters and marketing materials.

The course reviews whole numbers, decimals, fractions, and percent calculations and their application in payroll, interest, trade and cash discounts, markup and markdown, and interest calculations. Students learn to design professional-looking spreadsheets and charts. They will use advanced formulas, functions, data filtering, 3D linking and pivot tables to produce a variety of worksheets, such as budgets, financial statements, payroll, amortization schedules, and invoices.

In this course, daily practice in free writing and composition is combined with exercises in grammar in order to develop clear and concise written and oral messages. This will be necessary for achieving success in the workplace. Emphasis will be placed on proofreading and editing for clarity, sentence structure, effective language, unified paragraphs, and correct business formatting.


This course focuses on understanding and developing interpersonal communication skills from a holistic perspective. It is designed to broaden students’ repertoire of effective communication behaviours and strengthen their skill at performing them. The fundamental skills taught in this program are designed to foster competence in: Self-Awareness – knowing one’s inner state, preferences, resources, and intuitions; Self-Regulation - managing one’s inner state, impulses, stressors, and resources, Personal and Emotional Accountability - utilizing appropriate emotional motivation and tendencies to guide or facilitate goals, Empathy - awareness of others’ feelings, needs, and concerns, and Social Skills adeptness at being able to interact respectfully and reciprocally with others to achieve mutual goals.  

 

Some specific skills include: listening and reflecting skills; building rapport and interpersonal trust; expressing feelings congruently at both the verbal and non-verbal levels; understanding the communication needs and expectations in both personal and professional contexts, and appropriately responding to miscommunication and interpersonal conflict situations. These practical skills will be acquired experientially through participation in group exercises and follow-up discussion, and will be supported by readings and suggestions in the text and additional activities. It is essential that students make these skills their own through practice. 

The course begins with an introduction to electronic databases, understanding data structure, database concepts and terminology.   Students learn to create database objects: tables, forms, queries and reports.  They will use data management tools: searching, filtering, sorting, masking and validating.  They will also work with multiple tables and handle relational databases. Additionally, students will customize different business report.