Skip to main content
sign in
Username
Password
forgot?
Share
help_outline
help
User's Guide
Please enable JavaScript on your web browser
menu
iRubric: Exam 2 Spa rubric
Your browser does not support iframes.
edit
print
share
Copy to my rubrics
Bookmark
test run
assess...
delete
Do more...
Exam 2 Spa
Exam 2 Spa
Rubric Code:
GX64369
By
nghiased
Ready to use
Public Rubric
Subject:
Business
Type:
Exam
Grade Levels:
Undergraduate
Your browser does not support iframes.
Desktop Mode
Mobile Mode
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
PRODUCTS.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) 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.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) 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.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) 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.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
You may also be interested in:
More rubrics by this author
More Business rubrics
More Exam rubrics
Do more with this rubric:
Preview
Preview this rubric.
Edit
Modify this rubric.
Copy
Make a copy of this rubric and begin editing the copy.
Print
Show a printable version of this rubric.
Categorize
Add this rubric to multiple categories.
Bookmark
Bookmark this rubric for future reference.
Assess
Test run
Test this rubric or perform an ad-hoc assessment.
Grade
Build a gradebook to assess students.
Collaborate
Apply this rubric to any object and invite others to assess.
Share
Publish
Link, embed, and showcase your rubrics on your website.
Email
Email this rubric to a friend.
Discuss
Discuss this rubric with other members.
Do more with rubrics than ever imagined possible.
Only with iRubric
tm
.
iRubric and RCampus are Trademarks of Reazon Systems, Inc.
Copyright (C)
Reazon Systems Inc. All Rights Reserved
n178
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.