Chabot College

Course Outline for Computer Application Systems 60, page 1

Fall 2010

Chabot CollegeFall 2010

Course Outline for Computer Application Systems 60

BUSINESS SOFTWARE APPLICATIONS/GENERAL ACCOUNTING

Catalog Description:

60 – Business Software Applications/General Accounting12 units

(May be repeated 1 time

Introduction to the principles of automated and manual accounting systems, computerized spreadsheets and databases typically required for employment. This self-paced, individualized course in general accounting, systematic record keeping and business transaction analysis emphasizes using personal computers to develop a fluent understanding and hands-on application of accounting and database principles and practices and related software applications such as Excel, Access and Accounting. (Combined credit for Computer Application Systems 60, Business 5 and/or Business 7 may not exceed 12 units.) 35 hours laboratory for 18 weeks.
[Typical contact hours: 630]

Prerequisite Skills:

None

Expected Outcomes for Students:

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

  1. demonstrate the use of manual and computerized accounting methods for completing the accounting cycle by performing accounting procedures appropriate for various business organizations;
  2. define accounting equation, implement theory, practice debit and credit concepts, and classify general ledger accounts;
  3. analyze source documents, journalize and post day-to-day business transactions, adjust entries;
  4. locate and correct errors on spreadsheets;
  5. analyze and develop financial statements;
  6. discuss the accounting cycle;
  7. create and maintain payroll records for a service-oriented business, prepare payroll tax reports;
  8. record and process accounts payable and accounts receivable transactions using special journals;
  9. prepare and reconcile bank statements;
  10. apply accounting procedure concepts;
  11. develop Microsoft Excel spreadsheets using beginning, intermediate, and advanced software features;
  12. use a computer keyboard to type with a net speed and accuracy of 42 wpm;
  13. use calculator and computer keyboard at a minimum of 160 net strokes per minute;
  14. send and receive e-mail via Internet and access career-related information;
  15. design Microsoft Access databases using beginning, intermediate, and advanced software features.

Course Content:

  1. Accounting cycle, concepts, source documents, and journal entries
  2. General ledgers, worksheets, financial statements, posting closing trial balance, special journals
  3. Bank reconciliation, correcting errors
  4. Payroll and employer taxes, employee earnings
  5. Computer keyboarding, ten-key
  6. Excel spreadsheets and graphs: formatting, moving, copying, saving, printing
  7. Functions
  8. Formulas
  9. Sort and filter
  10. Templates
  11. Goal seek
  12. Creating and editing macros in Excel and Access
  13. Pivot tables
  14. Internet
  15. Creating and managing relational databases

Methods of Presentation:

  1. One-on-one tutoring
  2. Small group instruction
  3. Instructor demonstration with computer
  4. Review of student assignments
  5. Laboratory practice
  6. Discussion
  7. Problem solving

Assignments and Methods of Evaluating Student Progress:

1.Typical Assignments

  1. Assigned problems
  2. Lab assignments
  3. Production of a wide variety of spreadsheets
  4. Automated accounting assigned & lab problems
  5. Computer keyboard testing
  6. Internet activities
  7. Database creation and management projects

2.Methods of Evaluating Student Progress

a.Midterm project

b.Weekly Access assignments

c.Group projects

d.Final project

Textbook(s) (Typical):

Keyboarding & Formatting Essentials 5, Lessons 1-60 Van Huss, Forde, Woo Southwestern

Access 2007: Introductory Concepts and Techniques, Shelly, Cashman, Quasney, Course Technology, 2008

Excel 2007: Introductory Concepts and Techniques, Shelly, Cashman, Quasney, Course Technology, 2008

Excel Applications for Accounting Principles, Gaylord N. Smith, Thomson/South-Western, 2008

Special Student Materials:

Portable USB storage device

MD, C:\CAS 60 Curric Outline.docx

Revised 02/10/10