Thursday, September 02, 2010

   Quick Links:   Articles     MA Blog     Community Blog     Templates     Books     BA Humor     Events     Jobs     Interview Questions         RSS Feeds

Business Analysis Templates & Aides for the Business Analyst

Resources



Templates & Aides


Recent Templates | | Search | Subscribe (RSS)

» Use Case Points - Excel Template and Tutorial for Project Estimation

Statistics:Article Rating (10665 Views) (6 Comments)
Posted by: sehlhorst on Monday, August 25, 2008
Categories: Business Analysis Planning (BABOK KA), Requirements Analysis (BABOK KA), xxx> MS Excel, Estimation

Estimating the amount of work required to deliver software is hard. Estimating the amount of work in the very early stages of a project is even harder. A method was developed to estimate the amount of work required by analyzing what the system will allow its users to do. That method is called Estimating With Use Case Points.

Introduction

The cost estimation technique of use case points evaluates the following factors to determine an estimate of cost:

  1. Technical Factors of the Implementation. Primarily non-functional requirements of the system.
  2. Environmental Factors. Mostly characterizing the implementation team, but touching on process as well.
  3. Use Case Quantity and Complexity. The number of use cases and the number of steps within the use cases.
  4. Actor Quantity and Complexity. The number and type of actors and interface.
  5. Effort Estimation. The previously collected data is converted into man-hours.
  6. Free Excel Spreadsheet for Calculating UCP. Download it today. Its free.

Author: Scott Sehlhorst

DOWNLOAD: You must be logged-on in order to download templates.

Comments
By monopoly @ Saturday, January 17, 2009 4:34 PM
Thanks for ur sharing,very good resource!!

By djl @ Tuesday, May 19, 2009 4:52 PM
This template was exactly what I needed. With it, I was able to reply to and meet a specific customer need. Thank you very much for developing this template and sharing it with the rest of us.

By BColpitts @ Wednesday, July 15, 2009 2:47 PM
Yes, kuddos for this template. I also wish to thank you for sharing this.

By shakti123 @ Wednesday, May 05, 2010 7:11 AM
Thanks for the stunning post. I like that. www.designingtips.com for new business templates.

By MAK @ Tuesday, May 25, 2010 2:43 AM
Good stuff, Thanks for sharing the template. As we all understand, any simple, consistent and workable methodology would help practitioners. If possible, please share one fully worked out example.

By Anonymous @ Tuesday, May 25, 2010 6:41 PM
Hello All,
Great template, but I was wondering if anyone has any resource that can supplement my understanding of how to rank each variable.

Also, In what scenarios, have u guys used the above template.

Thanks
Chapman MBA Grad

Only registered users may post comments.

Do you twitter?: If you want short updates on what's going on in the BA world and at ModernAnalyst.com, simply follow us on Twitter: http://twitter.com/ModernAnalyst



Privacy Statement  |  Terms Of Use
Copyright 2006-2010 by Modern Analyst Media LLC