Grading Criteria for Project 4

 

Practice Exercise 5, page 210, 50 points

Points

Requirement

     2

The Excel file name is Chapter 4 Practice 5 - Solution.xls.  If the title at the top of the worksheet is anything other than ‘The Value of a Roth IRA’, please send me an email immediately.

   10

Cells C5-J14 Of the “Calculations” worksheet have formulae equivalent to: =FV($B5,C$4,-$J$16)

   10

A separate Line Chart exists in the Excel worksheet showing the value (y-axis) of a Roth IRA for different time periods (x-axis) and different interest rates (plotted lines)

     5

All lines on the chart have increased weight (thickness)

     5

The 9.00% line is red, the 8.500% line is green and the 8.00% line is blue

     2

The Word file name is Chapter 4 Practice 5 - Solution.doc

     2

The left and right margins of the Word document are .75”

   10

Both the worksheet data and chart are properly linked into the Word document, the Excel table is centered on the first (portrait) page and the Chart is fills the second  (landscape) page

     4

Student’s name, course name, section, and project identifier are on a worksheet.

 

Practice Exercise 9, page 214, 50 points

Points

Requirement

    2

File name is Chapter 4 Practice 9 - Solution.xls.  If the value in cell C10 is anything other than ‘4455’, please send me an email immediately.

    4

C4:C17 have formulae equivalent to =LEFT(B4,4)

    4

Cells H4-H17 have formulae equivalent to either: =(D4*$D$24)+(E4*$E$24)+(F4*$F$24)+(G4*$G$24)   or  =AVERAGE(D4*$D$24+E4*$E$24+F4*$F$24+G4*$G$24)

    4

Cells J4:J17 have nested if formulae equivalent to: =IF(I4="Good",$I$22,IF(I4="OK",$I$21,IF(I4="Poor",$I$20,0)))  or

=IF(I4=$H$22,$I$22,IF(I4=$H$21,$I$21,IF(I4=$H$20,$I$20,0)))

    4

Cell I16 is blank and cell J16 has a value of 0.0

    4

Cells K4-K17 have formulae equivalent to: =ROUND(H4+J4,0)

    4

Cells L4-L17 have formulae equivalent to: =VLOOKUP(K4,$J$20:$K$24,2)

    4

Cells L4-L17 have conditional formatting so each A is green and each D is red

    4

Cells M4:M17 have formulae equivalent to: =RANK(K4,$K$4:$K$17)

    4

Formatting and contents match figure 425, page 214

    4

Row 3 has a thick bottom border and row 19 has a thick top border

    4

Columns A, B are hidden on the submitted workbook.

    4

Student’s name, course name, section, and project identifier are on a worksheet.