In this course, learners will be introduced to the capstone project and how to use advanced Data Analysis Tools to build spreadsheet models to solve a real-world business problem. In addition, learners will learn how to perform Correlation Analysis and Sensitivity Analysis using Microsoft Excel.
This module introduces learners to the final project and describes how to perform correlation analysis to help make informed business decisions.
涵盖的内容
6个视频2篇阅读材料5个作业
显示有关单元内容的信息
6个视频•总计15分钟
Welcome to the Capstone Course•2分钟
Correlation Analysis Overview•3分钟
Performing Correlation Analysis in Microsoft Excel•2分钟
Using Correlation Analysis in Business Problem Solving•2分钟
Walkthrough: Correlation Problem Aerospace R&D•3分钟
Walkthrough: Correlation Problem Psychology Exam•3分钟
2篇阅读材料•总计20分钟
Business Case: Aerospace R&D•10分钟
Practice Problem: Psychology Exam Scores•10分钟
5个作业•总计210分钟
Practice Quiz Lesson 1.1•30分钟
Aerospace R&D•60分钟
Psychology Exam Scores•60分钟
Practice Quiz Lesson 1.2•30分钟
Graded Quiz Lesson 1.1 - Lesson 1.2•30分钟
Sensitivity Analysis
第 2 单元•小时 后完成
单元详情
This module explains how to perform sensitivity analysis using Microsoft Excel and provides business problem examples to practice.
涵盖的内容
5个视频2篇阅读材料3个作业
显示有关单元内容的信息
5个视频•总计17分钟
Introduction to Sensitivity Analysis•1分钟
Performing Sensitivity Anaylsis Using Microsoft Excel•5分钟
Using Sensitivity Analysis in Business Problem Solving•3分钟
Sensitivity Problem Walkthrough: L-ia’s Bags•4分钟
Sensitivity Problem Walkthrough: Arts Kites•5分钟
2篇阅读材料•总计20分钟
Business Case: L-ia's Bags•10分钟
Business Case: Arts Kites •10分钟
3个作业•总计150分钟
L-ia's Bags•60分钟
Arts Kites•60分钟
Graded Quiz Lesson 2.1 - Lesson 2.2•30分钟
Final Project
第 3 单元•小时 后完成
单元详情
This module outlines the specifications for the final project. A sample business problem is also provided with step-by-step instructions.
Founded in 1867, Howard University is a private, research university that is comprised of 14 schools and colleges. Students pursue more than 140 programs of study leading to undergraduate, graduate and professional degrees. The University operates with a commitment to Excellence in Truth and Service and has produced one Schwarzman Scholar, three Marshall Scholars, four Rhodes Scholars, 12 Truman Scholars, 25 Pickering Fellows and more than 165 Fulbright recipients. Howard also produces more on-campus African American Ph.D. recipients than any other university in the United States. For more information on Howard University, visit www.howard.edu.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.