FALL 2009

Instructor: Martin M. Rudoff, MBA

Office:

Phone: 215-801-1756

E-mail: mrudoff@ccp.edu

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

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 (Peachtree Complete Accounting 2009, Release 16.0Ò).

Course Prerequisite: ACCT 101

Technology Requirements: To fulfill the requirements of this course, you MUST have the following software and hardware resources available to use. Software, you must have Microsoft ExcelÒ available to you on your computer. Peachtree Complete Accounting is packaged with the text, and you will have to install it on the computer you intend to use for this course. Hardware, to use Peachtree Complete, the system requirements include an IBM PC compatible with a Pentium II processor 300 MHz or higher, Windows XP SP1/2000SP3/ME/98SE or Windows NT 4.0 with Service Pack 6a, 64 MB minimum (128 MB recommended). A CD-ROM drive is required. 1100-250 MB free hard disk space, 256-color SVGA display or better, 800 X 600 resolution with 64K colors (or higher using Small Fonts in your Windows Control Panel Display settings).

Text: Computer Accounting with Peachtree Complete 2009, Release 16.0, 13^th Edition. Carol Yacht. McGraw-Hill, and, Microsoft Excel 2003, Introductory. O’Leary and O’Leary. McGraw-Hill.

Attendance: College Policy #95 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 files for me to review. The WebStudy page for the course contains the required homework assignments. 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 related to the accounting software and the spreadsheet. 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. The WebStudy page for the course contains more detailed information about the comprehensive problems. Exams must be completed and submitted by the published 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:

Peachtree Homework Average 20%

Peachtree Practice Set Average 40%

Excel Assignment Average 30%

Forum Participation 10%

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

Introduction

Peachtree

Installation and Overview

Vendor Transactions

Customer Transactions

Employee Transactions

General Ledger and Inventory

Job Costing

Financial Statements

Maintaining Accounting Records for Service Businesses

Completing Quarterly Activities and Closing Fiscal Year

Accounts Payable - Merchandising Business

Merchandising and Accounts Receivable

Merchandise Inventory

Payroll

Exporting Data

Using Peachtree With Word and Excel

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 my home page http://faculty.ccp.edu/faculty/mrudoff