View the step-by-step solution to:

STATEMENT OF WORK 3 Assignment 3 - SE Develop a Worksheet Tool for Size Estimating and use it to develop a Size Estimate Report Background IPC...

Size estimation report
STATEMENT OF WORK Assignment 3 - SE Develop a Worksheet Tool for Size Estimating and use it to develop a Size Estimate Report Background IPC frequently develops software and has built up a large data base of information on what it takes to build certain specific kinds of software. There is also a small data base of reusable software components that are frequently used within new products. You have been assigned to develop a size estimating tool using a spreadsheet. The size estimating tool will accept data about a new project and historical data about related, prior projects and use this data to estimate the size of the new software, in source lines of code (SLOC) and in estimated bytes of memory (RAM). The spreadsheet(s) should produce tables that satisfy your company's policies for size estimation, per a separate handout. Note that although this assignment does not entail use of function points, the tool should be designed to work equally well with lines of code, function points, or any other unit of software size. Typical software projects The typical software project at IPC produces from 1 to 5 separate software items (SIs) , each of which performs a specific function, often on a separate processor. These processors and their corresponding software items are typically integrated to form the final system product. The reason software is divided into separate items is because each software item typically performs a separate function, on a separate processor, and may also be programmed in a different language. By keeping them separate, it is easier to develop them in parallel and, when repair and maintenance are required, you may be able to fix any one of them without changing the others. You can also develop and deliver different software items on different schedules. Each software item is typically subdivided into components that perform specific sub- functions. Some of these components are available in a library of reusable components, and in other cases such a component is derived from an older component by some sort of modification (for example, rewriting in a new language, adding functionality or changing it to be compatible with more recent standards). And sometimes a component may be shared between software items (this is known as “concurrent reuse”). _____________________________________________________________________________ _ Page 1 3
Background image of page 1
Sample Project To test out your estimating tool, you will use data from the "Mr. Television" project. Several documents are supplied to describe this project: a Statement of Work from the marketing organization and a System Design Summary from the system engineering organization are formal documents (but not necessarily complete or accurate). Other documents are provided as well, some of which may conflict with each other or with the formal documents . Part of your task is to evaluate all of this information and make judgment calls and assumptions (explaining your assumptions). Company Standards Also provided is a set of sample company standards for size and cost estimating and creating WBSs. These are inspired by actual company standards but are greatly reduced in scope. Your work is expected to conform to these standards to a reasonable degree. But if you have a good reason for differing, go ahead (and explain why). Risks and Assumptions The "Mr. Television" project has many risks. As you develop your estimate, note software related risks that might affect the size estimate and take them into consideration when doing your work. For example, if the information available on estimated size is unreliable, you might want to assume a greater range of possible sizes. Also note these risks for later use in the risk management plan of your SDP. You should also make a list of important questions you would like to get answers to if this were a real project. Those questions will be included in the risk management plan as well. If there is something you don’t know but feel that you need to know, you may need to make assumptions about the unknown. For example, suppose you don’t know if there is enough space to accommodate all of your software staff. You might make the assumption that there is enough space. Such unknowns and assumptions are documented at the beginning of the SDP. 1.0 Work to be Performed 1.1 Using a spreadsheet tool such as Microsoft Excel™, you are to design and implement a worksheet that will estimate the size of a single software item (type-I worksheet) and a second worksheet that will combine the information from several worksheets of the first kind (one per software item) into a size estimate for the entire system (type-S worksheet). A type-S worksheet will allow inputs from up to five separate type-I worksheets. Hint 1: to develop the type-S worksheet, start with a type-I worksheet and change the "components" to be the totals from the type-I worksheets). Hint 2: create a workbook for the whole assignment that contains each of the individual worksheets mentioned above as a separate worksheet. _____________________________________________________________________________ _ Page 2
Background image of page 2
Show entire document

Top Answer

We need you to clarify your question for our tutors! Clarification request: Dear Student, We... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online