Grading Rubric – Excel 2003



Grading Rubric – Excel 2003

Tutorial 1, Case Problem 3

Class:

Professor:

Notes:

Solution File(s): Site2.xls and Site3.xls

|Description |Pts |Your Score |

|Site2.xls: | | |

|Formulas entered in range B14:E17 to calculate the weighted score for each factor in each city |2 | |

|Total weight score for each city in range B18:F18 calculated using AutoSum |2 | |

|Your name and the date entered on the Documentation sheet |1 | |

|Spell Checker used to correct spelling errors in the workbook |1 | |

|Site3.xls: |2 | |

|Copy of the Site Analysis worksheet pasted in a new sheet named “Site Analysis 2” | | |

|Weight score of Market Size (cell G7) changed to 0.2 and Labor Pool (cell G8) changed to 0.4. |2 | |

| | | |

|TOTAL POSSIBLE POINTS: |10 | |

YOUR SCORE: _______________

Grading Rubric – Excel 2003

Tutorial 1, Case Problem 4

Class:

Professor:

Notes:

Solution File(s): Budget.xls

|Description |Pts |Your Score |

|Labels and values, as shown in Figure 1-39, entered |1 | |

|Total net pay (in cell E9), total of each expense category (in range E12:18) and total monthly expenses |2 | |

|(in range B19:E19) calculated using AutoSum | | |

|Formulas entered in range B21:E21 to calculate the difference between the monthly net pay in row 9 and |2 | |

|the total expenses in row 19 | | |

|Formula entered in cell B6 to calculate the ending cash balance equal to the starting cash balance added|1 | |

|to the total net cash flow in cell E21 | | |

|Worksheet renamed as “Monthly Budget” |1 | |

|Documentation sheet with your name, the date, and the purpose of the workbook inserted at the beginning |1 | |

|of the workbook | | |

|Spell checker used to correct spelling errors on both worksheets |1 | |

|Empty worksheets deleted |1 | |

| | | |

|TOTAL POSSIBLE POINTS: |10 | |

YOUR SCORE: _______________

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download