Office Administration

This course teaches students the fundamentals of the Microsoft Access application. In this course, students examine database objects and learn to manage data in a database. They learn to sort and filter data, display and format data, and use simple queries to retrieve data. Students learn to create and modify databases and tables and work with simple forms and reports.

This course teaches students advanced-level concepts and features of the Microsoft Access application. In this course, students work with advanced and complex queries, forms, and reports. Students learn to create PivotCharts and PivotTables, import and export data, use macros, and maintain, optimize, and document a database.

In this course, students learn to create and manage worksheets and workbook files; enter data and create basic formulas to perform calculations. They learn to edit and manipulate cell content, modify worksheet structure, view and format worksheets, and use Excel’s predefined functions. Students use the Find and Replace feature, use themes to format workbooks and practice preparing, previewing, and printing worksheets.

This course teaches students intermediate to advanced-level concepts and features of the Microsoft Excel application. They learn to use named references, validate and consolidate data, use links and hyperlinks, and reference external data. Students learn to use cell comments, custom and conditional formatting, styles, and templates. They also practice working with graphics, charts, diagrams, and databases (lists).

In this course, students will build upon the skills learned in the Microsoft Excel Level 1 and Level 2 courses and will cover more advanced level concepts and features of Microsoft Excel. They will learn to increase productivity and enhancements of spreadsheets using some of Excel’s more advanced level features. Students will be given ample opportunity to explore and practice these techniques throughout the course.

In this course, students will learn how to use both the e-mail program and the personal information manager components of Microsoft Outlook. The skills learned in this course will help students use Microsoft Outlook effectively both at work and in your personal life.

In this course, students learn to customize Outlook, personalize and secure email messages, and organize and manage email effectively. Students learn to search, sort, filter and categorize e-mail messages. They learn to archive messages, and retrieve archived messages, create and manage rules, and customize message alerts. They also learn how to utilize Outlook to collaborate and share information with others.

This course teaches students the fundamentals of this application and its usage within the Windows environment. Students learn to create, modify, and deliver electronic presentations. They learn to create slides containing text, tables, charts, diagrams, and graphics. Students practice customizing slides and finalizing presentations, and then learn to print and deliver slide shows.

In this course, students learn to customize PowerPoint and create professional presentations by building upon the basic skills learned in the PowerPoint Level 1 course. They learn to work with slide masters, design templates, and incorporate multimedia effects such as animation, sound, and motion clips into their presentations. Students also learn to apply good design principles, use colour effectively, use features that enhance collaboration with others, and deliver online (Web) presentations.

This course teaches students how to use Publisher to create a variety of publications quickly and easily using Publishers Design Templates. Students learn to modify the design, colour and font schemes, page layout, and background of a publication. Students also learn to create master pages, add and format text, WordArt, and graphics, insert hyperlinks, hotspots, and forms, as well as, manage their publications, email publications, and create and manage web sites.

In this course, students learn to create, navigate, and organize documents and use the help functions. They learn to edit and manipulate text, view and format documents, and use Word’s predefined functions. Students use the Find and Replace feature, use proofing and language tools, create, format and modify tables, work with hyperlinks and cross-references, and learn how to preview and print a document.

In this course, students learn to customize Word and build upon the basic skills learned in the Word – Level 1 course. They learn how to increase their productivity and enhance their documents using some of Microsoft Word’s intermediate to advanced level features. They will be given ample opportunity to explore and practice these techniques throughout the course.

In this course, students learn to use mail merge and work with fields, macros, large documents, and forms. They learn to merge form letters, emails, envelopes, and labels using a data source. Students work with fields and macros, and learn to use features that facilitate working with large documents, including generating an index, table of contents, and tables of figures and authorities. They also learn to create forms using form fields such as drop-down lists and checkboxes.

This course provides students with an understanding of the double-entry system of bookkeeping and provides the essential accounting tools for the workplace. The course is especially beneficial for students planning to take a computer accounting program or use computer accounting in the workplace. Basic Bookkeeping Level 1 explains the principles of handling a company’s books of accounts, including Accounts Payable, Accounts Receivable, and Payroll.

This course will assist students in learning the fundamentals of effective business planning. It teaches students the concepts they need to understand in order to properly assess a new business idea and make it yield results. Several skill-building exercises help to put the theory into practice. Topics covered include organizing a business plan, choosing a business name, developing a mission statement and executive summary, analyzing the environmental factors that can affect a business, marketing the business, and managing people and the competition.

This course places emphasis on the acquisition of skills and style mechanics needed to produce personal and office correspondence. The parts of a business letter are examined in detail, as are the guidelines for organizing and writing a letter. Students will learn how to write neutral and inquiry letters, as well as positive and negative letters. Proper punctuation and word usage skills are also addressed. The latter part of the course deals with creating envelopes and labels using Microsoft Word, as well as writing and managing e-mail using Microsoft Outlook. Writing and creating memos, fax cover sheets, and forms using Microsoft Word templates are also covered.

This course is designed specifically for the correspondence required in a corporate environment. Students will learn how to create form letters using Microsoft Word’s Mail Merge Wizard, how to prepare, organize and write a report using various report styles and supplementary parts, how to prepare proposals and quotations using boilerplates, how to plan meetings and prepare agendas for various types of meetings, and how to take and prepare minutes at a meeting.

This course will assist students in learning and practicing important office procedures, such as basic banking, records management, postal and courier services, telephone and fax services, dealing with the public, and using the Internet to research information.

This course covers a variety of topics as it simulates an office environment and challenges students with tasks that they would typically perform. Students develop an understanding of the various levels of management and associated responsibilities. They also learn about the various forms used in an office and how to complete these forms. A section on organizing a workspace, planning work activities, and using a scheduling system to plan events is included. Students also learn about reprographics, preparing for a meeting, procedures to follow in a meeting, and requirements when making travel arrangements.

Management Fundamentals is an introductory management course that provides students with the essential tools required of today’s effective supervisors or junior managers. The course combines theoretical, how-to information, with practical applications. The course provides students with a balance of soft and hard skills. The soft skills students will develop and apply to realistic case studies include communication, problem-solving, decision-making, negotiating, planning and organizing, time management, facilitating, and coordinating. The hard skills include setting goals and objectives; preparing forecasts and budgets; using planning and organizing tools; maintaining records; drafting training and development plans, procedural checklists, and reward initiatives; and developing strategies.

This course will assist students in learning the fundamentals of punctuation and writing. Students will learn punctuation rules, commonly misspelled and confusing words, English grammar, and elements of effective writing style.

This course explores the various components of the Internet using Microsoft Internet Explorer. Students are oriented to common procedures used to maximize the successful use of the Internet and all its features. They learn how to customize the Internet Explorer browser, and examine the Web, e-mail, blogs, discussion groups, social media, chatting, multimedia and other web technologies.

In this course, students learn about the components and basic operation of the personal computer. The content in this course is both conceptual and practical and is intended to provide students with a working knowledge of computing. Students explore hardware troubleshooting, file management, multimedia options, and browsing the Internet.

The course will walk you through performing basic operations such as opening applications, using Help and shutting down the computer. Additionally, you will learn to set up user accounts, create and use custom keyboard shortcuts, personalize and organize the working space, and use the Action Centre. The course will also provide you with hands-on experience on how to connect, use and update devices, use File Explorer to manage files and folders, as well as navigate the internet using various browsers, including Internet Explorer and Microsoft Edge.

This course provides an advanced look at the Windows 10 operating system, which is a platform that builds on previous versions of Windows. In this latest version of Windows, earlier features and functionalities have been improved and new and exciting tools have been incorporated. In this course, students will learn about managing, maintaining, troubleshooting, and optimizing the Microsoft Windows 10 operating system.

This course is designed for individuals who have no formal training in keyboarding. The objective is to teach students the skill of keyboarding – essential to the learning of other computer applications and workplace skills. The course begins with an overview of the basics of computer use. Students learn about the components of the computer and keyboard, as well as the seating, posture, and hand positioning necessary for efficient keyboarding.

This course is designed for individuals who have basic keyboard proficiency, and wish to increase speed and dexterity. Each lesson increases key recognition and builds confidence using the keyboard while improving speed and accuracy. Typing Trainer helps students learn and improve skills using a variety of methods: graphical keyboard drills, speed drills, alphabet drills, word, phrase and sentence drills, and keyboarding Self-Tests. Upon completion of this course, students are expected to keyboard at a minimum of 25 words per minute.

This course is designed for individuals proficient in keyboarding who wish to increase speed and dexterity. Students are introduced to Special Keys on the keyboard. Each lesson increases key recognition and builds confidence using the keyboard while increasing speed and accuracy. Speed achieved depends on personal dexterity and time spent on practice lessons.

During the course, students will develop and apply such skills as setting goals, developing job search strategies, using planning and organizing tools, maintaining records, communicating, decision making; and negotiating. This course follows a job search process in which, among many other things, the student is provided with the opportunity to create effective résumés and covering letters using traditional and innovative methods, including social networking, and uploading electronic résumés.

The course is designed to improve the student’s learning experience and prepare him or her for personal and professional growth and success. The focus is on increasing the student’s self-discipline and self-esteem. The positive concepts taught in this course are intended to unleash the student’s potential for growth and creativity, resulting in personal and professional development. Humour and practical examples are used to target the primary concerns of adult students. In addition, written exercises, activities, and audiotapes provide understanding, acceptance, and reinforcement of the program material.