CIS 3100 - Business Intelligence Case Equal Pay Assessment for Sonoma Industries, Inc.
CIS 3100 – MS Excel Assignment
Scoring Rubric
|
Criteria |
|
Points Possible |
Points Earned |
|
A. MyAnalysis.xlsx file 1. Successful creation of the MyAnalysis.xlsx file
|
(5)
|
5 |
|
|
B. Census Sheet 1. Successful data migration from Sample_Dataset 2. Durations for current and terminated employees 3. Evaluation scoring and performance rating
|
(5) (5) (5) |
15 |
|
|
C. Male_ Employees Sheet 1. Successful data migration from Census sheet
|
(5)
|
5 |
|
|
D. Female_ Employees Sheet 1. Successful data migration from Census sheet
|
(5) |
5 |
|
|
E. Salary_Pivot 1. Successful results displayed as directed |
(10)
|
10 |
|
|
F. Occupation_Pivot 1. Successful results displayed as directed
|
(10) |
10 |
|
|
G. Data_Analysis (Executive Summary) 1. Data Analysis Format 2. Salary Comparison Report 3. Salary Bracket 4. Average Salary by Occupation 5. Top 10 Highest Paid Positions 6. Visualization Charts as directed
|
(5) (10) (10) (10) (5) (10) |
50 |
|
|
Total |
100 |
|