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 application of these approaches to solve business problems. Students will have hands-on experience with current, cutting-edge tools such as MySQL and R.
Learning Outcomes
- 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.
Prerequisites
Grade of C or better in MIS2101.
Evaluation
Item |
Percentage |
Exam 1 |
20% |
Exam 2 |
20% |
Exam 3 |
20% |
Assignments (9) |
30% |
In-class activities |
5% |
Participation / Attendance |
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. Tentative exam schedules are available below.
- Exam 1: 2/26 during class time
- Exam 2: 3/31 during class time
- Final Exam: 5/3 at 1PM
Zoom, Proctorio, or a similar proctoring tool may be used to proctor exams and quizzes in this course. These tools verify your identity and record online actions and surroundings. It is your responsibility to have the necessary government or school issued ID, a laptop or desktop computer with a reliable internet connection, the Google Chrome and Proctorio extension, a webcam/built-in camera and microphone, and system requirements for using Proctorio, Zoom, or a similar proctoring tool.
Technology Requirements:
The expectation for the online class sessions is that students participate both by video and audio. All students are required to have a working camera and headset during class times. These class sessions are recorded, and the recordings are posted shortly after class, please be aware that anything said during class sessions will be included and posted.
- Headphones
- Webcam: You are required to keep your webcam on during the duration of the class session
- Recommended Internet Speed: 8mbps download & 5mbps upload. Check your internet connection at speedtest.net
- Please note: Hard-wired connections are more consistent than Wi-Fi for Zoom sessions
- 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 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.
- Note that some software is available for free download on the ITS Academic Support Other specialty software may be available for remote access through ITS.
Zoom Virtual Classes:
This course will meet twice a week using Zoom. Zoom is downloaded to your computer the first time you use it and does require regular updates; please download the latest version of Zoom and open the downloaded file to install the app before the course begins. If you have already downloaded Zoom for a previous course, click review instructions on updating to the latest version.
Make sure you enter your first name and last name correctly when signing into your Zoom session. While there are ways to join a Zoom session through mobile phone, this should only be used in an emergency. Please log into the virtual classes before the scheduled class time, as we will begin promptly. You can access the virtual classes in Canvas under the “Zoom” link in your Course Navigation.
Proctorio
Proctorio is an online automated proctoring service that allows you to take your exam from the comfort of your home. To access this service, you will navigate to the exam area within your Canvas course. Once you start the exam, Proctorio will initiate the exam setup. You should expect the startup process to take up to 10 minutes. However, the time to complete the startup process will not affect your exam time. Please feel free to direct any questions to the Proctorio student support team via the live chat during the exam.
Proctorio’s services are available 24/7. Proctorio does not require advance scheduling. Please make sure that you are using the current version of the Chrome browser and have downloaded the Proctorio extension.
In order to use Proctorio you will need the following:
● High-speed internet connection (8mbps download & 5mbps upload)
● Webcam (internal or external)
● Windows or Mac Operating System
● Chrome browser and Proctorio extension installed
● Hard copy of a Government issued photo ID or university issued photo ID
It’s recommended that you visit https://proctorio.com/support prior to your proctoring session to review the test-taking system requirements. It is also encouraged to take the Proctorio practice quiz if your instructor has enabled this within your course.
Additionally, please visit and review the test-taker resource center and the Terms of Service.
TEMPLE AND COVID-19
Temple University’s motto is Perseverance Conquers, and we will meet the challenges of the COVID pandemic with flexibility and resilience. The university has made plans for multiple eventualities. Working together as a community to deliver a meaningful learning experience is a responsibility we all share: we’re in this together so we can be together.
PRO Point Requirement (MIS Majors Only)
All BBA in MIS majors must have 200 Professional Achievement (PRO) points by the end of this course in order to receive a grade. If you do not have 200 points by the of the term, you will receive an incomplete, which will remain in place until you reach the required number of points.
Assignments
There will be nine assignments. All assignments should be submitted via Canvas before their 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 ITA for the course.
Late assignments will not be accepted.
Please note:
- 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.
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 fail. Missed or late submissions will receive a zero (fail) grade. Equipment failure is not an acceptable reason for turning in a deliverable late.
Video Recording and Sharing Policy
It is also important to foster a respectful and productive learning environment that includes all students in our diverse community of learners. Our differences, some of which are outlined in the University’s nondiscrimination statement, will add richness to this learning experience. Therefore, all opinions and experiences, no matter how different or controversial they may be perceived, must be respected in the tolerant spirit of academic discourse.
Treat your classmates and instructor with respect in all communication, class activities, and meetings. You are encouraged to comment, question, or critique an idea but you are not to attack an individual. Please consider that sarcasm, humor and slang can be misconstrued in online interactions and generate unintended disruptions. Profanity should be avoided as should the use of all capital letters when composing responses in discussion threads, which can be construed as “shouting” online. Remember to be careful with your own and others’ privacy. In general, have your behavior mirror how you would like to be treated by others.
Code of Conduct Statement for Online Classes
Online Behavior:
Students are expected to be respectful of one another and the instructor in online discussions. The goal is to foster a safe learning environment where students feel comfortable in discussing concepts and in applying them in class. If for any reason your behavior is viewed as disruptive to the class, you will be asked to leave and you will be marked absent from that class. Please read the university policy concerning disruptive behavior:
The disruptive student is one who persistently makes inordinate demands for time and attention from faculty and staff, habitually interferes with the learning environment by disruptive verbal or behavioral expressions, verbally threatens or abuses college personnel, willfully damages college property, misuses drugs or alcohol on college premises, or physically threatens or assaults others. The result is the disruption of academic, administrative, social, or recreational activities on campus.
Online Classroom Etiquette:
The MIS Department wants to ensure you have a positive, engaging online experience. Therefore, during class, you are expected to keep your webcam video on with your face clearly visible – with or without a virtual background – and your microphone muted unless you are speaking. If you do not have your video turned on during a class session, you may be removed from that session at the instructor’s discretion. To request an exception to this policy, please consult your instructor.
The expectation is that students attending online courses will behave in the same manner as if they were in a live classroom. Be courteous and professional in your location, attire and behavior. Specifically, your location should reflect a clean and professional appearance – not a bedroom, crowded conference room, loud restaurant/bar, etc. Your attire should mirror what you might wear to a live classroom. We expect that students will not disrupt class through visuals or verbal outbursts, such as but not limited to, conversations with other people in the room, engaging in inappropriate behavior while you are in class or distracting the class in any other way. In addition, students should refrain from doing something in their online class that they would not do in a live classroom. which includes eating large meals, drinking alcohol, vaping, getting up often and leaving the online class (not staying at their computer). You should arrive on time and leave when the class is over. If there is an emergency of some kind, notify your faculty member via email or the chat function in Zoom.
It is also important to foster a respectful and productive learning environment that includes all students in our diverse community of learners. Our differences, some of which are outlined in the University’s nondiscrimination statement, will add richness to this learning experience. Therefore, all opinions and experiences, no matter how different or controversial they may be perceived, must be respected in the tolerant spirit of academic discourse.
Treat your classmates and instructor with respect in all communication, class activities, and meetings. You are encouraged to comment, question, or critique an idea but you are not to attack an individual. Please consider that sarcasm, humor and slang can be misconstrued in online interactions and generate unintended disruptions. Profanity should be avoided as should the use of all capital letters when composing responses in discussion threads, which can be construed as “shouting” online. Remember to be careful with your own and others’ privacy. In general, have your behavior mirror how you would like to be treated by others.
Class Participation
Participation: 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. However, note my policy is not to cold call students who are sitting in the front row. If something prevented you from being prepared for class on a particular day, you are invited to sit in the front row.
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 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.