iRubric: Exam 2 SU15 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Exam 2 SU15 Exam 2 Rubric Code: BX33A23 By nghiased Ready to use Public Rubric Subject: Business Type: Exam Grade Levels: Undergraduate

A.01 Descriptions
	Unacceptable 0 pts	N/A 0 pts	N/A 2 pts	Target 5 pts
DONORS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Named range in donors.xls successfully imported; table contains 180 records
B.02
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATIONS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS.Date of Pledge default is Now() or Date()
B.03a
	Enter Title 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATIONS	Enter Title Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS.Pledge Amount has Currency data type
B.03b
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATIONS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS.Pledge Amount Validation Rule set to >=0
B.01
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
DONATIONS	Unacceptable Incomplete or two or more errors found.	N/A	Acceptable Minor Errors One error found.	Target "DONATIONS.Account Number drop list shows account number and fund.
B.04a
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATIONS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS.Contacted by Recruiter field name changed to Contacted
B.04b
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATIONS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS.Contacted has "Was Contacted?" caption
B.05 and B.06
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONATION DETAILS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATION DETAILS.Recurited by Validation Rule "Between 1 and 57" Validation Text "Invalid Entry" Details data type has memo data type
B.07a
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONORS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONORS.City Format property is >
B.07b
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONORS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONORS.City Field Size is 30
B.08a B.08b
	Unacceptable 0 pts	Acceptable Minor Errors 1 pts	Acceptable Minor Error 3 pts	Target 5 pts
DONORS	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found.	Target DONORS.Work Phone Field size is 14 DONORS.Home Phone input mask is !\(999") "000\-0000;0;_ OR is !\(000") "000\-0000;0;_
B.09
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
DONORS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONORS.Matching Gifts? Data type is Yes/No
B.10
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 2 pts
Relationship Window	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target DONATIONS to ACCOUNTS relationship has ref integrity & cascade update.
C.01
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Acceptable Minor Error 3.5 pts	Target 5 pts
Update Query	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Target Query1 successfully updated all KC cities to Kansas City; Open the DONORS table and make sure that there are no cities named KC.
C.02a C.02b
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Acceptable Minor Error 3.5 pts	Target 5 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) Query2 has correct rows and columns (b) Query2 has correct results
C.03a C.03b
	Unacceptable 0 pts	Acceptable Minor Errors 2 pts	Acceptable Minor Error 3.5 pts	Target 5 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.
C.04a C.04b C.04c C.04d
	Unacceptable 0 pts	Acceptable Minor Errors 4 pts	Acceptable Minor Error 6 pts	Target 8 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) Earliest Pledge is correct (b) Most Recent Pledge is correct (c ) Average Pledge is correct (d) Number of Pledges is correct (e) Query correctly sorted in Design View
C.05a
	Unacceptable 0 pts	Acceptable Minor Errors 7 pts	Acceptable Minor Error 9.5 pts	Enter Title 12 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 6 pts	Acceptable Minor Error 8 pts	Target 10 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"
D. Form Tab Control & Subform
	Unacceptable 0 pts	Acceptable Minor Errors 4 pts	Acceptable Minor Error 5 pts	Target 6 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 Tab control captions are Donations and Balance Summary "2nd page of tab control has all fields from FormPage2 query: Page 2 Subform label has been removed. Donor ID field is hidden on Balance Summary subform
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.
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 Donations by State. Date is in the upper right corner of the Report and has the same blue color or is set to Transparent.
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.

Subjects:

Business

Types:

Exam

Discuss this rubric