Northeast Wisconsin Technical College
10-101-156 020272 Accounting-Automated Applications
Outline of Instruction

Course Information
Description10-101-156 ACCOUNTING-AUTOMATED APPLICATIONS ...Excel, worksheet applications, lookups, if statements, data analysis, macros, evaluation of accounting software, installation of software, and conversion of manual accounting system to a computerized system. (Prerequisites: 10-101-120, Accounting 2; 10-101-105, Accounting-Computer Ledger)
Total Credits3
Prior Learning Assessments
Course Competencies
  1. Demonstrate computer file management.
  2. Develop worksheets using Excel.
  3. Develop familiarity with QuickBooks.
  4. Set up a company using QuickBooks software.
  5. Enter transactions for an accrual cash business using QuickBooks software.
  6. Process accounts receivable and sales for a business using QuickBooks software.
  7. Process accounts payable and purchases for a landscape service business using QuickBooks software.
  8. Manage cash payments and cash receipts using QuickBooks software.
  9. Prepare financial statements using QuickBooks software.
  10. Process purchases of inventory in a landscape services business using QuickBooks software.
  11. Process sales of inventory in a landscape services business using QuickBooks software.
  12. Manage payroll using QuickBooks software.
  13. Apply accounting knowledge, Excel skills, and QuickBooks software applications.
  14. Communicate effectively orally in a group setting.