در این آموزش تصویری با ارزیابی پروژه با استفاده از Statistics و Excel آشنا می شوید. در این دوره آموزشی استفاده از توابع آماری ساخته شده در اکسل و فایل های قالب و دانش پروژه برای تخمین مدت زمان پروژه، تلاش های کار، هزینه ها آموزش داده می شود. و همچنین روش برنامه ریزی یکپارچه نیز مطرح می شود.

این دوره آموزشی محصول موسسه آموزشی Pluralsight است.

لیست سرفصل های این دوره:

  • مقدمه ای بر PERT و روش برنامه ریزی یکپارچه
  • تکنیک های تخمین
  • میانگین، میانه و مد
  • انحراف معیار
  • توابع آماری اکسل
  • برآورد PERT
  • قانون پارکینسون
  • توزیع نرمال با استفاده از DIST
  • انحراف استاندارد PERT
  • SPERT برآورد شده با انتظار بالا
  • SPERT برآورد شده با انتظار پایین
  • SPERT برآورد شده با انتظار متوسط
  • ویژگی های SPERT
  • روش برنامه ریزی یکپارچه (USM)
  • توزیع دو جمله ای
  • ساخت پروژه Obversion در اکسل
  • شبیه سازی پروژه Obversion
  • 6 گام روند USM
  • و…

عنوان دوره: Pluralsight Easily Estimate Projects Using Statistics and Excel

نویسنده: William Davis

سطح: مبتدی

مدت زمان: 4 ساعت و 51 دقیقه


Use Microsoft Excel's built-in statistical functions, course template files, and your own project knowledge to easily and confidently estimate project durations, work efforts, costs, agile sprints, and agile releases. Use the Unified Scheduling Method to confidently create a dynamic, right-sized project reserve for traditional projects.
How confident are you when you create project schedules and budgets? How confident does your project sponsor want you to be? What would it cost to increase your confidence, or how much less costly would your project be if you accepted more risk? Using Microsoft's built-in statistical functions, you can easily create probabilistic project estimates using just a 3-point estimate (minimum, most likely, maximum) for any uncertain outcome and a subjective opinion about how likely the most likely outcome really is. Using the normal distribution probability curve and Excel's statistical functions, it's easy to see the difference between low risk, high cost, long schedule estimates from high risk, low cost, short schedule estimates. The key concept that this course introduces is called Statistical PERT, which goes well beyond the Program Evaluation and Review Technique (PERT.) Statisitical PERT can be used by both traditional and agile project teams to create project-related estimates. Using additional Excel statistical functions, this course also shows how traditional project teams can use the Unified Scheduling Method to create dynamic, right-sized project reserves for when their Statistical PERT estimates are exceeded during the project execution phase. Confidently create project estimates to fit any tolerance for risk you want using Microsoft Excel, Statistical PERT, and the Unified Scheduling Method!

Easily Estimate Projects Using Statistics and Excel
Course Introduction
Introduction to Statistical PERT and Unified Scheduling Method
Estimation Techniques
Estimating in the Area of Uncertainty
Statistics Refresher Introduction
Mean, Median and Mode
Standard Deviation
Bell-shaped Curves
Excel's Statistical Functions
Foundational Underpinnings of Statistical PERT
PERT Estimation
Parkinson's Law
Normal Distribution using NORM.DIST (Part 1)
PERT Standard Deviation
Normal Distribution using NORM.DIST (Part 2)
SPERT Estimation with High Expectation
SPERT Estimation with Low Expectation
SPERT Estimation with Moderate Expectation
Characteristics of SPERT
Demonstrate Statistical PERT in Excel
SPERT Template Quick Demo
Mode versus Mean in SPERT
SPERT from Scratch (Part 1)
SPERT from Scratch (Part 2)
SPERT from Scratch (Part 3)
SPERT from Scratch (Part 4)
SPERT Template Full Demo
SPERT Calibration and Ratio Scales
The Unified Scheduling Method (USM)
Introduction and Objectives
The Game of Obversion
The Binomial Distribution (Part 1)
The Binomial Distribution (Part 2)
The Binomial Distribution (Part 3)
Project Obversion Introduction
Build Project Obversion in Excel
Choose a Reserve for Project Obversion
Simulate Project Obversion
USM Project Statements
Successful Failures in USM
The 6-Step USM Process
USM Demo (Part 1)
USM Demo (Part 2)
Statistical PERT for Agile Teams
Introduction and Objectives
Agile Estimation Techniques
SPERT Estimates for Agile Teams
An Agile Sprint Goal, Stretch Goal
Committed and Uncommitted PBIs
An Agile Sprint Bell Curve (Part 1)
An Agile Sprint Bell Curve (Part 2)
Defining a Sprint Goal and Stretch Goal
SPERT in Agile Action - 5 Steps
SPERT with Sprint Planning Demo (Part 1)
SPERT with Sprint Planning Demo (Part 2)
SPERT with Sprint Planning Demo (Part 3)
SPERT with Agile Release Planning
Agile Release Planning - An Example
An Agile Release Plan Bell Curve
SPERT with Release Planning Demo

حجم فایل: 400MB