DA 200 Data Analytics

 

Course Description

This course is designed as an introduction to the field of analytics, an inductive approach to gaining insights on data, thus informing decision-making. It covers various fundamental techniques rooted in management science to solve problems in various functional domains, such as marketing, finance, economics and operations. Students will learn a wide variety of analytical and business intelligence tools to demonstrate their ability to execute, understand, present and discuss analytical results, thus building a strong foundation in data-driven decision making.

Course Learning Goals

After completing this course, you will be able to:

  • Apply quantitative methods to solve management problems in marketing, finance, economics and operations
  • Interpret and communicate results of analyses effectively
  • Retrieve and manipulate data for analysis
  • Evaluate scenarios to support optimal decision making

    Course Competencies

    In this course, you will develop the following competencies:

    Competence

    Competence Statement and Criteria

    S1X

    Can implement data-driven solutions to business problems

    FX

    Can apply data-driven concepts and tools to one’s focus area

    S5

    Can explain and evaluate the nature and process of science

    Course Resources

    To buy your books, go to http://depaul-loop.bncollege.com

    Required Reading

    MyITLab 2016. Pearson.

    ISBN: 9780134455877

    Exploring Microsoft Office Excel 2016 Comprehensive

    ISBN: 9780134479446

    Recommended reading (not required):

    To be assigned and made available as needed.

    Course Grading Scale

    A = 94 to 100

    A- = 90 to 93.99

    B+ = 87 to 89.99

    B = 83 to 86.99

    B- = 80 to 82.99

    C+ = 77 to 79.99

    C = 73 to 76.99

    C- = 70 to 72.99

    D+ = 67 to 69.99

    D = 60 to 69.99

    F = 59.99 or below

    INC

    Grades lower than a C- do not earn credit or competence at the School of Continuing and Professional Studies.

    Course Structure

    This course consists of X modules. The estimated time to complete each module is week. The following table outlines the course. Please note that all videos are available on MyITLab. Students must have an active account to view them.

    Week, Module # and Title

    Readings

    Assignments

    Module 1 Introduction (or Refresher)

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R.(2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 1. Introduction to Excel [Video].
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 1 Power Point Slides
    • Ungraded simulation exercise  on MyITLab (Under Module 1)

    1.1 Discussion 1

    Module 2 Basic Quantitative Analysis

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 2. Quantitative Analysis [Video].
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 2 Power Point slides
    • Simulation exercises 1 on MyITLab (Under Module 2)

    2.1 Assignment 1

    Module 3 Depicting Data Visually

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 2. Quantitative Analysis [Video].
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 3 Power Point slides
    • Simulation exercises 2 on MyITLab (Under Module 3)

    3.1 Assignments 2

    3.2 Assignments 2

    Module 4 Summarising Data for Analysis

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 5. Subtotals, Pivot Tables, Pivot Charts [Video]
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 4 Power Point slides
    • Simulation exercise 3 on MyITLab (Under Module 4)

    4.1 Assignment 3

    Module 5 Data Modelling

    Required
    • Power Pivot Demo
    • Optional
      • Stikeleather, J. (2013). How to Tell a Story with Data. Harvard Business Review. April 24, 2013. https://hbr.org/2013/04/how-to-tell-a-story-with-data/
      • The 101 Guide To Telling a Compelling Story With Data. Maptive. https://www.maptive.com/101-guide-telling-compelling-story-data/
      • Segal, E. How to Tell Stories with Data (Really).
      • InteractiveJournalism_Presentation.pdf

    5.1 Discussion 3

    5.2 Term Project Proposal

    Module 6: Decision Making I – What-If Analysis and Optimisation

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 6. What If Analysis: Using Decision Making Tools [Video].
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 6 Power Point slides
    • Simulation exercise on MyITLab (Under Module 6 and 7)

    6.1 Assignment 4

    Module 7: Decision Making II – What-If Analysis and Optimisation

    Required

    Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 6. What If Analysis: Using Decision Making Tools[Video].

    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 6 Power Point slides
    • Simulation exercise on MyITLab (Under Module 6 and 7)

    7.1 Assignment 5

    7.2 Discussion 4

    Module 8: Statistical Functions

    Required

    Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 8. Imports, Web Queries, and XML: Managing Data [Video].

    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 8 Power Point slides
    • Simulation exercise on MyITLab (Under Module 8)

    8.1 Assignment 6

    Module 9: Data Queries and Management

    Required

    Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 8. Imports, Web Queries, and XML: Managing Data [Video].

    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 9 Power Point slides
    • Simulation exercise on MyITLab (Under Module 9)

    9.1 Assignment 7

    9.2 Discussion 5

    Module 10: Financial Functions

    Required
    • Poatsy, M., Mulbery, K., Davidson, J., and Grauer, R. (2013). Exploring: Microsoft Excel 2013, Comprehensive. Chapter 7. Specialized Functions: Logical, Lookup, Databases, and Finances [Video].
    Highly Encouraged
    • Test your understanding exercises
    Optional
    • Module 10 Power Point slides
    • Simulation exercise on MyITLab (Under Module 10)

    10.1 Term Project

    10.2 Assignemnt 8

    To see the course due dates, please check the Calendar on your course home page.


    Assessment of Learning


    Percentage distribution of Assessments

    Grading Category

    % of Final Grade

    Assignments (x7)

    42%

    Discussion (x5)

    15%

    Project proposal

    13%

    Project (Paper)

    30%

    Total

    100%

    There are 8 assignments in total that are to be completed on MyITLab. Each can be attempted multiple times before the deadline, and the highest score from each attempt will be taken. The lowest score from the 8 will be dropped.

    Grading Policies and Practices

    To complete the course, you must complete each of the assignments as described in the course and submit them to your instructor by the assigned deadline. In addition, you must participate in the course discussion forum by responding to all instructor requests and by interacting with fellow classmates as necessary.

    Completed work must be uploaded on D2L. This includes all assignments and the ePortfolio. The discussions and recaps are completed on D2L. The due dates for each of the assignment are on the course calendar. All late submissions without an approved extension will receive a 5% penalty for each day late. All coursework, with or without an approved extension, must be turned in by the end of the 6th week. Afterwhich, no submissions will be accepted.

    General Assessment Criteria for All Writing Assignments

    All writing assignments are expected to conform to basic college-level standards of mechanics and presentation.

    Consider visiting the Writing Center to discuss your assignments for this course or any others. You may schedule appointments (30 or 50 minutes) on an as–needed or weekly basis, scheduling up to 3 hours worth of appointments per week. Online services include Feedback–by–Email and IM conferencing (with or without a webcam). All writing center services are free.

    Writing Center tutors are specially selected and trained graduate and undergraduate students who can help you at almost any stage of your writing. They will not do your work for you, but they can help you focus and develop your ideas, review your drafts, and polish your writing. They can answer questions about grammar, mechanics, different kinds of writing styles, and documentation formats. They also can answer questions and provide feedback online, through IM/webcam chats and email. Obviously, the tutors won’t necessarily be familiar with every class or subject, but they are able to provide valuable help from the perspective of an interested and careful reader as well as a serious and experienced student-writer.

    Schedule your appointments with enough time to think about and use the feedback you’ll receive. To schedule a Face-to-Face, Written Feedback by Email, or Online Appointment, visit www.depaul.edu/writing.

    College and University Policies

    This course includes and adheres to the college and university policies described in the links below:

    Academic Integrity Policy (UGRAD)

    Academic Integrity Policy (GRAD)

    Incomplete Policy

    Course Withdrawal Timelines and Grade/Fee Consequences

    Accommodations Based on the Impact of a Disability

    Protection of Human Research Participants

    APA citation format (GRAD)

    Additional Course Resources

    University Center for Writing-based Learning

    SNL Writing Guide

    Dean of Students Office

    Discussion Forums

    Discussion Forums are an important component of your online experience. This course contains discussion forums related to the topics you are studying each week. For requirements on your participation in the Discussion Forums, please see “Course Expectations” in the syllabus.

    A Course Q & A discussion forum has also been established to manage necessary, ongoing social and administrative activities. This is where the management and administrative tasks of the course are conducted, and where you can ask ‘process’ questions and receive answers throughout the course. Please feel free to answer any question if you feel you know the answer; this sharing of information is valuable to other students.

    Course Expectations

    Time Management and Attendance

    SCPS courses are not self-paced and require a regular time commitment EACH week throughout the quarter.

    You are required to log in to your course at least four times a week so that you can participate in the ongoing course discussions.

    Online courses are no less time consuming than "face to face" courses. You will have to dedicate some time every day or at least every second day to your studies. A typical four credit hour "face to face" course at SCPS involves three hours of classroom meeting per week, plus at least three to six hours of study and homework per week.

    This course will require at least the same time commitment, but your learning activities will be spread out through the week. If you have any problems with your technology, or if you need to improve your reading or writing skills, it may take even longer.

    The instructor should be notified if your life events do not allow you to participate in the course and the online discussions for more than one week. This is particularly important when there are group discussions or you are working as part of a team.

    If you find yourself getting behind, please contact the instructor immediately.

    Your Instructor's Role

    Your instructor's role in this course is that of a discussion facilitator and learning advisor. It is not their responsibility to make sure you log in regularly and submit your assignments. As instructor, s/he will read all postings to the general discussion forums on a daily basis but may not choose to respond to each posting. You will receive feedback to assignments.

    The instructor may choose to designate "office hours" when s/he will be online and available and will immediately respond to questions. Depending on the instructor, this response may be by e-mail, instant messenger or telephone. Otherwise, you will generally receive a response to emailed or posted queries within 48 hours.

    Your Role as a Student

    As an online student, you will be taking a proactive approach to your learning. As the course instructor's role is that of a learning guide, your role is that of the leader in your own learning.

    You will be managing your own time so that you can complete the readings, activities and assignments for the course, and you will also be expected to take a more active role in peer learning.

    View this brief demo Taking SCPS courses in D2L to learn how to navigate through your course.

    If you’re new to SCPS see additional resources on the course home page under Student Resources/Getting Started.

    Course Netiquette

    Online discussions are an important part of your course experience. To ensure a positive learning environment, please follow the following minimum expectations. Use your common sense, as not all situations can be covered:

    Policies

    Academic Integrity

    DePaul University is a learning community that fosters the pursuit of knowledge and the transmission of ideas within a context that emphasizes a sense of responsibility for oneself, for others and for society at large. Violations of academic integrity, in any of their forms, are, therefore, detrimental to the values of DePaul, to the students' own development as responsible members of society, and to the pursuit of knowledge and the transmission of ideas. Violations include but are not limited to the following categories: cheating; plagiarism; fabrication; falsification or sabotage of research data; destruction or misuse of the university's academic resources; alteration or falsification of academic records; and academic misconduct. Conduct that is punishable under the Academic Integrity Policy could result in additional disciplinary actions by other university officials and possible civil or criminal prosecution. Please refer to your Student Handbook for further details.

    Plagiarism: Plagiarism is a major form of academic dishonesty involving the presentation of the work of another as one's own. Plagiarism includes but is not limited to the following:

    Plagiarism, like other forms of academic dishonesty, is always a serious matter. If a instructor finds that a student has plagiarized, the appropriate penalty is at the instructor's discretion.

    DePaul University Incomplete Policy

    The intent of the Incomplete grade is to allow students extra time to complete their final assignments. This need arises because, in the closing weeks of the course, they have an event of significant magnitude that adversely affects their ability to complete the course, e.g. serious illness, death in the family, overseas deployment, or natural disaster.

    You must request an incomplete grade in writing two weeks before the end of the quarter. Incomplete grades will be considered only after you have satisfactorily completed at least 75 percent of the coursework, and you have such an unexpected, uncontrollable event that prevents you from completing your course. Do not assume that you will qualify for an incomplete. Students who are failing the course at the point where they request an incomplete will not receive one, nor will they be granted after the end of the quarter. Incomplete grades are given at the discretion of the instructor.

    If you do receive permission from the instructor to take an incomplete in the course, you will be required to complete a contract with the instructor, specifying how you will finish the missing work within the next two quarters (excluding summer). See the Incomplete Grade Contract Form.

    Undergraduate and graduate students will have up to two quarters to complete an incomplete. At the end of the second quarter (excluding summer) following the term in which the incomplete grade was assigned, remaining incompletes will automatically convert to "F" grades. Ordinarily no incomplete grade may be completed after the grace period has expired. Instructors may not change incomplete grades after the end of the grace period without the permission of a college-based Exceptions Committee. This policy applies to undergraduate, graduate and professional programs. NOTE: In the case of a student who has applied for graduation and who has been approved for an Incomplete in his or her final term, the incomplete must be resolved within the four-week grace period before final degree certification.

    Description of Pass/Fail Grading Options

    Students have the option of taking all SCPS undergraduate courses as Pass/Fail even if a class is initially structured for a letter grade assessment. In these cases a Pass is awarded when competence is demonstrated at a level that would otherwise earn a grade of C- or higher.

    In deciding to select Pass/Fail grading students should be aware that competencies assessed in a course as Pass will earn credit hours toward degree completion but will not be included in computing grade point averages. Attempted competence demonstration assessed within a class as Fail will not only be recorded as credit hours attempted but will also be included in computing a student's grade point average.

    For SCPS students, competencies awarded for Independent Learning Pursuits and in the Lifelong Learning Domain do not count toward the university's specification that only twenty credit hours may be earned through the Pass/Fail assessment option.

    Please note: There are three SCPS courses within the BA curriculum that are always assessed on a Pass/Fail basis: Foundations of Adult Learning (course number LL 250; competences L-2 and F-1), Advanced Project (course number FA 303; competences F-11 and F-12) and Summit Seminar (course number LL 390; competence L-12). These classes may not be taken for a letter grade assessment. Therefore, work that might otherwise be assessed at grades A through C- will earn a Pass in these classes.

    There are an additional four SCPS courses within the Lifelong Learning Area of the BA curriculum for which instructors regularly use a Pass/Fail grading system that may instead be taken for a letter grade assessment if this is a student's preference. These classes are: Independent Learning Seminar (course number LL 103; competence L1); Writing to Competence (course number LL 260; competence L-4), Critical Thinking (course number LL 270; competence L-5), Research Seminar (course number LL 300; competences L-8 and L-9), and Externship (course number LL 302; competences L-10 and L-11). In addition, SNL's undergraduate Writing Workshop (course number LL 140; competence H-3-J) regularly uses Pass/Fail, although students may request a letter grade assessment. In these instances SNL offers undergraduate students the opportunity to request a letter grade assessment from their instructor. Students who need a letter grade for tuition reimbursement may wish to consider this option, as well as those who wish to raise their GPA. Students planning to attend graduate school may also prefer letter grades to Pass/Fail assessments.

    If a student wants to switch the method of assessment, either to or from the Pass/Fail option, this must be requested from the instructor in writing by the beginning of the third week of the quarter. For courses that meet fewer than ten weeks of the quarter, this request must be made by the beginning of the third week of the course. The grading basis may not be changed after these deadlines, with no exceptions.

    For Students Who Need Accommodations Based on the Impact of a Disability

    Students seeking disability-related accommodations are required to register with DePaul's Center for Students with Disabilities (CSD) enabling you to access accommodations and support services to assist your success. There are two office locations:

    Loop Campus - Lewis Center #1420 - (312) 362-8002
    Lincoln Park Campus - Student Center #370 - (773) 325-1677
    csd@depaul.edu
    Students are also invited to contact their instructor privately to discuss your challenges and how the instructor may assist in facilitating the accommodations you will use in this course. This is best done early in the term and the conversation will remain confidential.

    Dean of Students Office
    The Dean of Students Office (DOS) helps students in navigating the university, particularly during difficult situations, such as personal, financial, medical, and/or family crises. Absence Notifications to faculty, Late Withdrawals, and Community Resource Referrals, support students both in and outside of the classroom. Additionally we have resources and programs to support health and wellness, violence prevention, substance abuse and drug prevention, and LGBTQ student services. We are committed to your success as a DePaul student. Please feel free to contact us at http://studentaffairs.depaul.edu/dos/.

    Copyright and Student Privacy
    In accordance with DePaul’s Acceptable Use Policy, commentary and materials within SNL Online classes shall not be copied, reproduced or published elsewhere without the express written consent of individuals involved.

    Protection of Human Subjects

    For more information see: http://research.depaul.edu/

    Demonstrating the acquisition of competences in this course can involve "interactions"—interviewing and or observing other people—discussing those interviews or observations with other class members and writing them up in one or more final report(s). As such, these activities qualify as "research" with "human subjects" and are subject to University and Federal guidelines. Because it takes place in the context of this course, your research is exempt from approval by the School for New Learning's Local Review Board only under the following conditions:

    Credits

    This course was designed and produced by X and staff at SNL Online of the School of Continuing and Professional Studies of DePaul University.

    ©2015 School of Continuing and Professional Studies, DePaul University. All Rights Reserved by SCPS during contractual interval with the Author.

    Printed in the USA.4

    ​​​​​​​​​​​