CaseRubric3.1.docx
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 15 points
|
|
B-1
|
Male_employees Worksheet
• Missing employee information
• Missing headings
• Incorrect filtered data
|
Up to 5 points
|
|
B-2
|
Female_employees Worksheet
• Missing employee information
• Missing headings
• Incorrect filtered data
|
Up to 10 points
|
|
C-1
|
Salary_pivot Worksheet
• Incorrect PivotTable results
|
Up to 10 points
|
|
C-2
|
Occupation_pivot Worksheet
• Incorrect PivotTable results
|
Up to 10 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 50 points
|
Kingmatt
