ACCT130 Accounting Applications for the Computer
Department of Business and Innovation: 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
Course Learning Goals
- create financial statements using multiple worksheets and cell referencing;
- prepare lists using pivot tables, look up tables and goal seek functions;
- graph components of financial statements in a pie chart, line graph and bar graph and analyze results; and
- record journal entries through the accounting cycle using current industry standard software.
Planned Sequence of Topics and/or Learning Activities
- use worksheets to make business decisions
- create a worksheet
- develop a professional-looking worksheet
- create charts
- work with computerized spreadsheet lists
- integrate computerized spreadsheet with other computer programs
- develop computerized spreadsheet applications
- work with multiple worksheets and workbooks
- create data tables and scenario management
- use computer applications for complex problems
- complete the accounting cycle for a business entity using current industry standard software
Assessment Methods for Course Learning GoalsThe assessment of course learning goals will be based on homework, exams, assignments, papers, performance based tasks and a comprehensive project, and/or instructor evaluation.
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