Course Name: Data Integration and Manipulation |
Term: Fall 2018 |
Course Number: ISM 4138C |
Session: 4 |
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) |
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 Alteryx Designer Core Certification.
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.
To maximize your chances for success in this course, make sure that you meet the following course prerequisites:
![]() |
Textbook and Material Information Learning Alteryx: A beginner's guide to using Alteryx for self-service analytics and business intelligenceBaruti, Renato
|
This is a 3 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.
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 | Readings | Activities, Assignments & Assessments | |
Week 1
|
By the end of this lesson, you will be able to: 1.1 Retrieving, restrict and sort Data |
Orientation to the course |
1. Orientation to class |
|
Week 2
|
By the end of this lesson, you will be able to: 2.1 Describe the value of functions within a SQL query |
Orientation CH 2: Basic SQL SELECT Statements |
Before class: Read Chapter 2 |
|
In class: 1. Practice queries |
||||
Online/Out of class:
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 3 Thursday, November 1, 2018 |
By the end of this lesson, you will be able to: 3.1 Describe the types of reports that use grouping |
CH 8: Restricting Rows and Sorting Data |
Before class: Read Chapter 8 |
|
In class: Practice queries |
||||
Online/Out of class:
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 4 Thursday, November 8, 2018
|
By the end of this lesson, you will be able to: 4.1 Describe the types of problems that subqueries can solve |
CH 9: Joining Data from Multiple Tables |
Before class: Read chapter 9 |
|
In Class: In class lab |
||||
Online/Out of class
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 5
Thursday, November 15, 2018
|
By the end of this lesson, you will be able to: 5.1 Insert, update, and delete data
|
CH 10: Selected Single-Row Functions |
Before class: Read chapter 10 |
|
In Class: In class lab |
||||
Online/Out of class:
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 6 Thursday, November 22, 2018
|
By the end of this lesson, you will be able to: 5.2 Explain the table structure |
CH 11: Group Functions |
Before class: Read Chapter 11 |
|
In Class: In class lab |
||||
Online/Out of class:
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 7 Thursday, November 29, 2018
|
Oracle 1Z0-071 SQL Exam Prep |
CH 12: Subqueries and MERGE Statements |
Before class: Practice Exams |
|
In Class: In class lab
|
||||
Online/Out of class:
|
||||
Dates & Units | Specific Learning Outcomes | Readings | Activities, Assignments & Assessments | |
Week 8 Thursday, December 6, 2018 |
Oracle 1Z0-071 SQL Exam Prep |
Practice Exams |
Before class: Practice Exams |
|
In Class: Cert Exam |
||||
Online/Out of class: Practice Exam |
Instructions for Discussions (if used):
Instructions for Quizzes:
Instructions for Exercises:
Instructions for Labs:
Grades
How your Grade will be Determined
Assessment |
Percent of Final Grade |
Quizzes |
25% |
Exercises |
25% |
In Class Labs |
25% |
Final Certification Exam |
25% |
Total |
100% |
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% |
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.
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.
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
//