iRubric: Exam 2 Mosely Green 75pts rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Exam 2 Mosely Green 75pts Exam 2 75pts Rubric Code: KX96C67 By rlewando Ready to use Public Rubric Subject: Business Type: Exam Grade Levels: Undergraduate

A.01 Descriptions
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
CUSTOMERS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Named range in Customers.xls successfully imported; table contains 61 records
B.02
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Plant Name	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Plant Name Field changed to 75 field size
B.03a
	Enter Title 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Price	Enter Title Incomplete or one or more errors found.	N/A	N/A	Target Price Field has Currency data type and 2 decimals.
B.01
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
State Format	Unacceptable Incomplete or two or more errors found.	N/A N/A	Acceptable Minor Errors One error found.	Target State field should be upper case and field size 2.
B.04a
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
State Data validation	Unacceptable Incomplete or two or more errors found.	N/A N/A	Acceptable Minor Errors One error found.	Target State field should have Data Validation of "MA" "VT" or "NH" Invalid Entry should be the response
B.04b
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Telephone	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Field size should be 14.
B.05 and B.06
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Errors 1 pts	Target 2 pts
Telephone Input Mask	Unacceptable Incomplete or two or more errors found.	N/A	Acceptable Minor Errors One error found.	Target Input mask for telephone correct. This field should be Required.
B.07a
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Status	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Drop down menu for status with Customer, Priority and Preferred.
B.07b
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Date	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Formatted as a Medium Date
B.08a B.08b
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Date Default Value	Unacceptable Incomplete or two or more errors found.	N/A N/A	Acceptable Minor Error One error found.	Target Default Value should be Date() function.
B.09
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Cust No	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Name changed to Number
B.10
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 1 pts
Relationship Window	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Relationships properly created.
C.01
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Acceptable Minor Error 2 pts	Target 3 pts
Make Table Query	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target (a) Query1 has correct rows and columns (b) Query1 has correct results
C.02a C.02b
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Acceptable Minor Error 2 pts	Target 3 pts
Update Query	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target Query2 successfully updated. City field should not have any blank fields. They were properly updated to Salem
C.03a C.03b
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Acceptable Minor Error 2 pts	Target 3 pts
Query 3	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View (c) Query correctly sorted in Design View (d) Criteria correct. There will be 4 Blanks
C.04a C.04b C.04c C.04d
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Acceptable Minor Error 3 pts	Target 5 pts
Query 4	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target (a) City criteria correct (b) Address criteria correct (c ) Date criteria correct (d) Where clause used 3 times. (e) Query correctly sorted in Design View
C.05a
	Unacceptable 0 pts	Acceptable Minor Errors 4 pts	Acceptable Minor Error 6 pts	Enter Title 8 pts
Query 5	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Enter Title (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View (c) Query correctly sorted in Design View (d) TOTAL included in datasheet (d) Criteria is correct
C.05a
	Unacceptable 0 pts	Acceptable Minor Errors 4 pts	Acceptable Minor Error 6 pts	Target 8 pts
Query 6	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View "(c) Query correctly sorted in Design View (d) Criteria is correct" (e) Calculated Field correct (f) Where clause used correctly.
C.7
	Unacceptable 0 pts	Acceptable Minor Errors 4 pts	Acceptable Minor Error 6 pts	Target 8 pts
Query 7	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View "(c) Query correctly sorted in Design View (d) Criteria is correct (e) Calculated Field correct (f) Where clause used 3 times correctly.
D. Form Tab Control & Subform
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 4 pts	Target 5 pts
Form Tab Control & Subform	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target Tabs correctly named Customer Information and Purchase Details. 1st page of tab control should load the Customer Form. "2nd page of tab control has all fields from FormPage2 query: Page 2 Subform label has been removed.
D. Form Subform Calculation
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 4 pts	Target 5 pts
Form Subform Calculation	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target Calculated Field correct. Column heading should read Remaining Balance for calculation and field should be formatted as currency. Number field is hidden on Purchase Details subform.
E Report Creation
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 4 pts	Target 5 pts
Report Creation	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target All fields included. Report Title reads Commercial Sales and should be Red. All field data is visible. Block Layout used.
E Report Subtotals and Grand Totals
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 4 pts	Target 5 pts
Report Subtotals and Grand Totals	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target Report has Subtotals and Grand Totals by State with correct labels and Currency Format. Both Label and Totals are Bold.

Subjects:

Business

Types:

Exam

Discuss this rubric