MIS 6100 - MIS: Concepts and Applications

** Any Blackboard problem, contact CSUB help desk
at 654-2307 or Helpdesk@csub.edu **
Name: Yong Choi, PhD
Office: BDC 103
Office Phone: 654 - 6691
Email Address: ychoi2@csub.edu
Venue: BDC 163
Office Hours:
 - Tuesday (3:30pm-5:30pm)
 - Thursday (3:30pm-5:30pm)

 - After class Or by an appointment

Information Links
 - Syllabus
 - Announcement
 - Group Information
 - Peer Evaluation
 - How to Enroll into Blackboard
 - How to submit thru Blackboard
 - Downlaod MS Office for PC
 - Downlaod MS Office for Apple No Access!
Digital Big Data Book:
 - Big Data Analytics & Understanding Big Data
 - Harness the Power of Big Data 
Digital GIS book:
 - Geospatial Analysis
Digital Database Book:
 - DatabaseFundamentals of Database

Digital E-Commerce Book:
 - E-Commerce:The Strategic Perspective

 

This table shows primary activities with due dates. Please click each title for the detail instruction (except Quiz). All the online activities can be started in advance such as Big Data Paper, E-Commerce Project, quiz, and Case Discussion

Sep DB Assignment (click for instruction)
- 20 points & individual
- Data Files: Employee, Order, Supplier, and CSUBbank
- Due: Oct 2 (Monday, 11:59pm)
- Postponed!
Oct Quiz 1, 2, and 3
- Online only

- Each quiz 3 points & individual
- Detail instruction on Blackboard
- Please take it thru Blackboard
- Due: Oct 2 (Monday, 11:59pm)
DSS Assignment (click for instruction)
- 10 points & individual

- Due: Oct 16 (Monday, 11:59pm)
- Postponed!
Case Discussion (click for instruction)
- Online only

- Chapters 1, 2, 3, and 4
- 5 points for each chap & group (four)
- Must discuss thru Blackabord
- Due: Oct 16 (Monday, 11:50pm)
E-Commerce Project (click for instruction)
- Online only
- 20 points & group (two)
- Due: Oct 16 (Monday, 11:59pm)
Data Model Individual Assignment
 - 15 points and individual
 - Due: Oct 23 (Monday, 11:50pm)
Nov  Nothing is due on November! 
Dec Case Discussion (click for instruction)
- Online only

- Chapters 5, 6, 7, and 8
- 5 points for each chap & group (four)
- Please discuss thru Blackboard
- Due: Dec 4 (Monday, 11:50pm)
Quiz 4, 5, 6, and 7
- Online only
- Each quiz 3 points & individual
- Detail instruction on Blackboard
- Please take it thru Blackbo
- Please take it thru Blackboard
- Due: Dec 4 (Monday, 11:59pm)
ArcGIS Online Assignment (click for instruction)
- Online only

- 10 points & individual
- Due: Dec 4 (11:59pm, Monday)
Big Data Paper (click for instruction)
- Online only
- 40 points & individual
- Due: Dec 11 (Monday, 11:59pm)

- Free Online: Big Data Course try this first!
- Free Book: Big Data Analytics, Harness the Power of Big Data, and Understanding Big Data

Course Schedule (Subject to change!)
Week

In-Class

Online Chapters and Assignment
1

Aug 29/31: Introduction to Course

Textbook:
- Chapter 1: The Information Age in Which You Live: Changing the Face of Business
-
XLM A: Computer Hardware and Software
Microsoft Tutorial:
M
ust Try This!
- Access 2013 Tutorial & Access 2016 Tutorial
2

Sep 5/7: Lecture - IS Revolution

3&4 Sep 12/14 and Sep 19/21
Access Database: Lecture 1, Lecture 2, Lecture 3, and Lecture 4
Files for Database Development:
Restaurant 1, Restaurant 2, and Restaurant 3
Example:
Composite PK, PK as FK, FineFood DB and Referential Integrity
Excel File: BillingAddress, import Excel file (PPT)
Relationship using Excel:
Course, Instrcutor, and Membership
Query Practice DB: Roadrunner database

Other Files: CSUB Logo, NewRest HTML, and Loan XML
Textbook:
- Chapter 2: Major Business Initiatives: Gaining Competitive Advantage with IT
-
XLM B: The World Wide Web and the Internet

5 Sep 26/28: DSS Development
 - 401k Lecture, 401k worksheet, and 401k handout  Type of DSS: What-if Analysis & Goal-seek Analysis

 - DSS assignment initial worksheet
6 Oct 3/5:
Free Database Textbook new!

Data Modeling Lecture & Example of Business Ruel Sources
Basics of Data Modeling Video & ERD development using a CASE tool
Textbook:
- Chapter 3: Databases and Data Warehouses: Building Business Intelligence
- XLM J: Implementing a Database with Microsoft Access
7

Oct 10/12:
Data Modeling Lecture and Practice (see class hand out!)
Amamzon Aurora RDS, Amazon Web Services, and Online tutorials with AWS

8 Oct 17/19: Online
ERD Tutorial One, ERD Tutorial Two, and Crow's Feet Are Best
Database Modling Tool: Lucidchart.com & Lucidchart.com tutorial
Data Model Individual Assignment (15 points):
- Due: Oct 23 (Monday, 11:59pm)
Textbook:
-
Chapter 4: Decision Support and Artificial Intelligence: Brainpower for Your Business
- Chapter 5: Electronic Commerce: Strategies for the New Economy
9  Oct 24/26:Super/Sub Type Entity
Requirements Analysis & The Department of Justice SDLC Document

E-Commerce & Socialnomics 2017 by Equalman (2:28)
10 Oct 31/Nov 2: Transformation
ERD to Relational Model
ERD to Relational model Practice
Textbook:
- Chapter 6 Systems Development: Phases, Tools, and Techniques
- XLM E Network Basics
11

Nov 7/9:
Reverse Engineering: 1, 2, and 3
Normalization: Normalization Lecture Note, Practice

12 Nov 14/16:
Restaurant 3 SQL, and SQL DB file for the lecture
SQL Lecture Part 1, Part 2, and Lecture Example SQL
Textbook:
- Chapter 7 Enterprise Infrastructure, Metrics, and Business Continuity Planning: Building and Sustaining the Dynamic Enterprise
- Chapter 8 Protecting People and Information: Threats and Safeguards
13 Nov 21/23: Thanksgiving Break!
SQL Online: W3schools
14

Nov 28/30: SQL (con't)
SQL Lecture Part 2

Textbook:
- Chapter 9: Emerging Trends and Technologies: Business, People, and Technology Tomorrow
15

Dec 5/7: SQL (con't)

16 Final Exam