ACCT 1150 - Microcomputer Applications in Accounting

Credits: 3.00
(3 contact hrs)
The student uses a microcomputer to complete accounting tasks and to solve various accounting problems. These accounting systems are studied: general ledger, accounts receivable, accounts payable, depreciation and payroll. In addition, a number of spreadsheet applications are covered.

Pre & Co Requisite(s): Prerequisite: ACCT-1090

OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will be able to use the Excel spreadsheet program to prepare reports, manipulate data, perform financial and statistical calculations, and other common tasks that accountants often must do on a day-to-day basis.

Objectives: 1. Use basic Microsoft Excel functions

Create a worksheet
Create formulas and functions
Create charts
Manipulate a worksheet

Objectives: 2. Perform accounting applications using Microsoft Excel

Prepare an Income Statement and Balance Sheet
Prepare a Bank Reconciliation
Prepare a Depreciation Schedule
Compute financial ratios
Prepare a Software Amortization Loan schedule

Outcome 2: Upon completion of this course, students will be able to use an accounting program to carry out setting up accounts, recording of transactions, posting to accounts and preparing typical reports with these program modules: Accounts Receivable, Accounts Payable, Payroll and General Ledger.

Objectives:

Process sales and receivables
Process payables and purchases
Perform general accounting and end-of-period procedures
Process payroll

COMMON DEGREE OUTCOMES
(Bulleted outcomes apply to the course)

1. The graduate can integrate the knowledge and technological skills necessary to be a successful learner.

2. The graduate can demonstrate how to think competently.

3. The graduate can demonstrate how to employ mathematical knowledge.

4. The graduate can demonstrate how to communicate competently.

The graduate is sensitive to issues relating to a diverse, global society.

COURSE CONTENT OUTLINE

Introduction to Microsoft Excel
1. General Microsoft Excel Navigation
2. Formulas and Functions
3. Charts
4. Database Tools
Accounting Specific Applications using Microsoft Excel
1. Income Statement and Balance Sheet
2. Bank Reconciliation
3. Statement of Cash Flows
4. Depreciation Schedule
5. General Financial Ratios
6. Bond Amortization Schedule
Accounting Software
1. Introduction to Computers and the Software
2. Service Business
3. Sales and Receivables
4. Payables and Purchases
5. End-of-Period Procedures
Merchandising Business
1. Sales and Receivables
2. Payables and Purchases
3. End-of-Period Procedures
4. Payroll
5. Computerizing a Manual Accounting System

Primary Faculty
Jex, Fred
Secondary Faculty

Associate Dean
Evans-Mach, Patrick

Official Course Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088