MIS 300
Management Information Systems: Concepts and Applications
 Fall 2009

>> It is always your responsibility to check the class announcement page to see updated information.
>> Please bring a rewritable CD or memory stick to save your work for lab sessions.
 >> Click HERE to visit Textbook Website

Instructor
Name:                    Yong Choi, PhD
Office:                    BDC 101
Office Phone:         (661) 654 - 6691
Email Address:       ychoi2@csub.edu 		Class
Office Hours:       
  - Tuesday (3:20 – 5:20pm and 7:30 – 8:00pm )
 - Wednesday (10:00am – 12:00pm)
 - Or by an appointment
 Venue:                BDC 163
Web Site:            www.csub.edu/~ychoi2/mis300.htm  

Information Links

 - Syllabus
 - Announcement
 - Group Information
 - Peer Evaluation
  - Midterm Guideline
 - GIS Code

 E-Commerce Project Resources:
 - EC Project Guide
 - EC Example 1
 - EC Example 2
 - EC Example
Group Project Part I
Group 1
 Group 2
Group 3		 Group 4
Group 5
Group 6		 Group 7
Group 8
Group 9

Course Schedule

 

 Week

Class Materials

 Assignment
  Tuesday Thursday  
 1 Introduction of Class
 - Class Overview
 - Triumph of the Nerds		 From Textbook and Textbook Website:
 - Ch 1: The Information Age in Which You Live
 - Get to know Access 2007
 - Choose between Access and Excel		 Assignment Format
 
Please find each assignment due date from our course WebCT
2

Supplement by Instructor: Chap 1 and 2
  - Create tables for a new Access 2007 database
DB Development: DB 1 Lecture
DB Lab Files: Restaurant 1

 From Textbook and Textbook Website:
 - Ch 2: Major Business Initiative
  - Design tables for a new Access 2007 database		 Assignment 1
3 Supplement by Instructor: XLM/A and Ch 9
DB Development: DB 2 Lecture
DB Lab Files: Restaurant 1, BillingAddress, FineFood,
DB Practice 1 Files: Course, Instructor, and Membership
DB Development Supplement: Composite PK, PK as FK, Referential Integrity Example, and importing process of Excel		 From Textbook and Textbook Website:
  - XLM/A: Computer HW and SW
 - Ch 9: Emerging Trend and Technologies

Hardware and Software Online Lectures
 - Chapter 1; Introduction to Computer Systems
  - Chapter 2: Analog and Binary Signals

 Assignment 2 
4 DB Development: DB 3 Lecture and DB 4 Lecture
DB Lab Files:  Restaurant 2-relationship and Restaurant3-queries
DB Practice 2 Files: Roadrunner, Roadrunner logo, NewRest and Loans		 From Textbook and Textbook Website:
 - Ch 3: Organizing Data and information		 Assignment 3
5 1st part EC group project (proposal):
 - Due: Oct 14 (Wed) - 17 (Sat)
  - Submit thru the WebCT 		From Textbook and Textbook Website:
 - Ch 5: Electronic Commerce
 - XLM/B: The World Wide Web and the Internet
 - XLM/E: Network Basics		 Assignment 4

FrontPage Tutorial
6 GIS Course Registration
In order to take GIS courses, you must register for each course. Please try the below tutorial for the registration.
 - Tutorial for ESRI Online Course Registration 
Since you are new to online ESRI self-study courses, I strongly recommend to try the following orientation.
 - Please click HERE for trying Flash Version of course orientation. Or click below    http://training.esri.com/courses/_shared2003/vc/vccourseorientation/flash_broadband/demo.htm 
 - Please click HERE for trying Non-Flash Version of course orientation. Or click below http://training.esri.com/courses/_shared2003/vc/vccourseorientation/orientation1.htm 
Introduction of GIS: This introduction of GIS website is like a our basic textbook. You will be able to learn about fundamentals of GIS. There are four GIS components you can try. Please try them all. I strongly recommend you to try "Introductory theory and concepts" first and then, "Interactive GIS examples."
 - Please CLICK HERE for introduction of GIS
DB Lab Files: Restaurant3
DB Practice 2 Files: Roadrunner, Roadrunner logo, NewRest and Loans
Click here for the Midterm
1st part EC group project (proposal):
 - Due: Oct 21 (Wed) - 24 (Sat)
 - Submit thru the WebCT 		Introduction to ArcView 3.X:
 - Module 1: Basics of ArcView
 - Module 2: Querying Data in ArcView 
 - Module 3: Working with Tables in ArcView		  
7 Click below link and try each subject
 Create a FrontPage Web site
 - About FrontPage Web Sites
 - How to create a FrontPage Web Site
  - Manage a web site using different views
 - How to create a web page
Website Development: Lecture Note 1
 - Files for the FrontPage Lab
 - Sunny Web Folder
Sample Website: Sunny Website		 Introduction to ArcView 3.X:  
 - Module 4: Analyzing Spatial Relationships Using ArcView
 - Module 5: Presenting Information in ArcView and
 - Module 6: Creating Your Own Data in ArcView

Assignment 5

 8 Con't Website Development
 - Sunny Web Folder (from the last class)
 - Order Form Page
 Website Development: Note 2		 From Textbook and Textbook Website: Ch 4: Decision Support Systems

 
9

Con't Website Development
 Shopping Cart: Example (free in Zip format)
 - FrontPage Tutorial: XLM/L
Supplement by Instructor: Chap 5

 From Textbook and Textbook Website:
 - Ch 6: IS Systems Development
 - Computer Crimes and Digital Forensics: XLM/H		 Assignment 6
10 Supplement by Instructor: Chap 4, EIS drill down example
Type of DSS Analysis: What-if Analysis and Goal-seek Analysis
2nd part EC group project (website):
 - Due: Nov 18(Wed) - 21(Sat)
 - Submit thru the WebCT or by web address 		From Textbook and Textbook Website:
 - Ch 7: Enterprise Infrastructure, Metrics, and Business Continuity Planning
 - Ch 8: Protecting People and Information		 Assignment 7

11

 Please take the final exam thru WebCT - Final Exam Instruction
- Final Exam Guideline