Program Overview
This comprehensive diploma program equips students with essential skills in Microsoft Office Suite, business mathematics, law, communication, and accounting. It prepares individuals for careers in accounting, bookkeeping, and payroll administration, meeting the industry's demands for qualified professionals. The program includes modules on student success strategies, employment success strategies, and practical software applications like QuickBooks and Simply Accounting.
Program Outline
Outline:
Module 1: Student Success Strategies
- Goal setting
- Self-awareness
- Personal self-management
- Stress management
- Learning
- Active reading
- Interdependence
- Studying smarter
- Next steps
- Course overview, exam preparation and final exam
Module 2: MS Word
- Enhanced editing
- Using illustrations and graphics
- Proofing documents
- Applying references and hyperlinks
- Performing mail merges
- Maintaining documents and working with templates
- Protecting and sharing documents
- Using advanced options
- Using word HTML features
- Course overview, exam preparation and final exam
Module 3: MS Excel
- Working with advanced filters
- Advanced charting
- Using auditing tools
- Using scenarios & goal seeking
- Solving problems
- Using automatic formatting & style
- Using advanced formulas and securing workbooks
- Creating charts and pivot tables
- Adding pictures and shapes to a worksheet
- Course overview, exam preparation and final exam
Module 4: MS Office Access
- Database essentials
- Create data tables
- Work with tables/database records
- Modifying and fields
- Create forms
- Create reports
- Use controls in reports and forms
- Create and modify queries
- Creating flexible queries
- Course overview, exam preparation and final exam
Module 5: MS Office Outlook
- Getting to know outlook
- Email basics
- Advanced E-mail tools
- Managing E-mail messaging
- Automatic message processing
- Working with contents
- Advanced contact management
- Calendar basics
- Managing meetings
- Advanced calendar management
- Managing tasks
- Categories and outlook data files
- Managing notes and journal entries
- Course overview, exam preparation and final exam
Module 6: MS Office PowerPoint
- Power point essentials
- Presentation basics
- Working with texts
- Designing a presentation
- Adding tables to slides
- Using in a presentation
- Creating SmartArt graphics
- Adding graphics to a presentation
- Using animations and multimedia
- Securing and sharing a presentation
- Delivering a presentation
- Course overview, exam preparation and final exam
Module 7: Business mathematics
- Review of arithmetic
- Review of basic algebra
- Ratio, Proportion and percent
- Trade discount, discount, markup, and markdown
- Breakeven and cost-volume-profit relationships
- Mid-term exam
- Simple interest
- Simple interest applications
- Course overview, exam preparation and final exam
Module 8: Business law and mathematics
- Introduction to legal system in Canada
- Overview of Canadian legal system in Canada
- Contract law-impeachment
- Contract law-the effect of breach
- Contract law-remedies for breach
- The law of torts
- Torts-professional liability
- Competition law-government regulation of business
- LLP-Limited liability partnerships, company law, director/officers liability
- Employment law-contract of employment
- Business ethics
- Case studies in business ethics
- Course overview, exam preparation and finale exam
Module 9: Business communication
- Foundation of business communication
- The writing process
- Memos, letters, email and brief messages
- Report structure
- Spoken communication
- Giving speeches and oral presentations
- Project proposals
- Negotiation and persuasion skills
- Ethics of documentation
- Course overview, exam preparation and final exam
Module 10: Office administration procedures
- Understanding office environment
- Developing professional skills
- Issues in the office
- Time management
- Telecommunications
- Building communications skills
- Processing mail
- Record management
- Banking and accounting procedures
- Scheduling appointments and receiving visitors
- Making travel arrangement
- Planning meetings and conferences
- Developing effective oral presentations
- Course overview, exam preparation and final exam
Module 11: Bookkeeping and financial accounting fundamentals
- Accounting for and evaluating environment
- Recording business transactions
- Measuring business income: the adjusting process
- Completing the accounting cycle
- Merchandising operations & the accounting cycle
- Accounting for merchandise inventory
- Mid-term review
- Mid-term exam
- Accounting information systems
- Internal control and cash
- Receivables
- PP&E, goodwill and intangible assets
- Current liabilities and payroll
- Course overview & exam preparation
- Exam
Module 12: Bookkeeping and financial accounting intermediate
- Partnerships
- Corporations: share capital & the balance sheet
- Corporations: retained earnings and the income statement
- Long-term liabilities (part1)
- Long-term liabilities (part 2)
- Mid-term review
- Mid-term examination
- Investments and international operations
- Investments and international operations (part 2)
- The cash flow statement (part 1)
- The cash flow statement (part 2)
- Financial statement analysis (part 1)
- Financial statement analysis (part 2)
- Course overview & exam preparation
- Exam
Module 13: Payroll Administration I
- Canadian payroll-basic concepts
- Employee deductions and employee contributions
- Employee deductions and employee contributions
- Unionized and non-unionized environments
- Legislation regarding terminations and layoffs
- Computerized accounting using the simply
- Course overview, exam preparation and final exam
Module 14: Payroll Administration II
- Employment insurance Act
- Canada pension plan
- Income tax act
- Worker’s compensation
- Government remittance and compliances
- Year end
- Practicum
- Course overview, exam preparation final exam
Module 15: QuickBooks
- Getting started and intro to taxes
- Cash transactions
- General journal transactions
- Creating a new company
- Vendor transactions
- Customer transactions
- Discount, estimates, and orders
- Banking, taxes, and credit cards
- Company setup
- Payroll transactions
- Inventory transactions
- Course overview and final exam
Module 16: Simply accounting
- Getting started and introduction to taxes
- General journal
- General ledger setup
- Accounts payable
- Accounts receivable
- Receivable & payables setup
- Payroll journal
- Payroll ledger setup
- Mid-term examination (class 1- class 8 content)
- Inventory transactions
- Orders, quotes, and deposits
- Currencies, remittances and accountant’s copy
- Project allocations
- Budgeting
- Reconciliation and deposits
- Payroll inventory and comprehensive practice
- Time and billing
- Departmental accounting
- Course overview & exam preparation
- Exam
Module 17: ACCPAC—Part 1 G/L
- System manager
- G/L setup
- Charts accounts
- Opening balances
- Budget sets
- Daily transactions
- Displaying account transactions & periodic processing
- Statement designer
- Course overview, exam preparation and final exam
Module 18: ACCPAC—Part 2 A/R
- Accounts receivable setup
- Customer maintenance
- Opening balances and current year transactions
- Adjustments processing
- Receipt processing
- Periodic batch processing
- Periodic processing
- Year-end procedures
- Course overview, exam preparation and final examination
Module 19: ACCPAC—Part 3 A/P
- G/L subledger services, bank services and tax services (part I)
- G/L subledger services, ban services, and tax services (part II)
- Account payable setup
- Vendor maintenance
- Opening balances and current year transactions
- Adjustments
- Payment entry
- Accounts payable periodic processing
- Course overview, exam preparation and final examination
Module 20: Canadian tax practice
- Compensation issues-income from employment
- Compensation issues-allowable tax deductions for employees
- Income from business-business income earned by sole proprietors & corporations
- Depreciable property-acquisition, use and disposal of depreciable property
- Investment income-income from property
- Corporations-An introduction
- Corporations organization, capital structure, & income distribution of corporations
- Special tax rules for Canadian controllers private corporations (CCPC)course overview, exam preparation and final exam
Module 21: Employment success strategies
- Resumes
- Cover letters
- Job search essentials
- Interview essentials
- Interview follow up
Careers:
The field of accounting, bookkeeping and payroll administration can provide a challenging but also rewarding career. The various courses in the diploma were developed with the help of professionals from the accounting industry to ensure the training you receive at the EPIC College of Technology matches the skills and knowledge employers are looking for and demanding from graduates in areas related to general accounting, bookkeeping and payroll administration.