Syllabus
Instructor: Shuting Wang (ada.wang@temple.edu)
Office: 201 Speakman Hall
Office hours: 3:00 – 4:00 PM, Monday and Wednesday, or by appointment
Teaching Assistant: Chinmay Muttur (tug40317@temple.edu)
Location: ALTER 232
Time: 2:00 – 2:50 PM, Monday, Wednesday and Friday
Prerequisites: Grade of C or better in MIS2101.
Download the syllabus: MIS2502 Syllabus [Ada] – 2018 Fall
Course Description:
The course provides a foundation for designing database systems and analyzing business data to enhance firm competitiveness. Concepts introduced in this course aim to develop an understanding of the different types of business data, various analytical approaches, and application of these approaches to solve business problems. Students will have hands-on experience with current, cutting-edge tools such as MySQL and R.
Course Objectives:
- Articulate the key components of an organizations’ information infrastructure.
- Create data models based on business rules.
- Create a transactional database from a model using SQL.
- Create an analytical data store by extracting relevant data from a transactional database.
- Perform extract, transform, load (ETL) functions such as data sourcing, pre-processing, and cleansing.
- Discover trends in analytical data stores using the data mining techniques of clustering, segmentation, association, and decision trees.
- Present data visually for clear communication to a managerial audience.
Required Textbook:
There is no required textbook for this course.
Evaluation and Grading
| Item | Percentage |
| Exams (3) | 60% |
| Assignments (8) | 24% |
| Group project | 6% |
| In-class activities | 5% |
| Presence & participation | 5% |
| Scale | |||
| 94 – 100 | A | 73 – 76.99 | C |
| 90 – 93.99 | A- | 70 – 72.99 | C- |
| 87 – 89.99 | B+ | 67 – 69.99 | D+ |
| 83 – 86.99 | B | 63 – 66.99 | D |
| 80 – 82.99 | B- | 60 – 62.99 | D- |
| 77 – 79.99 | C+ | Below 60 | F |