Syllabus
This is a blended course that meets in Bldg. 13, Room 105

Course Name: Data Integration and Manipulation
Term: Fall 2018
Course Number: ISM 4138C
Session: 4

Table of Contents

Faculty Contact Information Schedule and Course Activities
Course Description and Purpose Grading and Instructions for Course Activities
General Course Outcomes Attendance and Participation Policies
Prerequisites & Co-requisites Communication Practices
Textbook and Course Materials General Policies and Technical Requirements
Methods of Instruction (Course Structure)  

Faculty Contact Information

Instructor Name: Prof. Fenick
Office Phone: 954-201-6698
Department Phone: 954-201-6723
Email: Please use mfenick@broward.edu to reach me.
Office Hours: TBA
BC Safety Phone #: 954-201-HELP (4357)

Return to Table of Contents

Course Description and Purpose

In this course, students extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations including data warehouses. Students will solve data integration business problems using best practices and troubleshooting techniques. This will prepare students for the Tableau Prep Designer Core Certification.

Return to Table of Contents

General Course Outcomes

1.0 The student shall be able to read and write from multiple data sources.

2.0 The student shall be able to parse data from multiple sources

3.0 The student shall be able to load data from multiple sources at once.

4.0 The student shall be able to join data sets and write to multiple data files grouped by key fields.

Return to Table of Contents

Prerequisites & Co-requisites

To maximize your chances for success in this course, make sure that you meet the following course prerequisites:

Return to Table of Contents

Textbook and Course Materials

Textbook and Material Information

No textbook purchase is required. Reading and videos will be provided within the shell.

 

Return to Table of Contents

Methods of Instruction (Course Structure)

This is a credit hour blended course. In this class, you will attend on-campus classes plus 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/or online quizzes and tests. See the course activity schedule for a detailed description of activities. Students are responsible for regularly reviewing the activity schedule and completing all required assignments including quizzes and participating in discussions.

There will be times during class where you may be asked to watch a video or read an article prior to attending class. This will be part of the class discussion and you may be asked to work in a group. Students who are ready for class generally are more successful in the course. Always check a rubric to see how you will be graded.

Return to Table of Contents

Schedule and Class Activities

Read and refer to this section regularly. It will provide you with an in-class and online schedule of due dates. 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.).

Class Activities Schedule

 

Meeting Dates

 

Specific Learning Outcomes Activities, Assignments & Assessments

Week 1

Thursday, October 18, 2018

 

By the end of this lesson, you will be able to:

1.1The student will load data from multiple sources

1.2 The student will join data sets

1.3The student will write to multiple data files, grouped by key fields

1.4 The student will use conditional statements in formulas

1. Orientation to class
2. Review of syllabus
3. Login and Navigate Tableau Prep
4. View 2 Tableau prep videos
5. Assignment 1
6. Discussion 1

Week 2
Thursday, October 25, 2018

By the end of this lesson, you will be able to:

1.5 The student will format Date/Time fields
1.6 The student will use values from previous/subsequent rows in formulas

1. View Input Step Video
2. Read Input Step PDF
3. Complete Assignment 3
4. Discussion 2

Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 3

Thursday, November 1, 2018

 By the end of this lesson, you will be able to:

 2.1 The student will format data sets
2.2 The student will find and replace delimiters
2.3 The student will split fields into multiple columns

1 .Watch The Cleaning Step Video
2. Review the cleaning step PDF document
3. Complete Assignment
4. Watch Grou pand Replace Video
5. Review Group and Replace PDF
6. Complete Assignment 5: Group and Replace
6. Participate in Discussion 3

Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 4

Thursday, November 8, 2018

By the end of this lesson, you will be able to:

3.1 The student will summarize data by groups
3.2 The student will sort data.
3.3 The student will extract a specified portion of records from the data

  1. Watch Profile Pane Video
  2. Review Watch Profile Pane PDF document
  3. Complete Assignment 6: The Profile Pane
  4. Participate in Discussion 4: Data Quality
Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 5

 

Thursday, November 15, 2018

 

By the end of this lesson, you will be able to:

3.4 The student will pivot the orientation of a data table
3.5 The student will append multiple data streams into one unified stream



  1. Watch Pivot Step Video
  2. Review The Pivot Step (notes) pdf
  3. Complete Assignment 7: The Pivot Step
  4. Participate in Discussion 5: Why ETL?

 

Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 6

Thursday, November 22, 2018

 

 

By the end of this lesson, you will be able to:

4.1 The student will implement simple XML parsing and regular expressions
4.2 The student will build a Fuzzy Matching process
4.3 The student will build basic predictive time series forecasting workflows

 

  1. Watch Aggregate step Video
  2. Review The aggregate step (notes) pdf
  3. Complete Assignment 8: The Aggregate Step
  4. Participate in Discussion 6: Careers

 

Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 7

Thursday, November 29, 2018

 

 4.4 The student will parse JSON Data
4.5 The student will build an iterative macro

  1. Watch Union Step Video
  2. Review Union Step PDF document
  3. Assignment 9
  4. Watch the Join step Video
  5. Review the Join Step PDF
  6. Complete Assignment 10
  7. Participate in Discussion 7

 

Dates & Units Specific Learning Outcomes Activities, Assignments & Assessments

Week 8

Thursday, December 6, 2018

Tableau Prep Exam Prep

  1. Watch Output Step Video
  2. Review The Output Step (notes) pdf
  3. Complete Assignment 11: The Output Step
  4. Complete Final Project in class

 

 

Return to Table of Contents

Grading and Instructions for Course Activities

Instructions for Discussions (if used):

Instructions for Quizzes:

Instructions for Exercises:

Instructions for Labs:

Grades

How your Grade will be Determined

 

Item Number of Items Points per item Total points per item type Percent of Total Grade
Exercises  11 50 550 55%
In class Participation 7 30 210 21%
Discussions 7 20 140 14%
Final (in class) Project 1 100 100 10%

Grading Scale

Grades

Percentage

Grade = A

90 - 100+%

Grade = B

80 - 89.9%

Grade = C

70 - 79.9%

Grade = D

60 - 69.9%

Grade = F

59.9% -0.0%

Return to Table of Contents

Attendance and Participation Policies

You must attend class regularly, attendance is mandatory. If you feel like you will not be able to maintain regular attendance, obtain the required course materials and fulfill the course requirements, 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.

Return to Table of Contents

Communication Practices

Communication

Faculty Response

Netiquette

In all online communication, it is expected that all students will follow rules of online "netiquette". Netiquette is a set of rules for polite online behavior that all members of this class are expected to follow. Review some of the general netiquette rules.

Individuals who violate the netiquette policy or engage in disruptive online behaviors such as flaming (posting disrespectful or hostile comments), posting inappropriate comments, or shouting (posting messages using all capitals) 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.

Please don't use email short hand like ROTFLO (rolling on the floor laughing out loud) or BTW (by the way) - not everyone knows what these abbreviations mean. If you want to use emoticons (smileys) to convey feelings, please stick with the basics happy :-) sad :-( or wink ;-). Others are less well known and are subject to different interpretations. The idea is to be clear in your communications.

Return to Table of Contents

General Policies & Technical Requirements

You are responsible for being familiar with Broward College policies and procedures. See technical requirements in this section to "ready" your computer for online activities. A 24/7 helpdesk is available to address all technical issues.

Academic Success Centers (ASC)

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 are 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 the purpose of detecting plagiarism of such papers.

Types of Academic Dishonesty:

Class Policies

Disability Services

If you need academic accommodations and/or disability services support, you must contact the Office of Disability Services (ODS). It is your responsibility to contact the ODS to document disability prior to receiving services. You must notify the instructor that you have registered with the ODS and provide the instructor a copy of the ODS letter. Your documentation and any related communication with your instructor remain strictly confidential

Technical Requirements

Technical Issues

Return to Table of Contents