sfsuISYS 363 Spring 2011 Information Systems for Management

Instructor: Brenda Mak bmak@sfsu.edu      Science 345,   Telephone: 415-405-0595
Office Hours:  Tuesday Thursday 3:25pm-5:10pm;9:45pm - 10:00pm, and by appointment only.
Class Schedule:
ISYS 363-03(schedule # 13569) Tuesday 7:00pm-9:45pm (BUS 138 / BUS 214)
ISYS 363-04(schedule # 13570) Tuesday 2:10pm-3:25pm (TH 335) Thursday 2:10pm-3:25pm (BUS 214)
Textbooks:
Management Information Systems: Managing the Digital Firm (ISBN-10: 0132304619) (student web site) (amazon web sites)

References:
1. Exploring Microsoft Office Excel 2007 Comprehensive by Grauer, Mulbery, Scheeren
2
. Exploring Microsoft Access 2007 Volume 1 by Grauer, Lockley, Mulbery (amazon website)
3. Dreamweaver 8: Complete Concepts and Techniques, by Shelly, Cashman, Wells, and Freund, Thomson, Course Technology, ISBN: 1418859923.
(www.dreamweaver.com free trial download for 30 days) or Macromedia Dreamweaver 8 -- illustrated introductory by Sherry Bishop (amazon's web site)

4. Electronic Commerce: A Managerial Perspective 2006 by Efraim Turban, Dave King, Jae Kyu Lee, and Dennis Viehland: , 4/E, Prentice Hall, 2006, ISBN: 0-13-185461-5 (T)

5. Required: Mannino, Database Application Development & Design, McGraw-Hill Irwin, 2007, 3rd edition, ISBN-13 9780072942200   (online learning center)

Grading

Project progress report 5%; final deliverable 15%

20%
Exams midterm 20%; final 35%
55%
Assignments
ExcelA1:3%, ExcelA2:4%, Excel A3: 3%
Dreamweaver A1: 2%, DreamweaverA2: 3%
AccessA1: 3%, AccessA2: 3%, Access A3: 3%
Total for assignments: 24%
Attendance
1%

Project: Students are to work on a project, in groups of 2 to 3, to develop a website for a company. The website shows the pictures and prices of company products, and location of the company. In addition, the index page links to a pdf file showing the ERD of the database for the company, and an access database for the company. The index page also describes capabilities and benefits of the system. For more details, refer to Project specification.

Assignments: There are 8 assignments, due one week after we work on them in the lab. Assignments are to be emailed to the instructor. For each assignment, if there are errors in the assignment submitted the first time, students can redo and resubmit it a second time to improve the assignment score.

Philosophy of Teaching : The objective of this course is to study the use of information technology. Students will learn the the concepts in management information systems, and how to integrate information system to the management of business companies. Students will learn to define the requirements of a good system. Students will develop capacities for synthesis and analysis in class discussions and a semester project on evaluation and development of mock internet system in business to increase international exposure in a multicultural context. Students will gain understanding and knowledge in the impact and significance of information technology worldwide.

Topics covered in the course: (i) organizations, management and the networked enterprises; (ii) Informationa technology infrastructure, including hardware, software, telecommunications, system security; (iii) digital applications, such as enterprise applications and e-commerce; (iv) building systems and project management. In addition, students learn to use Excel and Access for information management. These topics will be approached using a combination of lectures, readings, assignments, and class discussions. Students are encouraged to apply the concepts learned in class to analyze systems in the real world.

Education is a cooperative effort that involves active participation from both the instructor and the students.  Students are expected to engage actively in the learning process and to provide feedback on what they have expected to learn in the course and whether the materials covered in classes and homework assignments are helping them achieve their desired outcomes. As such, students should participate actively in going through the lecture materials, reading the texts and extra handouts, and doing the assignments and projects. Please do not hesitate to ask the instructor if there are questions, even during the course of a lecture. If you are confused, it is likely that someone else is also confused. To facilitate this process of  mutual learning and growth, we do not allow any behavior that would disrupt the classroom learning process.  Students should respect the rights of others seeking to learn.  All cellular phones or pagers should be turned off, or put on vibrant mode if they are needed for emergency purposes.  There should not be any talking during lectures and presentations.  If there are questions, bring them to the class. Our goal is to allow every student to devote his or her attention on learning.

Academic Honesty :
Students are expected to follow the highest principles of academic honesty. Any work a student turns in should be the work of the student, and no answers to homework assignments or examinations should be "given away". Students may, however, discuss with one another, but each should develop his or her own final version of the assignment. Students may borrow models (codes or concepts) for the assignments, but must cite the models (codes or concepts) taken from elsewhere with comments that specifies the original author, the date and version of the model, a summary of the modifications made to the model, and instructions for getting the original model. This applies to the models (codes or concepts) obtained from the web, the lectures, the text and elsewhere. Under no circumstances will cheating or plagiarism be allowed. Penalties for academic misconduct range from F for the course to expulsion from the university. For more information, refer to the University Catalog (Policies and Regulations).

Services for Students with Disabilities :
The University is committed to providing reasonable academic accommodation to students with disabilities. Individuals with physical, perceptual, or learning disabilities (as addressed in the Americans with Disabilities Act) who need reasonable accommodations are encouraged to contact the instructor. The Disabilities Resources Center (Student Services Building 110, telephone: 415-338-2472) is available to facilitate the reasonable accommodations process.


Class Schedule
Important Dates:Feb 4: Last day to add/drop classes, Feb 18: last day for late add by exception; Mar 18: last day to request CR/NC option, Apr 22: withdrawal deadline.

Week
Material Readings/ Homework

1:D-Jan25,27; E-Jan 25

Introduction. ch1: Role of information system in business, DreamweaverA1.ppt, Dreamweaver A1.doc

Laudon 1

2:D-Feb1,3; E-Feb1

ch2: e-business, Project specification, DreamweaverA2.ppt, DreamweaverA2.doc

Laudon 2, Sample Project: Long Beach Island Spa, Herbal Experience, Sushi Bistro
3: D-Feb8,10;E-Feb8

ch3: Organizations, Excel: generating reports and Pivot tables, ExcelA1

Laudon 3
4: D-Feb15,17;E-Feb15

ch4: ethical and social issues in information systems, Excel IF function & database functions, ExcelA2

Laudon 4
5: D-Feb22,24; E-Feb22

ch 7: Telecommunication and wireless (Internet privacy), capital budgeting using excel spreadsheet: Excel A3, Project Progress Report

Laudon 7
6: D-Mar1,3; E-Mar1 Excel: More excel functions, Exam 1 review  
7: D-Mar8,10;E-Mar8
Exam 1 (bring scantron Form 882-E , paper, and pencil) (Day class: meet in BUS 209 Lab C on Mar 8 for exams on Laudon related to Laudon texts & powerpoint; BUS 214 on April 14 for Excel exam) (Evening class: meet in BUS 214 at 7pm on Mar 8) Laudon 1,2,3,4,7; Excel Notes & slides  
8:D-Mar15,17;E-Mar15
ch 6: databases, Introduction to Access : Access Assignment 1 (create an access database)

Laudon 6

9:D-Mar22,24;E-Mar22

ch 13: Building system, Access 2, Access Assignment 2 (develop queries)

Laudon 13

10: Mar 29,31
Spring Recess  
11:D-Apr5,7; E-Apr5
Laudon 14
12: D-Apr12,14; E-Apr12

Project Progress Report Presentation (Day class: meet in BUS 209 Lab C on April 12; BUS 214 on April 14) (Evening class: meet in BUS 214 at 7pm on April 12)

Project Progress Report (Day class due date: April 14; Evening class due date: April 12)

13: D-Apr 19, 21; E-Apr19

ch 8: security: digital crimes, hacking, virus protection, privacy , ch9: supply chain management, customer relationship management,

Laudon 8, 9
14: D-Apr 26, 28;E-Apr26 ch 10: e-commerce, final review Laudon 10
15: D-May3,5; E-May3 work on final deliverable (Day class: we will have classes in BUS 214 on May 3 and 5) (Evening class: we will be in the lab May 3 starting at 7pm)  
16: D-May10,12; E-May10 presentation of final deliverable (Day class: we will have classes in BUS 214 on May 10 and 12) (Evening class: we will be in the lab on May 10 starting 7pm) Project Final Deliverable Report due May 10
17: May 17 Final Exam (bring scantron Form 882-E , paper, and pencil) Day class: 1:30pm-4:00pm; Evening class: 7pm-9:30pm Laudon 6,13, 14, 8, 9, 10 Access Notes & slides
Note: The teaching plan is subject to change depending on the background, interests and feedback of students taking the course.

More lectures on dreamweaver for your reference: DreamweaverLab1, DreamweaverMultimedia, DreamweaverReservationForm&Calendar

Dreamweaver Rollover images (Rollover.html) , Using frames in dreamweaver: Frames versus Tables

Dreamweaver Write text over image (example), Other tools: Using image maps (example), using animation (example), using popup (example)