Accounting Certificate Program Course Outline

ACCOUNTING
(CERTIFICATE PROGRAM)

OBJECTIVE:
The Institute’s Computerized Accounting curriculum is designed to prepare students for entry level computer support roles in business accounting settings and financial services industries.

PROGRAM LENGTH:
This program is available both day and evening, meeting five times per week. The program meets approximately 5 hours per class session for a total of 24 hours per week. Students are required to take Employment Preparation and Communication & Customer Relations courses. This brings the program’s length to 32 semester credit hours or 720 classroom hours. The program comprises of approximately 30 weeks of instruction for both day and evening programs.

Course Number Course Title Total Hours Academic Semester Credit Hours
CP100 Computer Essentials 30 1
CP210 Spreadsheet Fundamentals 90 4
CP220 Advanced Spreadsheet 90 4
MT110 Business Math 60 3
AC111 Principles of Accounting I 90 4
AC112 Principles of Accounting II 90 4
AC260 QuickBooks for Accounting I 90 4
AC261 QuickBooks for Accounting II 90 4
EN100 Communication & Customer Relations 60 3
EP101 Employment Preparation 30 1
  TOTAL 720 32

 

Course Descriptions:

CP100 Computer Essentials (No prerequisite, 3 Semester Credit Hours)
This course introduces students to basic computer concepts using Windows Operating Systems and Microsoft Office Applications. Students get an overview of computing concepts and the basics of an Operating System. Students work with Microsoft Word to create, edit, and format standard word processing documents. Basic file management techniques are introduced to organize, store, and retrieve files and documents. Students move on to using Internet applications such as email, web search engines and networking and examine issues of internet security and privacy. Microsoft Office applications such as Excel will be introduced and via brief overview MS Office applications to create flyers, reports, tables and presentation graphics.

OS101 Basic Keyboarding and Typing (No prerequisite, 1 Semester Credit Hours)
Keyboarding skills are developed on the alphabetical keyboard using the computer. The student learns the fundamentals of centering text, tabulation, and letter placement. A minimum speed of 45 words per minute is achieved.

CP210 Spreadsheet Fundamentals (Prerequisite: CP100, 3 Semester Credit Hours)
This course introduces the basic tool of computerized accounting, the electronic spreadsheet (specifically Microsoft Excel, the most widely used in industry). Solving theoretical exercise problems using spreadsheet software will emphasize the use of the computer as a tool to assist in financial planning and accounting for business.

CP220 Advanced Spreadsheet Applications (Prerequisite: CP210, 3 Semester Credit Hours)
This course covers advanced skills using Microsoft Excel 2007. Students will create formulas, add formatting attributes, and create charts. Additional skills coverage includes working with financial formulas and functions, managing workbooks, automating worksheet tasks, and using lists. The student will create templates, learn 3D drilling for multi worksheets and create workspaces from multi workbooks. Also, the student will create macros and automate worksheets using VBA.

MT110BusinessMath (Noprerequisite,3 Semester Credit Hours)
This course provides a review of basic mathematical functions with emphasis on practical problems including interest, discounts, percentages, and payroll. Proficiency is developed in performing business mathematical operations.

AC111 Principles of Accounting I (Prerequisite: MT110, 4 Semester Credit Hours)
This course provides the student with an understanding of the fundamental principles, methods, and procedures of ac¬counting and the accounting cycle. Topics will include general and subsidiary ledgers, preparation of financial statements, reports and analysis of data of the general ledger, accounts receivables/payables, inventory, payroll, accounting for merchandise transactions and asset management. Journalizing, posting, preparing a trial balance and worksheet, adjusting and closing entries, and preparing a post-closing trial balance are also discussed.

AC112 Principles of Accounting II (Prerequisite: AC111, 4 Semester Credit Hours)
The accounting cycle will be reviewed including partnership accounting and accounting for corporations. The student will gain an understanding of computerized accounting topics that include stockholders equity, long-term liabilities (bonds, investments), cash flow, inventory valuation, accounting for property, plant and equipment, preparation and analysis of partnership and corporate financial statements. Managerial aspects of accounting, such as manufacturing statements and job order and process cost systems will be introduced.

AC260 QuickBooks for Accounting I (Prerequisite: CP100, 4 Semester Credit Hours)
This course provides an introduction to accounting with QuickBooks software. Students will learn how the double entry system of bookkeeping is implemented through QuickBooks’ system of document preparation. Students will enter sales, receivables, payables and purchases for a service business. Students will become proficient at using QuickBooks Navigators, Menus and Registers.

AC261 QuickBooks for Accounting II (Prerequisite: AC260, 4 Semester Credit Hours)
Additional practice and proficiency in QuickBooks is this course’s goal. Students will apply QuickBooks skills to a merchandising company. Other topics covered include preparing payroll, reconciling bank accounts and working with the numerous reports QuickBooks offers. Integrating QuickBooks with Excel, Word and online services will be presented.

EN100 Communication & Customer Relations (No prerequisite, 3 Semester Credit Hours)
This course introduces students to effective written & verbal communication. They will explore the language of global business, alongside the study of leadership, management and communication across national boundaries with cultural understanding and awareness. In addition, this course provides students with the foundation of sound customer service and customer relations.

EP101 Employment Preparation (No prerequisite, l Semester Credit Hours)
In this seminar students are taught how to conduct a job search, including locating sources of employment, writing letters of application, creating a resume, and interviewing for a job with necessary follow-up procedures.