Course Outline for Business 6

Chabot College Fall 2006

Course Outline for Business 6

COMPUTERIZED ACCOUNTING USING EXCEL AND QUICKBOOKS

Catalog Description:

6 – Computerized Accounting using Excel and QuickBooks 2 units

Introduction to computerized accounting using Excel and QuickBooks. Using software to process the accounting cycle using the general journal and the general ledger for a service organization. Recording transactions, posting, making adjustments, and preparing financial statements. Using Excel spreadsheets and QuickBooks modules for a merchandising organization. Specific modules include accounts payable, accounts receivable, inventory, and payroll. Strongly recommended: Business 1A, Business 7 or equivalent. May be offered in Distance Education delivery format. 1 hour lecture, 3 hours laboratory.

Prerequisite Skills:

None

Expected Outcomes for Students:

Upon completion of this course, the student should be able to:

1. compare and contrast manual and computer-based accounting systems;

2. use Excel and QuickBooks software effectively;

3. enter, update, evaluate, and analyze accounting process using Excel spreadsheet and QuickBooks program menu;

4. complete the accounting cycle and discuss the relationship between its steps;

5. generate financial statements;

6. analyze financial data using ratios.

Course Content:

1. Comparison of manual and computer-based accounting systems

2. How to use Excel and QuickBooks software to enter accounting transactions, complete accounting cycle, generate financial statements

3. Entering data and summarizing transactions

4. Importance of backing up accounting data

5. Using special modules for detailed information

6. Exporting QuickBooks data to Excel

7. Financial ratios and financial analysis

Methods of Presentation:

1. hands-on explanation and use of the PC

2. lecture and demonstration

3. hands-on opportunities using computer and software

4. software simulation

Chabot College

Course Outline for Business 6, Page 2

Fall 2006

Assignments and Methods of Evaluating Student Progress:

1. Typical Assignments:

a. Enter Sales, Cash, On-Account Sales, and generate the Accounts Receivable Report

b. Complete all stages of accounting cycle for a service company using both software

2. Methods of Evaluating Student Progress

a. Examinations

b. Final examination

c. Graded assignments

Textbook(s) Typical:

Microsoft Excel for Accounting: The first course, K. Smith, Prentice Hall, 2003

QuickBooks Pro 2004: Introduction, Janet Horne, 2005

Special Student Materials:

Removable storage media, such as USB Flash Drives or diskettes.

wwong

Bus 06 course outline.doc

November 2005