DOC PREVIEW
USC CSCI 599 - PSSPKit1Sv1

This preview shows page 1-2-3 out of 9 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 9 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 9 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 9 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 9 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

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

USC CSCI 599 - PSSPKit1Sv1

Documents in this Course
Week8_1

Week8_1

22 pages

Week2_b

Week2_b

10 pages

LECT6BW

LECT6BW

20 pages

LECT6BW

LECT6BW

20 pages

5

5

44 pages

12

12

15 pages

16

16

20 pages

Nima

Nima

8 pages

Week1

Week1

38 pages

Week11_c

Week11_c

30 pages

afsin

afsin

5 pages

October5b

October5b

43 pages

Week11_2

Week11_2

20 pages

final

final

2 pages

c-4

c-4

12 pages

0420

0420

3 pages

Week9_b

Week9_b

20 pages

S7Kriegel

S7Kriegel

21 pages

Week4_2

Week4_2

16 pages

sandpres

sandpres

21 pages

Week6_1

Week6_1

20 pages

4

4

33 pages

Week10_c

Week10_c

13 pages

fft

fft

18 pages

LECT7BW

LECT7BW

19 pages

24

24

15 pages

14

14

35 pages

Week9_c

Week9_c

24 pages

Week11_67

Week11_67

22 pages

Week1

Week1

37 pages

LECT3BW

LECT3BW

28 pages

Week8_c2

Week8_c2

19 pages

Week5_1

Week5_1

19 pages

LECT5BW

LECT5BW

24 pages

Week10_b

Week10_b

16 pages

Week11_1

Week11_1

43 pages

Week7_2

Week7_2

15 pages

Week5_b

Week5_b

19 pages

Week11_a

Week11_a

29 pages

LECT14BW

LECT14BW

24 pages

T7kriegel

T7kriegel

21 pages

0413

0413

2 pages

3

3

23 pages

C2-TSE

C2-TSE

16 pages

10_19_99

10_19_99

12 pages

s1and2-v2

s1and2-v2

37 pages

Week10_3

Week10_3

23 pages

jalal

jalal

6 pages

1

1

25 pages

T3Querys

T3Querys

47 pages

CS17

CS17

15 pages

porkaew

porkaew

20 pages

LECT4BW

LECT4BW

21 pages

Week10_1

Week10_1

25 pages

wavelet

wavelet

17 pages

October5a

October5a

22 pages

p289-korn

p289-korn

12 pages

2

2

33 pages

rose

rose

36 pages

9_7_99

9_7_99

18 pages

Week10_2

Week10_2

28 pages

Week7_3

Week7_3

37 pages

Load more
Download PSSPKit1Sv1
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view PSSPKit1Sv1 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view PSSPKit1Sv1 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?