Introduction

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 Python.

Learning Outcomes

Articulate the key components of an organization’s information infrastructure.
Understand and use a transactional database from a model based on both SQL and NoSQL.
Create an analytical data store by extracting relevant data from a transactional database.
Perform extract, transform, and 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.

Prerequisites

Grade of C or better in MIS2101.

Evaluation

Item	Percentage
Exams (3)	60%
Assignments (9)	35%
In-class activities	5%

Grading

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

Exams

There will be three exams during the semester. The dates of these are documented in the class schedule.

Makeup Exams

Makeup exams present a number of logistical challenges. Out of fairness to all students taking the course, makeup examinations will only be given in accordance with the official University policy. Exceptions are granted at the instructor’s discretion and are typically limited to extreme circumstances such as documented hospitalization. If a student is permitted to take a make-up exam, the instructor reserves the right to substitute an alternate exam with different content. Students may find the content of the make-up exam to be more difficult than the original. It is, therefore, to a student’s advantage to show up for each exam at the scheduled time and take it with the rest of the class.

Assignments

There will be nine assignments. All assignments should be submitted via Canvas before the due date. They are to be done individually and should represent your own work. If you need help, you may consult with your instructor or the GTA/ITA for the course.

#	Assignment
1	Database Schema
2	SQL #1 – Basic queries
3	SQL #2 – Advanced queries
4	Python Basics
5	Python and JSON
6	Python and Pandas
7	Decision Trees
8	Clustering
9	Association Rules

Late Assignment Policy

All assignments will be assessed a 20% penalty (subtracted from that assignment’s score) for every day they are late. Also, no credit will be given for assignments turned in more than 3 days past the deadline.

Please note:

All requests for extending the deadline for assignments must be discussed and approved by the instructor at least a day prior to the due date. No excuses will be accepted if discussed after the due date.
Equipment failure is not an acceptable reason for turning in an assignment late.
In case the Canvas submission link does not work, you must send the submission to the instructor’s email by the due date.
For the assignment to be considered “on time,” you must attach all necessary files specified in the assignment instructions by the due date. For any revisions or additional documents received after the due date, the usual late penalty applies.

A Note on Regrade Requests

The instructor will make every effort to return exam/assignment grades within 1 week of submission. If you believe that your grade is inaccurate, you may request a regrade under the following conditions:

Regrade requests must be submitted within 1 week of the date when the grade was returned.
For assignment and ICAs grades, regrade requests must be emailed to the instructor or TA and must outline the reasons you deserve a higher grade. Referencing another student’s grade is inappropriate and irrelevant. While we do our best to apply an even standard across students, we can’t discuss anyone else’s grade with you, so we need to deal with the merits of your particular case.
For exam grades, regrade requests must be made during office hours.
I reserve the right to regrade the entire assignment/project/exam, and thus your grade may go up or down.

In-Class Activities

In-class activities are very hands-on in nature, where students will be expected to work with various examples and data sets based on instructions and class discussions.

After we complete the in-class activities, you are required to submit your solutions through Canvas by the end of the class unless otherwise notified.

You are allowed to miss two submissions for in-class activities. Deliverables from in-class activities will be graded by success or failure. Missed or late submissions will receive a zero (fail) grade. Equipment failure is not an acceptable reason for turning in a deliverable late.

Extra Credit: Extra credit opportunities will not be offered to compensate for poor academic performance earlier in the semester.

Attendance and Participation:

Attendance and participation are essential.

I strongly encourage your active class participation and discussion. Involvement during class is also important. Being present in class to ask and answer questions is essential to the learning process. Don’t feel shy to speak up, ask questions, or answer them. All students are expected to come prepared for the class and volunteer answers. I may also “cold call” students in class.

An important note regarding attendance: if a student does miss class, it is the student’s responsibility to catch up on any related material. While every student is encouraged to use oﬃce hours to gain a better understanding of class material, oﬃce hours are NOT for helping students catch up on material they missed because they were absent.

Attendance Protocol and Your Health

If you feel unwell, you should not come to campus, and you will not be penalized for your absence. Instructors are required to ensure that attendance is recorded for each in-person or synchronous class session. The primary reason for documentation of attendance is to facilitate contact tracing, so that if a student or instructor with whom you have had close contact tests positive for COVID-19, the university can contact you. Recording of attendance will also provide an opportunity for outreach from student services and/or academic

support units to support students should they become ill. Faculty and students agree to act in good faith and work with mutual flexibility. The expectation is that students will be honest in representing class attendance.

Laptop Requirement

The software that we use in the course works on Windows and MacOS. Students should have a laptop to follow the course materials (e.g., ICAs).
Chromebooks are not considered as laptops as they are a Google tablet/device.

https://its.temple.edu/shoppers-guide

Limited resources are available for students who do not have the technology they need for class. Students with educational technology needs, including no computer or camera or insufficient Wifi-access, should submit a request outlining their needs using the Student Emergency Aid Fund form. The University will endeavor to meet needs, such as with a long-term loan of a laptop or Mifi device, a refurbished computer, or subsidized internet access.

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
Having someone else complete your homework or project and submitting it as if it were your own
Using material from another student’s assignment in your own assignment

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 your work is 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.

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), which can be accessed through the following link:
http://policies.temple.edu/getdoc.asp?policy_no=03.70.02

Disability Statement
Any student who has a need for accommodation based on the impact of a disability should contact me privately to discuss the specific situation as soon as possible. Contact Temple University’s Disability Resources and Services (DRS) office at (215)204-1280 at 100 Ritter Annex to coordinate accommodations for students with documented disabilities. Please contact your instructor and the DRS within the first week of class, at the beginning of the semester. DRS will establish your needs and make necessary arrangements with the faculty. If you choose not to contact DRS and have difficulty, you will be unable to receive accommodations retroactively, once exams are completed and/or course grades are submitted. Such decisions are made jointly between the DRS office and the instructor, at their discretion based on circumstances. Accommodation letters must be received by the instructor during the first two
weeks of the semester.

Class recordings

Class meetings will be recorded. Class recordings will be made available to the Temple community at the instructors first opportunity. Any student who is not comfortable with this and/or has any related privacy concerns should contact the instructor.

Any recordings permitted in this class can only be used for the student’s personal educational use. Students are not permitted to copy, publish, or redistribute audio or video recordings of any portion of the class session to individuals who are not students in the course or academic program without the express permission of the faculty member and of any students who are recorded. Distribution without permission may be a violation of educational privacy law, known as FERPA as well as certain copyright laws. Any recordings made by the instructor or university of this course are the property of Temple University.

MIS Department PRO Points Requirement:

The MIS Department has instituted a PRO point (professional achievement point) requirement for all MIS majors. This class is a checkpoint to ensure that students are focused on this requirement and on track to earn their 1,000 points by graduation. Students in MIS2502 must earn a minimum of 200 points by the end of the semester. Students who fail to earn the required points will receive an “Incomplete” for this course regardless of performance on exams or class participation.

IMPORTANT NOTE: If a student fails to earn the minimum number of PRO points within one year from the end of the semester or does not notify their instructor that they have earned the minimum number of points, then their “Incomplete” will be changed to an “F” automatically. The grade of “F” will then be the student’s permanent grade.

Students are STRONGLY encouraged to, at a minimum, do the following to earn points:

Create an e-Portfolio and have it listed with the department.
Become an active member of AIS and participate in professional development activities.
Attend the IT Awards Reception (spring semester only).
Participate in the Data Analytics Challenge (fall semester only) and the MIS Department’s Career Fair.
Volunteer your time for department-sponsored events.
Discuss opportunities to earn MIS PRO points for projects with your MIS instructors. Note that students may not request course/project-related PRO points more than one year after the end of the semester.

Finally, here are two excellent resources that describe why the MIS professional achievement points are important to you.