ACCT130 Accounting Applications for the Computer

Department of Business Studies: Accounting

I. Course Number and Title
ACCT130 Accounting Applications for the Computer
II. Number of Credits
3 credits
III. Minimum Number of Instructional Minutes Per Semester
2250
IV. Prerequisites
ACCT103 (C or better) or ACCT105 (C or better)
Corequisites
None
V. Other Pertinent Information
None
VI. Catalog Course Description
This course provides a survey of automated accounting functions, including basic accounting procedures through the accounting cycle for service and merchandising businesses. Students implement current industry standard software to perform accounting functions and analyze financial statements.
VII. Required Course Content and Direction
  1. Learning Goals:

    1. Course
    2. Students will
      1. create financial statements using multiple worksheets and cell referencing;
      2. prepare lists using pivot tables, look up tables and goal seek functions;
      3. graph components of financial statements in a pie chart, line graph and bar graph and analyze results; and
      4. record journal entries through the accounting cycle using current industry standard software.

    3. Core (if applicable)
    4. This course is not included in the Core.
  2. Planned Sequence of Topics and/or Learning Activities:

    1. use worksheets to make business decisions
    2. create a worksheet
    3. develop a professional-looking worksheet
    4. create charts
    5. work with computerized spreadsheet lists
    6. integrate computerized spreadsheet with other computer programs
    7. develop computerized spreadsheet applications
    8. work with multiple worksheets and workbooks
    9. create data tables and scenario management
    10. use computer applications for complex problems
    11. complete the accounting cycle for a business entity using current industry standard software
  3. Assessment Methods for Core Learning Goals:

    1. Course
    2. The assessment of course learning goals will be based on homework, exams, assignments, papers, performance based tasks and a comprehensive project, and/or instructor evaluation.

    3. Core (if applicable)
    4. This course is not included in the Core.
  4. Reference, Resource, or Learning Materials to be used by Students:

    See course format for required textbook and any related materials.
VIII. Teaching Methods Employed
Section VIII is not being used in new and revised syllabi as of 12/10/08.

Review/Approval Date - 5/99; Revised 3/05; Revised 12/2011