Accounting Information Systems

Accounting Information Systems

AC 415

Summer, 1998

Instructor: Ron Clark

Office: 301 Lowder Business Bldg.

Office Hours: MW 2-5p.m. Others by appointment

Phone: 844-6221

EMail: rclark@business.auburn.edu

Web Page www.auburn.edu/~clarkrl

Required Text: Moscove, Simkin & Bagranoff, Core Concepts of Accounting

Information Systems, 5^th ed. (1997)

Grauer & Barber, Exploring Microsoft Office 97 Professional, Vol. 1.

(1998)

Arens and Ward, Systems Understanding Aid, 4^th ed. (1995)

Grading: Exam 1 100

Exam 2 100

Final 100

Projects 75

Total Points 375

A = 337

B = 300

C = 262

D = 225

F = Below 225 pts.

Course Objective:

This course introduces you to Accounting Information Systems. You will learn just what an AIS is and how it is used to generate accounting information. Through the course projects, you will also develop skills in building and evaluating AIS. The course materials and lectures will also provide you with information about career opportunities in the field of AIS.

Course Projects:

Seven projects have been developed to help you learn and understand AIS concepts. Due dates are indicated on the Course Schedule. There will be a 50% reduction in points for projects turned in after the due date. All projects are to be completed individually. In each of the projects except number one, you are required to turn in a diskette containing your files. Make sure you have a backup. Professors have been known to misplace student projects. I would hate for you to have to redo the projects.

Project 1: The System Understanding Aid (15 pts.)

This project helps you understand the foundations of accounting systems through a manual practice set. Most of the concepts discussed subsequently in the course are based on documents, procedures, and techniques learned in the SUA. In completing the SUA, use Option 1 on page 8 and prepare documents as discussed on page 9 (see word Yes in the box). The SUA is due at the beginning of class on July 2.

Project 3 will use Document No. 24, Waren Distributing Year-End Worksheet. Make a copy of this worksheet before turning in the SUA for grading. Project 5 will use the Sales in the Sales Journal. Copy the journal before turning in the SUA. Project 6 will use the Accounts Receivable Subsidiary Ledger, pages 36 and 37 in the workbook. Copy these two pages before turning in the SUA.

Project 2: The Grade Book Spreadsheet (10 pts.)

The first chapter on Excel in the Microsoft Manual has you build a simple grade book. Starting on page 101, the manual takes you through a revision of that grade book and introduces you to several important spreadsheet features. On page 111, the manual refers to a file Expanded Grade Book in the Exploring Excel folder. You can download this file from the COB network and then start the tutorial. The project ends on page 121. Follow the instructions and perform all tasks. Turn in on July 16 your diskette containing the Grade Book file and all printed reports. Do not turn in separate diskettes for the spreadsheet projects (#2, #3, and #4). Put all three on the same diskette.

Project 3: A Spreadsheet Trial Balance (5 pts.)

Build an Excel spreadsheet using Document No. 24, Waren Distributing Year-End Worksheet from the SUA. I will randomly change various numbers to test the design and functioning of your spreadsheet. Turn in on July 16 your diskette containing the Worksheet spreadsheet. No printed material is necessary. Do not turn in separate diskettes for the spreadsheet projects (#2, #3, and #4). Put all three on the same diskette.

Project 4: Spreadsheet Graphs (5 pts.)

Complete the requirements for Number 3 on page 182, Excel, in the Microsoft manual. Print out each graph. Turn in July 16 your diskette containing the Graph spreadsheet. Do not turn in separate diskettes for the spreadsheet projects (#2, #3, and #4). Put all three on the same diskette.

Project 5: Building a BASIC Input System (10 pts.)

Design and program a Sales Input System using BASIC. Enter the Sales from the SUA. Your system should consist of at least three parts: (1) A screen that provides the user three options - Input Sales, Print Sales Journal, and Exit. Name your BASIC program SLSSYS. (2) A sales input option that allows the user to input sales and store the sales in a file. Name the data file SALES. (3) An option that allows the user to print, in good form to the screen, the following sales information - Date, Customer Number, Amount (not necessary to print to a printer). Turn in your diskette containing the BASIC program for grading. Put Projects 5, 6, and 7 on the same diskette. Project due August 20.

Project 6: Building an Access Database (15 pts.)

This projects requires you to use Access to build three files (tables), two input FORMS, and generate two reports based on information from the SUA.

Files (tables):

Customer file. Name file CUSTOMERS and include fields for customer name and customer number (CUSTNO). Make the customer number the primary field. Create an input FORM and enter the five customers (ignore Reliance Electric).

Sales file. Name file SALES and include fields for customer number, date, invoice number, and amount. Make the invoice number the primary field. In your SUA instructions book you will note on page 37 that customers Saginaw Sales & Service and Okemos Housewares have beginning balances on October 1. Record these amounts in the SALES file as October 1 sales. Create an input FORM and enter each of the sales for October, November, and December (see amounts below).

Cash Receipts file. Name file CASHREC and include fields for customer number, date, invoice number, and amount. Do not create a primary field.

In your SUA instructions book you will note on page 36 that customer Hanover Hardware has Credit Memos for November 6 and December 23. Also notice that customer Okemos Housewares has a write-off on December 23. Treat these three items as cash receipts. We will also assume that all sales are on credit. Therefore, enter the cash receipts from pages 36 and 37, not from the Cash Receipts Journal (see amounts below). Create an input FORM and enter each of the receipts for October, November, and December.

Inputs:

You should have the following Sales and Cash Receipts to enter:

Sales Cash Receipts

22,748.00 19,000.00

13,500.00 13,500.00

9,850.00 2,500.00

24,687.50 24,687.50

7,315.00

14,025.00 8,215.00

5,810.00

6,700.00 6,700.00

1,716.00 1,060.00*

656.00*

500.00

13,300.00 13,300.00

850.00

9,679.00 9,679.00

850.00

*Add these two numbers together and enter as one cash receipt.

Reports:

Create and print the following reports.

Sales Journal. Include customer number, customer name, date, invoice number and amount. Note, you must define a relationship between the Customer and Sales files.

Cash Receipts Journal. Include customer number, customer name, date, invoice number and amount. Note, you must define a relationship between the Customer and Cash Receipts files.

Grading:

Turn in for grading a diskette containing you database (all tables, forms, and reports) and copies of your printed reports. I will enter additional data to make sure your forms and reports work properly. Grading will be based on the following:

Functioning of the system 80% of points

Design of the system 20% of points

Based on the above grading scheme, you will be rewarded for adding features to your systems and for making it "look professional." Project is to be turned in on August 20. Turn in projects 5, 6 and 7 on the same diskette.

Project 7: Creating An Accounts Receivable Query Report (15 pts.)

In this project you will create an Accounts Receivable report based on a query. I will give you additional instructions on how to complete the project later in the course. Grading will be based on the following:

Functioning of the system 80% of points

Design of the system 20% of points

Course Schedule
Date	Topic	Assignment
H - 06/18	Overview of AIS and Course Introduction to Manual Systems	Chapter 1 System Understanding Aid
	Foundations of an AIS
T - 06/30	Processing Transactions Transaction Cycles	Chapter 4 Chapter 5
	Automating the Accounting System
H - 07/02	Computer Hardware/Software Review Systems Understanding Aid	Chapter 2 SUA project due
T - 07/07	Building Spreadsheets	Excel 97 (pp. 1-74)
H - 07/09	The Spreadsheet Projects	Excel 97
T - 07/14	Examination #1
	Building Computer-based AIS
H - 07/16	Design Documentation File Structures Building Files Using BASIC	Chapter 3 Chapter 6 (pp. 125-132) BASIC Handout Spreadsheet projects due
T - 07/21	BASIC Programming	BASIC Handout
T - 07/28	Databases and modeling	Chapter 6 (pp. 132-144)
H - 07/30	Examination #2
T - 08/04	Designing files and input forms	Access 97 (pp. 1-77)
H - 08/06	Designing Reports and Queries	Access 97 (pp. 87-127)
T - 08/11	The Database Projects	Access 97
	Risk Analysis and Auditing the AIS
H - 08/13	Internal Control Structure Controls for AIS	Chapter 8 Chapter 9
H - 08/20	Auditing the AIS	Chapters 10, 11 BASIC & Database projects due
F - 08/28	Final, 5 - 7:30 p.m.