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
Class meeting on: xx/xx/xxxx

1.1 Compare and contrast the most relevant sources of business data.
1.2 Analyze the similarities and differences between working with data files versus database servers.
1.3 Explain and apply Dimensions and Measures when visualizing data.

 

Reading Assignments:

Review Syllabus

Chapter 1: The importance of context

Assessment Due Dates: xx/xx/xxxx

Syllabus Agreement (Online)
Unit 1 Discussion (online)
Unit 1 Assignment A (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates

Week 2
Class on xx/xx/xxxx

1.4 Joining multiple data sources into one visualization.
1.5 Troubleshoot data connection problems such as changes to underlying sources.

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:xx/xx/xxxx

Unit 1 Assignment B (in class)
Unit 1 Project (in class)

Unit 2 Discussion (online)
Unit 2 Assignment A (In class)
Unit 2 Assignment B (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates
Week 3
Class on XX/XX/XXXX
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:

Unit 2 Project (in class)

Unit 3 Discussion (online)
Unit 3 Assignment A (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates

Week 4
Class on XX/XX/XXXX

 

 

2.3 Create subtotals and cross-tabs.
2.4 Create trend lines, subtotals, and Aliases

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: XX/XX/XXXX

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 XX/XX/XXXX
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:
Ch 7: Lessons in StoryTelling

Class Activities:

Review Unit 3 assignments and practice for Unit 4


In class/Online/Out of class:

Due Date:

Unit 4 Project (in class)
Unit 4 Discussion (online)
Unit 4 Assignment A (In class)
Unit 4 Assignment B (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates
Week 6
Class on XX/XX/XXXX

4.1 Make worksheets interactive by using actions and filters.
4.2 Publish workbooks to formats including:Adobe ReaderPackaged WorkbooksPDFHTML

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)
Unit 5 Discussion (online)
Unit 5 Assignment A (In class)
Unit 5 Assignment B (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates
Week 7
Class on XX/XX/XXXX
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 02: 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)
Unit 6 Discussion (online)
Unit 6 Assignment A (In class)
Unit 6 Assignment B (In class)

Dates & Units Specific Learning Outcomes Class Activities Assessment Due Dates
Week 8
Class on XX/XX/XXXX

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):

Instructions for Quizzes & Tests:

Instructions for Assignments and Group Projects:

Late Work and Make-up Assessments

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

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:

Class Policies

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.

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