Fall 2004

Instructor: Alan E. Davis, CPA

Office: B2-22C

Phone: 215-751-8711

E-mail: adavis@ccp.edu

Website: http://faculty.ccp.edu/faculty/adavis/

Office Hours: Will be posted during the first week of class.

M ___________ T ___________ W ___________ R ___________ F ___________

Course Description: Introduction to microcomputer applications will focus on financial accounting problems and their solutions adapted to microcomputers. In this course students will utilize a spreadsheet program (Microsoft ExcelÒ) and a commercial general ledger software package (QuickBooks Pro 2004).

Course Prerequisite: ACCT 101

Texts: Computer Accounting with QuickBooks Pro 2004. Donna Ulmer. McGraw-Hill.

Microsoft Excel 2003, Introductory. O’Leary and O’Leary. McGraw-Hill.

Supplies: You should have at least 3, 3/5” floppy disks available for use exclusively in this course, or a flash drive. Trial versions of QuickBooks 2004 are available from the publisher, Intuit Corp., for a small shipping and handling fee; approximately $3.95. They can be ordered from the Intuit website, www.intuit.com.

Attendance: College Policy #5 allows your instructor to withdraw any student from the class who has missed at least two (2) weeks of class.

Academic Honesty: Except when permitted by your instructor, all work is expected to reflect an individual effort. Attribution should be given when appropriate. Cheating will be grounds for a failing grade.

Disabilities: Students with verifiable disabilities will be accommodated, but they must register with the Center on Disability, room M1-22, during the first two weeks of class.

Homework: Homework assignments are an integral part of any course you take. To master the requisite skills for success in the course, you should complete all homework assignments prior to their being reviewed in class. Throughout this course, homework assignments need to be completed and submitted for part of your grade. Homework submissions will be accomplish by either answering specific questions about problems you are assigned, or by submitting documents or files for me to review. You must complete your homework and submit it by the announced due date. Late assignments will be penalized 5 points for each day they are submitted late.

Examinations: This course requires that you complete comprehensive problems that will replace examinations. These problems relate to the accounting software. As with your homework assignments, you will be required to either answer specific questions about the problems after you’ve completed them, or submit your files for me to review and grade. Exams must be completed and submitted by the announced due date. Each day the exam is late will result in a deduction of 10 points.

Grading: The College grading scale will apply. Your final grade will be determined by the grades you earn on homework assignments, examinations, and for participation in class “forums.” Each of these components of your final grade will be weighted as follows:

QuickBooks Average 20%

QuickBooks Practice Set Average 40%

Excel Assignment Average 40%

Topical Outline: During the semester, the following topics will be covered in class:

Introduction to ACCT 103

QuickBooks

Overview

Chart of Accounts

Banking

Customers and Sales

Vendors, Purchases, and Inventory

Employees and Payroll

Reports and Graphs

Creating a Service Company

Accounting for a Service Company

Merchandising Corporation: Sales, Purchases, and Inventory

Merchandising Corporation: Payroll

Advanced Topics

Using Microsoft Word and Excel with QuickBooks

Excel

An Introduction to Excel

Charting in Excel

Excel Workbook Management and Analysis

What-If Analysis, Protection, Windows, and Links in Excel

Excel Functions, Data Tables, and Macros

Using Excel to Manage Data

Return to this course page

Return to instructor’s home page