instructor: Aaron Zhi Cheng, Section 003


Instructor: Aaron Zhi Cheng

Office:                     201F Speakman Hall
Office hours:          3:50 PM – 4:50 PM Mondays and Wednesdays or by appointment


Nathaly Gonzalez (

Class Location and Time

location: Alter Hall 232
Time: Monday/Wednesday/Friday, 3:00 pm – 3:50 pm

Course Websites

We will use both the community site and the Canvas site. The detailed usage of the two sites is as follows.

Website Usage
Community Site: The community site has an up-to-date copy of the syllabus, schedule, class announcements, slide decks, in-class exercises, assignment instructions, as well as other course documents. While I will try to make announcements both in class and on the community site, it is a good idea for you to check the website regularly.
Canvas: The Canvas site is primarily for assignment submission and sharing videos/recordings. The grades will also be posted on Canvas.

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.

Professional Achievement Point Requirement (MIS Majors Only)

The MIS department has instituted a professional achievement point requirement for MIS majors. We have found that our most successful students are not only engaged inside the classroom but also with the department and our Student Professional Organization, AIS. Students will be required to create a portfolio which documents their achievements in the classroom, with the department, and within AIS. For each addition to their portfolio, a student will earn some number of “professional achievement points”. Students will be required to accumulate 1,000 professional achievement points to meet this graduation requirement.

As a departmental policy, starting from this spring semester, all MIS majors who take MIS2502 are required to earn a minimum of 200 professional achievement points by the end of the semester.  Students who have earned a “C” or better but do not earn the minimum number of professional achievement points by the end of the semester will receive an “Incomplete” for this course regardless of performance on exams or class participation!

If a student earns the minimum number of professional achievement points within one year from the end of the semester and notifies their instructor, the instructor will update their grade from “Incomplete” to a traditional grade.

If a student fails to  earn the minimum number of professional achievement points within one year from the end of the semester or does not notify their instructor that they have earned the minimum number of professional achievement points then their “Incomplete” will be changed to an “F” automatically by the system and will be the student’s permanent grade.

You are STRONGLY encouraged to, at a minimum, do the following to earn professional achievement points:

  1. Create an e-Portfolio and have it listed with the department.
  2. Become an active member of AIS and participate in professional development activities.
  3. Attend the IT Awards Reception (spring semester only) and the MIS Department’s Career Fair.
  4. Volunteer your time for department-sponsored events.
  5. Discuss opportunities to earn points for projects with your MIS instructors.

Please contact Professor Mart Doyle ( for further information.