- Username
- Password
forgot?

iRubric: Exam 2 Spa rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Exam 2 Spa Exam 2 Rubric Code: HX58C64 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 2 pts	Target 5 pts
Spa_Products	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Named range in Spa_Product.xls successfully imported; table contains 30 records
B.01
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 4 pts
PRODUCT.Category	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Category drop down menu created correctly.
B.02
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
PURCHASE.PurchaseDate	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target PURCHASE DATE default value is Now() or Date()
B.03
	Enter Title 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
PURCHASE.Quantity	Enter Title Incomplete or one or more errors found.	N/A	N/A	Target PURCHASE.quantity has Currency data type
B.04
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
PURCHASE.InPersonOrOnline	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Caption changed to Purchase Type
B.05
	Unacceptable 0 pts	N/A 0 pts	Acceptable Minor Errors 2 pts	Target 4 pts
SERVICE.LengthOfService	Unacceptable Incomplete or two or more errors found.	N/A	Acceptable Minor Errors One error found.	Target Validation Rule created "Between 15 and 90" Invalid Entry should be the error message.
B.06
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
SERVICE.Description	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Required Field property changed to Yes
B.07
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
CUSTOMER.CustCity	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Field Size 40 Format >
B.08
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 4 pts
CUSTOMER.CustPhone	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target Field Size 14 Input Mask set to !\(999") "000\-0000;0;_
B.09
	Unacceptable 0 pts	N/A 0 pts	N/A 0 pts	Target 3 pts
RELATIONSHIPS	Unacceptable Incomplete or one or more errors found.	N/A	N/A	Target PURCHASE to PRODUCT 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 Blank Sizes (5 total) from the import of the Spa_Products spreadheet. Check that Records 2 and 24 have 8s.
C.02
	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 Customer Backup table was created. Query 2 was saved as a MakeTable query.
C.03
	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. (e) 4 Records Total (f) Criteria is Is Null and >100
C.04
	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) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View (c) Criteria can be in Description field or Type field. If Type is used it should be Hidden. (d) #9:00 AM# (e) One records
C.05
	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) Earliest Appointment is correct (Min Function) (b) Most Recent Appointment is correct (Max Function) (c ) Average Fee is correct (Avg Function) (d) Number of Appointment is correct (Count Function) (e) Query correctly sorted Descending order by Number of Appointments
C.06
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 5 pts	Acceptable Minor Error 7 pts
Query 6	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Acceptable Minor Error (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 for Type (e) Descending by 2016 Fee (e) 5 Records (f) Where Clause for DateOfAppt
C.07
	Unacceptable 0 pts	Acceptable Minor Errors 3 pts	Acceptable Minor Error 5 pts	Acceptable Minor Error 7 pts
Query 7	Unacceptable Incomplete or three or more errors found.	Acceptable Minor Errors Two errors found.	Acceptable Minor Error One error found	Acceptable Minor Error (a) Correct fields listed in Datasheet View (b) Correct tables are listed in Design View (c) 20 records (e) Calculated Field correct (f) Sum function (g) Descending for RemainingStock
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 (a) Tab control captions are Customer Information and Purchase Details (b) 2nd page of tab control has all fields from Form Query: (c) Page 2 Subform label has been removed. (d) Purchase ID and InPersonOrOnline fields 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 (a) Calculated Field correct. (b) Column heading should read Total Price for calculation (c) 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 (a) All fields included. (b) Report Title reads Total Price by Purchase Type. (c) Date is in the upper right corner of the Report and has the same blue color or is set to Transparent. (d) Customer ID and Product ID fields do not have a border
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 (a) Report has Subtotals and Grand Totals by Total Price (b) Subtotal and Grand Total labels and Currency Format. (c) No blank pages in Print Preview and the Report should only be 1 page.

Subjects:

Business

Types:

Exam

Discuss this rubric