iRubric: Quiz 2 FA19 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Quiz 2 FA19 Quiz 2 Rubric Code: U2W4A83 By rlewando Ready to use Public Rubric Subject: Business Type: Assessment Grade Levels: Undergraduate

New Employees Descriptions
	Unacceptable 0 pts	Acceptable Minor Errors (N/A)	Target 0.5 pts
New Employees Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors N/A	Target New Employees Query created properly.
Employees
	Unacceptable 0 pts	Acceptable Minor Errors 0.25 pts	Target 1 pts
Employees Transformed	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target (a) Query Imported properly (b) Bottom 2 rows removed (c) New Employees appended to the bottom so that there are 20 total rows. D) FullName field created and Moved.
Customer & Product
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 1 pts
Uppercase & Data Type	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target (a) First and Last Names are UPPERCASE (b) Price Column has Currency Data Type
Calculated Fields	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target (a) Merge correct with Field named Product Price. (b) Total Sales Calculated Column correct. (c) Total Discount Calculated Column correct. (d) Data Types are correct
Purchase
	Unacceptable 0 pts	Acceptable Minor Errors (N/A)	Target 0.5 pts
Relationship Correct	Unacceptable Incomplete or errors found.	Acceptable Minor Errors N/A	Target Relationship correct.
KPI Calculated Field
	Unacceptable 0 pts	Acceptable Minor Errors (N/A)	Target 1 pts
SUMX	Unacceptable Incomplete or errors found.	Acceptable Minor Errors N/A	Target SUMX function correct.
KPI created	Unacceptable Incomplete or errors found.	Acceptable Minor Errors N/A	Target KPI created with the correct Absolute Value and color schemes correct.
Pivot Table KPI	Unacceptable Incomplete or errors found.	Acceptable Minor Errors N/A	Target Pivot Table KPI built correctly and displays Status colors correctly.
Pivot Table Questions
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
Question 1	Unacceptable Incorrect	Acceptable Minor Errors N/A	Target Question 1 is correct
Question 2	Unacceptable Incorrect	Acceptable Minor Errors Only one part of the question was correct.	Target Question 2 is correct
Question 3	Unacceptable Incorrect	Acceptable Minor Errors N/A	Target Question 3 is correct
Files not Linked Properly
	Unacceptable 0 pts	Unacceptable 0 pts	Unacceptable 0 pts
Link to G Drive broken	Unacceptable N/A	Unacceptable N/A	Unacceptable One or more files are not linked. No points assigned to this but if any of them are not linked, deduct -1 in the grade.