iRubric: MSM Excel Exam 60 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
MSM Excel Exam 60 MSM Exam FA19 Rubric Code: AX6A39A By rlewando Ready to use Public Rubric Subject: Business Type: Exam Grade Levels: Undergraduate

A.03 Descriptions
	Unacceptable 0 pts	N/A 0 pts	Target 0.5 pts
Today's Date	Unacceptable Incomplete or one error found.	N/A N/A	Target 1. Documentation! Correct function for today's date
B.01
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Percent Discount	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 3. 'Customer'! Col O Function Returns correct "Percent Discount"
B.02
	Unacceptable 0 pts	Acceptable Minor Errors 0 pts	Target 0.5 pts
Conditional Formatting	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 4. 'Customer'! Col O Correct conditional formatting used
B.03
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Lengthy Business Trips	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 6. 'Customer'! E39 Function returns correct "Number of Lengthy Business Trips" values
B.04
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Business Trip Net Revenue	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 7. 'Customer'! E40 Function returns correct "Business Trip Net Revenue" values including ROUND.
B.05
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
% of Net Revenue	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 8. 'Customer'! E41 Function returns correct "% Net Revenue from Business Trips" values
B.06
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Average Airfare per Business Travel	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 9. 'Customer'! E42 Function returns correct "Average Airfare per Business Traveler" values
B.07
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Bonus/No Bonus	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 10. 'Customer'! H39:H42 Function returns correct "Sales Rep Bonus or No Bonus" values
B.08
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Commission Earned	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 11. 'Customer'! K39:K42 Function returns correct Commission Earned for each Sales Rep including the Bonus.
B.09
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Weeks since last departure	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 12. 'Customer'! N39 Function returns correct "Whole Weeks since last departure" values
C.00
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Named Range	Unacceptable Incomplete or two errors found.	N/A N/A	Target 13. 'Airlines'! Named Range Correct
C.01
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Flight Airline	Unacceptable Incomplete or two or more errors found.	N/A N/A	Target 14. 'New Travel'! C4 Function returns correct "Flight Airline"
C.03
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Total Surcharge	Unacceptable Incomplete or two or more errors found.	N/A N/A	Target 15. 'New Travel'! E4 Function returns correct "Total Surcharge"
C.04
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Region	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 16. 'New Travel'! F4 Function returns correct "Region"
C.05
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
Average Surcharge	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 17. 'New Travel'! M5 Function returns Average Surcharge per ticket.
D.01 & D.02
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Pivot Table creation	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 18. 'Pivot Table'! Creation correct
D.03 & D.04
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Grouping and Labels	Unacceptable Incomplete or two or more errors found.	N/A N/A	Target 19. 'Pivot Table'! Grouping and Labels
D.05
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Currency formatting	Unacceptable Incomplete or one error found.	N/A N/A	Target 20. 'Pivot Table'! Currency Formatting
D.06
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Slicers	Unacceptable Incomplete or one error found.	N/A N/A	Target 21. 'Pivot Table'! Slicers
D.07.a
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Question 1	Unacceptable Incomplete or one error found.	N/A N/A	Target 22. 'Pivot Table Questions'! Question 1
D.07.b
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Question 2	Unacceptable Incomplete or one error found.	N/A N/A	Target 23. 'Pivot Table Questions'! Question 2
D.07.c
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Question 3	Unacceptable Incomplete or one error found.	N/A N/A	Target 24. 'Pivot Table Questions'! Question 3
E.01
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Loan Quarterly Payment	Unacceptable Incomplete or two or more errors found.	N/A N/A	Target 25. 'Loan'! D7 Quarterly Payment
E.02
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Data Table	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 26. 'Loan'! Data Table B12:D17
E.02
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Format as Blank	Unacceptable Incomplete or one error found.	N/A N/A	Target 27. 'Loan'! A11 Custom Formatting
E.03.a
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Beginning and Ending Balance	Unacceptable Incomplete or two or more errors found.	N/A N/A	Target 28. Loan! Amortization Table Beginning and Ending Balance
E.03.b
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Interest and Principal	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 29. Loan! Amortization Table Interest and Principal payment calculated correctly
F.01
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Solver Target Cell	Unacceptable Incomplete or one error found.	N/A N/A	Target 30. 'Solver'! Target Cell correct
F.01
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
Changing Cells	Unacceptable Incomplete or one error found.	N/A N/A	Target 31. 'Solver'! Changing Cells correct
F.01
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Constraints	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 32. 'Solver'! Constraints correct

Subjects:

Business

Types:

Exam

Discuss this rubric