Dec 04, 2020  
Official Course Syllabi 2020-2021 
Official Course Syllabi 2020-2021
Add to Favorites (opens a new window)

ACCT 1150 - Microcomputer Applications in Accounting

Credit Hours: 3.00

Prerequisites: ACCT 1090

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.

Contact Hours: 3
Billable Contact Hours: 3
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

  1. Create a worksheet
  2. Create formulas and functions
  3. Create charts
  4. Manipulate a worksheet

Objectives: 2. Perform accounting applications using Microsoft Excel

  1. Prepare an Income Statement and Balance Sheet
  2. Prepare a Bank Reconciliation
  3. Prepare a Depreciation Schedule
  4. Compute financial ratios
  5. 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.


  1. Process sales and receivables
  2. Process payables and purchases
  3. Perform general accounting and end-of-period procedures
  4. Process payroll

(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.
  1. The graduate is sensitive to issues relating to a diverse, global society.

  1. Introduction to Microsoft Excel
    1. General Microsoft Excel Navigation
    2. Formulas and Functions
    3. Charts
    4. Database Tools
  2. 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
  3. 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
  4. 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
Corba, David

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

Add to Favorites (opens a new window)