COLLEGE OF BUSINESS AND PUBLIC AFFAIRS

Course Data Sheet

Spring Semester, 2008

 

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 external 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 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:  Spring 2008

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:/staff/bputman/

 

Office Hours:  M & W 1:00-3:30 PM

Publisher’s Website

http://www.mhhe.com/ulmer2007

 

Class meets: M & W 3:30-4:45 PM

 

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 two unexcused absences are excessive.  For each unexcused absence in excess of two, 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:

 

First Exam    (Chapters 1-3)                      100 Points        

Second Exam  (Chapters 4-6)                   100                                                                                      
Third Exam (Chapters 7-9)                        100                                                                                          
Final Exam                                                    100                                                  
Project 9-1                                                        25                

Project 10-1                                                     25                 

Homework                                                       25    

Attendance and Participation                      25                                                                                        
Total                                                               500  Points                                                                             

 Letter Grade Assignment

 

450-500 Points   -     A

400-449 Points   -     B

350-399 Points   -     C

300-349 Points   -     D

LT 300 Points    -     F

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. 

 

 

 

Ethics 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 course. 

  

 

 

                    

 

      Important Dates To Observe During the Semester

 

       Last day to add a course or drop with 100% refund----January 18, 2008

       First Exam-Chapters 1-3-------------February 6, 2008

       Second Exam—Chapters 4-6------------March 3, 2008

       Last day to drop a class, WD--------March 7, 2008

       Third Exam—Chapters 7-9-------------April 2, 2008

       Project 9.1 Due---------------------April 9, 2008

       Project 10.1 Due-------------------April 28, 2008

       Final Exam-Chapters 10, 11, 12----May 5, 2008

 


                                                                                                       TENTATIVE SCHEDULE

 

Date

Chapter

Topic

In Class Assignments

Homework Assignments and Due Dates; BSBA Statements

January 14

1

Course syllabus and requirements; Computer commands review

 

None

 

None

16

1

QuickBooks Tour; Basic Commands; Execution & Results; Navigation and Help commands

Saving and Retrieving Files

Text pp 1.4-1.24

Text pp 1.25-1.46

Exercise 1.1 Due January 23

BSBA 3; BSBA 5

21

 

HOLIDAY: NO CLASS: STUDY HARD

 

 

23

2

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

Text pp. 2.1-2.11

 

28

2

Displaying and editing chart of accounts; adding and deleting accounts

Text pp. 2.12-2.17

Text pp. 2.18-2.31

Exercise 2.1; Exercise 2.2; Exercise 2.3; Due January 30

BSBA 3; BSBA 5

30

3

Banking; View and print Check register; Writing checks; One-step and two-step approach;

Text pp. 3.1-3.13

Text pp. 3.13-3.18

 

February 4

3

Print Journal and reconcile bank statements

Text pp. 3.18-3.26

Exercises 3.1 and 3.2

Due February 11

BSBA 3; BSBA 5

6

 

Exam on Chapters 1-3

 

 

11

4

Customer lists; viewing, adding new customers;

Text pp. 4.1-4.11

Text pp. 4.11-4.23

 

13

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 February 18

18

5

Vendor lists and purchase orders; adding new vendors; Inventory items and lists; adding new items;

Text pp. 5.1-5.11

Text pp. 5.12-5.18

 

20

5

Printing lists; Create purchase orders; receive inventory and pay bills

Text pp. 5.19-5.45

Exercise 5.1; 5.2; 5.3; 5.4; Due February 25

BSBA 3; BSBA 5

25

6

Payroll setup and time tracking; Payroll and employee preferences;

Employee lists and time tracking

Text pp. 6.1-6.11

Text pp. 6.12-6.21

 

27

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 March 5

BSBA 3; BSBA 4

March 3

 

Exam 2-Chapters 4-6

 

 

5

7

The accounting cycle; Trial balance; Adjusting entries; Recording adjusting entries;

Text pp. 7.1-7.9

Text pp. 7.10-7.16

 

March 10-16

Spring Break!! No classes this week

 

17

7

adjusted trial balance; general ledger; Financial statements and income tax reports

Text pp. 7.16-7.28

Exercises 7.1; 7.2; 7.3; and 7.6

Due March 19

BSBA 3; BSBA 4; BSBA 5

19

8

New Company setup; Service Company; Proprietorship

Text pp. 8.1-8.19

24

8

Printing chart of accounts; Customer and vendor lists; Creating items list

Text pp. 8.19-8.24

Text pp. 8.24-8.27

Exercises 8.1 and 8.2; Due March 26

BSBA 3; BSBA 5

26

9

Accounting for owner’s original investment; Record purchase transactions

Text pp. 9.1-9.16

 

31

9

Record sales transactions;

Make adjusting entries and printing reports; closing

Text pp. 9.17-9.22

Text pp. 9.23-9.27

Exercises 9.1; 9.2; 9.3;9.4;9.5

Due April 7

April 2

Exam 3-Chapters 7-9

 

7

10

Create customer and vendor lists

Text pp. 10.1-10.15

 

9

10

Create inventory list; record transactions and print reports

Text pp. 10.15-10.21

Text pp. 10.21-10.41

Project 9.1 Due today

14

11

Setup a payroll; Enable payroll;

Calculate payroll manually

Text pp. 11.1-11.7

Text pp. 11.7-11.24

Exercises 10.1 and 10.3; Due April 14

BSBA 3; BSBA 4; BSBA 5

16

11

Printing payroll checks; journal entries; payroll liabilities and reports

Text pp. 11.25-11.35

 

21

 

11

Special payroll and payroll tax problems

Chapter 11 [Portable File] Due April 23

BSBA 4

23

Handout

Cash Flow Statement considerations: Illustrations of GAAP Cash Flow Statement presentation

Intermediate Accounting texts

Project 10.1 Due April 28 includes GAAP Cash Flow Statement

28

12

Cash Flow Statement continued

 

May 5

 

Final Exam on Chapters 10-12

12:45-2:45 PM