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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- advanced excel statistical functions formulae
- repeatability california state university northridge
- grading rubric excel 2003
- business and technical complexity assessment
- georgia department of education
- starting excel as a beginner
- analytic hierarchy process what is ahp
- calculation of repeatability and reproducibility
Related searches
- grading rubric for essay
- grading rubric for argumentative essay
- essay grading rubric template
- essay grading rubric sample
- grading rubric format
- grading rubric template for college
- grading rubric for persuasive essay
- grading rubric example
- grading rubric template free
- grading rubric examples college
- college grading rubric for papers
- grading rubric for writing assignment