Administrative Specialist

Emphasis is placed on analyzing and recording business transactions using the rules of double-entry bookkeeping. Adjusting journal entries are recorded and basic financial statements prepared. Preparation and posting of journal entries for a merchandising 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 and the three financial statements. The complete accounting cycle is examined through closing entries, worksheets and the post-closing trial balance.

This module provides the students with an understanding of arithmetic, mathematics, and measurements used in common business and industry environments. At the end of the module the student will be able to define whole numbers, fractions, decimals and percentages; become familiar with equations and formulae; and learn the use of graphs..

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 - Part II.

This module continues to build on the concepts and skills introduced in Career Planning and Preparation - Part 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 - Part I will be reviewed, with a focus towards on-the-job success in both learner placements and post-graduate employment.

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.

Management of the financial transactions of a business is absolutely critical to its survival. This introduction to finance will examine the analysis of changes in financial statements and interpretation of financial statements through ratio analysis, budgeting and profit planning, business plans, the cost of capital, and forms of financing, management of capital structure and capital investment decisions, working capital management and the time value of money, along with business valuation concerns.

Focusing on internal business processes, this module examines the different methods of depreciation (amortization), accounting for asset disposal, revision of depreciation along with departmental/responsibility accounting and job order cost accounting. Additionally, bank reconciliations, cash control, temporary investments and the monitoring of accounts receivable are examined, as well as accounting for cost of goods sold, techniques for inventory control, along with payroll accounting procedures.

The importance of the accounting cycle and of internal control procedures is highlighted with a major hands-on project. The project, a realistic business simulation, takes the student through the steps of the accounting process from the origin of transactions through to the preparation of financial statements. Emphasis is on the use of documentation and detailed recording and summarizing of events. Students will understand and visualize the entire accounting process.

Accounting procedures in a corporate type computerized environment are examined using the General Ledger, Accounts Receivable and Accounts Payable modules of Sage 300. Students learn and practice essential Sage 300 skills including company, general ledger, accounts receivable and accounts payable setup, creating and posting transaction batches including invoice, cash and adjustment batches, general ledger reports and procedures, month end and year end procedures, accounts receivable and accounts payable reports and procedures and processing of both manual and system cheques.

Accounting procedures in a small business style computerized environment are examined using the general, payables, receivables payroll, inventory and project modules of Sage 50. Students practice complete setup procedures including general ledger, accounts receivable, accounts payable, payroll, inventory and job cost setup, and record a wide variety of business transactions. Period end procedures, financial statement design, graphing and reports, and multi-currency situations are also explored.

This software lab module consists of online training and assessment in Microsoft Access. Students learn a comprehensive set of skills, including creating and modifying database tables, defining table relationships, sorting data, creating simple and advanced queries, creating and formatting forms and reports, and creating and running macros.

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.

This software lab module consists of online training and assessment in Microsoft Word, and builds on the skills introduced in Computer Fundamentals. Students learn a comprehensive set of skills, with coverage including formatting text for layout and appearance, formatting document sections, using styles, working with header/footer content, inserting and formatting tables, graphics and pictures, working with templates and themes, using advanced editing features, and working with mailing tools.

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.

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.

Through lectures, textbook exercises, and classroom labs, this module teaches students the skills and knowledge necessary to apply basic business writing skills when creating various memos; routine letters; good news letters; persuasive and bad news letters; presentations; and meeting agendas.