CES4A / Career and Employment Strategies
In this course students will learn how to use source and apply for a job. Facilitators will be available to provide guidance with respect to interviewing skills, resume writing and the effective use of social media to promote oneself.
MSA4A / Microsoft Access
This course introduces the students to relational databases with Microsoft Access. The course starts with an overview of Microsoft Access and databases in general. Students will learn the fundamental features of relational database and how databases are used to store related information and query the information. After learning how to create and modify a database and work with records, students will learn to sort data and filter to a database. Students will then explore the different ways to query a database and extract the information based on different criteria. Subsequent to working with multi-table databases, students will then learn to work with different types of functions to manipulate data, forms to input data into a database and reports to display data.
MSE4A / Microsoft Excel
Relying heavily on a hands-on practical training approach, students learn by doing skills based simulations, training and assessments in Microsoft Excel. The course starts with an overview of spreadsheets and how to use the common features and functions of Microsoft Excel. The course then focuses on the core features of Microsoft Excel where students learn how to enter and format data and use the various functions and formulas to manage and manipulate data. The course continues with more advanced topics such as performing quantitative analysis with logical, lookup and various mathematical and financial functions. Depicting data visually is an important feature of Excel. Students will learn how to work with charts in Excel to produce a variety of different charts based on data housed in a spreadsheet. Finally students will learn to handle large volumes of data with datasets and tables.
MSW4A / Microsoft Word
This course introduces the students to word processing with Microsoft Word. Relying heavily on a hands-on practical training approach, students learn by doing skills based simulations, training and assessments. Learners will focus on the core features of Microsoft Word such as proper document formatting, organization and editing using the tools and features of the ribbon. The course will then continue with more advanced topics such as working with tables, lists, objects, templates footnotes and endnotes and mail merges. Students will explore the collaboration features that allow users to share and collaborate on documents through the use of track changes, sharing and reviewing.
B1068O / Computerized Accounting III with QuickBooks
In this module, students continue to build their knowledge and skills in computerized accounting systems, learning QuickBooks, an easy-to-use and powerful system. Students will learn to set up a new QuickBooks company and manage customer accounts. Students also review and consolidate their understanding of Excel and Word by exporting QuickBooks data into these programs. QuickBooks payroll features are also covered.
ITFO / Income Tax Fundamentals
This course is designed to follow the general structure of the Canadian Income Tax Act for individual taxpayers. This introductory course presents in-depth coverage of the information needed to prepare a majority of individual income tax returns for residents of Canada. The course will cover major income categories, applicable tax rules to calculate net income, allowable deductions for tax payers and calculation of tax payable for individuals. The course will also determine who is subject to tax in Canada and the basis on which Canada levies income tax. Advance tax topics are covered briefly in this course to create an awareness of subject matter. Upon successful completion of this course, the student will be able to prepare a basic individual tax return.
CAB4 / Computerized Accounting II
This course is a continuation of Computerized Accounting with Sage 50 Level 1. Students learn how to set up for Payroll and Inventory, record payroll and inventory, set up budgets, and reconcile accounts by working with a variety of business simulations.
AFA4 / Accounting Fundamentals I
This module is intended to provide students with a general background of the fundamentals of accounting as a means to understand the daily transaction procedures that exist in business. Students are introduced to double entry bookkeeping including debits and credits, assets, liabilities, equities, journalizing transactions, posting of accounts to ledgers, and preparing a trial balance. Students are also introduced to financial statements and to adjusting and closing accounts.
AFB4 / Accounting Fundamentals II
Students focus on the following topics: special journal and subsidiary ledger systems, cash control and banking, completing accounting cycle for merchandising company and preparing year-end financial statements. By the end of this course, students will have an in-depth knowledge of the complete accounting cycle including the flow of funds in an organization. (PR: BF1R)
CAA4 / Computerized Accounting I
This course provides a practical instruction to Sage 50 Accounting. Students learn how to set up a computerized accounting environment and record transactions in the General, Payable, and Receivable ledgers by working with a variety of business simulations.
EBW4 / Effective Business Writing
Following the completion of this course, students will be able to: describe business communications in today’s workplace; communicate in teams using listening, nonverbal and meeting skills; plan, write and review various types of business messages; communicate effectively using memos, email, letters and instant messages; create business reports and proposals; plan, write and deliver oral presentations.
PRAC100 / Practicum
This module is for course credits but has no grade. Students will be placed in actual work places related to their field of study and will be expected to act as a regular employee in order to gain the valuable "real world" experience that so many employers seek. Students are encouraged to find their own work experience placement; however, once placed, continuation in that placement is mandatory. (PR: All coursework)
MOT4 / Microsoft Outlook
This course explores information using Microsoft Outlook. It will present the MS Outlook application interface, tools, and features. You will learn about the fundamentals of an email application, scheduling, calendars, contact lists, creating, forwarding and managing messages. This course relies heavily upon hands-on practical activities that allow you to learn the concepts by practicing them on a regular basis.
PRL1 / Payroll Basics
By the end of this course, students will understand the compulsory aspects of payroll and its objectives. They will know the difference between independent/self-employed compared to business employer/employee relationships based on CRA guidelines. Major emphasis will be placed on the mandatory aspects of payroll such as calculating statutory deductions for federal and provincial governments. Students will understand the role of government agencies (CRA, Service Canada, and ESDC) that control payroll rules and regulations governing all stakeholders.
PRL2 / Payroll Processing
By the end of this course, students will be able to interpret their own pay stub. They will be able to accurately calculate normal/regular payroll cycles. They will understand different aspects of income and statutory requirements pertaining to areas such as earnings, benefits, allowances, and expense reimbursements. Students will be able to calculate statutory and non-statutory deductions, and they will be able to accurately process special payments including bonuses, retroactive pay, vacation pay, director fees, and employment termination amounts. Exposure to ROE (Record of Employment) will be provided.
PRL3 / Payroll Remittance and Reporting
Upon completion of this course, students will be able to calculate and know the deadlines and procedures associated with remitting statutory deductions to CRA and RQ (Quebec Provincial Ministry). They will understand the repercussions of not submitting remittances, or of submitting late remittances. Students will learn provincial requirements of payroll tax levies, and they will receive exposure to non-government unions, private pensions, garnishments and WCB calculations) deduction amounts. A detailed exposure will be given to T4/T4A, RL-1, and other annual required reports. At the end of the course, students will understand the accounting aspects of payroll, its remittances, and payroll accruals.
PSK4 / Professional Skills
This course is designed to equip students with the skills necessary for dealing effectively with both customers and colleagues in the business world. Using a variety of instructional methods including role-plays, case studies, group exercises, simulated situations, and discussions, students learn and practice customer service and interpersonal skills necessary for success in today’s business environment.
SSS4 / Student Success Strategies
Emphasis is placed on thinking about achieving success from day one, and developing the non-technical skills to enhance personal, academic, and career success.
HRE4 / Human Resources
Employees are the most valuable asset of a business and all aspects from hiring to performance appraisal are examined utilizing the case study approach.