iRubric: Assignment 3 SU20 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Assignment 3 SU20 Assignment 6 FA19 Rubric Code: F2X5A84 By rlewando Ready to use Public Rubric Subject: Business Type: Assignment Grade Levels: Undergraduate

Late Submission Descriptions Enter rubric description
	Unacceptable 0 pts	Acceptable Minor Error 0 pts	Target 0 pts
Enter Title	Unacceptable Two or more days late. 20% per day.	Acceptable Minor Error One day late.	Target Assignment turned in on time
Getting Data
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Importing and Connecting	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target 11 Data files connect to the ITAOAssignments folder correctly.
EMPLOYEES EMPLOYEES table
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
UPPERCASE	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Rename Columns Enter description	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Duplicate, Split	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Move, Rename	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
EMPLOYMENT TYPE EMPLOYMENT TYPE table
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Index Column	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Rename & Move Column	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
JOB HISTORY JOB HISTORY table
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Rename Column	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Data Types Changed	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
Remove Errors & Blanks	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete
JOB HISTORY
	Unacceptable 0 pts	Acceptable Minor Error 0.25 pts	Target 0.75 pts
Calculated Column	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete. Must calculate the Salary with Bonus not just Bonus.
JOBS
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Index Column	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Rename & Move	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
STATES
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Rename & UPPERCASE	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Find & Replace	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
WORK LOCATION
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Merge	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Rename Find & Replace	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
HOME LOCATION
	Unacceptable 0 pts	Acceptable Minor Error (N/A)	Target 0.25 pts
Merge	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Rename Find & Replace	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Relationships & Pivot Tables
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Relationships and Hidden Tables	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Pivot Table 1 Build, Worksheet Name & Must delete all other worksheets not used	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Formatting	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Chart Build	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Pivot Table 2 Build & Formatting	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Slicers added and Connected	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Question 1	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Question 2	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Question 3	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Question 4	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete.
Total Annual Salary Calculated Field in Power Pivot	Unacceptable	Acceptable Minor Error	Target
% Total Annual Salary
	Unacceptable 0 pts	Acceptable Minor Error 2 pts	Target 3 pts
% Total Annual Salary Calculated Field in Power Pivot	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found	Target Complete. Must have DIVIDE, CALCULATE and ALL functions.
Report #1
	Unacceptable 0 pts	Acceptable Minor Error 0.25 pts	Target 1 pts
3 Visualizations Used	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target 3 Visualizations Used
Title	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Title added and it ties into the overall theme of the Report
Formatting	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Color scheme used properly so that all chart bars, columns & pies are easily visible and clear.
Worksheet Name	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Worksheet Renamed and it ties into the overall theme of the Report
Chart Combinations Make Sense	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target The combinations used has a flow and makes sense that they are used together.
Report #2
	Unacceptable 0 pts	Acceptable Minor Error 0.25 pts	Target 1 pts
3 Visualizations Used	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target 3 Visualizations Used
Title	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Title added and it ties into the overall theme of the Report
Formatting	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Color scheme used properly so that all chart bars, columns & pies are easily visible and clear.
Worksheet Name	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target Worksheet Renamed and it ties into the overall theme of the Report
Chart Combinations Make Sense	Unacceptable Missing, incomplete or two or more errors.	Acceptable Minor Error One error found.	Target The combinations used has a flow and makes sense that they are used together.
Summery Report 1
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Thoughtful Analysis	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target The Analysis is well written. The story they are trying to tell is clear and the analysis provides an understanding of what the student was trying to accomplish.
Tied in all Charts Used	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target The analysis tied in all charts used in the Report.
Summery Report 2
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Enter Title	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target The Analysis is well written. The story they are trying to tell is clear and the analysis provides an understanding of what the student was trying to accomplish.
Enter Title	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target The analysis tied in all charts used in the Report.
KPI
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
KPI present and correct	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target KPI was correct and used in one of the two Reports.

Subjects:

Business

Types:

Assignment

Discuss this rubric