PPMP Exercise Kit 1S© 1999 A. Winsor Brown BES/MSEE PSSPKit1Sv1.DOC-1 06/30/99@11:07 AMPPMP Assignment Kit # 1S Process version: PSSP0 Lecture Number: 1Assignment:Text Read Preface, Chapters 1 and 2Spreadsheet 1S Use PSSP0 to write spreadsheet 1s, Linear RegressionReport R0 SEI Student QuestionaireBefore writing spreadsheet 1s, repeat the class demonstration; read process specifications(attached or Appendices C) and the attached Spreadsheet Guidance and exercisespecifications .Assignment Kit 1S Contents Instructions Order to submit assignmentPSSP0 Process Scripts PSSP0 Project Plan SummaryPSSP0 Script n/a Time Recording LogPSSP0 Planning Script n/a Defect Recording LogPSSP0 Development Script n/a Spreadsheet source listingPSSP0 Postmortem Script n/a Other requested materialsForms, Templates, and StandardsPSSP0 Project Plan SummaryLike C15C16 Time Recording LogC17C18 Defect Recording LogC19C20 Defect Type Standard n/aPPMP Exercise Kit 1S 2© 1999 A. Winsor Brown BES/MSEE PSSPKit1Sv1.DOC-2 06/30/99@11:07 AMExercise GuidanceAssumptions• You are assumed to be as proficient in doing spreadsheets as you are at your second best orsecond most favorite programming language. If not, pay attention to the demonstrationsAND repeat them before starting an assignment.• You are using Excel 97 or higher, or some other compatible spreadsheet tool.• You are going to be producing personal tools. The data used for testing is NOT your data, soyou MUST set up the results so that they can be easily re-used. We will provide suggestionson how you can do that, but you are free to find AND DOCUMENT (on the spreadsheet)your own ways of accomplishing the objective.Repeating Demonstration versus Doing Assignment• Demonstrations are designed as refreshers for those who know Excel well. They are alsosupposed to expose those who have only cursory knowledge of Excel to the approaches,techniques and functions that you will need for the course• If you learned things from the in-class demonstrations, Repeat it!− DO NOT record time--this is learning to bring you to a proficiency level assumed byPSP/PPMP.− DO NOT fill out a project plan summary--this is learning ….− DO NOT record defects--this is learning ….− DO record your own notes, hints, lessons learned!Hints• In general, you will be given "hints" (names of functions, and specific guidance) to help yougenerate the assignment.General• Directory structure: Package all the stuff of one assignment in the same folder.•PPMP Exercise Kit 1S 3© 1999 A. Winsor Brown BES/MSEE PSSPKit1Sv1.DOC-3 06/30/99@11:07 AMSpreadsheet GuidanceOperational: Spreadsheet "Programming" as PSP/PPMP learning tool – simulate theprogramming experience• do "coding"− in formula mode or its equivalent (Tools/Options/View/Formulas[Window Option])− with "no calculation" on entry (Tools/Options/Calculation/Manual).− on syntax errors, record the time spent correcting as PSP "Compile" phase• during coding− Use named regions− • do "testing"− turn formula mode off− "test" your spreadsheet.• use any applicable built in functions in your spreadsheet− specific function hints often be provided• use graphs where ever appropriate− to check your work− to validate your data.• keep things simple:− Don’t nest functions;− transform data from one area to another in simple, logical steps;− refer back to base input data (use named ranges); etc.• exercise descriptions and test data provide an indication of the desired precision of the results• where data are provided in a tabular format,duplicate that format in the design of your spreadsheet (even though not explicitly call for)Doing Assignment• Move and copy worksheets rather than continually adding to the spreadsheet.• Keep the skeleton answer as simple as possible. Only it needs to be shown in Formula mode– do thad in a separate worksheet.Graphing:• Scatter Diagrams for x,y pairs• Frequency distributions via _________• Frequency distributions with FREQUENCY• Overlay straight lines for +/- 1,2, and 3 σPPMP Exercise Kit 1S 4© 1999 A. Winsor Brown BES/MSEE PSSPKit1Sv1.DOC-4 06/30/99@11:07 AMRemember/Repeat the Demo• Using the simple template• How to add data• Frequency diagramDemo Kit # 1S Lecture PPMP1: Process version: PPMP/PSP0Standard DeviationSpreadsheet 1S1. References: DSE1 Appendix A2 (see below for abreviated version)2. Spreadsheet Demo 1S RequirementsWrite a spreadsheet to estimate the mean and standard deviation of a sample of n realnumbers. The mean is the average of numbers. The standard deviation calculation isdescribed in A2 (but you may use built in functions if you wish).Do a graphic frequency distribution of the Demo data. Indicate on it the mean and +/- 1, 2and 3 sigma values.Hints:• Use STDEV, AVERAGE for the simple calculations• Use FREQUENCY to get the distributionDSE Appendix A2 abreviated versionwhere i is an index to the numbers, andXavg is the average value of the numbers.Std =σ=xi− xavg()2i=1n∑n − 1Table A9 Variance Calculation for Item Num Total (LOC)n x (Xi -Xavg)**1 1862 6993 1324 2725 2916 3317 1998 18909 78810 1601TotalsAverageVarianceStandard Deviation 1 A Discipline for Software Engineering, Watts HumphreyPPMP Exercise Kit 1S 5© 1999 A. Winsor Brown BES/MSEE PSSPKit1Sv1.DOC-5 06/30/99@11:07 AMExercise Kit # 1SLecture PPMP1: Process version: PPMP/PSP0Exercise Spreadsheet 1S:Linear Regression1. Prerequisites and References:DSE Appendix A7 (see below for abreviated version) and spreadsheet 1S.A2. Spreadsheet 1S RequirementsDevelop a spreadsheet to calculate the linear regression size-estimating parameters for aset of n programs where historical object LOC and new and changed LOC data areavailable.Linear regression and the required formulas are explained in Section A7 (but you mayuse built in functions if you wish).Do a graphic frequency distribution of the 1S data.Indicate on it the mean and +/- 1, 2 and 3 sigma values.Do a graphic display of the 1S data sets and super-impose on the data the linearregression curve.Hints:• Use STDEV, AVERAGE for the simple calculations• Use INTERCEPT and SLOPE funcions for the beta calculations• use 0, ½ maximum of the original independent variable rounded up to the next 100, and therounded up maximum as the three independent values for the lines;• use the formula with the appropriate values of the betas to calculate the
View Full Document