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 Mosely Green 75pts rubric
Your browser does not support iframes.
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
Your browser does not support iframes.
Desktop Mode
Mobile Mode
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
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
n202
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.