Course Syllabus
Course Name: Applied Business Analytics |
Term/Session: Spring 2018 |
Course Number: QMB2302C |
Reference Number: 585242 |
Table of Contents
Faculty Contact Information
Instructor Name: |
Michael Fenick |
Office Phone: |
954-201-6698 |
Fax: |
954-201-7937 |
Email: |
Please use BConline (D2L) email. Use my BC email ONLY if you are unable to access the course email: mfenick@broward.edu |
Office Hours: |
Office: Campus / Bld. / Room: Central/Bldg 9/ room 136
Days/Time: Tuesdays, Wednesdays From 2pm - 4:30pm and Mondays from 9:30am until 2:00 pm
I will be in my office during these days and hours if you need to see me in person.
|
BC Safety Phone #: |
954-201-HELP (4357) |
Return to Table of Contents
Course Description
This course provides a foundation for students to understand and apply the core principles and tools of a relational database. This combination of knowledge and skills will allow students to create tables, manage data within those tables, and create customized reports derived from data stored in relational databases.
Return to Table of Contents
General Course Outcomes
- Retrieving Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables Using Joins
- Using Subqueries to Solve Queries
Return to Table of Contents
Prerequisites & Corequisites
To maximize your chances for success in this course, make sure that you meet the following course prerequisites:
- Course Prerequisites and Co-requisites: Successful completion or testing out of REA 0017C and Eligibility to take ENC 1101
Return to Table of Contents
Attendance & Participation Policies
You must complete the Orientation tasks (Discussion, assignment, and assessment) by the due date listed or you will be withdrawn from the course. Simply logging into the course will not satisfy your attendance during this time. As with an on-campus course, students who are reported for non-attendance in an online course and are withdrawn are still responsible for paying for the course. If you do not complete the requirements of the first week of class, you should drop the course by the official drop/add deadline or expect to pay for the course.
It is very important for you to actively participate in this online class. If you stop participating in class discussions, do not submit assignments, or fail to take assessments prior to the withdrawal date, you will be withdrawn from class and receive a W or, if it is your third attempt, an F.
If you stop participating after the withdrawal date, you will receive an F. To avoid this situation, you should remain an active learner in this class and always communicate extenuating circumstances to your instructor. Ongoing communication with the instructor is critical to your course success. Completion of assessments, assignments, and other class activities are used as indicators of your participation in order to satisfy this reporting requirement.
See the list of activities required for participation and attendance on the General Course Policies page
Return to Table of Contents
General Policies & Technical Requirements
You are responsible for being familiar with all BConline policies and procedures related to your activity in this course.
Broward College Policies
- Review the Broward College Policies on topics including disability services, academic honesty, privacy, and critical event procedures.
BConline Policies
- Review the General Course Policies page for topics including rules for netiquette, definition of participation, and other information.
Technical Requirements
- Students taking an online course are expected to be moderately proficient in using a computer. Please go to the Technical Requirements page for a complete list of computer skills and technical requirements.
Return to Table of Contents
Communication Policies
Communication
- Use the course email tool only for private, personal, one-to-one communication with a specific individual, or groups of individuals. Do not send course related emails to the instructor's BC email address.
- 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. Access your BC email account at http://www.outlook.com
Faculty Response
- Course emails and discussion posts will be answered within 48 hours. Emails and submissions sent on Saturday or Sunday, or holidays may not be answered until the next school day. It is recommended that you post course-related questions in the discussion area. Other students may have the same questions as you or may even be able to answer your questions. If you need info related to a test or assignment, plan ahead and submit your questions well ahead of the due date. Additionally, you can contact your instructor during their online office hours or schedule an online meeting. Your instructor is not online 24 hours per day, so please allow time for responses.
Return to Table of Contents
Textbook & Materials
Return to Table of Contents
Methods of Instruction
This is a 3-credit hour blended course with several in class meetings. In this class, you will engage in structured out-of-class and online activities as well as meet in person on campus. The online activities may include, but are not limited to, readings, discussions, essays, case studies, research, and/or online assessments. See the course schedule for a detailed description of activities. Students are responsible for regularly reviewing the course schedule, meeting in class on campus, and completing all required assignments, discussions, and assessments.
Return to Table of Contents
Course Schedule & Activities
Submitting work late will be permitted only under extenuating circumstances and only with prior notification and documentation (original funeral notice, original doctor note, etc.). The deduction for late work will be 10% for each day late.
Instructions for Discussion Forum:
- Use the Q&A discussion thread to post questions that might be of general interest to all students such as questions about assignments, assessments, etc. Feel free to respond to other students if you think you can help them.
Instructions for Assignments:
- All your assignments are completed using MS Word and uploading the assignments into D2L.
Instructions for assessments:
- Some assessments will be completed in D2L and others may be taken during class time at the instructors discretion.. The assessments are timed and you will only be able to attempt each test once.
- Allow time to complete them before the closing date and time. Make sure you have a solid internet connection. If your ISP disconnects during a test you have a very short window of time to regain access. If you don't regain access your test will be closed and that will count as your attempt and you will not be able to repeat it.
- assessments are for assessment purposes only. They are not learning events. Once submitted you will not have access to the questions or answers.
Instructions for Participation:
- All your assessments are completed in D2L. The assessments are timed and you will only be able to attempt each test once.
- Allow time to complete them before the closing date and time. Make sure you have a solid internet connection. If your ISP disconnects during a test you have a very short window of time to regain access. If you don't regain access your test will be closed and that will count as your attempt and you will not be able to repeat it.
- assessments are for assessment purposes only. They are not learning events. Once submitted you will not have access to the questions or answers.
581116 |
QMB2302C |
APPLD BUS ANALYTICS |
08/21/2017 |
10/12/2017 |
06:30 PM to 09:15 PM |
W |
71 /230 |
HR Schema we will use:
\
How to login to Oracle:
****Login to Oracle using information here: QMB2302C_index****
- you mayl need to change your password after you login but you can just change it to password1 again to keep things easy!
Meeting Dates |
Topic |
Readdings |
Task to complete |
Wednesday, January 10, 2018 |
Introduction to Database Topics |
Lesson 1 |
|
Wednesday, January 17, 2018 |
Retrieving Data using the SQL SELECT Statement |
Lesson 2 |
- Attend Class
- Discussion 1
- Assignment 1
- Discussion 2
- Assignment 2
|
Wednesday, January 24, 2018 |
Restricting and Sorting Data |
Lesson 3 |
- Attend Class
- Discussion 3
- Assignment 3
|
Wednesday, January 31, 2018 |
Using Single-Row Functions to Customize Output |
Lesson 4 |
- Attend Class
- Discussion 4
- Assignment 4
|
Wednesday, February 7, 2018 |
Using Conversion Functions and Conditional Expressions |
Lesson 5 |
- Attend Class
- Discussion 5
- Assignment 5
|
Wednesday, February 14, 2018 |
Reporting Aggregated Data Using the Group Functions |
Lesson 6 |
- Attend Class
- Discussion 6
- Assignment 6
|
Wednesday, February 21, 2018 |
Displaying Data From Multiple Tables Using Joins |
Lesson 7 |
- Attend Class
- Discussion 7
- Assignment 7
|
Wednesday, February 28, 2018 |
Using Subqueries to Solve Queries |
Lesson 8 |
- Attend Class
- Discussion 8
- Assignment 8
|
Due dates:
There will be an in class project each week and a homework assignment each week
Return to Table of Contents
Grading & Exam Policies
- View your Grades
- Online assessment and exam grades will be available after finishing the assessment or exam.
- Grades for assignments will be posted within five BC working days of the closing date of the assignment.
- Grades for discussion postings will be posted within five BC working days after the discussion has closed.
- Make-up Exam
- It is at the discretion of the instructor to offer a make-up exam. Make-up exams 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 exam.
- How your Grade will be Determined
- You do NOT need to turn in work - if you have done the assigned queries your instructor will know from reports given to them by the database!!
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
Total points |
Percentage of total |
Assignments
|
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
400 |
50 |
Discussions |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
400 |
50 |
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
Technical Resources
- Password Reset
- If your password does not work or you forgot it, click this link to reset it: Student Password Reset.
- If you need further support, please contact the BC helpdesk at 954-201-7521 or helpdesk@broward.edu.
Return to Table of Contents