Prerequisites
A grade of C or better in MIS 2101.
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 the 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 mining, and decision trees.
- Present data visually for clear communication to a managerial audience.
Required Textbook
There is no required textbook for this course.
PRO Point Requirement (MIS Majors Only)
All BBA in MIS majors must have 250 Professional Achievement (PRO) points by the end of this course in order to receive a grade. If you do not have 250 points by the of the term, you will receive an incomplete, which will remain in place until you reach the required number of points.
Plagiarism and Academic Dishonesty
Plagiarism and academic dishonesty can take many forms. The most obvious is copying from another student’s exam, but the following are also forms of this:
- Copying material directly, word-for-word, from a source (including the Internet)
- Using material from a source without a proper citation
- Turning in an assignment from a previous semester as if it were your own
- Using material from another student’s assignment in your own assignment
- Sharing your answers to an assignment with another student
- Working together on individual assignments
If you use text, figures, and data in reports that were created by someone other than yourself, you must identify the source and clearly differentiate your work from the material that you are referencing. There are many different acceptable formats that you can use to cite the work of others (see some of the resources below). You must clearly show the reader what is your work and what is a reference to somebody else’s work.
Plagiarism and cheating are serious offenses. Penalties for such actions are given at my discretion, and can range from a failing grade for the individual assignment, to a failing grade for the entire course, to expulsion from the program.
Classroom Etiquette
The environment you and your fellow students create in class directly impacts the value gained from the course. To that end, the following are my expectation of your conduct in this class:
- Arrive on time and stay until the end of class.
- Silence your electronic devices (e.g., laptop, mobile devices, etc.) and alarms while in class.
- Encourage the use of electronic devices to class-related usages such as taking notes and quick searchings. Limit the use of electronic devices and Internet connection to learning-unrelated usages such as checking email, Internet browsing, and sending instant messages.
- During class time speak to the entire class (or breakout group) and let each person “take their turn.”
- Be fully present and remain present for the entirety of each class meeting.
Student and Faculty Academic Rights and Responsibilities
The University has adopted a policy on Student and Faculty Academic Rights and Responsibilities (Policy # 03.70.02).