ACT115-1,
Computerized Accounting 3-credit
Course Outline – Spring
2006
Meets: Mon, Wed
11:00-12:20pm,
Instructor: Ms. Anna Boulware
Work Phone: 636-922-8328
E-mail: aboulware@stchas.edu
Office Location: Tech Building Room 205
Office Hours: M,W
8:25-8:55am,
12:30-2:00pm, or
T,
R 8:25-9:55am or by appointment.
COURSE TEXTS:
1. Excel Handout (given by teacher)
2. Computer Accounting With Peachtree
Complete for
Microsoft Windows, 8th ed, Release 11.0, Carol Yacht
3. Computer Accounting with QuickBooks 2005,
6th
ed., Donna Ulmer
COMPUTER HARDWARE/SOFTWARE:
¨ IBM PC using 3.5 disks and CD-rom
drive
¨ 1 jump drive (64MB or 128MB) (**Note- If you do
not have a
jump drive on your home computer you may want to use 31/2 disks
instead. You
will need approx 15 discs or one zip disk.)
COURSE DESCRIPTION:
Emphasizes application of computerized financial software used in
business. Topics include setting up a company, receivables,
payables,
inventory control, payroll, time tracking, job estimating and
spreadsheets.
COURSE COMPETENCIES:
During this course, the student will be expected to:
1. Demonstrate keyboard and mouse proficiency.
1.1 Operate keyboard and mouse to move within
programs.
1.2 Demonstrate knowledge of program function keys.
2. Access menu options.
2.1 Explain differences between the menu bar and
screen
navigators.
2.2 Identify the menu bar and its functions.
2.3 Identify the accounting systems.
2.4 Demonstrate alternative methods to perform tasks
using
menu bar or “navigator” pop-up windows.
3. Implement computer and disk security procedures.
3.1 Discuss ways to protect loss of data.
3.2 Demonstrate how to backup and restore company
data.
4. Assemble financial transactions.
4.1 Demonstrate procedures for entering the journal
entries.
4.2 Demonstrate procedures for entering the sales on
account
transactions.
4.3 Demonstrate procedures for entering the cash
receipts and
credit memo transactions.
4.4 Demonstrate procedures for entering cash
payments, bills
and debit memo transactions.
4.5 Prepare inventory transactions.
4.5.1 Prepare purchase orders.
4.5.2 Receipts of inventory.
4.5.3 Discuss need for inventory adjustments.
4.6 Enter depreciation data.
4.7 Prepare payroll transaction.
4.8 Demonstrate audit trail.
5. Select the integration procedures.
5.1 Set up chart of accounts.
5.1.1 Demonstrate proficiency in entering beginning
balances.
5.2 Set up account classifications.
5.3 Prepare customer master file and update customer
master
file.
5.4 Prepare vendor master file and update vendor
master file.
5.5 Prepare inventory master file and update
inventory master
file.
6. Demonstrate an understanding of computer output.
6.1 Prepare a trial balance.
6.2 Prepare a balance sheet and income statement.
6.3 Prepare a post-closing trial balance.
6.4 Explain the statement of cash flows.
6.5 Prepare depreciation reports.
6.6 Prepare inventory reports.
6.7 Prepare payroll reports.
7. Demonstrate proficiency in using and creating
spreadsheets.
7.1 Use basic formulas, formats and functions in
creating
worksheets
7.2 Prepare charts using worksheets
HOMEWORK ASSIGNMENTS:
Assignments and schedule for each chapter are listed below.
However, I
reserve the right to add or delete from the list at my
discretion. All
assigned exercises must be completed and turned in (when applicable) on
time. Assignments will be due the next time which class
meets.
Partially complete problems receive no credit. Late
assignments (no
more than one class day) are automatically discounted 30%.
Assignments
turned in after this time will receive no credit.
****IMPORTANT ALL ASSIGNMENTS MUST BE COMPLETED IN ORDER TO
RECEIVE A
GRADE for the class!!
|
Due Date |
Lesson and Assignments |
Due 1/23 Excel lessons 1-3 (in Handout)
Read and complete all 3
lessons including What-if
analysis
at end of each lesson. Turn in for grading—Skill Review
lessons
1-3. (60 points)
Due 1/30 Excel lesson 4-5 (
in handout) Read and complete both lessons including
What-if
analysis at end
of each lesson. Turn in for grading—Skill
Review lessons 4-5. (40 points)
Turn in Excel for Windows Supplemental Test covering
chapters 1-5
(50 points)
Due 2/06 QuickBooks chapters 1-3 (skip
pgs 3.26-.31online banking) Print only Activities 1.1 & 1.2. 2.1,
2.2, 2.3 3.1 & 3.2
Tear off or copy “print out
Checklist ” at end
of each chapter and attach to top
of assignments.
Due 2/13
QuickBooks chapters 4-6 Print only
Activities
4.1 - 4.4., 5.1- 5.4, 6.1
-
6.3 Tear off or copy “print out Checklist ” at
end of
each chapter and attach to
top of assignments.
Due 2/20 QuickBooks chapters
7-8
Print only Activities 7.1 - 7.2.
8.1-8.4, Tear
off or copy “print out Checklist
” at end
of each chapter and attach to top of assignments.
Due 2/27 QuickBooks chapters 9, proj
9.1 Print only Activities 9.1 - 9.5 (includes WebQuest
exercise). Tear off or copy “print
out Checklist
” at end
of chapter and attach to top of assignments.
Complete project 9.1 (100 points) Tear off or copy Printout Checklist
and
attach to top of project.
Due 3/06 QuickBooks
chapters
10--print off reports on pg 10.45-pay special attention to step
5
on pg 10.40, which asks
you to circle some accounts. No additional activities or printouts are required in this chapter.
Complete Project 10.1 (100 points),
Tear off or copy Printout Checklist and attach to top of work
and of
Project 10.1
Due 3/20 QuickBooks
chapters
11-- Do chapter work only! No additional exercises are required in this
chapter. Use
printout
checklist on page 11.41
QuickBooks
chapters 12-- Do chapter work only! No additional exercises are
required in
this chapter. Use
printout checklist on page 12.42
Due 3/27
Peachtree chapters 1-3 complete
the
Exercises at end of each chapter . (20 points total for each
chapter.
Total=60 points)
IMPORTANT**Before printing chapter 5 work, make sure to correct
any
errors you made in previous chapter exercises otherwise totals
will
be off.
Due 4/03 Peachtree chapters 4 and 5
complete the
exercises at end of the chapter. (20
pts each).
Chapters 1-4 of Murder
Mystery
handed out. These chapters (1-4) will be due 4/26 and are worth 20
pts for
each chapter (total 80 pts).
Due 4/10 Peachtree chapters 6, 7 and
8
complete the exercises at end of both chapters. (20 pts each).
Due 4/17 Peachtree chapters 9 and 10
complete the
exercises at end of both chapters. (20 pts each).
Due 4/24 Peachtree chapter Project 1. ( 100pts
pg
364 lists the printouts you must submit. In addition complete pg
365
and submit.
Hint**remember
to check your trial balance numbers on your printout of check figures)Chapters
1-4 of Murder Mystery are
due on 4/26!! Chapters 5-6 of Murder Mystery will be handed
out and
will be due at the end of last class.
Due 5/01 Peachtree
chapter 11
and 12. Complete the exercises at end of each chapter. (20pts
each)
Due 5/08
Peachtree chapter 13 and 14-hint**(On
Ex
14.1 choose CA first in the state
field, then Tri-met
will pop up--
then type OR in
state field again.) Complete the exercises at end of each
chapter
(20 pts each).
Due 5/10
Chapters
5-6 of the Murder Mystery due 5/10 (40 pts)
Evaluation:
|
Excel Completion of all lessons and Skill Reviews ( lessons 1-3, 4-5) |
100 points |
|
Excel for Windows Supplemental Test covering lessons 1-5 |
50 points |
|
Quickbooks Completion of all chapter Practice exercises (11 chapters & 27assignments @ 5 ) |
190 points |
|
Quickbooks Proj 9.1 |
100 points |
|
Quickbooks chapter 10 |
40 points |
|
Quickbooks Proj 10.1 |
100 points |
|
Peachtree Matching and exercises (14 chapters @ 20 pts each) |
280 points |
|
Peachtree Project 1 |
100 points |
|
Murder Mystery chapters 1-6 (20 pts each) |
120 points |
|
Total points possible |
1080 points |
|
A= 90% B=80% C= 70% D=60% F= Below 60% of 1080 points |
|
ATTENDANCE:
Roll is taken at
each class
meeting. Students are expected to attend all classes. If a
student
is ill or has some other reasonable excuse, the instructor should be
contacted
prior to class. If it is not possible to reach the instructor,
then leave
a message on e-mail or with the instructor’s voice mail.
Any
student that does miss a class should contact a fellow student to get
assignments and class notes.
GRADING:
Homework should be
turned in
at the beginning of class. Any quizzes, exams/projects will be
turned in
at the beginning of class unless otherwise notified. Homework
will be
graded and returned to you within two class periods.
ADDITONAL NOTES: Having the
ability to
manage information and the possession of higher order thinking skills
are
essential in today’s business/accounting environment. In
order to
strengthen these skills, assignments have been chosen to help the
student
exercise his/her ability to manage information and to utilize that
information
in order to make decisions.
STUDENTS WITH DISABILITIES: The
college has an Office of Accessibility
Services which
guides, counsels and assists students with disabilities. It is
located in
room 1206 of the ADM building. It is your responsibility to
discuss with
the instructor during the first week of class anything needed to help
you
succeed. If you have special needs, please call Pam Bova
(922-8247) in the Office of Accessibility Services so that your
eligibility for
services can be determined.
**LAST DAY TO DROP A CLASS AND RECEIVE A “W” IS Mar 31.
It is the student’s responsibility
to drop
a class. Non-attendance does not constitute a drop.