excel

Business Intelligence Project Grading Rubric (50 points):

The following list shows the points for each worksheet. Partial credit may be earned for each worksheet. It also shows the order that these worksheets are expected in the Excel workbook. Please make that your final workbook has the worksheets in the order listed below (i.e, Data Analysis, Male_employees Worksheet, Female_employees Worksheet, etc.). Adherence to these instructions will facilitate the assessment of your project results.

RUBRIC CODE DESCRIPTION TOTAL POINTS

A

Census Worksheet

• Missing or incorrect job duration values

• Incorrect formula for Evaluation Total

Up to 7.5 points

B-1

Male_employees Worksheet

• Missing employee information

• Missing headings

• Incorrect filtered data

Up to 2.5 points

B-2

Female_employees Worksheet

• Missing employee information

• Missing headings

• Incorrect filtered data

Up to 5 points

C-1

Salary_pivot Worksheet

• Incorrect PivotTable results

Up to 5 points

C-2

Occupation_pivot Worksheet

• Incorrect PivotTable results

Up to 5 points

D

Data_Analysis Worksheet

• Incorrect formulas used to derive values for the cells of the worksheet

• No formulas used; values “hard coded” into the worksheet

• Incorrect PivotTable results

• Incorrect PivotChart results

• PivotChart lacks formatting (e.g., chart title, labels)

Up to 25 points