iRubric: Final Exam FA19 rubric

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

Percent Discount Descriptions
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Target 5 pts
Percent Discount	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! Col O Function Returns correct "Percent Discount"
Conditional Formatting
	Unacceptable 0 pts	Acceptable Minor Errors 0 pts	Target 1 pts
Conditional Formatting	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! Col O Correct conditional formatting used
Lengthy Business Trips
	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 'Customer'! E39 Function returns correct "Number of Lengthy Business Trips" values
Business Trip Net Revenue
	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 'Customer'! E40 Function returns correct "Business Trip Net Revenue" values including ROUND.
Avg Airfare by Business Traveler
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Target 6 pts
Average Airfare per Business Travel	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! E41 Function returns correct "Average Airfare per Business Traveler" values
Bonus
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 5 pts
Bonus/No Bonus	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! H39:H42 Function returns correct "Sales Rep Bonus or No Bonus" values
Commission
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 5 pts
Commission Earned	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! K39:K42 Function returns correct Commission Earned for each Sales Rep including the Bonus.
Weeks
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Weeks since last departure	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! N39 Function returns correct "Whole Weeks since last departure" values
Revenue by Rep & Trips
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Net Revenue by Rep & Trips	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Customer'! Q39:S42 Function returns correct Total Net Revenue by Rep and Trip Length.
Named Range
	Unacceptable 0 pts	Acceptable Minor Errors 0 pts	Target 2 pts
Named Range	Unacceptable Incomplete or two errors found.	Acceptable Minor Errors Blank cells inside the Range	Target 'Airlines'! Named Range Correct
Region Discount
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Target 6 pts
Region Discount	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'New Travel'! F4 Function returns correct discount per "Region"
Avg Surcharge by Day & Time
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Target 6 pts
Average Surcharge	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'New Travel'! M5 Function returns Average Surcharge per ticket.
Amount Borrowed
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Actual Amount Borrowed	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Loan'! I8 Actual Amount Borrowed is correct including Points and Fees.
PMT
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Loan Semi Annual Payment	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Loan'! H8 Semi Annual Payment
Data Table
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Target 3 pts
Data Table	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target 'Loan'! Data Table B20:G25 Deduction of -1 using the incorrect Payment in the Data Table. Do this manually for this row. Must Format cell A19 as Blank.
Loan
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Beginning and Ending Balance	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target Loan! Amortization Table Beginning and Ending Balance 0 balance should be achieved.
Loan
	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 Loan! Amortization Table Interest and Principal payments calculated correctly
Solver
	Unacceptable 0 pts	N/A 0 pts	Target 2 pts
Solver Target Cell	Unacceptable Incomplete or one error found.	N/A	Target Solver'! Target Cell correct
Solver
	Unacceptable 0 pts	N/A 0 pts	Target 2 pts
Changing Cells	Unacceptable Incomplete or one error found.	N/A	Target 'Solver'! Changing Cells correct
Solver
	Unacceptable 3 pts	Acceptable Minor Errors 4 pts	Target 5 pts
Constraints	Unacceptable Incomplete. One point per constraint. Subtract 1 for each missing or incorrect constraint.	Acceptable Minor Errors One error found.	Target 'Solver'! Constraints correct
Power Query
	Unacceptable 0 pts	Acceptable Minor Errors 0 pts	Target 2 pts
5 Queries Uploaded	Unacceptable Incomplete or one error found.	Acceptable Minor Errors	Target 5 Queries are uploaded and linked properly
Customer
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Edits on Customer Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target Contact name edited Columns Removed Duplicate, Split and Rename
Products
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Edits on Products Query	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Calculated Column named Price with correct Data Type
Order Details
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Edits on Order Details Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target Merge complete for Product.Price field with the correct Data Type.
Sales Rep
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Edits on Sales Rep Query	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target First and Last Names are UPPERCASE Zip code is correct.
Relationships
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Data Model Diagram View	Unacceptable Incomplete or one error found.	Acceptable Minor Errors N/A	Target Relationships are correct in the Diagram View.
Revenue
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Revenue Calculated Field	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target SUMX function used correctly. Total should be $54,028.25 in Data View on the Order Details tab. Formatting should be correct.
Revenue Percentage
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 3 pts
Revenue Percentage Field	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target DIVIDE.CALCULATE.ALL functions used correctly. Total should read 100% and is based on the Revenue calculation.
Pivot Table Created
	Unacceptable 0 pts	Acceptable Minor Errors 0 pts	Target 2 pts
Pivot Table Created	Unacceptable Incomplete or one error found.	Acceptable Minor Errors N/A	Target The Pivot Table has been created and the answer to the question should be displayed.
Power View
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Power View Column	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Column chart is built correctly. Chart does not appear too long or skinny and all axis labels and legend is properly displayed.
Power View Bar	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Bar chart is built correctly.
Power View Line	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Line chart is built correctly.
Formatting and Filter	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Filter was properly used to show top 5 product names. Charts do not appear too long or skinny and all axis labels and legend is properly displayed.
Title and Worksheet Name	Unacceptable Incomplete or one error found.	Acceptable Minor Errors One error found.	Target Power View Title is correct Worksheet name is correct.

Subjects:

Business

Types:

Exam

Discuss this rubric