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 rubric
Your browser does not support iframes.
edit
print
share
Copy to my rubrics
Bookmark
test run
assess...
delete
Do more...
Exam 2
Rubric Code:
RB836A
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
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
0 pts
DONATIONS
Unacceptable
Incomplete or one or more errors found.
N/A
N/A
Target
DONATIONS.Pledge Amount Validation Rule set to >=0
REMOVED BY PROF. LEWANDOWSKI
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
Acceptable Minor Errors
2 pts
Target
4 pts
DONATIONS
Unacceptable
Incomplete or one or more errors found.
N/A
Acceptable Minor Errors
Target
DONATIONS.Contacted by Recruiter field name changed to Contacted Yet?
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 58" 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 35
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
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.