Business
Accounting and Payroll Administrator
Thoroughly covers accounting and payroll principles, and includes a 10 week placement.
Type
Diploma
Duration
Remote: 37 Weeks
On-Campus: 61 Weeks
Self-Study: 29 Weeks
Internship
Remote: 8 Weeks
On-Campus: 12 Weeks
Self-Study: NA
About The Program
The Accounting and Payroll Administrator diploma program offers a 10-week field placement to gain hands-on experience in the field. Graduates will also be eligible for the Payroll Certified Practitioner designation.
Career Opportunities
As an Accounting and Payroll Administrator, you will qualify for positions such as: Accounts Clerk, Payroll Administrator, and Pay & Benefits Administrator.
Employers Who Have Hired Eastern Grads
- ADP Canada
- Research Productivity Council
- Wood Motors Ford
- RBC
- Social Development
- ABC Tax and Accounting
Salary
89
%
Employment Rate*
$
20
Average Wage/hr**
$
28
High Wage/hr**
*Employment Rate based on 2018 contactable Eastern graduates employed in a related field.
Source: workingincanada.gc.ca
NOC Code: 1311, 1431, 1432 - **Wage data based on NOC Code 1432 and rounded down to the nearest dollar based on Nova Scotia data. Average wage doesn't reflect the starting salary but represents the middle value between lowest to highest wages. Local (or regional) income may vary. Last updated in July 2021.
Program Details
Are you interested in learning the core principles of accounting and becoming an administrator in the field? If so, the Accounting and Payroll Administrator diploma program is just what you need to kick start your new career.
In this 60-week program, you will learn everything from accounts payable and accounts receivable to cash flows and balance sheets. You will take courses in finance, business, and bookkeeping to help set you up for a successful career in this industry. These skills are vital to fulfill the need of hundreds of organizations around the globe and a diploma in the right course will help you fill that demand.
Successful graduates of this program who earn the appropriate passing grades for the Canadian Payroll Association (CPA) courses, namely Payroll Compliance Legislation, Payroll Fundamentals I and Payroll Fundamentals II (a minimum of 65% overall in each course, and earn at least 65% on each of the final exams), will be eligible to pursue CPA’s Payroll Compliance Practitioner (PCP) certification. The PCP designation is nationally recognized as the standard of excellence for payroll training.
To be fully certified, PCP candidates must satisfy the following criteria:
- Obtain the Introduction to Accounting transfer of credit;
- Maintain CPA membership either through an individual membership (a 1-year individual Associate Membership is included in this Eastern program), or through a company that has a Business membership;
- Complete the CPA’s Work Experience Requirement Application (WERA) process, to demonstrate 1 year of experience (within 5 years after the start of the Payroll Compliance Legislation course) in which your job role involves paying employees accurately and on time, in compliance with legislative requirements, contributing to the full annual payroll cycle.
- Complete the online Certification Declaration.
Course Listings: New Brunswick 
Bookkeeping Level I and II
This course will introduce the analysis and recording of business transactions using the rules of double-entry accounting. Adjusting journal entries are recorded and basic financial statements are prepared. Preparation and posting of journal entries for a business are examined, coupled with preparation of cost of goods sold, cash and trade discounts, closing entries, and the use of special journals and subsidiary ledgers. Students will learn fundamental accounting principles, understand the classification of assets, liabilities, equities, utilize the double-entry system and a general ledger chart of accounts, post entries to those accounts, and prepare trial balances along with the appropriate financial statements. The complete accounting cycle is examined through closing entries, worksheets, and the post-closing trial balance.
Business English
In this course, you will develop professional communication skills in a business setting using MS Office including Word and Outlook. You will apply proper grammar to create and review appropriate business documents such as emails, memos, letters, reports, text messages, and social media posts for company websites, LinkedIn, Twitter, and Facebook. You will practice grammar, spelling, and error correction while developing clear and concise writing skills. You will rewrite and edit professional documents while demonstrating spelling accuracy, proper capitalization, and punctuation. You will recognize and correct commonly misspelled words. Furthermore, you will explore sentence elements such as modifiers, connectors, and sequencers to write brief and jargon-free business messages. You will distinguish active and passive voice to write effective sentences. You will also review and incorporate inclusive language to avoid biases and discrimination. Using a range of grammatical structures, you will adopt and follow modern business communication standards.
Business Math
This course reviews and introduces basic and intermediate math concepts including the relationships between the following operations: addition and subtraction, multiplication and division, and decimals, percentages, and fractions. You will complete a variety of textbook readings, LinkedIn Learning and Khan Academy videos, worksheets, word problems, as well as two in-class assignments and two tests to ensure you are able to apply these math concepts to complete a variety of common business math operations. The first week focuses on a brief review of basic operations, fractions, and decimals while learning to decipher and complete word problems. The second week then looks at percentages, ratios, equations, and graphs to provide a robust review of key operations, word problems, and common business math requirements. This includes calculating costs, interest, budgets, and measurements, with a focus on transportation, nutrition, and costing. Throughout the course, you will complete work with and without a calculator to ensure you have mastered concepts and can complete operations efficiently and accurately in a work environment.
Career Planning & Preparation - Level I
This module will introduce you to and provide practice in using the tools required for a successful job search. The concepts covered in this module will help you maintain a career-focused approach throughout your studies so that you are better prepared to conduct a job search after graduating. Specifically, you will learn how to identify your soft and hard skills and how to articulate your abilities in a clear and concise Elevator Pitch that will appeal to employers and resonate with industry contacts. You will learn about the job search resources available to you including using career websites, creating Linked In profiles, accessing the “hidden” job market, and networking. You will examine sample resumes and cover letters and begin the process of creating your own professional resumes and cover letters that align with current conventions for content, organization, and formatting. You will also learn about the role of references, thank you letters, workplace philosophies, and strategies for success including maintaining a professional image and using proper etiquette when communicating with potential employers and industry contacts.
An introduction to Occupational Health and Safety is also provided with specific focus on employees’ rights and responsibilities, workplace health and safety policy and programs, hazard identification and control, and safety training options such as WHIMIS and First Aid.
Career Planning & Preparation - Level II
This module builds on concepts and skills introduced in the Career Planning and Preparation Level 1 prerequisite module. In this subsequent module, you will update and refine your resume and Linked In Profile. You will continue writing cover letters and learn the value of customizing cover letters to specific job postings. You will have the opportunity to apply this knowledge as you conduct a job search and write a cover letter tailored to an ideal job post. Through research, you will create a list of top employers and target current industry opportunities. You will learn about current methods for applying to job postings using technology. You will also gain an understanding of the job interview process, typical interview questions and possible responses, and expectations of both the interviewer and interviewee. In addition, you will engage in practical application of the interview process through role-plays. Topics such as negotiating salary, self-management, and on-the-job success for placements and post-graduate employment will be also covered.
Digital Literacy for Professionals
This course has four units that introduces you to the fundamental concepts and principles of learning and working in a digital environment. The first unit introduces you to using devices and handling information with topics on operating systems (Windows, MAC, and Linux), computer organization (folder management and naming conventions), cloud storage (including Microsoft OneDrive), types of web browsers including Google Chrome, Mozilla Firefox, and Apple Safari), and fundamental troubleshooting. In the second unit, you will become familiar with creating and editing information through learning about file formats (pdf, mp4, docx), productivity (including iWork and Microsoft Office Suite) and creativity (Adobe, Canva, iMovie) platforms, and basic introduction to Microsoft Word, Excel, and PowerPoint. The third unit on communicating and collaborating will introduce you to web conferencing applications (Slack, Zoom, Microsoft Teams), mail applications (including Microsoft Outlook and Gmail,), project management tools (Trello, Asana), and time management tools (including Todoist, Outlook Calendar, and iCal), and building rapport virtually. In the final unit, you will gain an understanding on netiquette, cybersecurity, and digital wellness. After completing this course, you will have enhanced digital literacy skills as a professional in the working and learning environment.
Finance
This course will introduce students to financial decision making for students with no previous exposure to finance principles. Topics covered will enable students to master the language and concepts to succeed in an accounting or business environment with an emphasis on budgeting and obtaining business financing.
Field Placement - Accounting and Payroll Administrator
On successful completion of the classroom hours of this program, students will be placed on field placement at an outside organization. Students will have the opportunity to apply their newly developed knowledge and skills in a real-world environment.
Image Development
This module teaches the student how to develop and manage a professional image. Topics include: appearance-visual and verbal, interpersonal interaction, business etiquette, and networking skills. At the end of the module, students will have an appreciation and understanding of the importance of a professional image in the business environment.
Intermediate & Management Accounting
This course focuses on internal business processes and examines the different methods of depreciation, accounting for fixed asset disposal, revision of depreciation, management responsibility, and cost accounting. Topics covered include bank reconciliations, cash flow and control, long term notes, monitoring of accounts receivable, accounting for cost of goods sold, financial analysis, and techniques for inventory control.
Internal Control
In this course, students will consolidate and enhance their previous accounting training and apply it to real-world scenarios. The students will review and further develop understanding in GAAP and GAAS. Students will gain a better understanding of auditing, audit preparation, and the concept of audit trails. This will be accomplished through the detailed creation and filing of source documents. Students will complete source documents, input data, create financial statements, and electronically file all materials in the cloud environment using a state-of-the-art cloud-based training package.
Payroll Compliance Legislation
Students who complete this module will understand compliance responsibilities that affect organizations, be able to comprehend legislation, and be able to effectively communicate these to all stakeholders. This course will provide students with the payroll-related legislation affecting organizations, as well as the tools to find information and apply that information to different scenarios in relation to individual pay. Specific skills include: describing payroll’s objectives and stakeholders; identifying an employee relationship; applying federal and provincial legislation to payroll including: Canada Pension Plan, Employment Insurance, Income Tax, Employment Standards Legislation, Workers’ Compensation Acts, and Quebec-specific legislation; and communicating payroll compliance requirements to various stakeholders.
Payroll Fundamentals I
Students who complete this module will be able to apply payroll legislation and calculate individual pay. This includes all components of individual pay from remuneration, through deductions, to net pay for both regular and non-regular situations. Students will have the content and skills to effectively communicate all aspects of the individual pay calculation process to external and internal stakeholders. Specific skills include: calculating regular individual net pay including allowances, expenses and benefits; calculating non-regular individual net pay including bonus and vacation payments; calculating termination payments; calculating commission payments; completing a Record of Employment; and communicating all aspects of individual pay requirements to various stakeholders.
Payroll Fundamentals II
Students who complete this module will be able to calculate and report government and third party remittances, year end requirements and accounting for payroll at the compliance level for the organization. Students will be able to effectively communicate these organizational processes and requirements to internal and external stakeholders. Specific skills include: calculating organizational remittances to federal, provincial and third party stakeholders; preparing and accounting documentation for payroll; completing federal year end documentation; completing year end documentation for the province of Quebec; and communicating all aspects of organizational remittance, accounting and year end requirements to various stakeholders.
QuickBooks
This course will introduce the accounting cycle in QuickBooks and further the student’s knowledge of accounting procedures in payroll, collections, payables, cash management, and bank reconciliations. Topics covered include inventory management and adjustment procedures with an overall emphasis on accurate documentation and procedures in QuickBooks.
Computerized Accounting with Sage 300
In this course, students will learn to set up banking and taxes service modules in Sage 300. Students will also learn to set up vendor and customer records and process transactions in the accounts payable and accounts receivable modules of Sage 300.
Computerized Accounting with Sage 50
Accounting procedures in a small business style computerized environment will be examined using the general, payables, receivables, payroll, and inventory modules of Sage 50. Students practice complete setup procedures including general ledger, accounts receivable, accounts payable, payroll, and inventory to record a wide variety of business transactions using Sage 50. Period end procedures, financial statement design, graphing and reports, and multi-currency situations are also explored.
Software Lab - Database Management
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Access. You will learn how to create and build a database (including basic database concepts and terms, using Backstage view, starting and exiting Access, Datasheet view and Design view, copy and paste records from another Access database, and so forth). You will gain an understanding on how to build a database and define table relationships, covering sub-topics such as setting fields properties, importing data from Excel and an existing table structure, and more. You will acquire the skill of maintaining and querying a database (such as find, modify, and delete records in a table, work in the Query window in Design view, run queries, sort data with Filter data, and so on). You will discover how to create forms and reports (using Form Wizard, apply themes to a form, add pictures to a form, change color of text on a form, and more). You will understand how to create advanced queries and enhance table design (using naming standards, AutoFilter, parameter query, lookup fields, input masks, and so forth).
Software Lab - Presentations
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft PowerPoint. You will learn a comprehensive set of skills centered on creating a presentation (create title slide, slide with lists, format text, duplicate, rearrange, and delete slides, change a theme, and so on). You will learn how to effectively add media and special effects (apply theme used in another presentation, insert shapes and pictures, rotate objects, create a table, and more). You will apply advanced formatting and animation to objects (including inserting SmartArt graphic, audio clips, and WordArt style). You will be able to distribute presentations and integration PowerPoint with other Microsoft Office programs, such as Word and Excel. You will learn how to customize presentations and become familiar with the PowerPoint environment, (how to work in a Slide Master View, work with comments, save a custom theme, and so on).
Software Lab - Word Processing
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Word. It builds on the skills introduced in Digital Literacy for Professionals course. You will learn a comprehensive set of skills, with coverage including creating and editing a document (this includes saving a document, using AutoComplete and AutoCorrect, undo and redo actions, paragraph spacing, and more), formatting a document (covering topics like addressing comments in documents, using drag and drop, as well as cut, copy and paste). This course will also introduce you to how to create tables and a multipage report (including options found in the Navigation pane, formatting a table, merging cells and adding a formula, using SmartArt graphic, and more). You will acquire skills in editing text or content for layout and appearance (wrap text, WordArt, cropping a picture, and so on). Additionally, you will work with templates, themes, and styles (creating a new document from a template, using thesaurus, saving a custom theme, customizing a style, and so on). This course concludes with the mail merge feature (such as inserting mail merge fields into a document, complete a mail merge, and more).
Software Lab - Spreadsheets
"This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Excel. You will learn the fundamentals of excel, such as opening and closing a workbook, entering formulas, modifying worksheet views, and so on. You will acquire skill in formatting workbook text and data (change fonts, font style, and font colour, format dates and times, merge, use the AVERAGE function, and more). This course will also introduce you to the skill of performing calculations with formula and functions, including sub-topics such as extend data and formulas with AutoFill, calculate statistics, and so forth. You will also be able to analyze and chart financial data using available excel charts, such as pie chart, line char, chart legends, data bar, and so on. This course will conclude with you learning how to generate reports from multiple worksheets and workbooks (such as copy worksheets between workbooks, organize worksheets in a worksheet group, hyperlink to a document, create a workbook template, and more).
Course Listings: Nova Scotia
Student Success Strategies
In this orientation module, you will focus on achieving success from day one. You will develop non-technical skills to enhance your personal, academic, and career success. You will explore learning styles, including visual, auditory, and kinesthetic learning. You will also enhance your practical study skills, such as memory, reading, note- and test-taking techniques. Personal exercises will focus on teamwork, decision-making and problem-solving skills, setting SMART goals, and maintaining a positive attitude. You will also explore techniques for managing change, stress, and conflict.
Course Listings: Nova Scotia
Bookkeeping Level I and II
This course will introduce the analysis and recording of business transactions using the rules of double-entry accounting. Adjusting journal entries are recorded and basic financial statements are prepared. Preparation and posting of journal entries for a business are examined, coupled with preparation of cost of goods sold, cash and trade discounts, closing entries, and the use of special journals and subsidiary ledgers. Students will learn fundamental accounting principles, understand the classification of assets, liabilities, equities, utilize the double-entry system and a general ledger chart of accounts, post entries to those accounts, and prepare trial balances along with the appropriate financial statements. The complete accounting cycle is examined through closing entries, worksheets, and the post-closing trial balance.
Business English
In this course, you will develop professional communication skills in a business setting using MS Office including Word and Outlook. You will apply proper grammar to create and review appropriate business documents such as emails, memos, letters, reports, text messages, and social media posts for company websites, LinkedIn, Twitter, and Facebook. You will practice grammar, spelling, and error correction while developing clear and concise writing skills. You will rewrite and edit professional documents while demonstrating spelling accuracy, proper capitalization, and punctuation. You will recognize and correct commonly misspelled words. Furthermore, you will explore sentence elements such as modifiers, connectors, and sequencers to write brief and jargon-free business messages. You will distinguish active and passive voice to write effective sentences. You will also review and incorporate inclusive language to avoid biases and discrimination. Using a range of grammatical structures, you will adopt and follow modern business communication standards.
Business Math
This course reviews and introduces basic and intermediate math concepts including the relationships between the following operations: addition and subtraction, multiplication and division, and decimals, percentages, and fractions. You will complete a variety of textbook readings, LinkedIn Learning and Khan Academy videos, worksheets, word problems, as well as two in-class assignments and two tests to ensure you are able to apply these math concepts to complete a variety of common business math operations. The first week focuses on a brief review of basic operations, fractions, and decimals while learning to decipher and complete word problems. The second week then looks at percentages, ratios, equations, and graphs to provide a robust review of key operations, word problems, and common business math requirements. This includes calculating costs, interest, budgets, and measurements, with a focus on transportation, nutrition, and costing. Throughout the course, you will complete work with and without a calculator to ensure you have mastered concepts and can complete operations efficiently and accurately in a work environment.
Career Planning & Preparation - Level I
This module will introduce you to and provide practice in using the tools required for a successful job search. The concepts covered in this module will help you maintain a career-focused approach throughout your studies so that you are better prepared to conduct a job search after graduating. Specifically, you will learn how to identify your soft and hard skills and how to articulate your abilities in a clear and concise Elevator Pitch that will appeal to employers and resonate with industry contacts. You will learn about the job search resources available to you including using career websites, creating Linked In profiles, accessing the “hidden” job market, and networking. You will examine sample resumes and cover letters and begin the process of creating your own professional resumes and cover letters that align with current conventions for content, organization, and formatting. You will also learn about the role of references, thank you letters, workplace philosophies, and strategies for success including maintaining a professional image and using proper etiquette when communicating with potential employers and industry contacts.
An introduction to Occupational Health and Safety is also provided with specific focus on employees’ rights and responsibilities, workplace health and safety policy and programs, hazard identification and control, and safety training options such as WHIMIS and First Aid.
Career Planning & Preparation - Level II
This module builds on concepts and skills introduced in the Career Planning and Preparation Level 1 prerequisite module. In this subsequent module, you will update and refine your resume and Linked In Profile. You will continue writing cover letters and learn the value of customizing cover letters to specific job postings. You will have the opportunity to apply this knowledge as you conduct a job search and write a cover letter tailored to an ideal job post. Through research, you will create a list of top employers and target current industry opportunities. You will learn about current methods for applying to job postings using technology. You will also gain an understanding of the job interview process, typical interview questions and possible responses, and expectations of both the interviewer and interviewee. In addition, you will engage in practical application of the interview process through role-plays. Topics such as negotiating salary, self-management, and on-the-job success for placements and post-graduate employment will be also covered.
Digital Literacy for Professionals
This course has four units that introduces you to the fundamental concepts and principles of learning and working in a digital environment. The first unit introduces you to using devices and handling information with topics on operating systems (Windows, MAC, and Linux), computer organization (folder management and naming conventions), cloud storage (including Microsoft OneDrive), types of web browsers including Google Chrome, Mozilla Firefox, and Apple Safari), and fundamental troubleshooting. In the second unit, you will become familiar with creating and editing information through learning about file formats (pdf, mp4, docx), productivity (including iWork and Microsoft Office Suite) and creativity (Adobe, Canva, iMovie) platforms, and basic introduction to Microsoft Word, Excel, and PowerPoint. The third unit on communicating and collaborating will introduce you to web conferencing applications (Slack, Zoom, Microsoft Teams), mail applications (including Microsoft Outlook and Gmail,), project management tools (Trello, Asana), and time management tools (including Todoist, Outlook Calendar, and iCal), and building rapport virtually. In the final unit, you will gain an understanding on netiquette, cybersecurity, and digital wellness. After completing this course, you will have enhanced digital literacy skills as a professional in the working and learning environment.
Finance
This course will introduce students to financial decision making for students with no previous exposure to finance principles. Topics covered will enable students to master the language and concepts to succeed in an accounting or business environment with an emphasis on budgeting and obtaining business financing.
Field Placement - Accounting and Payroll Administrator
On successful completion of the classroom hours of this program, students will be placed on field placement at an outside organization. Students will have the opportunity to apply their newly developed knowledge and skills in a real-world environment.
Image Development
This module teaches the student how to develop and manage a professional image. Topics include: appearance-visual and verbal, interpersonal interaction, business etiquette, and networking skills. At the end of the module, students will have an appreciation and understanding of the importance of a professional image in the business environment.
Intermediate & Management Accounting
This course focuses on internal business processes and examines the different methods of depreciation, accounting for fixed asset disposal, revision of depreciation, management responsibility, and cost accounting. Topics covered include bank reconciliations, cash flow and control, long term notes, monitoring of accounts receivable, accounting for cost of goods sold, financial analysis, and techniques for inventory control.
Internal Control
In this course, students will consolidate and enhance their previous accounting training and apply it to real-world scenarios. The students will review and further develop understanding in GAAP and GAAS. Students will gain a better understanding of auditing, audit preparation, and the concept of audit trails. This will be accomplished through the detailed creation and filing of source documents. Students will complete source documents, input data, create financial statements, and electronically file all materials in the cloud environment using a state-of-the-art cloud-based training package.
Payroll Compliance Legislation
Students who complete this module will understand compliance responsibilities that affect organizations, be able to comprehend legislation, and be able to effectively communicate these to all stakeholders. This course will provide students with the payroll-related legislation affecting organizations, as well as the tools to find information and apply that information to different scenarios in relation to individual pay. Specific skills include: describing payroll’s objectives and stakeholders; identifying an employee relationship; applying federal and provincial legislation to payroll including: Canada Pension Plan, Employment Insurance, Income Tax, Employment Standards Legislation, Workers’ Compensation Acts, and Quebec-specific legislation; and communicating payroll compliance requirements to various stakeholders.
Payroll Fundamentals I
Students who complete this module will be able to apply payroll legislation and calculate individual pay. This includes all components of individual pay from remuneration, through deductions, to net pay for both regular and non-regular situations. Students will have the content and skills to effectively communicate all aspects of the individual pay calculation process to external and internal stakeholders. Specific skills include: calculating regular individual net pay including allowances, expenses and benefits; calculating non-regular individual net pay including bonus and vacation payments; calculating termination payments; calculating commission payments; completing a Record of Employment; and communicating all aspects of individual pay requirements to various stakeholders.
Payroll Fundamentals II
Students who complete this module will be able to calculate and report government and third party remittances, year end requirements and accounting for payroll at the compliance level for the organization. Students will be able to effectively communicate these organizational processes and requirements to internal and external stakeholders. Specific skills include: calculating organizational remittances to federal, provincial and third party stakeholders; preparing and accounting documentation for payroll; completing federal year end documentation; completing year end documentation for the province of Quebec; and communicating all aspects of organizational remittance, accounting and year end requirements to various stakeholders.
QuickBooks
This course will introduce the accounting cycle in QuickBooks and further the student’s knowledge of accounting procedures in payroll, collections, payables, cash management, and bank reconciliations. Topics covered include inventory management and adjustment procedures with an overall emphasis on accurate documentation and procedures in QuickBooks.
Computerized Accounting with Sage 300
In this course, students will learn to set up banking and taxes service modules in Sage 300. Students will also learn to set up vendor and customer records and process transactions in the accounts payable and accounts receivable modules of Sage 300.
Computerized Accounting with Sage 50
Accounting procedures in a small business style computerized environment will be examined using the general, payables, receivables, payroll, and inventory modules of Sage 50. Students practice complete setup procedures including general ledger, accounts receivable, accounts payable, payroll, and inventory to record a wide variety of business transactions using Sage 50. Period end procedures, financial statement design, graphing and reports, and multi-currency situations are also explored.
Software Lab - Database Management
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Access. You will learn how to create and build a database (including basic database concepts and terms, using Backstage view, starting and exiting Access, Datasheet view and Design view, copy and paste records from another Access database, and so forth). You will gain an understanding on how to build a database and define table relationships, covering sub-topics such as setting fields properties, importing data from Excel and an existing table structure, and more. You will acquire the skill of maintaining and querying a database (such as find, modify, and delete records in a table, work in the Query window in Design view, run queries, sort data with Filter data, and so on). You will discover how to create forms and reports (using Form Wizard, apply themes to a form, add pictures to a form, change color of text on a form, and more). You will understand how to create advanced queries and enhance table design (using naming standards, AutoFilter, parameter query, lookup fields, input masks, and so forth).
Software Lab - Presentations
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft PowerPoint. You will learn a comprehensive set of skills centered on creating a presentation (create title slide, slide with lists, format text, duplicate, rearrange, and delete slides, change a theme, and so on). You will learn how to effectively add media and special effects (apply theme used in another presentation, insert shapes and pictures, rotate objects, create a table, and more). You will apply advanced formatting and animation to objects (including inserting SmartArt graphic, audio clips, and WordArt style). You will be able to distribute presentations and integration PowerPoint with other Microsoft Office programs, such as Word and Excel. You will learn how to customize presentations and become familiar with the PowerPoint environment, (how to work in a Slide Master View, work with comments, save a custom theme, and so on).
Software Lab - Word Processing
This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Word. It builds on the skills introduced in Digital Literacy for Professionals course. You will learn a comprehensive set of skills, with coverage including creating and editing a document (this includes saving a document, using AutoComplete and AutoCorrect, undo and redo actions, paragraph spacing, and more), formatting a document (covering topics like addressing comments in documents, using drag and drop, as well as cut, copy and paste). This course will also introduce you to how to create tables and a multipage report (including options found in the Navigation pane, formatting a table, merging cells and adding a formula, using SmartArt graphic, and more). You will acquire skills in editing text or content for layout and appearance (wrap text, WordArt, cropping a picture, and so on). Additionally, you will work with templates, themes, and styles (creating a new document from a template, using thesaurus, saving a custom theme, customizing a style, and so on). This course concludes with the mail merge feature (such as inserting mail merge fields into a document, complete a mail merge, and more).
Software Lab - Spreadsheets
"This software lab module will use a simulation-based program called MindTap that consists of online trainings and assessments in Microsoft Excel. You will learn the fundamentals of excel, such as opening and closing a workbook, entering formulas, modifying worksheet views, and so on. You will acquire skill in formatting workbook text and data (change fonts, font style, and font colour, format dates and times, merge, use the AVERAGE function, and more). This course will also introduce you to the skill of performing calculations with formula and functions, including sub-topics such as extend data and formulas with AutoFill, calculate statistics, and so forth. You will also be able to analyze and chart financial data using available excel charts, such as pie chart, line char, chart legends, data bar, and so on. This course will conclude with you learning how to generate reports from multiple worksheets and workbooks (such as copy worksheets between workbooks, organize worksheets in a worksheet group, hyperlink to a document, create a workbook template, and more).
Course Listings: Test
Admission Requirements
Student Success Strategies
In this orientation module, you will focus on achieving success from day one. You will develop non-technical skills to enhance your personal, academic, and career success. You will explore learning styles, including visual, auditory, and kinesthetic learning. You will also enhance your practical study skills, such as memory, reading, note- and test-taking techniques. Personal exercises will focus on teamwork, decision-making and problem-solving skills, setting SMART goals, and maintaining a positive attitude. You will also explore techniques for managing change, stress, and conflict.
Course Listings: Test
Intermediate Accounting (with Sage 50)
This course furthers the student’s knowledge of accounting procedures in payroll, pay cash and bank reconciliations. Central to this course is the merchandising firm and its accounting cycle, appropriate valuation of inventory and cost of goods sold calculations. This material will be presented both manually - working on paper - and using the computerized accounting system of Sage 50.
Advanced Accounting
In this course, students will build on principles learned in the intermediate accounting course. Students will learn how to manage the accounts and flow of cash in a small business and will be introduced to accounting in corporations. As well, students learn inventory costing, how to manage the Cost of Goods Sold (COGS), accounting for liabilities, receivables, adjustments, analyzing Cash flows, financial statement analysis, temporary and long-term investments and bonds. An overview of up and coming IFRS changes will be provided.
Microsoft Outlook
This Microsoft Outlook course is created for students to build and validate the skills businesses need to
succeed in today's information economy. It also provides students with the skills and knowledge they
need to use to effectively manage e-mails, contacts, calendars, and tasks. Outlook has become the
corporate standard electronic personal organizer. These are the foundational skills needed to
communicate using Outlook in a variety of positions within and organization. This course is computer
intensive and demands basic computer proficiency and understanding of e-mail software. Students
are expected to make arrangements to meet proficiency needs.
Microsoft Powerpoint
This software lab module consists of online training and assessment in Microsoft PowerPoint. Students
learn a comprehensive set of skills centered around the creation of attractive, professional-looking
presentations. Students learn how to effectively use and format animations, transitions, pictures, audio,
video, charts and tables, as well incorporate speaker notes and annotations into their presentations.
Career Planning & Preparation - Level I
This module introduces tools for planning and preparing for a successful job search, so that students can maintain a career-focused approach throughout their education program. Students will learn about the "Hidden" Job Market and ways to access it in their upcoming job search, how to research opportunities and network for industry contacts, and use appropriate etiquette when communicating with prospective employers. Students will identify their personal skills, values and preferences for the workplace, begin preparation of a professional resume and references, and organize proof documents for their career portfolio. Class discussions on various self-management topics introduced in Student Success Strategies will round out this module, which is a pre-requisite for Career Planning and Preparation - Level II.
Career Planning & Preparation - Level 2
This module continues to build on the concepts and skills introduced in Career Planning and Preparation
- Level I. Students will learn how to conduct an effective job search and identify various methods of
applying for work with today's technology. Students will create a personal list of "Top Employers" and
target current industry opportunities, while finalizing their professional resume, portfolio and career
correspondence. Students will learn to identify the different types and forms of interviews, practice
responding to typical questions, and practice follow-up, evaluation and negotiation techniques they can
use to ensure success. Self-management topics from Career Planning and Preparation - Level I will be
reviewed, with a focus towards on-the-job success in both learner placements and post-graduate
employment.
Microsoft Excel
This software lab module consists of online training and assessment in Microsoft Excel. Students learn a
comprehensive set of skills, with coverage including creating, formatting and printing worksheets,
creating simple and advanced formulas, using mathematical, logical, statistical and financial functions,
creating and modifying charts and pivot tables, and using data tools. Students will be evaluated through
a variety of assignments, projects, quizzes and exams in addition to their participation throughout the
course.
Computer Fundamentals
Through a combination of virtual training and critical thinking, this course examines the role and use of technology in today’s workplace. Emphasis is placed on those computers outfitted with the Microsoft Windows 10 operating system. Students will review basic computer components, Windows usage, file management, common applications, navigating and searching the web, and staying protected and safe while using a computer. Students will also start to hone their keyboarding skills through drills and timed exercises.
Student Success Strategies
In this orientation module, emphasis is placed on thinking about achieving success from Day One. This module stresses the importance of developing non-technical skills to enhance personal, academic, and career success. This includes understanding learning styles and honing practical study skills, such as memory, reading, note-and test-taking techniques. Personal exercises will focus on teamwork, decision making and problem solving skills, setting SMART goals and maintaining a positive attitude; techniques for managing change, stress and conflict will also be explored.
Microsoft Word Part 1
In this course, students learn a comprehensive set of skills in Microsoft Word, including formatting text for layout and appearance, formatting document sections, and using styles. They also learn how to create and edit header/footer content, insert and format tables, graphics and pictures, and work with templates and themes. The course consists of a combination of virtual training using simulations, as well as projects and exams using the desktop software.
Admission Requirements
High school graduation or equivalent. For those without high school completion, please refer to the Program Overview at the top of this page or speak to your Education Consultant.
Career Quiz
Take a quick and easy quiz to find out more about yourself, your goals, and identify your strengths and social style. This quiz gives you suggestions for what career areas you might consider based on your likes and preferences. Give it a try now!
Success Stories
“Going to Eastern has been such a huge turning point in my life. I've made some incredible friends that I know will last a lifetime. The educators and staff are friendly, helpful, and beyond accommodating. Easily one of the best choices I've made for my life and my family to date!”