I. COURSE TITLE: Electronic Spreadsheet Applications for Accounting
II. CATALOGUE DESCRIPTION: 2004 - 2006 Concentrates on financial and managerial accounting applications with particular emphasis on using advanced spreadsheet financial functions related to recording business transactions; developing adjusted trial balance; preparing financial statements; analyzing and presenting accounts receivable; analyzing inventory; accounting for property, plant, and equipment; examining bonds payable and time value of money; evaluating performance; understanding costvolume- profit relationships; and capital budgeting supported by spreadsheet, graphics, database, and macro capabilities. Prerequisites: AC11 and either AC37, BA22 or CS11. A-E-G/4 credit hrs.
III. GOALS OF THE COURSE: The accounting faculty will assist accounting and non-accounting majors to achieve the desired learning outcomes listed below. In addition, the faculty will provide an opportunity for all students to develop and improve their analytical skills.
To that end, instruction will be directed at introducing students to:
A. Formulate solutions to accounting problems and program spreadsheets to store these solutions. B. Engage in "what-if" style problem solving techniques. C. Utilize the graphing capabilities of spreadsheet software to enhance the presentation of accounting reports. D. Perform the programming steps necessary to create, store, and use "macros" in the preparation and presentation of accounting reports. E. Incorporate the database capabilities of the software to customize reports and conduct inventory searches. F. Experience the use of specialized financial functions available in spreadsheet software. G. Understand advanced accounting topics including the time value of money, capital budgeting models, and cost-volume-profit relationships. H. The use of "spreadsheet publishing" capabilities of the software to produce professional quality financial statements and reports.
IV. STUDENT LEARNING OUTCOMES: Upon successful completion of AC82 (Electronic Spreadsheet Applications for Accounting) students will: A. use basic tools of spreadsheet software. B. know how to create and analyze financial graphs and charts. C. program macros into spreadsheet files to facilitate data entry and computation. D. manipulate accounting files through the use of database sorting, finding, extracting and report generating techniques. E. incorporate advanced financial functions into accounting problem solutions. F. routinely utilize presentation enhancement capabilities of spreadsheet software in accounting reports. G. be aware of the technological advances and resources available to accountants and accounting students.
V. SPECIAL INSTRUCTIONS/INFORMATION FOR THE TEACHER: A. Prerequisite to this course: AC11 - Principles of Accounting I and either AC37 - Computer Accounting Principles or BA22 - Computing for Business CS11 - Introduction to Computing B. Programs that require this course: A.S. Degree: None A.A.S. Degree: None 1-Year Certificate: None C. Courses which require this course as a prerequisite or co requisite: None D. External Jurisdictions: None
IV. MAJOR TOPICS REQUIRED (50 Hours) A. CORE LEVEL EXCEL SKILL AREAS (22 HOURS) Design, setup and formatting of worksheets. Enhancing worksheets. Moving data within and between workbooks. Maintaining workbooks. Creating charts and enhancing workbook display. Incorporate into FOUR (4) accounting projects designed to demonstrate these Excel features. B. EXPERT LEVEL EXCEL SKILL AREAS (23 HOURS) Introduction of advanced formatting techniques. Working with templates. Introduction of advanced financial functions. Working with lists. Using Excel’s analysis tools. Managing and auditing worksheets. Collaborating with workgroups. Importing & exporting data. Incorporate into four (4) accounting projects designed to demonstrate these Excel features.
V. EVALUATION OF STUDENT PERFORMANCE (5 HOURS) It is strongly suggested that there be at least two (2) full period examinations (or the equivalent in distance education sections). The examinations could include short answers and problems that reflect the activities presented in class as well as essay questions.
The Business Administration and Accounting Department endorses the college’s “Writing to Learn” initiative and strongly recommends that a writing component be included in all business and accounting courses.
