Syllabus
Course Information
Course Name: Applied Business Analytics QMB2302C
Reference Number: 641156
Term / Session: Fall 2019
Days / Time: Wednesdays 6:30 pm -9:15 pm
Location: South Campus bldg 72 room 193
Instructor Contact Information
Instructor Name: Michael Fenick
Email Address: mfenick@broward.edu
Department / Office Number: bldg 9 room 136
Office Hours: 10-3pm Mondays through Thursdays
Course Description and General Course Outcomes
This course is designed to allow students to implement the important concepts and techniques used to move from simple to complex visualizations of business data. This is a course in applied data collection and presentation.
In this course you will learn the basic concepts of:
Unit 1 : Introduction of Data Visualization
General Outcome
1.0 The student shall: Compare the many options for connecting to data.
Specific Learning Outcomes
Unit 2 : Business Data Analysis
General Outcome
2.0 The student shall: choose and create the appropriate data visualization to convey information to business users
Specific Learning Outcomes
Unit 3 : Calculated Fields and Formatting
General Outcome
3.0 The student shall: work with calculated fields, dates, aggregations, and formatting tools to help analyze business data.
Specific Learning Outcomes
Unit 4 : Building Visualizations and Sharing Data
General Outcome
4.0 The student shall: combine individual visualizations and share with end users to enable business decision makers.
Specific Learning Outcomes
Unit 5 : Business scenarios and best practices
General Outcome
5.0 The student shall: Identify and apply the appropriate visualization for different types of real-world problems.
Specific Learning Outcomes
Prerequisites & Corequisites
To maximize your chances for success in this course, make sure that you meet the following course prerequisites:
Prerequisites: None
Corequisites: None
Textbook and Course Materials
Title: Storytelling with Data
Author(s): Knaflic
Publisher, Edition: Wiley
ISBN:9781119002253
Link here: storytelling-with-data-cole-nussbaumer-knaflic
Software: Tableau Public and Tableu Gallery
Method of Instruction | Course Structure
In this class, you will attend on-campus classes and will engage in structured out-of-class and online activities. The online and in-class activities may include, but are not limited to, readings, discussions, essays, case studies, research, and quizzes & tests. See the course activity schedule for a detailed description of activities. Students are responsible for regularly reviewing the activity schedule and completing all assigned class activities.
Schedule Class Activities
Read and refer to this section regularly. Deadlines for assignments, assessments, discussions, quizzes & tests, and all other graded and non-graded activities are posted in the course schedule. Submitting work late will be permitted only under extenuating circumstances and only with prior notification and documentation (original funeral notice, original doctor note, etc.).
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
|---|---|---|---|
|
Week 1 |
1.1 Compare and contrast the most relevant sources of business data.
|
Reading Assignments: Chapter 1: the importance of context |
Assessment Due Dates: 10/23/2019 Syllabus Agreement (Online) Due:
|
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
|
Week 2 |
1.4 Joining multiple data sources into one visualization. |
Reading Assignments: Chapter 2 choosing an effective visualization Class Activities: Review Unit 1 assignment and practice for Unit 2 |
In class/Online/Out of class:10/30/2019 Unit 1 Project (in class)
|
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
| Week 3 Class on 10/30/2019 |
2.1 Create views including: Geographic MapsHeat MapsPie and Bar Charts Aggregate and Disaggregate data 2.2 Sort and Group data within a visualization. |
Reading Assignments: Chapter 3 and 4 clutter is your enemy and focus your audience's attention Class Activities: Review Unit 2 assignment and practice for Unit 3 |
In class/Online/Out of class: Due Date:11/6/ Unit 2 Project (in class) Unit 3 Discussion (online) |
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
|
Week 4
|
2.3 Create subtotals and cross-tabs. |
Reading Assignments: Ch 5, 6: Think like a designer and Six dissecting model visuals Class Activities: Review Unit 3 assignments and practice for Unit 4 |
In class/Online/Out of class: Due Date:11/13/2019 Unit 3 Assignment B (In class) Unit 3 Project (in class) |
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
| Week 5 Class on 11/13/2019 |
3.1 Manipulate string data using built in string functions. 3.2 Combine date functionality to describe data. 3.3 Apply logic statements to build a business visualization 3.4 Apply appropriate labels and annotations 3.5 Implement titles and captions |
Reading Assignments: Class Activities: Review Unit 3 assignments and practice for Unit 4
|
In class/Online/Out of class: Due Date: Unit 4 Project (in class) |
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
| Week 6 Class on 11/20/2019 |
4.1 Make worksheets interactive by using actions and filters. |
Reading Assignments: Chapter 8 and 9: Pulling it together and Case Studies Class Activities: Review Unit 3 assignments and practice for Unit 4 |
In class/Online/Out of class: Unit 5 Project (in class) |
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
| Week 7 Class on 11/27/2019 |
5.1 Choose the most appropriate type of visualization when making comparisons. 5.2 Apply the most effective visualization when checking the progress of a project or process. |
Reading Assignments: Ch 12: Final Thoughts Class Activities: Review Unit 3 assignments and practice for Unit 4 |
In class/Online/Out of class: 12/4/2019 Unit 6 Project (in class) |
| Dates & Units | Specific Learning Outcomes | Class Activities | Assessment Due Dates |
| Week 8 Class on 12/4/2019 |
5.3 Visualization of spatial relationships. 5.4 Incorporate an iterative approach and user feedback when improving and versioning data visualizations. |
Reading Assignments: Class Activities: Review job opportunities on indeed.com for SQL within your field of study. |
In class/Online/Out of class: 12/4/2019 None
|
Grading and Instructions for Course Activities
Instructions for Discussions (if used):
- Use the discussion board to respond to the assigned topic or post questions that might be of general interest to all students such as questions about assignments, tests, etc. Feel free to respond to other students if you think you can help them. In all online communication, it is expected that all students will follow adhere to the netiquette rules. Individuals who violate the netiquette policy or engage in disruptive online behaviors may have their class access privileges revoked and/or they may be referred to the Student Dean. Students who continue to engage in unacceptable online behavior even after being warned, may be permanently denied access to the class and/or may receive an F for the class.
Instructions for Quizzes & Tests:
- You will take quizzes in class/online. Tests and exams will be administered in class. Questions may be multiple choice, matching, fill in the blank, and short answer. Scores will be posted x business days after the due date.
Instructions for Assignments and Group Projects:
- Assignments are due on the due date as listed in the course activities schedule. Assignment scores and feedback will be given x business days after the due date. Groups will be assigned in class.
Late Work and Make-up Assessments
- It is at the discretion of the instructor to offer a make-up activity and is not guaranteed. Make-up tests will only be considered under extenuating circumstances, and with prior notification and documentation (original funeral notice, original doctor note, etc.). Scheduling appointments and vacations are not valid reasons for requesting a make-up test.
How your Grade will be Determined
| Assessment (Quantity) | Graded Points | Total Points | Percent Total |
|---|---|---|
|
Discussions (6) |
30 points |
180 |
|
In class Projects (6) |
40 points |
240 |
|
Assignments (12) |
45 points |
540 |
|
Orientation Discussion (1) |
20 points |
20 |
| Orientation Quiz (1) | 20 points | 20 |
Grading Scale
| Grade | Points Earned / Percentage |
|---|---|
|
A |
900 - 1000+ points | 90 - 100+% |
|
B |
800 - 899 points | 80 - 89.9% |
|
C |
700 - 799 points | 70 - 79.9% |
|
D |
600 - 699 points| 60- 69.9% |
|
F |
0 - 599 points | 0.0 - 59.9% |
Course Policies
Attendance and Participation Policies
During the first week of class and to be successful in the course, attending the first day is important. If you do not complete the requirements by the add/drop date, you should drop the course by the official drop/add deadline or expect to pay for the course.
If you stop participating after the withdrawal date, you will receive an F. To avoid this situation, you should attend class regularly and remain an active learner in the online portion of the class. Always communicate extenuating circumstances to your instructor. Ongoing communication with the instructor is critical to your course success.
Communication Practices
- In the event that the course communication tools are unavailable for more than 24 hours, the instructor will communicate with students (if necessary) via their BC email address.
- You may contact your instructor during their online/in-person office hours or schedule an online/in-person meeting.
Academic Honesty
Your academic work must be the result of your own thought, research, or self-expression. Academic misconduct includes, but is not limited to the following: cheating, plagiarism, unacceptable collaboration, falsification of data, aiding and abetting dishonesty, unauthorized or malicious interference, hacking computer property or software, and online disturbances. Please refer to the Student Code of Conduct Policy and the Student Code of Conduct section located in the Student Handbook for more information. All required class activities may be subject to submission to Turnitin.com for the detection of plagiarism. All submitted papers will be included as source documents in the Turnitin.com reference database solely for detecting plagiarism of such papers.
Types of Academic Dishonesty:
- Cheating: Is defined as obtaining or attempting to obtain, or aiding another to obtain credit for work by dishonest or deceptive means.
- Plagiarism: The use of words or ideas of the original creator without attribution as if they were your own. Plagiarism ranges from copying someone else's work verbatim and elaborating on or altering someone else's work.
- Self-Plagiarism: Submitting or reusing parts of a previous paper without referencing source it was first submitted. This includes retaking a course and turning in previously submitted papers and data.
- Unacceptable Collaboration: Using answers, solutions, or ideas that are the results of collaboration without citing the fact of the collaboration is improper.
- Falsification of Data: Making up or falsifying information and data. Examples include making up or altering data for an experiment or citing reference to sources you did not actually use.
- Pay Services: Employing an assignment writing service or having another write the paper for you.
- Enabling: Aiding and abetting another student in an act of academic dishonesty. Examples include giving someone a paper to copy and allowing someone access to your account.
- Unauthorized or malicious interferences: If one person deliberately interferes with the work or activities of another person on purpose to cause the other harm or irreparable damages. Academic honesty violations are considered a breach of policy and may result in academic penalties (zero points on the assignment/test in question, and/or a failing grade for the class), disciplinary action, and/or referral to the Dean of Student Affairs.
Class Policies
- Cell phone - Please turn your phone to silent as to not disturb the class.
- Arriving late/leaving early - Please be considerate of the class in progress, make every effort to arrive on time, and do not leave class early.
Academic Accommodations for Students with Disabilities
If you are requesting academic accommodations, you must first register with Accessibility Resources (contact information is provided below). Accessibility Resources will evaluate your request and determine eligibility. If approved, you will be provided with an Accommodation Plan that you must deliver to me either electronically or in person. Once received, we will discuss which accommodations you are requesting for this class, and in accordance with Broward College policy 6Hx2-5.09 you will be provided with the appropriate accommodations. Students who wait until after completing the course, or an activity, to request accommodations should not expect any grade to be changed, or to be able to retake the course or activity.
- Central Campus, Willis Holcombe Center: 954-201-6527
- North Campus, BC Online: 954-201-2313
- South Campus, Miramar Centers, Pines Center, Weston Center: 954-201-8913
- Deaf Services: (TDD) 954-201-6445 (VP) 954-635-5850
Safety, Security & Emergency Preparedness
Safety is everyone’s responsibility, and it is essential that all members of the Broward College community familiarize themselves with various safety tools, resources, and procedures to remain safe both on and off campus. You are encouraged to visit the Campus Safety & Security website for a wealth of information and resources as it relates to safety at Broward College. Included on the website is a variety of information, videos, and resources on crime prevention, active shooter preparedness, how to report suspicious activity, hurricane preparedness, services, and how to respond in an emergency. Campus Safety is available 24 hours a day, 7 days a week and can be reached by calling 954-201-HELP (4357). Visit www.broward.edu/safety for more information.
Technical Requirements and Resources
- If you are having trouble with an online class activity or D2L tool, contact your instructor regarding the issue.
- For technical assistance, please visit the Help Desk page.