Archives of Lecture Notes/Outlines

Week 1

Tuesday (April 1): Course Introduction

Topics (Lecture Outline):

1. Getting acquainted
2. Student background and expectations
3. Course overview, goals, and administrivia
4. A Quick intro to the WWW and Netscape
5. Introductory Notes: A Framework for Understanding Accouting Information Systems

Readings:

• Course Syllabus
• Chapter 1

Assignments:

• Fill out the Student Survey Form
• Assignment 1 -- Create a personal WWW homepage (due 4/15)

Thursday (April 3): Elements and Procedures of AIS

Topics (Lecture Outline):

1. AIS role in an organization
2. Business Activities and Information Needs
3. Overview of Accounting Transactions/cycles

Readings:

• Chapter 2

Assignments:

• Download and print the following tutorial documents (bring them with you on Tuesday 4/8):
  1. Excel Tutorial -- a WORD document covering the basics
  2. Excel Graphics Tutorial -- a WORD document on generating graphs and charts in Excel
• Read Chapter 7

Week 2

Tuesday (April 8): Modeling and Data Analysis Using Excel

Topics (Lecture Outline):

1. Spreadsheet Concepts
2. Modeling Concepts
3. Worksheet Building
4. Excel Graphics
5. Advanced Features

Readings:

• Download and print the following tutorial documents (bring them with you on Tuesday 4/8):
  1. Excel Tutorial -- a WORD document covering the basics
  2. Excel Graphics Tutorial -- a WORD document on generating graphs and charts in Excel

Assignments:

• Assignment 2 -- Using Excel (due 4/15)
• Assignment 3 -- Spreadsheet Modeling (due 4/17)

Thursday (April 10): The Technology of AIS

Topics (Lecture Outline):

1. Hardware Architecture

Readings:

• Chapter 7

Assignments (readings for next week):

• Chapter 8 (on Software)
• Chapter 9 (on Principles of Data Communications)

Week 3

Tuesday (April 15): The Technology of AIS: Software Architecture and Principles

Topics (Lecture Outline):

1. Software Architecture
2. Operating Systems
3. Application Software
4. Management Issues

Readings:

• Chapter 8

Thursday (April 17): Data Communication and the Internet

Topics: (see lecture outline)

1. Principles of Data Communications
2. Local Area Networks
3. Network/Internet Services

Readings:

• Read TB: Chapter 9
• Skim/browse through the EFF (Extended) Guide to the Internet
• Use as a reference - Glossary of Internet Terms

Assignments:

• Assignment 4 -- Sportswear Corporation (due 4/24)
• For discussion next week on Electronic Commerce read "The Business of the Internet", by Rawan Shah

Week 4

Tuesday (April 22): The Internet and Electronic Commerce

Topics (Lecture Notes):

1. The sturcture of the Internet
2. Overview of Electronic Commerce
3. What can the Internet do for Businesses?
4. Doing Business on the Interent
5. Internet Entrepreneurship

Readings:

• The Business of the Internet, by Rawan Shah, RTD Systems and Networking, Inc.
• Skim the following:
  • The Accidental Superhighway: A Survey of the Internet, The Economist, July 1, 1995.
  • The Death of Distance: A Survey of Telecommunications, The Economist, September 30, 1995.

Thursday (April 24): Electronic Commerce Issues

Topics (Lecture Notes):

1. EDI and Intranets
2. Business Implications

Readings:

• Can You Make Money on the Net? BusinessWeek, cover story, September 23, 1996.

Assignments:

• Assignment 5 -- WhizTech Corporation
• Chapter 6

Week 5

Tuesday (April 29): Database Management Systems

Topics:

1. The Data Processing Cycle
2. Fundamental Data Storage Concepts and Principles (notes on Data Representation)
3. File Organization and Access
4. Architecture of Database Management Systems (notes on DBMS)

Readings:

• Chapter 4

Assignments:

• Download and print the Access Tutorial document; bring it with you on Tuesday 5/6.

Thursday (May 1): First Examination

Week 6

Tuesday (May 6): Database Management Systems

Topics:

1. Introduction to the Relational Database Model
2. MS Access Tutorial

Readings:

• Chapter 5
• Introduction to Access (tutorial notes; download and print)

Assignments:

• Assignment 6 (due Tuesday, May 13)

Thursday (May 8): Relational Query Languages

Topics:

1. Return and go over the exam
2. Advanced query facilities in MS Access
3. Data Modeling Concepts

Readings:

• Chapter 6

Assignments:

• Read the background document "Designing a Database--Understanding Relational Design"
• Read Chapter 3 and 10 for discussion next week

Week 7

Tuesday (May 13): Data Modeling and Database Design

Topics:

1. Conceptual Modeling: the ER Approach
2. Introduction to Database Design

Readings:

• Chapter 6
• Read the background document "Designing a Database--Understanding Relational Design"

Assignments:

• Assignment 7 -- Database Design and Manipulation (due Tuesday, May 20)

Thursday (May 15): System Development Life Cycle

Topics: (see lecture notes)

1. Overview of Systems Development Life Cycle
2. Understanding System Development as a Change Process
3. The Investigation Phase

Readings:

• Chapters 3 and 10

Week 8

Tuesday (May 19): Systems Development Life Cycle

Topics: (see lecture notes)

1. Systems Analysis
2. Data Flow Diagrams
3. Systems Design and Implementation

Readings:

• Chapters 11 & 12

Assignments:

• Assignment 8 (due Tuesday, May 27)

Thursday (May 21): AIS Security and Control

Topics: (see lecture notes)

1. control and computer security concepts
2. Risk assessment
3. Systems Controls: General and Application Controls

Readings:

• Chapters 13 and 14

Week 9

Tuesday (May 27): Systems Controls (continued)

Topics: (see lecture notes)

1. discussion of cases in the handout on computer crimes.
2. Network and data Security
3. Computer Viruses and Worms
4. MS Access: DDE

Readings:

• Chapters 14 & 15

Assignments:

• Assignment 9 -- Sharing Data Across Applications (due Tuesday, June 3rd)

Thursday (May 29): Auditing Computer-based IS

Topics: (see lecture notes)

1. The nature of Auditing
2. Infrmation Systems Audits
3. Financial Audits and Computer Software

Readings:

• Chapter 16

Week 10

Tuesday (June 3): Artificial Intelligence and Expert Systems

Topics: (see lecture notes)

1. discussion of cases in the handout on computer crimes.
2. discussion of assignment 8
3. Intro to Artificial Intelligence
4. Expert Systems

Readings:

• pp. 256-260
• notes

Thursday (June 5): Wrap-up

Topics:

1. Trends in Computing
2. Some Demos
3. Career Tips
4. Review for Exam

Links:

• "Moore's Law Repealed, Sort Of", Wired Magazine, May 1997.
• Cable Modems, LEOS (Iridium, DirectPC)

Back to AMIS 531 Class Page

---

Waleed A. Muhanna / wmuhanna@cob.ohio-state.edu