Nov 26, 2021  
College Catalog 2021-2022 
    
College Catalog 2021-2022
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.

Billable Contact Hours: 3

Search for Sections
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

  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.

Objectives:

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

COMMON DEGREE OUTCOMES (CDO)
• Communication: The graduate can communicate effectively for the intended purpose and audience.
• Critical Thinking: The graduate can make informed decisions after analyzing information or evidence related to the issue.
• Global Literacy: The graduate can analyze human behavior or experiences through cultural, social, political, or economic perspectives.
• Information Literacy: The graduate can responsibly use information gathered from a variety of formats in order to complete a task.
• Quantitative Reasoning: The graduate can apply quantitative methods or evidence to solve problems or make judgments.
• Scientific Literacy: The graduate can produce or interpret scientific information presented in a variety of formats.

CDO marked YES apply to this course:
Communication: YES
Critical Thinking: YES
Information Literacy: YES
Quantitative Reasoning: YES
COURSE CONTENT OUTLINE

  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
Johnson, Elise
Dean
Balsamo, Michael



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



Add to Favorites (opens a new window)