Course Details
Course Code: BUSN661 Course ID: 4631 Credit Hours: 3 Level: Graduate
This course is designed to continue the examination of data and its use in the problem-solving process. In this course, students will integrate advanced skills in Microsoft Excel 2010 with data analysis techniques, including an introduction to big data add-ins such as PowerPivot and the use of Data Analysis Expressions (DAX) to create queries in the PowerPivot tool. (Prerequisite: BUSN660)
Prerequisites
Course Schedule
| Registration Dates | Course Dates | Session | Weeks |
|---|---|---|---|
| 12/28/20 - 06/04/21 | 06/07/21 - 08/01/21 | Spring 2021 Session D | 8 Week session |
| 01/25/21 - 07/02/21 | 07/05/21 - 08/29/21 | Summer 2021 Session B | 8 Week session |
| 02/22/21 - 07/30/21 | 08/02/21 - 09/26/21 | Summer 2021 Session I | 8 Week session |
| 03/29/21 - 09/03/21 | 09/06/21 - 10/31/21 | Summer 2021 Session D | 8 Week session |
Current Syllabi
After successfully completing this course, you will be able to
CO‐1 Learn about various Excel functions and how to use them to carry out calculations and produce outcomes.
CO‐2 Learn about Optimization in Excel and how to use Solver add‐in to Perform calculations and produce optimization reports.
CO‐3 Summarize & describe data, and compute measures to demonstrate knowledge of descriptive statistics.
CO‐4 Learn about variable relationships and regression modeling CO‐5 Learn about PowerPivot & DAX
CO‐6 Use Data Visualization Software features within spreadsheet, statistical, and data visualization programs to display data.
This course delivered via distance learning will enable students to complete academic work in a flexible manner, completely online. Course materials and access to an online learning management system will be made available to each student. Online assignments are due by Sunday evening of the week as noted and include Forum questions (accomplished in groups through a threaded forum), examination, and individual assignments submitted for review by the Faculty Member). Assigned faculty will support the students throughout this eight‐week course.
| Name | Grade % |
|---|---|
| Discussion Forums | 21.00 % |
| Discussion 1 | 3.00 % |
| Discussion 2 | 3.00 % |
| Discussion 3 | 3.00 % |
| Discussion 4 | 3.00 % |
| Discussion 5 | 3.00 % |
| Discussion 6 | 3.00 % |
| Discussion 7 | 3.00 % |
| Assignments | 54.00 % |
| Week 1 Homework | 7.71 % |
| Week 2 Homework | 7.71 % |
| Week 3 Homework | 7.71 % |
| Week 4 Homework | 7.71 % |
| Week 5 Homework | 7.71 % |
| Week 6 Homework | 7.71 % |
| Week 7 Homework | 7.71 % |
| Final Exam | 25.00 % |
| Final Exam Project | 25.00 % |
Required Course Textbooks ‐
|
9780735669130 |
9780735681071 |
Wayne Winston |
Microsoft Excel 2013 Data Analysis and Business Modeling |
|
9780735676343 |
9780735676565 |
Marco Russo and Alberto Ferrari |
Microsoft® Excel® 2013: Building Data Models with PowerPivot |
Web Sites
In addition to the required course texts, the following public domain web sites are useful. Please abide by the university’s academic honesty policy when using Internet sources as well. Note web site addresses are subject to change.
|
Site Name |
Web Site URL/Address |
|
American Psychological Association (APA) Style Website |
|
|
Purdue Online Writing Lab |
|
|
YouTube Video on Formatting an APA Style Paper |
|
|
Microsoft Office Training Website |
http://office.microsoft.com/en‐us/support/training‐ FX101782702.aspx |
|
YouTube Videos on Microsoft Excel for Beginners |
|
|
Business Analytics Techniques |
| Book Title: | Microsoft® Excel® 2013: Building Data Models with PowerPivot (Ebook available through the APUS Online Library) |
| ISBN: | 9780735676343 |
| Publication Info: | Microsoft Press/Pearson |
| Author: | Marco Russo and Alberto Ferrari |
| Unit Cost: | $41.39 |
| Book Title: | Microsoft Excel 2013 Data Analysis and Business Modeling (Ebook available through the APUS Online Library) |
| ISBN: | 9780735669130 |
| Publication Info: | Microsoft Press/Pearson |
| Author: | Wayne Winston |
| Unit Cost: | $51.39 |