iRubric: Assignment 2 SP21 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Assignment 2 SP21 Assignment 2 FA19 Rubric Code: Q2238B5 By mhogue1 Ready to use Public Rubric Subject: Business Type: Assignment Grade Levels: Undergraduate

Late Submission Descriptions
	Unacceptable 0 pts	Unacceptable 0 pts	Unacceptable 0 pts
Late Submission	Unacceptable 3 Days Late.	Unacceptable 2 Days Late	Unacceptable 1 Day Late
A.05
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
DOCUMENTATION	Unacceptable Incomplete or One or more errors found.	N/A	Target 1. Documentation! C7 correctly formatted current date function
B.01 B.02a B.02b
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
DATA D Column	Unacceptable Incomplete or One or more errors found.	Acceptable minor error One error found.	Target 2. Data! Col D Validation and Conditional Formatting correct.Formatting and List should go the very bottom of the worksheet.
B.03
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
DATA G Column	Unacceptable Incomplete or One or more errors found.	N/A	Target 3. Data! Col G Validation correct.
B.04
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
DATA M and N Columns	Unacceptable Incomplete or One or more errors found.	Acceptable minor error One error found.	Target 4. M! Col M and N Data Validation correct.
B.05
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
DATA Named Range	Unacceptable Incomplete or One or more errors found.	N/A	Target 5. DATA named range correct.
C.01
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Salary & Bonus H Column	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 6. Col H Total Pay Including Overtime correct.
C.02
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Salary & Bonus J Column	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 7. Col J Freshman or Senior correct
C.03
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.75 pts
Salary & Bonus K Column	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 8. Col K Salary Calculation correct.
C.04
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Salary & Bonus L Column	Unacceptable Incomplete or One or more errors found.	Acceptable minor error One error found.	Target 9. Col L Bonus Calculation correct.
C.05
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.5 pts
Salary & Bonus M Column	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 10. Col M Total Salary with Bonus Calculation correct
C.06.a
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
Salary & Bonus D29	Unacceptable Incomplete or One or more errors found.	N/A	Target 11. D29 Correct calculation and function correct.
C.06.b
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
Salary & Bonus D30	Unacceptable Incomplete or One or more errors found.	N/A	Target 12. D30 Correct calculation and function correct.
C.06.c
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Salary & Bionus D31	Unacceptable Incomplete or One or more errors found.	Acceptable minor error	Target 14. D32 Correct calculation and function correct.
C.06.d
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Salary & Bonus D32	Unacceptable Incomplete or One or more errors found.	Acceptable minor error	Target 14. D32 Correct calculation and function correct.
E.02
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
TOTAL_Base_Salary B Column	Unacceptable Incomplete or One or more errors found.	N/A	Target 15. Col B Correct 3D cell referencing and calculation.
E.04.a
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
TOTAL_Base_Salary C Column	Unacceptable Incomplete or One or more errors found.	N/A	Target 16. Col C Correct 3D cell referencing and calculation.
E.04.b
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
TOTAL_Base_Salary D Column	Unacceptable Incomplete or One or more errors found.	N/A	Target 17. Col D Correct 3D cell referencing and calculation.
F.01
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.5 pts
INVESTMENT_LOAN C9	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 18. Investment_Loan! C9 Correct Future Value calculation.
F.02
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.5 pts
INVESTMENT_LOAN G8	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 19. Investment_Loan! G8 Correct Quarterly Payment calculation.
F.03.1
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.5 pts
INVESTMENT_LOAN Beginning & Ending	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 21. Investment_Loan! Beginning and Ending Balance Correct.
F.03.2
	Unacceptable 0 pts	Acceptable minor error 0.25 pts	Target 0.5 pts
INVESTMENT_LOAN Interest/Principal	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 21. Investment_Loan! Interest and Principal payments Correct.
G.01.a G.01.b
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Chart	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 22. Chart! Correct Chart type and data source for both charts.
G.02 G.03 G.04 G.05
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Chart	Unacceptable Incomplete or Two or more errors found.	Acceptable minor error One error found.	Target 23. Chart! Correct chart formatting for both charts

Subjects:

Business

Types:

Assignment

Discuss this rubric