|
|
|||||||||
|
ACCOUNTING SYSTEMS |
|||||||||
|
Class Hours: 3.0 |
|
Credit Hours: 3.0 |
|
||||||
|
Laboratory Hours: 0.0 |
|
Revised: Spring 07 |
|
||||||
|
NOTE: This course is not designed for transfer credit. |
|
||||||||
|
Catalog Course Description: |
|
|
|||||||
|
|
A study of the flow of documents and information from initial transaction to financial statement preparation. Emphasis is on computer software applications using general ledger software. Topics include internal control, general ledger, accounts receivable, accounts payable, payroll, and job order costing. |
||||||||
|
Entry Level Standards: |
|
|
|||||||
|
|
The student must have math, writing, and English skills at the college entry level. |
||||||||
|
Prerequisite: |
|
|
|||||||
|
|
ACC 2030 |
||||||||
|
Textbook(s) and Other Course Materials: |
|
||||||||
|
|
Textbook: Horne,
Janet. Quickbooks Pro 2004 with Update for Pro 2005.
Prentice-Hall, Inc. 2005. |
||||||||
|
I. Week/Unit/Topic Basis: |
|
|
|||||||
|
|
Week |
Topic |
|||||||
|
|
1 |
Review of Accounting Cycle |
|||||||
|
|
2 |
Introduction to Computers and Quickbooks Pro |
|||||||
|
|
3 |
Sales and Receivables: Service Business |
|||||||
|
|
4 |
Payables and Purchases: Service Business |
|||||||
|
|
5-6 |
General Accounting and Month-end Procedures |
|||||||
|
|
7-8 |
Payroll |
|||||||
|
|
9 |
Sales and Receivables: Merchandising |
|||||||
|
|
10 |
Payables and Purchases: Merchandising |
|||||||
|
|
11-12 |
Computerizing a Manual System |
|||||||
|
|
13-14 |
Database Systems and
Overview of Access |
|||||||
|
|
15 |
Final Exam |
|||||||
|
II. Course Objectives*: |
|
|
|||||||
|
|
A. |
Demonstrate knowledge of basic accounting concepts and the accounting cycle. III |
|||||||
|
|
B. |
Acquire an understanding of computerized general ledger systems and financial reporting. III |
|||||||
|
|
C. |
Develop an understanding of computerized accounts receivable systems. III |
|||||||
|
|
D. |
Develop an understanding of computerized accounts payable systems. III |
|||||||
|
|
E. |
Acquire an understanding of computerized payroll systems and job order costing. III |
|||||||
|
|
F. |
Develop an understanding of simple database concepts and usage. III |
|||||||
|
*Roman numerals after course objectives reference goals of the Computer Accounting program. |
|||||||||
|
III. Instructional Processes*: |
|
|
|||||||
|
Students will: |
|
|
|
||||||
|
|
1. |
Exhibit
professional behavior by attending class regularly, arriving punctually with
the appropriate materials, and being prepared for active class participation
each day. (Active Learning Strategies, Transitional Strategies) |
|||||||
|
|
2. |
Use
accounting software and database software on a personal computer. (Technological
Literacy Outcome, Active Learning Strategies) |
|||||||
|
|
3. |
Interpret
information from business and accounting reports. (Mathematics Outcome,
Technological Literacy Outcome) |
|||||||
|
*Strategies and outcomes listed after instructional processes reference TBR’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process. |
|||||||||
|
IV. Expectations for Student Performance*: |
|
|
|||||||
|
Upon successful completion of this course, the student should be able to: |
|||||||||
|
|
1. |
Start Quickbooks Accounting for Windows software. B |
|||||||
|
|
2. |
Explain and change the preference settings in Quickbooks. B |
|||||||
|
|
3. |
Backup and restore data files in Quickbooks. B |
|||||||
|
|
4. |
Perform maintenance activities for Quickbooks General Ledger. B |
|||||||
|
|
5. |
Record a variety of transactions and adjustments in Quickbooks General Ledger. A, B |
|||||||
|
|
6. |
Prepare a variety of reports in Quickbooks General Ledger and explain the information contained in each. A, B |
|||||||
|
|
7. |
Perform maintenance activities for Quickbooks Accounts Receivable. C |
|||||||
|
|
8. |
Record a variety of transactions in Quickbooks Accounts Receivable. A, C |
|||||||
|
|
9. |
Prepare a variety of reports in Quickbooks Accounts Receivable and explain the information contained in each. A, C |
|||||||
|
|
10. |
Perform maintenance activities for Quickbooks Accounts Payable. D |
|||||||
|
|
11. |
Record a variety of transactions in Quickbooks Accounts Payable. A, D |
|||||||
|
|
12. |
Prepare a variety of reports in Quickbooks Accounts Payable and explain the information contained in each. A, D |
|||||||
|
|
13. |
Perform maintenance activities for Quickbooks Payroll. E |
|||||||
|
|
14. |
Record a variety of transactions in Quickbooks Payroll. A, E |
|||||||
|
|
15. |
Prepare a variety of reports in Quickbooks Payroll and explain the information contained in each. A, E |
|||||||
|
|
16. |
Use the Quickbooks Account Reconciliation Feature. A, B |
|||||||
|
|
17. |
Correct errors in Quickbooks Accounting for Windows. A, B |
|||||||
|
|
18. |
Use basic features of Quickbooks accounting software. B, C, D |
|||||||
|
|
19. |
Explain the difference between a field, a record, and a table, and give examples of each. F |
|||||||
|
|
20. |
Create and edit a simple database table. F |
|||||||
|
|
21. |
Modify the structure and/or contents of a simple database table. F |
|||||||
|
|
22. |
Perform simple queries related to a database table. F |
|||||||
|
|
23. |
Prepare simple reports related to a database table. F |
|||||||
|
*Letters after performance expectations reference the course objectives listed above. |
|||||||||
|
V. Evaluation: |
|
|
|||||||
|
|
A. Testing Procedures: |
||||||||
|
|
The instructor's policy on exams, quizzes, homework, attendance, and grades will be provided in a supplement to the course syllabus. A minimum of four major exams is recommended. |
||||||||
|
|
B. Laboratory Expectations: |
||||||||
|
|
Computer based class assignments and homework problems will be introduced in class sessions held in the computer lab. Class assignments are to be completed during class time. Homework assignments are to be completed outside class. Detailed instructions on assignments and homework will be provided by the instructor. |
||||||||
|
|
C. Field Work: |
||||||||
|
|
N/A |
||||||||
|
|
D. Other Evaluation Methods: |
||||||||
|
|
N/A |
||||||||
|
|
E. Grading Scale: |
||||||||
|
|
A
92 -100 |
||||||||
|
VI. Policies: |
|
|
|||||||
|
|
A. Attendance Policy: |
||||||||
|
|
|
||||||||
|
|
B. Academic Dishonesty: |
||||||||
|
|
Plagiarism, cheating, and
other forms of academic dishonesty are prohibited. Students guilty of
academic misconduct, either directly or indirectly through participation or assistance,
are immediately responsible to the instructor of the class. In addition
to other possible disciplinary sanctions which may be imposed through the
regular |
||||||||
|
|
C. Accommodations for disabilities: |
||||||||
|
|
If you need accommodations because of a disability, if you have emergency medical information to share, or if you need special arrangements in case the building must be evacuated, please inform the instructor immediately. Please see the instructor privately after class or in his/her office. Students must present a current accommodation plan from a staff member in Services for Students with Disabilities (SSWD) in order to receive accommodations in this course. Services for Students with Disabilities may be contacted by going to Goins 127 or 131 or by phone: 694-6751(Voice/TTY) or 539-7153. |
||||||||
|
|
D. Other Policies |
||||||||
|
|
Computer Usage
Guidelines: |
||||||||