- Username
- Password
forgot?

iRubric: 24601 Assignment 1 rubric

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

Late Submission Descriptions Late Submission
	Unacceptable Two days late 0 pts	Unacceptable One day late 0 pts	On Time One day late TA Enter negative scoring if late. 0 pts
Late Submission Late Submission	Unacceptable Three days late	Unacceptable Two days late	On Time One day late
All Titles Formatted Title merged, centered, correctly formatted on all worksheets (except the Charts worksheet)
	Unacceptable Two or more errors found. 0 pts	Acceptable minor error One error found. 1 pts	Target All criteria correct. 2 pts
Titles Title Formatted	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All criteria correct.
Image Formatted Image added to upper left corner of the spreadsheet on all worksheets (except for the Charts worksheet.
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target All criteria correct. 1 pts
Images Image correct on all worksheets and is consistent	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target Image should be the same on all worksheets - in the same spot. Image should not look warped or should not resize when moving from worksheet to worksheet.
A. Date Date
	Unacceptable Two or more errors found. 0 pts	Acceptable minor error One error found. 0 pts	Target All criteria correct. 0.5 pts
Date when started Date in C6 should not be TODAY or DATE function. Formatting should be correct.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target Date the student began the project - should not be the current date. Format should be March 14 2012 format.
Print Preview Documentation! Print Preview
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target 1 pts
Page Setup Documentation! Print Preview should be correct with proper formatting	Unacceptable One or more errors found.	Acceptable minor error One error found	Target All criteria correct.
Salary Payouts Formatting Formatting correct for dollar values.
	Unacceptable 0 pts	Acceptable minor error One error found. 0 pts	Target All criteria correct. 0.5 pts
Salary Payouts Formatting Formatting correct	Unacceptable One or more errors found.	Acceptable minor error One error found.	Target All criteria correct. 5th row and 15th row should have currency format. Other values should be Number format. Check for negative numbers turning Red. Bottom of 14th row should have double line through F column.
Salary Payouts Calculations All Calculations
	Unacceptable 2 pts	Acceptable minor error 3 pts	Target All criteria correct. 4 pts
Functions correct All functions and values are correct on the worksheet.	Unacceptable Two or more errors found.	Acceptable minor error One error found	Target All calculations are worth 1 point up to 5 total points. Any calculation incorrect -1. TA Adjust score below 2 manually if needed.
Data Worksheet Functions correct
	Unacceptable 2 pts	Acceptable minor error 3 pts	Target 4 pts
Data worksheet Functions Functions are correct.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All functions are correct with correct values. I Column has correct formatting. TA Adjust score below 2 manually if needed.
Markup Markup formula correct
	Unacceptable Two or more errors found. 0 pts	Acceptable minor error One error found. 0.5 pts	Target All criteria correct. 1 pts
Markup formula Markup formula is correct.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All criteria correct. Formula is correct. Absolute and Mixed cell addressing is correct.
Salary & Bonus Salary & Bonus Functions
	Unacceptable Two or more errors found. 5 pts	Acceptable minor error One error found. 6 pts	Target All criteria correct. 7 pts
Salary & Bonus Salary & Bonus Functions are all correct.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All functions are correct. -1 for each incorrect function. TA Adjust score below 5 manually if needed.
Total Base Salary Multiple worksheets sum
	Unacceptable 0 pts	Acceptable minor error 0.5 pts	Target All criteria correct. 1 pts
Total Base Salary Table is correct with correct values.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All criteria correct.
Investment Loan Investment Loan functions are correct.
	Unacceptable Two or more errors found. 2 pts	Acceptable minor error One error found. 3 pts	Target All criteria correct. 4 pts
Financial Functions PMT, FV and Amortization are correct.	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target All functions are correct. -1 for each incorrect function/formula. TA adjust below 2 manually if needed.
Chart Charts
	Unacceptable 2 pts	Acceptable minor error 3 pts	Target All criteria correct. 4 pts
Charting Both Charts are correctly built and positioned	Unacceptable Two or more errors found.	Acceptable minor error One error found.	Target Both charts are built properly and formatting is correct TA adjust below 2 manually if needed. TA disregard Pie slice colors due to Mac users.

Subjects:

Business

Types:

Assignment

Discuss this rubric