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. Number of Instructional Minutes
IV. Prerequisites
ACCT103 (C or better) or ACCT105 (C or better)
V. Other Pertinent Information
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. Course Learning Goals

    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.
  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 Course Learning Goals

    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.
  4. Reference, Resource, or Learning Materials to be used by Student:

    See course syllabus for required textbook and any related materials.

Review/Approval Date - 5/99; Revised 3/05; Revised 12/2011; New Core 8/2015