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:
- demonstrate the use of manual and computerized accounting methods for completing the accounting cycle by performing accounting procedures appropriate for various business organizations;
- define accounting equation, implement theory, practice debit and credit concepts, and classify general ledger accounts;
- analyze source documents, journalize and post day-to-day business transactions, adjust entries;
- locate and correct errors on spreadsheets;
- analyze and develop financial statements;
- discuss the accounting cycle;
- create and maintain payroll records for a service-oriented business, prepare payroll tax reports;
- record and process accounts payable and accounts receivable transactions using special journals;
- prepare and reconcile bank statements;
- apply accounting procedure concepts;
- develop Microsoft Excel spreadsheets using beginning, intermediate, and advanced software features;
- use a computer keyboard to type with a net speed and accuracy of 42 wpm;
- use calculator and computer keyboard at a minimum of 160 net strokes per minute;
- send and receive e-mail via Internet and access career-related information;
- design Microsoft Access databases using beginning, intermediate, and advanced software features.
Course Content:
- Accounting cycle, concepts, source documents, and journal entries
- General ledgers, worksheets, financial statements, posting closing trial balance, special journals
- Bank reconciliation, correcting errors
- Payroll and employer taxes, employee earnings
- Computer keyboarding, ten-key
- Excel spreadsheets and graphs: formatting, moving, copying, saving, printing
- Functions
- Formulas
- Sort and filter
- Templates
- Goal seek
- Creating and editing macros in Excel and Access
- Pivot tables
- Internet
- Creating and managing relational databases
Methods of Presentation:
- One-on-one tutoring
- Small group instruction
- Instructor demonstration with computer
- Review of student assignments
- Laboratory practice
- Discussion
- Problem solving
Assignments and Methods of Evaluating Student Progress:
1.Typical Assignments
- Assigned problems
- Lab assignments
- Production of a wide variety of spreadsheets
- Automated accounting assigned & lab problems
- Computer keyboard testing
- Internet activities
- 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