inette.com

N W T C - M a r i n e t t e:  7 1 5 - 7 3 5 - 9 3 6 1

 

NWTC-Marinette - Fall 2007

Accounting Automated Applications
Class No. 81579, Catalog No. 10-101-156
 

ACCOUNT 10101156 - 01 Accounting-Automated Applications Northeast WI Technical College | Fall 2007 | Lecture Return to Results
CLASS DETAILS Status Open Class Number 81579 Session Regular Academic Session Units 3 units Instruction Mode Accelerated
Laboratory Lecture Class Components Career Post Secondary Dates 10/25/2007 - 12/20/2007 Grading Graded - Postsecondary
Location Marinette Campus Campus Marinette Campus
MEETING INFORMATION Days & Times Room Instructor Meeting Dates Th 5:00PM - 10:00PM Marinette Campus Room 120
Lloyd Cook 10/25/2007 - 12/20/2007 CLASS AVAILABILITY Class Capacity Wait List Capacity 18 2 Enrollment Total Wait List Total 7 0
Available Seats 11

DESCRIPTION

10-101-156 ACCOUNTING-AUTOMATED APPLICATIONS ...Windows, file management, worksheet applications, database applications, macros, evaluation of accounting software, installation of software, and conversion of manual accounting system to a computerized system. Requires experience with Windows, and prior completion of an introductory course in Word, and introductory and intermediate courses in Excel. (Prerequisite: 10-101-120, Accounting 2, 10-101-105 Accounting-Computer Ledger.

 Lloyd Cook, Adjunct Instructor - E-mail: Click here

Office Hours:  NWTC - by appointment - Th  4:45-5:00pm

Text:  Computer Accounting 11th Ed
         with Peachtree Complete ® Accounting 2007 Rel 14.0
         for Microsoft ® Windows ®
         McGraw-Hill Irwin © 2002
         Carol Yacht  ISBN 976-0-07-336591-6

Syllabus
Based on the syllabus of Janet Dausey
(Revision # 2- 12/04/2007

By the end of the course, the student will be able to demonstrate window commands for disk and file management; organize files efficiently on a hard drive; develop worksheets using Excel to supplement computerized accounting packages; evaluate general ledger accounting software; install software; implement the conversion of a manual accounting system to a computerized accounting system; complete accounting problem using accounts receivable module; complete accounting problem using accounts payable; complete accounting problem using payroll; analyze the integration of a general ledger module, with accounts receivable, accounts payable, and payroll; perform a class presentation of a project.  (whew!!!!!)

Computer Accounting - Resources - Student Edition

Course Description: 

This course provides the opportunity for the learner to develop the knowledge skills process and understanding of Windows commands, file management, worksheet applications, database applications, macros, evaluation of accounting software, installation of software, and conversion of manual accounting systems to computerized systems.

Pre-requisites:

Accounting 2 (10-101-120)
Accounting – Computer Ledger (10-101-105)

 Textbook:

Computer Accounting with Peachtree Complete 2006 for Microsoft Windows by Carol Yacht

Library Resources: 

Additional library resources may also be available at http://www.nwtc.edu

Supplies:

• 4 High-Density Disks or Flash Drive
• Access to the H: Drive

Course Competencies: 

1. Demonstrate Windows commands for disk and file management.
2. Organize files efficiently on a hard drive.
3. Develop worksheets using Excel to supplement computerized accounting packages.
4. Evaluate general ledger accounting software.
5. Install software.
6. Implement the conversion of a manual accounting system to a computerized computer system.
7. Complete accounting problem using accounts receivable module.
8. Complete accounting problem using accounts payable module.
9. Analyze the integration of a general ledger module, with accounts receivable, accounts payable, and payroll.
10. Perform a class presentation.

Expectations and Policies:

Attendance:  Regular attendance will ensure that you have the maximum opportunity to participate in your education.

Windows Assignment:  This assignment focuses on Windows commands and file management skills.  Lab time will be provided in class to work on the assignment.  See the Course Calendar and Assessment Activities Summary for due dates and other details.  Assignments handed in late will be subject to a 2-point penalty per class period late.  A late assignment will not be accepted more than two class periods after its respective due date.

Excel Projects:  These projects cover amortization, invoicing, financial statements, and depreciation.  Lab time will be provided in class to work on the projects.  See the Course Calendar and Assessment Activities Summary for project details and due dates.  Projects handed in late will be subject to a 5-point penalty per class period late.  A late project will not be accepted more than two class periods after its respective due date.

Peachtree Exercise Assignments:  These exercises require the use of Peachtree Accounting Software and provide the foundation for completing the Peachtree Projects.  Lab time will be provided in class to work on the assignments.  See the Course Calendar and Assessment Activities Summary for assignment details and due dates.  Assignments handed in late will be subject to a 2-point penalty per class period late.  A late exercise assignment will not be accepted more than two class periods after its respective due date.

Peachtree Projects:  Two Peachtree projects are assigned from the text.  They are cumulative in nature and therefore require mastery of skills from the related sections of the text.  Lab time will be provided in class to work on the projects.  See the Course Calendar and Assessment Activities Summary for project details and due dates.  Projects handed in late will be subject to a 10-point penalty per class period late.  A late project will not be accepted more than two class periods after its respective due date.

Inn Spot Peachtree Project:  This project requires the use of a chart of accounts, Excel schedules, default information, beginning balances, transactions, and a profit plan.  See the Course Calendar and Assessment Activities Summary for project details and due date.  Projects handed in late will be subject to a 10-point penalty per class period late.  A late project will not be accepted more than two class periods after its respective due date.

PowerPoint Presentation Project:  This project requires the creation of a PowerPoint presentation.  See the Course Calendar and Assessment Activities Summary for project details and due date.  PowerPoint Presentation Projects must be completed by the required due date.  Late projects will not be accepted or graded.

Scoring Composition:

Item	Quantity	Points Each	Total Points
Windows XP Assignment	1	10	10
Excel Project 1	1	32	32
Excel Project 2	1	40	40
Excel Project 3	1	60	60
Excel Project 4	1	30	30
Peachtree Exercise Assignments	13	10	130
Peachtree Projects	2	100	200
Inn Spot Peachtree Project	1	100	100
PowerPoint Presentation Project	1	100	100
Total			702

Grading Scale:   

93 – 100	A
85 – 92	B
77 – 84	C
69 – 76	D
Below 69	F

Academic Dishonesty:  Academic dishonesty will not be tolerated.  The minimum penalty will be a zero on the test or project.

Disability Act:  NWTC complies with all provisions of the Americans with Disabilities Act and makes reasonable accommodations upon request.
Please contact the Special Needs Office in room SC240 or call 920-498-6901 for more information regarding the support services available to you.

Student Rights:  For additional information regarding your rights as a student, including college policies on plagiarism, student rights and other
services available at NWTC, please consult the NWTC Student Handbook, available through Student Services or on the NWTC webpage
at http://www.nwtc.edu

Course Calendar:  See next page.

Accounting – Automated Applications 10/25/2007 - 12/20/2007 (8 sessions no class on Thanksgiving Day Nov 22) Course Calendar
Session	Date	Topic	Chapter	Assigned Today	Due Today
		Prior to using the Textbook:
1	10/25	Windows and Hard Drive	N/A	Windows XP Assignment
1	10/25	Excel:  Amortization	N/A	Excel Project 1
1	10/25	Excel:  Invoicing	N/A	Excel Project 2	Windows XP Assignment
1	10/25	Excel:  Invoicing	N/A
2	11/01	Excel:  Financial Statements	N/A	Excel Project 3	Excel Project 1
2	11/01	Excel:  Financial Statements	N/A		Excel Project 2
2	11/01	Excel:  Depreciation	N/A	Excel Project 4	Excel Project 3
2	11/01	Excel:  Depreciation	N/A
		Using the Textbook: Computer Accounting 11th Ed
3	11/08	Intro to Bellwether Garden Supply	1	Chapter 1 Exercises	Excel Project 4
3	11/08	Vendor Transactions	2	Chapter 2 Exercises
3	11/08	Customer Transactions	3	Chapter 3 Exercises	Chapter 1 Exercises
3	11/08	General Ledger and Inventory	5	Chapter 5 Exercises	Chapter 2 Exercises
4	11/15	Financial Statements	7	Chapter 7 Exercises	Chapter 3 Exercises
4	11/15	Maintaining Accounting Records for Service Businesses	9	Chapter 9 Exercises	Chapter 5 Exercises
4	11/15	Maintaining Accounting Records for Service Businesses	9		Chapter 7 Exercises
4	11/15	Completing Quarterly Activities and Closing the Fiscal Year	10	Chapter 10 Exercises	Chapter 9 Exercises
5	11/29	Susan Clarke, Accountant	Project 1	Peachtree Project 1
5	11/29	Accounts Payable	11	Chapter 11 Exercises	Chapter 10 Exercises
5	11/29	Accounts Payable	11
5	11/29	Accounts Receivable	12	Chapter 12 Exercises	Peachtree Project 1
6	12/06	Accounts Receivable	12		Chapter 11 Exercises
6	12/06	Merchandise Inventory	13	Chapter 13 Exercises	Chapter 12 Exercises
6	12/06	Gallardo's Sports	Project 2	Peachtree Project 2
6	12/06	Gallardo's Sports	Project 2		Chapter 13 Exercises
7	12/13	Customizing Forms	15	Chapter 15 Exercises
7	12/13	Import/Export	16	Chapter 16 Exercises	Peachtree Project 2
7	12/13	Using PCA 2006 with Excel and Word	17	Chapter 17 Exercises	Chapter 15 Exercises
7	12/13	Inn Spot Peachtree Project – Chart of Accounts	N/A	Inn Spot Peachtree Project	Chapter 16 Exercises
8	12/20	Inn Spot Peachtree Project – Excel Schedule	N/A	PowerPoint Presentation	Chapter 17 Exercises
8	12/20	Inn Spot Peachtree Project – Default Information	N/A
8	12/20	Inn Spot Peachtree Project – Beginning Balances	N/A
8	12/20	Inn Spot Peachtree Project – Transactions	N/A
8	12/20	Inn Spot Peachtree Project – Profit Plan	N/A		Inn Spot Peachtree Project
8	12/20	PowerPoint Presentation	N/A		PowerPoint Presentation

 

Copyright © 1996 - 2007 Lloyd Cook
E-mail:
BS - Managerial Accounting - UW-Green Bay.
5 year teaching certificate - Accounting/Computer Applications -
  WI Technical College System
Certified Accelerated Learning Facilitator - NWTC-Green Bay
Adjunct Instructor (MS Office, Windows XP, Digital Photography, Scanners, Internet, E-mail & Web Design,
   All Accounting Courses, Economics & Credit Procedures) - NWTC-Marinette
Adjunct Instructor (Managerial Accounting) - Silver Lake College, Manitowoc, WI (NWTC-Marinette Campus)
Adjunct Instructor (MS Office, Windows, Adobe PhotoShop, Internet, Web Design, & College For Kids) UW-Marinette.
Certified Web Master. Member of: National Society of Accountants  International Webmasters Association (IWA)
 Internet Society (ISOC)  Html Writers Guild (HWG)
Last updated Tuesday, December 04, 2007 Home