Computerized Accounting Procedures Certificate
Overview:
Accounting jobs require the drive, attention to detail, and a solid education in the processes and procedures of the accounting industry. The Computerized Accounting Procedures certificate program at Academy of Learning Career College objective is to give students hands-on training in automated business accounting systems such as Sage 50 Premium Accounting and QuickBooks Premier.
The Computerized Accounting Procedures certificate program trains students in manual and computerized bookkeeping and financial accounting, as well as in leading industry software. This program can be applied in a number of industries and fields. Students are required to take some elective courses from prescribed study areas.
Career Opportunities:
Graduates skilled in computers play an integral role in the financial sector of any company. Those with initiative can work their way up the corporate ladder.
Duties & Responsibilities
- Assists all levels of
- Produces statistical reports and
- Performs some accounting
Required Skills & Personal Attributes
- Friendly
- Self-Motivated
- Dependable
- Aptitude for Figures
- Adaptable
- Cooperative
- Detail-Oriented
Electives: 4 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.
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.
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 features 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).
In the Microsoft Outlook Level 1 course, students will learn how to use both the e-mail program and the personal information manager components of Microsoft Outlook. The skills learned in this course will help students use Microsoft Outlook effectively both at work and in your personal life.
The Microsoft PowerPoint Level 1 course teaches students the fundamentals of this application and its usage within the Windows environment. Students learn to create, modify, and deliver electronic presentations. They learn to create slides containing text, tables, charts, diagrams, and graphics. Students practice customizing slides and finalizing presentations, and then learn to print and deliver slide shows.
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.
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 S
elf-Tests. Upon completion of this course, students are expected to keyboard at minimum 25 words per minute.
elf-Tests. Upon completion of this course, students are expected to keyboard at minimum 25 words per minute.
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.