COLLEGE OF BUSINESS AND PUBLIC AFFAIRS

Course Data Sheet

Fall Semester, 2007

 

Course Number and Title: Accounting 461, Accounting Information Systems (3) hours credit

 

Course   Description: An introduction to information systems with emphasis on concepts of analysis, design, and implementation of accounting systems with attention to internal control and the audit trail.  Students will be working with a computerized accounting software package. Prereq: At least a grade of C in ACCT 301 and ACCT 321.

 

Course Text and Required Materials:

 

Computer Accounting with QuickBooks Pro 2007, 9th Ed. By Donna Ulmer ISBN 978-0-07-352683-6; McGraw-Hill/Irwin; New York, 2008; Students should also have access to a recent edition of an Intermediate Accounting text.  The Online Learning Center (OLC) at www.mhhe.com/ulmer2007 will be used to download data files for practice during the course.  Students will need to have storage media available to save and work with portable data files.  A 1 GB Flash Drive is recommended.

 

College Mission Statement:

 

The College of Business and Public Affairs, consistent with the overall mission of The University of Teunessee at Martin, develops graduates whose skills, abilities and ethical standards contribute to a diversified and dynamic society. With a primary focus on teaching, the College emphasizes quality undergraduate and graduate instruction and faculty commitment to student and regional development. Programs are delivered in an environment that encourages a broad understanding of the forces shaping global social, political and economic change. The College promotes and supports cooperative alliances with stakeholders and outstanding teaching, research, and service.

 

BSBA Learning Objectives related to the CBPA Mission:

 

BSBA 3 Demonstrate competence in Technology

BSBA 4 Demonstrate effective verbal and written communication skills

BSBA 5 Demonstrate competence in the Accounting Major

 

Course Specific Objectives: (As approved by accounting faculty)

 

The study of Accounting Information Systems has as its objective to provide the student with an understanding of:

 

·              how accounting principles are integrated into computerized accounting information systems that use double-entry methodology to account for business transactions,

·              the steps necessary to adapt accounting information learned from textbooks to computerized accounting information systems,

 ·             the steps required to set up an accounting information system based on an appropriate chart of accounts used as the focus point to record transactions using a computerized accounting information system,

·              how to generate all financial statements required by generally accepted accounting principles through use of computers,

·              how the general ledger and various subsidiary ledgers work in an integrated computerized accounting information system, and

·              how computers have impacted the construction, maintenance, and reporting of accounting information


 

 

Class Data Sheet

Instructor:

Dr. Robert L. Putman, CPA

 

Semester:  Fall 2007

Office:

315 Clement Hall

 

Phone:  (731) 881-7305 or (731)-352-5797

E-mail:

bputman@utm.edu

 

Fax:  (731) 881-7241

Web Location :

http://www.utm.edu:/~bputman/

 

Office Hours: 

M, W, & F 9:00-11:00

M & W 2:00-4:00

Publisher’s Website

http://www.mhhe.com/ulmer2007

 

 

Attendance Policy:

 

All students are expected to attend class and to participate in classroom discussion. Excessive absences will result in the student’s inability to pick up important instruction and tips regarding the workings of an accounting information system. More than three unexcused absences are excessive.  For each unexcused absence in excess of three, one (1) point will be deducted from the total of 25 allowed for satisfactory attendance and participation in the class. 


  Homework Policy: 

Homework consists of working problems assigned outside of class and are due at the start of the class meeting immediately after completion of the chapter.  If you cannot attend due to an excused absence, please e-mail or fax the Problems and/or Questions to me prior to class. For each problem not TURNED IN or INCOMPLETE WHEN SUBMITTED, one point will be deducted from your 25 point homework participation grade.  There will be no points awarded for late homework unless you have a valid excuse for such tardiness.  Homework will be turned in on hard copy printout or as an e-mail attachment as directed by your instructor.  Points will be awarded for each problem you turn in if it is substantially complete.  If you receive an S on the problem, it means that you received satisfactory credit for that problem.  If you receive a U on the problem, it means no credit was awarded for that problem, but you can complete it and turn it back in within a week and receive satisfactory credit

Special Projects:  There will be two special projects assigned in your text that must be turned in on hard copy printout format.  It is important that you make duplicate copies of these problems to insure that backup data is stored in case of loss of the media or otherwise destruction of the files.  Each of these special projects will count up to 25 points toward your course grade.  The projects are due as indicated on the tentative schedule that follows.


 Classroom

Participation 

 You will be expected to enter into classroom discussions.  This includes asking and answering questions, bringing real life situations into the classroom through initiating discussions about them, and your overall attitude demonstrated throughout the course.  We will be working on problems in this classroom that will be similar to your assigned homework.  So you can see that your participation in this classroom will be very important to you in earning your course grade.

    Grades: 

Final grades will be determined as follows:

 

Points earned will be converted to letter grades for the course as follows;

 

A = 450-500 points

B = 400-449 points

C= 350-399 points

D=300-349 points

F=Less than 300 points

 

 
First Exam (Chapters 1-3)             100 points         

Second Exam (Chapters 4-6)         100 points

Third Exam (Chapters 7-9)            100 points
Final Exam (Chapters 10-12)         100 points                                 
Project 9.1                                        25 points

Project 10.1                                      25 points

Homework                                       25 points

Attendance and participation          25 points

Total points available                     500 points 

 

 

Any student eligible for and requesting academic accommodation due to a disability is required to supply a letter of accommodation from Disability Services (PACE Office), Clement 203 (Extension 7605 or 7744), within the first two weeks of the semester. 

 

 

 

 

Ethical  Considerations

You may have noticed that one of the BSBA learning objectives is that the student will have an understanding of the ethical business aspects.  Doing business, as in all other endeavors of life requires high ethical conduct in order for society to exist and advance for the betterment of all.  You are encouraged to review the Standards of Conduct as listed in “Students Responsibilities” section of the student handbook.  Cheating in any form in this class will not be tolerated and could result in dismissal from the class. 



 

“REVISED”

TENTATIVE SCHEDULE

Date

Chapter

Topic

In Class Assignments

Homework Assignments and Due Dates; BSBA Statements

8-27-07

1

Course syllabus and requirements; Computer commands review

 

None

 

None

29

1

QuickBooks Tour; Basic Commands; Execution & Results;

Text pp 1.4-1.24

 

31

1

Navigation and Help commands

Saving and Retrieving Files

Text pp 1.25-1.46

Exercise 1.1 Due September 5

BSBA 3; BSBA 5

9-3-07

 

LABOR DAY: NO CLASS: STUDY HARD

 

 

9-5-07

2

Chart of Accounts; Retrieving and working with portable files; password protection

Text pp. 2.1-2.11

 

7

2

Balance Sheet and Income Statement Accounts; Lists

Text pp. 2.12-2.17

 

10

2

Displaying and editing chart of accounts; adding and deleting accounts

Text pp. 2.18-2.31

 

Exercise 2.1; Exercise 2.2; Exercise 2.3; Due September 12

BSBA 3; BSBA 5

12

3

Banking; View and print Check register

Text pp. 3.1-3.13

 

14

3

Writing checks; One-step and two-step approach;

Text pp. 3.13-3.18

 

17

3

Print Journal and reconcile bank statements

Text pp. 3.18-3.26

Exercises 3.1 and 3.2

Due September 21

BSBA 3; BSBA 5

19

 

Exam on Chapters 1-3

 

 

21

4

Customer lists; viewing, adding new customers

Text pp. 4.1-4.11

 

24

4

Editing customer lists; adding jobs; recording sales

Text pp. 4.11-4.23

 

26

4

Online billing; reminder statements; and recording cust-omer payments and bank deposits

Text pp. 4.23-4.39

Exercise 4.1 and 4.2

Exercise 4.3 BSBA 4

Exercise 4.4 BSBA 5

Due September 28

28

5

Vendor lists and purchase orders; adding new vendors

Text pp. 5.1-5.11

 

10-1-2007

5

Inventory items and lists; adding new items; printing lists

Text pp. 5.12-5.18

 

3

5

Create purchase orders; receive inventory and pay bills

Text pp. 5.19-5.45

Exercise 5.1; 5.2; 5.3; 5.4; Due October 5

BSBA 3; BSBA 5

5

6

Payroll setup and time tracking; Payroll and employee preferences

Text pp. 6.1-6.11

 

8

6

Employee lists and time tracking

Text pp. 6.12-6.21

 

10

6

Time transfer to sales invoices; calculation of payroll taxes; payroll reports

Text pp. 6.22-6.34

Exercise 6.1 and 6.3; Due October 15

BSBA 3; BSBA 4

12

 

Exam 2-Chapters 4-6

 

 

15

7

The accounting cycle; Trial balance; Adjusting entries

Text pp. 7.1-7.9

 

17

7

Recording adjusting entries; adjusted trial balance; general ledger

Text pp. 7.10-7.16

 

19

7

Financial statements and income tax reports

Text pp. 7.16-7.28

Exercises 7.1; 7.2; 7.3; and 7.6

Due October 24

BSBA 3; BSBA 4; BSBA 5

22

 

FALL BREAK!! STUDY HARD THIS DAY

 

 

24

8

New Company setup; Service Company; Proprietorship

Text pp. 8.1-8.19

 

26

8

Printing chart of accounts; Customer and vendor lists

Text pp. 8.19-8.24

 

29

8

Creating items list

Text pp. 8.24-8.27

Exercises 8.1 and 8.2; Due November 2

BSBA 3; BSBA 5

31

9

Accounting for owner’s original investment; Record purchase transactions

Text pp. 9.1-9.16

 

11-2-07

9

Record sales transactions

Text pp. 9.17-9.22

 

5

7

9

Make adjusting entries and printing reports; closing

Text pp. 9.23-9.27

Exercises 9.1; 9.2; 9.3;9.4;9.5

Due November 12

11-9-07

 

Exam 3-Chapters 7-9

 

 

12

10

Setup of merchandising company

Text pp. 10.1-10.15

 

14

10

Create customer and vendor lists

Text pp. 10.15-10.21

Project 9.1 Due today

16

10

Create inventory list; record transactions and print reports

Text pp. 10.21-10.41

Exercises 10.1 and 10.3; Due November 16

BSBA 3; BSBA 4; BSBA 5

19

11

Setup a payroll; Enable payroll

Text pp. 11.1-11.7

 

19

 

11

Calculate payroll manually

Text pp. 11.7-11.24

Project 10.1 Due November 28

21

 

Thanksgiving Holiday

 

 

26

11

Printing payroll checks; journal entries; payroll liabilities and reports

Text pp. 11.25-11.35

Exercises 11.1; 11.2;11.3 due November 30

BSBA 4

28

12

Budgets and Estimates

Text pp. 12.1-10

 

30

12

Progress billings and invoices

Text pp. 12.10-12.15

 

12-3-07

12

Credit card sales; bad debts and memorized reports

Text pp. 12.16-12.34

Exercises 12.1 and 12.2 Due December 5

BSBA 3

5

 

Problem resolution; question and answer session and catch-up session

None

None

7

 

Review for final exam; point reconciliation; wrap up

None

None

12-10-07

 

Final Exam on Chapters 10-12

 

 

 

 

      Important Dates To Observe During the Semester

 

     Last day to add a course or drop with 100% refund----August 31, 2007

     First Exam-Chapters 1-3-----------------------------September 19, 2007

     Second Exam—Chapters 4-6------------------------October 12, 2007

     Last day to drop a class, WD---------------------------------October 17, 2007

     Third Exam—Chapters 7-9-------------------------------November 7, 2007

     Project 9.1 Due----------------------------November 12, 2007

     Project 10.1 Due---------------------------------November 19, 2007

     Final Exam-Chapters 10, 11, 12----------------------------December 10, 2007