- Username
- Password
forgot?

iRubric: Assignment 5 SP17 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Assignment 5 SP17 Assignment 5 Rubric Code: GX88332 By nghiased Ready to use Public Rubric Subject: Business Type: Assignment Grade Levels: Undergraduate

A.3 Descriptions
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
Documentation Form	Unacceptable Documentation form not filled out or incorrect.	N/A	Target 1. Documentation Form filled in correctly
G.6
	Unacceptable 0 pts	N/A (N/A)	Target 0.3 pts
Compact and Repair	Unacceptable File size too large and not compacted and repaired.	N/A	Target 2. Database correctly compacted and repaired
C.1
	Unacceptable 0 pts	Acceptable Minor Errors 0.35 pts	Target 0.7 pts
BUILDINGS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found.	Target "(a) BUILDINGS table correctly imported with primary key (b) BUILDINGS[BuildingCode] has correct field size"
D.1
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
CUSTOMERS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) CUSTOMERS[CustomerID] is primary key & correct field size (b) CUSTOMERS[ZipCode] has correct size & input mask (c) CUSTOMERS[BusName] has correct caption (d) CUSTOMERS[PreferredPmtMethod] has correct caption and format
D.3
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
CUSTOMERS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) CUSTOMERS[CreditCardType] has drop down list of 4 cards (b) CUSTOMERS[ExpirationDate] has correct type & format (c ) CUSTOMERS[SpecialRequests] has correct data type
C.3
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
EMPLOYEES	Unacceptable Incomplete or one error found.	N/A	Target EMPLOYEES table correctly imported
C.3 & D
	Unacceptable 0 pts	Acceptable Minor Errors 0.75 pts	Target 1.5 pts
EMPLOYEES	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) EMPLOYEES[EmployeeID] is primary key (b) EMPLOYEES[BirthDate] has correct validation rule and validation text (c) EMPLOYEES[HireDate] has correct default value & required (d) EMPLOYEES[HireDate] has correct format and input mask
D
	Unacceptable 0 pts	Acceptable Minor Errors 0.75 pts	Target 1.5 pts
EMPLOYEES	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) EMPLOYEES[StateOrProvince] has correct field size & caption (b) EMPLOYEES[ZipCode] exists and has correct field size (c) EMPLOYEES[HomePhone] has correct field size and input mask (d) EMPLOYEES[Extension] & [ReportsTo] were removed
C.2 & D
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
HARDINESS_CODES	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target HARDINESS_CODES table data correctly imported (a) HARDINESS_CODES[HardinessCode] is primary key & correct size (b) HARDINESS_CODES[FullName] has correct field size
D
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
PRODUCTS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) PRODUCTS[Hardiness] lookup shows code & full name (b) PRODUCTS[StockCode] lookup shows code and description (c) PRODUCTS[StandardMarkupValue] has correct format
B.1
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
STOCK_CODES	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target STOCK_CODES[StockCodes] is primary key & field size is 11 STOCK_CODES[StockCodes] is a required field STOCK_CODES[Description] field size is 50 STOCK_CODES[Description] is a required field
B.2
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
STOCK_CODES	Unacceptable Incomplete or one error found.	N/A	Target (a) STOCK_CODES table loaded with all stock codes
D
	Unacceptable 0 pts	N/A (N/A)	Target 0.25 pts
TRANSACTION_DETAILS	Unacceptable Incomplete or one error found.	N/A	Target TRANSACTION_DETAILS[Quantity] has correct data type
D
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
TRANSACTIONS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) TRANSACTIONS[TransactionID] has correct data type & size (b) TRANSACTIONS[Date] has correct data type and format (c) TRANSACTIONS[Date] has correct input mask
D
	Unacceptable 0 pts	Acceptable Minor Errors 0.25 pts	Target 0.5 pts
TRANSACTIONS	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) TRANSACTIONS[Delivery] has correct data type & correct default (b) TRANSACTIONS[Shipping] has correct data type
E.1
	Unacceptable 0 pts	N/A (N/A)	Target 0.5 pts
Relationship Window	Unacceptable Incomplete or one error found.	N/A	Target Relationships correctly established with ref integrity & cascade updates
F.1
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
Query1	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View
F.2
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
Query2	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields showing in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View
F.3
	Unacceptable 0 pts	Acceptable Minor Errors 0.5 pts	Target 1 pts
Query3	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields showing in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View
F.4
	Unacceptable 0 pts	Acceptable Minor Errors 0.6 pts	Target 1.25 pts
Query4	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields showing in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View
G.1
	Unacceptable 0 pts	Acceptable Minor Errors 0.75 pts	Target 1.5 pts
Query5	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields showing in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View
G.2
	Unacceptable 0 pts	Acceptable Minor Errors 0.9 pts	Target 1.75 pts
Query6	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Errors One error found	Target (a) Correct fields showing in Datasheet View (b) Correct tables are listed in Design View (c) Criteria correct in Design View (d) Query correctly sorted in Design View

Subjects:

Business

Types:

Assignment

Discuss this rubric