Chabot College Fall 2010 Course Outline for Computer Application Systems 60 business software applications/general accounting

60 – Business Software Applications/General Accounting 12 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.

None

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.
    

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
    

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
   

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
   

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