IS 602, MANAGEMENT INFORMATION SYSTEMS
SECTION 02 (10546), Fall 2024
● Course Description
This course teaches the fundamental concepts of information systems (IS). We first introduce the database system; learn how to structure, manipulate and retrieve data using MS Access. We will then study the enterprise systems and key business processes, using SAP as an example. We demonstrate how enterprise systems support the execution and management of these processes, and furthermore, how enterprise systems improve internal productivity and innovation within a company and shape the external competitive landscape. After that, we will use Business Intelligence software (MS Excel, Tableau) to analyze the data which was generated by modern enterprise systems.
Student Learning Outcomes (SLO)
Upon successful completion of this course, students will be able to:
● understand the mechanism and common operations of database system;
● acquire data in desired format from a database through queries;
● understand key business processes such as procurement, fulfillment, and production processes and how these business processes are carried out in an enterprise system;
● use Business Intelligence packages to explore business data;
● Learn how business analytics help businesses achieve competitive advantage.
● Texts/Readings
Textbook
1. I will use my teaching notes throughout this class, which will be provided in Canvas timely.
2. (Optional) Essentials of Business Processes and Information Systems by Simha R. Magal and Jeffrey Word, Wiley, 2009. (ISBN 0470505699)
3. (Optional) Management Information Systems: Managing the Digital Firm by Kenneth Laudon and Jane Laudon, Pearson, 2021. (ISBN 1292403284) (No need the latest version, any version of this book is fine)
Technical Requirements
For software, we will use:
MS Access, MS Excel, Tableau and SAP.
● PC user has three options:
1. you may install MS office package on your own computer (https://www.csulb.edu/academic-technology-services/office-365).
2. You can use SVL (student virtual lab) to do the exercises.
3. You can visit our school’s Lab.
● MAC user, you can use SVL (student virtual lab) or COB’s lab to do the MS Access/Excel exercises.
● Tableau (there is a free download for 14 days, also there is free student’s license if you register using CSULB email) has both PC and MAC versions.
● SAP (No need to install anything, everything is through an internet browser)
Tentative schedule (For reference only! I will update it if we have any changes)
|
Week
|
Date
|
Topic(s)
|
Readings
|
HOMEWORK (Release)
|
|
1
|
8/26
|
Course Introduction， Database I
|
Database Notes
|
|
|
2
|
9/2
|
No class (holiday)
|
|
|
|
3
|
9/9
|
Database II
|
|
|
|
4
|
9/16
|
Database III
|
|
Database HW
|
|
|
9/16-9/23
|
Exam 1
|
|
|
|
5
|
9/23
|
Business Processes and Enterprise Systems (SAP)
|
Business Process Notes, SAP handouts
|
SAP HW
|
|
6
|
9/30
|
Business Intelligence, Data Warehouse and Business Reporting
|
BI handouts
|
|
|
7
|
10/7
|
Business Reporting (Tableau)
|
Tableau handouts
|
BI HW
|
|
8
|
10/14
|
Business Analytics and Predictive Modeling
|
Business Analytics handouts
|
|
|
|
10/14-10/18
|
Exam 2
|
|
|
● Course Policies and Requirements
Grading Policy
Evaluation Method
|
Assignment
|
Points
|
Weight
|
|
First Exam
|
35
|
35%
|
|
Second Exam
|
35
|
35%
|
|
Canvas Quizzes
|
10
|
10%
|
|
Database Assignment (HW)
|
5
|
5%
|
|
SAP exercise (HW)
|
10
|
10%
|
|
BI Assignment (HW)
|
5
|
5%
|
|
Extra Credit
|
4
|
4%
|
Your final overall score = Exam1 raw score / Number of questions in Exam1 * 35
+ Exam2 raw score / Number of questions in Exam2 * 35
+ Canvas Quizzes raw score /Number of total quizzes Questions *10
+ Database HW score
+ SAP exercise finished percentage * 10
+ BI HW score
+ Extra Credit
Course Grading Scale (example)
|
Percent Range
|
Letter Grade
|
|
90-100%
|
A
|
|
89-80%
|
B
|
|
79-70%
|
C
|
|
69-60%
|
D
|
|
Below 60%
|
F
|
Communication Policy
We will use BeachBoard to make announcements, communicate information, post assignments and corresponding due dates, and discuss course-related topics. Please note: It is the student’s responsibility to check BeachBoard a minimum of once per week, as it will contain important information about upcoming class assignments, activities, and other elements of the course. Students should also be sure to check their CSULB email accounts a minimum of once per week to receive important communications about the course from the instructor or other enrolled students.