Computerized Accounting Diploma
The objective of the Computerized Accounting program is to provide the student with opportunities to acquire and apply the knowledge of business concepts and office skills to meet the demands of today’s business environment. You’ll benefit from courses delivered using hands–on computer applications, including extensive use of Microsoft Excel spreadsheets and computerized accounting software including AccPac, Sage 50 Premium Accounting and Quickbooks Premier. Students are required to take some elective courses from prescribed study areas.
Career Opportunities
Careers in computerized accounting are continuously in high demand. Excellent opportunities exist for skilled persons in a variety of accounting related positions, including the role of accounting bookkeeper, across the public and private sectors.
Duties and Responsibilities
- Handling confidential budget information
- Processing financial reports and memoranda
- Working with statistical and accounting data
- Maintaining files and records
- Performing a wide range of office support functions
Required Skills and Personal Attributes
- Aptitude for figures
- Good interpersonal skills
- Self-motivated
- Enthusiastic
- Detail-oriented
Electives: 3 Credits
Customize your program with additional course(s). Contact an Admissions Advisor for details.
Program Outline
Basic Bookkeeping Level 1 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 2 course provides students with a greater understanding of accounting and the procedures used to produce financial reports. It begins with a review of the bookkeeping procedures learned in the Basic Bookkeeping – Level 1 course and the process of balancing each of the subsidiary ledgers to its respective control account. Next, students learn about the different forms of business ownership (sole proprietorship, partnership and corporation), and then about the different types of organizations (service, merchandising, and manufacturing).
Basic Bookkeeping Level 2 explains the principles of handling a company’s petty cash account, reconciling the company’s bank account, calculating amortization and calculating the gain/loss on disposal of capital assets. During the course, students examine the Income Statement, the Statement of Owner’s Equity and the Balance Sheet, and then practice completing these financial statements. Finally, students learn briefly about the transition from a manual to a computerized bookkeeping system.
Basic Bookkeeping Level 2 explains the principles of handling a company’s petty cash account, reconciling the company’s bank account, calculating amortization and calculating the gain/loss on disposal of capital assets. During the course, students examine the Income Statement, the Statement of Owner’s Equity and the Balance Sheet, and then practice completing these financial statements. Finally, students learn briefly about the transition from a manual to a computerized bookkeeping system.
The Accpac General Ledger course provides an overview and introduction to the accounting software using a hands-on approach with simulated source documents. It takes students step-by-step through the procedures for setting up the General Ledger, followed by transaction by transaction processing covering the concepts and techniques needed to use the software.
The AccPac Accounts Payable course provides an overview and introduction to the accounting software using a hands-on approach with simulated source documents. It takes students step-by-step through the procedures for setting up the Accounts Payable subledger, followed by transaction by transaction processing covering the concepts and techniques needed to use the software.
The Accpac Accounts Receivable course provides an overview and introduction to the accounting software using a hands-on approach with simulated source documents. It takes students step-by-step through the procedures for setting up the Accounts Receivable module, followed by transaction by transaction processing covering the concepts and techniques needed to use the software.
In the QuickBooks Premier course students are introduced to QuickBooks and its features. As students progress through the course, they become familiar with the QuickBooks interface and learn how to perform common tasks using QuickBooks. Students learn how to use the EasyStep Interview to create a company file, how to customize the Chart of Accounts for the company, manage lists (customer, vendor, item, employee and payroll), create business forms (invoices, cheques, cash sales receipts, credit memos and refunds), use registers, pay bills (using cheques, credit cards and petty cash), create reports (balance sheet, profit and loss, customer and vendor balance detail), and manage a payroll (add/edit employees, process pay cheques, run payroll reports, and manage the payroll liabilities). Students also perform several account reconciliations (chequing, credit card, and petty cash).
In the Sage 50 Premium Accounting course (formerly Simply Accounting), the students will be introduced to the Sage 50 Premium Accounting software, using a hands-on approach with simulated source documents. Students will work step-by-step through the procedures for setting up each module, followed by transaction by transaction processing covering the concepts and techniques needed to use the software.
The Business Math course at Academy of Learning Career College is designed to introduce the basic mathematical skills needed to understand, analyse, and solve mathematical problems encountered in business and finance, and in investment decision making. This course introduce students to helpful tools that will enable them to perform quick, easy, and accurate basic math functions such as addition, subtraction, multiplication, and division. They will also learn to round numbers, calculate percentages, fractions, and decimals, as well as calculate interest, payments on loans, net present values, and returns on investments. Finally, students will compare leasing and purchasing options, look at break-even points, explore statistical terminology, and calculate and display various statistics.
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. Students are required to draw on their own experiences, to research information, and to apply their knowledge to typical junior management situations. 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 co-ordinating. 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.
The Office Procedures Level 1 course at Academy of Learning Career College 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 will teach students the fundamentals of customer service, and help them to develop core competencies for providing excellent customer service. Students learn the definition of customer service, who their customers are, and how to be customer service oriented through description and examples. They learn tips for managing time and stress, communicating effectively with customers, and managing customer relationships. The course highlights being prepared, and dealing professionally with customer conflicts and complaints. It identifies common pitfalls and explains how to avoid making them. It also emphasizes the importance of gathering and responding to customer feedback, and maintaining a professional image.
The Microsoft Access Level 1 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.
In the Microsoft Excel Level 1 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.
The Microsoft Excel Level 2 course teaches students intermediate to advanced-level concepts and featu
res of the Microsoft Excel application. In this course, students learn to customize Microsoft Excel and streamline workflow by building upon the basic skills learned in the Microsoft Excel – Level 1 course. 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).
res of the Microsoft Excel application. In this course, students learn to customize Microsoft Excel and streamline workflow by building upon the basic skills learned in the Microsoft Excel – Level 1 course. 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).
The Microsoft Excel Level 3 course teaches students advanced-level concepts and features of the Microsoft Excel application. 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.
In Microsoft Word Level 1 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.
The Internet Fundamentals course explores the various components of the Internet using Microsoft Internet Explorer. Students are oriented to common procedures used to maximize 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 the Personal Computer Fundamentals for End Users 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.
This course covers the basic concepts and most commonly used features and functions of Windows 10. 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 a 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.
The Introduction to Keyboarding 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.
The Keyboard Skill Building Level 1 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. Speed achieved depends on personal dexterity and time spent on practice lessons. Students who are not already familiar with the TypingTrainer software program are introduced to it. 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 minimum 25 words per minute.
Job Search and Résumé Writing provides students with both traditional and innovative job-search techniques and résumé writing skills required to gain employment in today’s competitive marketplace. The course combines theoretical, how-to information with hands-on practical applications. Students are required to draw on their own experiences to identify work preferences, accomplishments, technical and transferable skills, and to research, organize, and analyze information; and to apply their knowledge in a series of job search preparation and implementation tasks.
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.
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. Humor 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.