BUS 782 - Information Systems for Management, Spring 2012

Instructor: David Chao

Office: BUS 303, Phone: 415- 405-2594, email:dchao@sfsu.edu, website: userwww.sfsu.edu/~dchao

Office Hours: Mon: 1:45–3:35, 6:20-7 in BUS 303; Wed: 5-6:30 at Downtown Center, Room 575 (Phone:817-4363)

Course Description: This course is an introduction to computer applications and information systems for business management. Topics covered in the course include information technology for knowledge workers; basic personal computer applications including spreadsheet, database, and internet applications; characteristics and examples of different types of information systems including individual, workgroup, organizational, interorganizational, and international information systems; information system development; and end-user application development. By the end of this course you should have a general understanding of information technology and information systems. You should be able to discuss with computer professionals the basic information system needs at different levels of an organization. You should be able to use campus or other computer facilities to develop simple computer applications for a variety of common business problems.

Team Project: In addition to the computer assignments, you are required to complete a project in which you design and develop a simple computer information system for a real or hypothetical organization. You are to work in teams of two students on this project. Each team will have to select an organization, analyze the organization's requirements, and design an appropriate information system to meet the organization’s needs, and implement the system using Access. Each team will have to prepare a written report and presentation using PowerPoint on their project. Details of the project requirements will be discussed later in the class.

Textbooks:

(1) James O'Brien, George Marakas,, Management Information Systems, 10^th Edition, McGraw Hill

(recommended, not required)

(2) Efraim Turban, et al., Information Technology for Management, 4^th Edition, Wiley

Free download at: http://www.scribd.com/doc/60102949/Information-technology-for-Management-turban-4e

(3) Any Excel/Access book of your choice

Grading:

Assignments	20%
Project	10%
Three exams	70%

Assignments are due at the beginning of the due day’s class. Late assignments will receive up to 20% penalty. Assignments that are late for more than one week will not be accepted.

The lower limits for letter grades will be no lower than: A=93%, A-=90%, B+=87%, B=83%, B-=80%, C+=77%, C=73% , C-=70%, D+=67%, D=63%, D-=60%, F=0%. Grades will not be rounded.

Tentative Schedule:

Week	Date	Topic	Reading
1	1/25	Introduction to IT and IS	O'Brien 1, 2, 3, 4, 7
2	2/1	Introduction to IT and IS Spreadsheet design	O'Brien 1, 2, 3, 4, 7 Excel
3	2/8	Introduction to IT and IS Problem solving using functions	O'Brien 1, 2, 3, 4, 7 Excel
4	2/15	Problem solving using functions	Excel
5	2/22	Introduction to database	O'Brien 5
6	2/29	Database modeling and design with ERD Exam 1	O'Brien 5
7	3/7	Database modeling and design with ERD	O'Brien 5
8	3/14	Database implementation Using MS Access Database query language	Access
9	3/21	Spring Recess
10	3/28	Database query language	Access
11	4/4	OLAP with PivotTable Decision support systems	Excel O'Brien 10
12	4/11	Data warehouse and data mining	O'Brien 10
13	4/18	Introduction to telecommunication Exam 2	O’Brien 6
14	4/25	Introduction to E-Commerce	O’Brien 9
15	5/2	Information systems security Current topics in Information Systems	O’Brien 13
16	5/9	Project presentation and review
17	5/16	Exam 3

DISABILITY RESOURCE CENTER:

Students with disabilities who need reasonable accommodations are encouraged to contact the instructor. The Disability Programs and Resource Center (SSB 110) is available to facilitate the reasonable accommodation process. Requests for testing accommodations must be presented to the instructor two weeks prior to any quiz, test or homework deadline.