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
None
Course Competencies
  1. Demonstrate computer file management.
  2. Develop worksheets using Excel.
  3. Develop familiarity with QuickBooks.
  4. Set up an accrual-based landscaping company using QuickBooks software.
  5. Process accounts receivable and sales of inventory for a landscaping business using QuickBooks software.
  6. deleted
  7. Process accounts payable and purchases of inventory 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. Deleted.
  11. Deleted.
  12. Manage payroll using QB software and generate both Federal and WI payroll tax forms.
  13. Apply QB reports/ratios and use of Excel worksheets to interpret and analyze business operations.
  14. Orally communicate effectively in a group setting.