MIS 300 (winter 2013)
Management Information Systems: Concepts and Applications

** If you email me using your private email (NOT by the Blackboard email) after 10 days of the first class, I will not reply **
** If it is an emergency, please email me using your private email to ychoi2@csub.edu
** If you have any Blackboard related problems, please contact CSUB E-learning service at 654-2315 **

Instructor
Name: Yong Choi, PhD
Office: BDC 152
Office Phone: 654 - 6691
Email Address: ychoi2@csub.edu 		Class
Office Hours:
 - Tuesday (3:00pm - 5:00pm)
 - Thursday (10:30am - 12:30pm)
 - Or by an appointment
Venue: BDC 163

Information Links

Final in-class exam: Thursday, March 21st from 2:00pm to 4:30pm

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

E-Commerce Project:
 - EC Project Guide
 - EC Example 1
 - EC Example 2
 - EC Example 3		 Click the followings for:
 - Blackboard Tutorial
 - Assignment Guideline
 - How to submit assignment through Blackboard
 - Final Exam Guideline 		Important Due Dates:
 - Quiz & Assignment: Wednesdays
 - Midterm Exam:  Feb 14 (Thursday)
 - Group Project: March 14 (Thursday)

Course Schedule

 

 Week

Class Materials

 Assignment
 1
 		 Jan 10:
 Introduction of Course
 Lecture: IS Revolution		  
2 Textbook:
  - Chapter 1 The Information Age in Which You Live: Changing the Face of Business
 - XLM A Computer Hardware and Software		 Jan 17/Jan 24/Jan 31/Feb 7:
Database Development:
Lecture:
 - DB 1 Lecture and DB 2 Lecture
 - DB 3 Lecture and DB 4 Lecture
Microsoft Access Online Tutorial
 - Getting started with Access 2010
 - Design the tables for a new database
 - Create the tables for a new database
 - More Access tutorials
Database Files:
 - Restaurant 1, Restaurant 2, and Restaurant3
 - Composite PK and PK as FK
 - FineFood database and Referential Integrity
 - BillingAddress (import Excel file)  
 - CSUB Logo, NewRest HTML, and Loan XML
 Database Assignment 2 files: Course, Instructor, and Membership
Database Assignment 3 files: Roadrunner database
Database Modling
 - Database Model by a CASE tool
 - Sybase PowerDesigner Demo
Introduction to SQL: SQL DB		 Assignment 1 (5 points)
  - Due: Jan 23
Quiz 1
 - Practice (No Count)
3 Textbook:
  - Chapter 2 Major Business Initiatives: Gaining Competitive Advantage with IT
 - XLM B The World Wide Web and the Internet		 Assignment 2 (5 points)
 - Due: Jan 30
Quiz 2 (5 points)
 - Due: Jan 30
4 Textbook:
  - Chapter 3 Databases and Data Warehouses: Building Business Intelligence
 - XLM J Implementing a Database with Microsoft Access
Quiz 3 (5 points)
 - Due: Jan 30
5 Access Databse:
 - Create relationships for a new database
 - Create queries for a new database
 - Create forms for a new database
 - Create reports for a new database		 Assignment 3 (10 points)
 - Due: Feb 13
6

Textbook:
 - Chapter 4 Decision Support and Artificial Intelligence: Brainpower for Your Business
 - Chapter 9 Emerging Trends and Technologies: Business, People, and Technology Tomorrow

Feb 14:
 Midterm Exam (50 points): 
 - Midterm Guideline

 

 Quiz 4 (5 points)
  - Due: Feb 13
7 Textbook:
 - Chapter 5 Electronic Commerce: Strategies for the New Economy
 - XLM E Network Basics		 Feb 21:
DSS Development: 401k Lecture, 401k worksheet, and 401k handout
 DSS Example: Customer Billing and Sales Agreement
Type of DSS Analysis:
 - What-if Analysis and Goal-seek Analysis
Interactive Excel Tutorial
Additional Excel Practice: Pivot Table (Data: Capital Credit Union)

Assignment 4 (10 points)
 - Due: Feb 27

Quiz 5 (5 points)
 - Due: Feb 20
8 Textbook:
 - Chapter 6 Systems Development: Phases, Tools, and Techniques
 - Chapter 7 Enterprise Infrastructure, Metrics, and Business Continuity Planning: Building and Sustaining the Dynamic Enterprise		 Feb 28:
Introduction to DFD and DFD Example (Lemonade Stand)
Use Case Diagram / Reverse DFD
 - UCD example and example_ANS
EC group project: EC website development
 - www.wix.com
 - Google Search: Free Website Builder
 - Google Search: Free Website Templates
 - Due: Thursday, March 14

Quiz 6 (5 points)
 - Due: Feb 27
9 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 
Introduction of GIS: What is GIS?, Why use GIS?, and What Can You Do with GIS?
online    
Textbook:
 - Chapter 8 Protecting People and Information: Threats and Safeguards
- XLM H Computer Crime and Digital Forensics
Learning ArcGIS Desktop (for ArcGIS 9.2-9.3)
- Module 1: Getting Started with ArcGIS Desktop		 March 7:
 Learning ArcGIS Desktop (for ArcGIS 10)
- Module 2: Creating Map Symbology
 - Module 3: Referencing Data to Real Locations
 - Module 4: Organizing Geographic Data
- Module 5: Creating and Editing Data
- Module 6: Getting Started with GIS Analysis		 Quiz 7 (5 points)
 - Due: March 6
10

Learning ArcGIS Desktop (for ArcGIS 10)
- Module 7: Working with Geoprocessing and Modeling Tools
- Module 8: Designing Maps with ArcGIS

 March 14:
- Review of Final Exam
- E-Commerce Project Presentation 		Assignment 5 (20 points)
 - Due: March 13