>>PRINT
Accounting Software
ACCTG SOFTWARE
CLASS CODE: ACCTG 333 CREDITS:  3
DIVISION: BUSINESS & COMMUNICATION
DEPARTMENT: ACCOUNTING
GENERAL EDUCATION: This course does not fulfill a General Education requirement.

DESCRIPTION: This course focuses on developing analysis and problem solving skills. The three main tools used in this course are Excel, VBA in Excel, and QuickBooks (or Peach Tree). The course progresses from solving structured accounting problems using Excel to solving Time Value of Money (TVM) problems. The course then focuses on building custom procedures and functions in Excel to provide customized solutions and Excel applications. During the final section students are asked to learn QuickBooks (or Peach Tree) as they solve a case study problem.
TAUGHT: Fall, Winter
CONTENT AND TOPICS:

  • Microsoft Excel modeling and problem solving

  • Diagramming problems

  • Microsoft Excel functions and formatting

  • Microsoft Excel controls

  • Microsoft Visual Basic for Application programming basics

  • Accounting software including QuickBooks or Peach Tree


GOALS AND OBJECTIVES:

  1. Students will learn to use Excel to build financial and accounting models and to solve business problems, financial and otherwise.
  2. Students will prepare to add value to organizations by creating applications within Excel which improve information analysis and business processes.

  3. Students will learn to setup and use a full function accounting package.

REQUIREMENTS: Throughout the course students are asked to analyze and solve structured accounting problems and cases using Excel. Students are asked to learn the main TVM functions in Excel and develop models to handle single and multi-step solutions. Students are asked to learn and use Visual Basic for Applications (VBA) to solve business and accounting problems. Students learn the fundamentals of programming including sequence, selection, and iteration. Students are asked to learn QuickBooks (or Peach Tree) as they solve a case study problem.
PREREQUISITES: ACCTG 202
OTHER:
EFFECTIVE DATE: January 2002