ACCT 1150 - Microcomputer Applications in Accounting

Credit Hours: 3.00

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

• 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.

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