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.
| 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 |
ch 14: project management; Access 3, Access Assignment 3 (advanced queries) |
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 |
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)