IS 695 COURSE
SYLLABUS
Spring, 2001
Course
Name:Enterprise Resource Planning Systems
Course Number: IS695 (Call Number 18702)
Classroom: CBA 216
Instructor: Dr. Robert Chi
Office: CBA-424 (3rd floor)
Telephone:
(562 )985-4238
Email: rchi@csulb.edu
Fax:
(562) 985-4080
Office Hours: T 1:00pm -4:00pm
-
Course Objective and Format:
Theory and applications of ERP systems development using development tools
such as HTML and JavaScript. Active Server Page (ASP), ColdFusion and ORACLE
data base engine with Open Data Base Connectivity (ODBC). Use and
development of ERP application in the Client/Server environment. Other
issues such as Internet business opportunities, network security, home
page maintenance, Internet Database interface and cooperative computing
will also be covered.
-
Text Required:
Mission Critical: Realizing the
Promise of Enterprise Systems
By: Thomas Davenport
Harvard Business School Press,
ISBN: 0875849067
-
Text Optional
Coldfusion 4.0, by Ben Forta, QUE
publication, 1999.
ISBN: 078971809X
-
Equipment and other requirement:
PC with at least 500 MHz CPU, 2
giga harddrive space, 56 megabyte RAM.
Intenet access through CSULB (if
you live in 562 area code) or by other ISP (such as AOL, earthlink and
so on). Free ISP such as www.netzero.com, www.bluelight.com...
CSULB e-mail account (you can get
it from North Campus Library)
Download the following software
from www.download.com
1. WS_ftp (to
transfer files to web server)
2. Netscape communicator
4.5 or later version
-
Exam/Grading Policy:
Homework assignment 1
15%
Homework assignment 2
10%
Homework assignment 3
10%
Homework assignment 4
15%
Group Project
50%
==================================
Total
100%
-
Attendance policy. It is extremely
important to attend all classes. Participation is essential.
-
Prerequisites: IS500, database
concepts and SQL
-
A minimum level of computer literacy,
telecommunication and database concept is expected. Students who do not
have a recent background in fundamentals of computers/information systems
are advised to study at least one introductory level text.
Course Outline
Lecture
Student presentation
|
1/29
|
Introduction
to ERP |
|
|
|
2/5
|
chapter2, ORACLE |
|
Homework 1 assigned |
|
2/12
|
chapter3,
ORACLE |
|
|
|
2/19
|
Campus closed |
|
|
|
2/26
|
chapter4, |
SAP |
Homework
1 due
Homework 2 assigned |
|
3/5
|
Chapter5, HTML/JavaScript |
SAP |
|
|
3/12
|
Chapter6, Active Server Page
(ASP) concept and application |
WAP |
Homework 2 due
Homework 3 assigned |
|
3/19
|
Coldfusion |
ORACLE |
|
|
3/26
|
Coldfusion |
People Soft |
Homework 3 due
Homework 4 assigne |
|
4/2
|
Coldfusion |
SIEBEL |
|
|
4/9
|
Spring Break |
|
|
|
4/16
|
Chapter7, ERP system presentation |
|
Homework 4 due |
|
4/23
|
Chapter8, ERP system presentation |
|
|
|
4/30
|
Chapter9, ERP system presentation |
|
|
|
5/7
|
Final project discussion |
|
|
|
5/14
|
Final Project Presentation |
|
|
|
5/21
|
Final Project Presentation |
|
|
Assignment 1 (group
homework)
ERP system presentation
1.ORACLE
2. JD Edward
3. SAP
4. People Soft
5. Computer Associate
6. BAAN Presentation
Assignment 2
Create a table in ORACLE database named "student" with fields
of studentID, firstname, lastname, age, gender, and gpa.
Use coldfusion code to develop 5 functions
1. Add a new student
2. Delete a student
3. Search for a student by studentID
4. List all students
5. Update a student when studentID is provided
User name and password will be provided for both ORACLE server and
Coldfusion server
Please try this ColdFusion
Sample programs
Download f0.cfmf1.cfmf2.cfmf21.cfmf22.cfmf31.cfmf41.cfmf42.cfmColdFusion
Assignment 3
Use
data migration function in Access to migrate database from Access to Oracle
database
1. In
Oracle, login Oracle account
2. create
table structure in Oracle
3. In Access,
create linked Oracle tables
4. Write SQL
in Access and execute this query (one table needs one query)
For example, migrate access_table1 to oracle_table1
"insert into oracle_table1 select * from access_table1;"
5. Ask instructor
to change ODBC pointer from Access database to Oracle database
Assignment 4
CRM call center (sample site can be found www.inventionteam.com
username: vivian, passowrd:12345 salesID:100)
Design an enterprice call center function in a CRM package
1. Define users for the call center (operators, sales)
2. Define entities (Customers, Sales, Opportunities)
3. Define business logics
4. Define relationship between entities(C-O, O-S)
5. Design tables for each entity
6. Design user interface
7. Code implementation
8. Testing and documentation (3 pages)
Final Project
To be announced