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 Microsoft PowerPivot® and the use of Data Analysis Expressions (DAX) to create queries in the PowerPivot tool. (Prerequisite: BUSN660) Microsoft Excel 2010® is a registered trademark of Microsoft Corporation. Microsoft PowerPivot® is a registered trademark of Microsoft Corporation.
Prerequisites
Course Schedule
| Registration Dates | Course Dates | Start Month | Session | Weeks |
|---|---|---|---|---|
| 05/21/2022 - 11/04/2022 | 11/07/2022 - 01/01/2023 | November | Fall 2022 Session I | 8 Week session |
| 07/25/2022 - 12/30/2022 | 01/02/2023 - 02/26/2023 | January | Winter 2023 Session B | 8 Week session |
| 09/26/2022 - 03/03/2023 | 03/06/2023 - 04/30/2023 | March | Winter 2023 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.
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.
| Book Title: | Microsoft® Excel® 2013: Building Data Models with PowerPivot (Ebook available through the APUS Online Library) |
| ISBN: | 9780735676343 |
| Publication Info: | Microsoft Press/Pearson Lib |
| 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 Lib |
| Author: | Wayne Winston |
| Unit Cost: | $51.39 |