MIS 300
Management Information Systems: Concepts and Applications
 Fall 2008

>> 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.

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

Information Links

Course Schedule

 

 Week Topic/Readings Class Source Assignment
 1 Introduction of Class
 Ch 1: The Information Age in Which You Live
Ch 2: Major Business Initiatives		 Class Overview
Chapter 1 and 2 Lecture Note		 Assignment 1
 Assignment Format
2 XLM/A: Computer HW and SW
 Hardware and Software Online Lectures
 - Chapter 1; Introduction to Computer Systems
  - Chapter 2: Analog and Binary Signals
 - Chapter 3: Computer Memory
 - Chapter 4: The Processor
Ch 9: Emerging Trend and Technologies		 XLM/A and Chapter 9 Lecture Note 

 Additional HW and SW information:
How microprocessors work?
 Technical Glossary 		 Assignment 2
 
Database Development
  - Hard Copy of XLM/J (Office 2003)
 - XLM/J in the textbook uses 2007
 DB 1 Lecture Note 		DB Lab 1 Files: 
  - Restaurant 1, BillingAddress, and FineFood
  - Restaurant 2 for relationships
Introduction to Access
 - Get to know Access

 

3 & 4 DB 2 Lecture Note
DB 3 Lecture Note
DB 4 Lecture Note

Database Development Supplement
  - importing process of Excel file
  - Composite PK
  - PK as FK
  - Referential Integrity Example

Ch 3: Organizing Data and information

 		DB Practice 1 Files: 
  - Course, Instructor, and Membership

DB Lab 2 Files: 
  - Restaurant3 for queries

DB Practice 2 Files: 
  - Roadrunner, Roadrunner logo, NewRest, and Loans

Chapter 3 Lecture Note 		 
Oct 1
Online
  1. Table that data
  2. Queries I: Get answers with queries
  3. Queries II: Limit your results and calculate values
  1. Queries III: Create parameter queries that prompt users for input
  2. Reports I: Show off your data
  3. Forms I: Create a form to enter and view your data
  4. Forms II: Use subforms
5 Midterm Part I (10 points): take-home
  - Due Date:  Monday, Oct 13 by 11:00PM
  - Complete and submit XLM/J for Office 2003 thru WebCT. Click HERE to download the XLM/J
 - Don't do "Assignments and Exercises."
 - As long as I do not see any major problem, you will be fine. 
 - If you’d like, you can assign your own name for each (query, repot and form).
 - Only do the first two quesries. So, total number of queries will be two.
 - Only do the first Report. So, total number of reports will be only one.
 - Only do the first Form. So, total number of forms will be only one.
Midterm Part II (50 points):  in-class exam
  - Exam Date: Wednesday, Oct 15		  
1st part EC group project (proposal):
  - Presentation: Monday, Oct 20
 - Due: Wednesday, Oct 22
  - Turn in the proposal slides thru the WebCT by 11pm on presentation day.
6

Ch 4: Decision Support Systems
DSS Types:
  - What-if Analysis Example
  - Goal-seek Analysis Example

DSS Development:
  - 401K DSS Lecture Note

Chapter 4 Lecture Note
  - EIS drill down example

Files for DSS Development:
  - 401K DSS Worksheet
 - 401k Handout
 - DSS Practice

 MS Excel Tutorial

Assignment 3

 7 Website Development
 - FrontPage Tutorial from the Textbook (XLM/L)
  - Files for the FrontPage Lab
 - FrontPage Resource

Ch 5: Electronic Commerce
 

 FP Lecture: Note 1 and Note 2
Shopping Cart: Example (free in Zip format)
Sample Website
 - Sunny Website

Chapter 5:
 - Lecture Note 1: Cookie Example
 - Lecture Note 2: XLM/E for Network Basics (p.243)

 MS FrontPage Tutorial

Review of HTML

In order to take GIS courses, you must register for each course. Please try the below tutorial for the registration.

Since you are new to online ESRI self-study courses, I strongly recommend to try the following orientation.

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. This website covers followings;
8 Introduction to ArcView 3.X:
 - Please download a trial SW of ArcView 3.X from the ESRI's website.

Website Development (con't)

Ch 5: Electronic Commerce (con't)
 

 GIS Lecture 1: Monday
Module 1: Basics of ArcView
Module 2: Querying Data in ArcView 

Chapter 5:
 - Lecture Note 3
 - Lecture Note 4


 
9

Website Development (con't)

Ch 6: IS Systems Development
 - Chapter 6 Lecture Note

GIS Lecture 2: Monday
 Module 3: Working with Tables in ArcView
Module 4: Analyzing Spatial Relationships Using ArcView

Computer Crimes and Digital Forensics
  - XLM/H on page 360 - 400
 
10 2nd part EC group project (website):
  - Due on: Wednesday, Nov 19
 - Submit thru the WebCT or by web address

Ch 7: Enterprise Infrastructure, Metrics, and Business Continuity Planning

Ch 8: Protecting People and Information

 GIS Lecture 3: Monday
 Module 5: Presenting Information in ArcView
Module 6: Creating Your Own Data in ArcView
Chapter 7 Lecture Note
Chap 8 Lecture Note		  

11

 Final exam:  - Final Exam Key Words
 - Focus on lectures and textbook