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 10% penalty (subtracted from that assignment’s score) for every hour they are late. This means no credit will be given for assignments turned in more than 10 hours 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.

Academic Integrity

The MIS Department has a zero-tolerance policy for any type of academic dishonesty in the classroom.

Academic dishonesty refers to any form of cheating, plagiarism, or other unethical practices in academic settings. This includes, but is not limited to, the following:

Plagiarism includes, but is not limited to, the use, by paraphrase or direct quotation, of the published or unpublished work of another person without full and clear acknowledgment. It also includes the unacknowledged use of materials prepared by another person or agency engaged in the selling or distribution of term papers or other academic materials.
Cheating includes, but is not limited to: (1) use of any unauthorized assistance in taking quizzes, tests, or examinations; (2) use of sources beyond those authorized by the instructor in writing papers, preparing reports, solving problems, or carrying out other assignments; (3) the acquisition, without permission, of tests or other academic material belonging to a member of the university faculty or staff; (4) engaging in any behavior specifically prohibited by a faculty member in the course syllabus, assignment, or class discussion; (5) or otherwise engaging in behavior that gives the Student an unfair academic advantage including, but not limited to, fabrication of data or sources, resubmitting work already submitted for another academic requirement without prior authorization, or other similar behavior.
Facilitating, procuring, or encouraging another person to engage in plagiarism or cheating. To be clear, the following are unacceptable:

Copying material directly from the Internet (or another source) without a proper citation crediting the author.
Posting material to the Internet so that it can be used by other students who are violating this academic integrity policy (i.e. posting exam material or assignment material to Course Hero).
Turning in an assignment from a previous semester as if it were your own and created during the current semester.
Having someone else complete your assignment and submitting it as if it were your own.
Fraudulently updating the attendance record.
Use of assignments completed in one class as any part of a project assigned in another class.
Sharing/copying any graded assignment.
Use of any unauthorized information during an examination.

In cases of cheating where multiple parties are involved, all parties will be held equally responsible. Under this zero-tolerance policy, any student found violating the academic integrity policy will immediately receive a final grade of “F” for the course and a formal complaint will immediately be filed with Office of Student Conduct and Community Standards. This incident will be listed on your permanent academic record. As part of my formal complaint, I will petition to have you expelled from the university. I will not discuss the penalty for violating this policy; I will simply direct you to this paragraph in the class syllabus.

** As outlined in the university’s Withdrawal from Classes policy (policy no. 02.10.14), once a student has been informed that academic misconduct is suspected, the student may not drop or withdraw from the course during the investigation and adjudication process except where the drop or withdrawal is approved for exceptional circumstances.

https://studentconduct.temple.edu/

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.

MasteryGrids (Extra Credit)

MasteryGrids system is an interactive learning tool that helps you improve and track your understanding of course concepts. The system visualizes your progress through different course topics using a color-coded grid, where darker shades indicate higher mastery levels. As you work through the exercises and questions, you’ll not only strengthen your knowledge, but you can also earn extra credit. Specifically, you will receive a checkmark for a topic when you complete at least two Independent problems in it, and you can earn up to two extra points toward your final grade if you get checkmarks for all the topics presented in MasteryGrids. However, beyond the extra points, active engagement with MasteryGrids is an excellent way to reinforce learning. You can access the system anytime to practice and improve at your own pace. (Please note that your activity in MasteryGrids will be evaluated based on progress made up until the final exam on April 23.)

To get started, simply follow the http://adapt2.sis.pitt.edu/kt/ and log in using the same credentials you use for the MySQL server. If you would have any questions, please reach out to Prof. Bauman at kbauman@temple.edu.

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.