- Username
- Password
forgot?

iRubric: Assignment 6 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Assignment 6 Rubric Code: RB7B5C By rlewando Ready to use Public Rubric Subject: Business Type: Assignment Grade Levels: Undergraduate

A.3 Descriptions
	Unacceptable 0 pts	N/A 0 pts	Target 0.5 pts
Documentation & Compact & Repail	Unacceptable Incomplete or one or more errors found.	N/A	Target Make sure that the Student, Instructor & Section Info is correct. File size should be approximately 1550 KB
B
	Unacceptable 0 pts	N/A 0 pts	Target 0.5 pts
Relationship Window	Unacceptable Incomplete or one or more errors found.	N/A	Target All Relationships have been created with referential integrity and cascade update - compare with the Key.
C.1
	Unacceptable 0 pts	N/A 0 pts	Target 1.5 pts
MakeTable query	Unacceptable Incomplete or one or more errors found.	N/A	Target Run the MakeTable query. It should creates 405 records in new PREMIUM CUSTOMERS table
C.2
	Unacceptable 0 pts	N/A 0 pts	Target 1.5 pts
UpdateTable query	Unacceptable Incomplete or one or more errors found.	N/A	Target Run the UpdateTable query. It should change 30 blank credit ratings to "K" in the PREMIUM CUSTOMERS table.
C.3
	Unacceptable 0 pts	N/A 0 pts	Target 1 pts
DeleteTable query	Unacceptable Incomplete or one or more errors found.	N/A	Target Run the DeleteTable query. The PREMIUM CUSTOMERS table should now contain 400 recs
D.1
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Query1	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Item #, Hardiness Code, Product and Retail Price are only listed fields. PRODUCTS, HARDINESS_CODES Tables should be only tables listed in Design View. This query can also be run including the StockCode Table. "45 Records in Datasheet View Must return 45 records. Common variations : Retail Price>40, Hardiness (code) Like""P*""" Sorted Descending by Retail Price
D.2
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Query2	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target 1 Record: Cora, Ross (812) 335-9638 FirstName, LastName and Telephone are only listed fields. CUSTOMERS, TRANSACTIONS, TRANSACTION_DETAILS and PRODUCTS are only tables listed in Design View. "1 Record in Datasheet View & criteria listed as shown below: Note: Use your judgement if criteria specified differently. Must return 1 record." Sorted Ascending by LastName
D.3
	Unacceptable 0 pts	Acceptable Minor Error 1 pts	Target 2 pts
Query3	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target First Date, Last Date, Order Count, Type are only listed fielE20:E23ds. TRANSACTIONS, TRANSACTION_DETAILS and PRODUCTS are only tables listed in Design View. (Note: May also have the HARDINESS_CODES table listed if student uses the Hardiness Code field to specify plant hardiness. This is OK.) "13 Record in Datasheet View & criteria listed as shown below: Note: Must return 13 records and use MIN and MAX. " Sorted Descending by Order Count.
D.4a
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Indiana Total Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Indiana Total is only listed field. CUSTOMERS, TRANSACTIONS, TRANSACTION_DETAILS and PRODUCTS are only tables listed in Design View.
D.4b
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Illinois Total query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Illinois Total is only listed field. CUSTOMERS, TRANSACTIONS, TRANSACTION_DETAILS and PRODUCTS are only tables listed in Design View.
D.4c
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Both Total Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Both Total is only listed field. CUSTOMERS, TRANSACTIONS, TRANSACTION_DETAILS and PRODUCTS are only tables listed in Design View.
E.1
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Parameter Query	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Prompted with "Enter a Building Code:" when query is run. Hardiness, Category, Type, Product, Retail Price, Plant Location and Building Type are only listed fields. BUILDINGS and PRODUCTS are only tables listed in Design View.
F.1 - F.4
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Last Year Sales Report	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Sorted Ascending by Type and then by Product Report grouped by Category and sorted by Type. Has Stepped layout and portrait orientation Format Properties of the Category Header make sure it specifies UPPER CASE using the > symbol
F.5 - F.7 and F.13
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Last Year Fiscal Sales Report	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Report shows current date in header & NetID in footer Print Preview and make sure that there are no blank pages or partial data on pages.
H.8 - H.12
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Subtotal and Grand Totals	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Report correctly calculates subtotals and grand total - Accessories Subtotal = $38,571.84 with final subtotal and Grand Total $161,853.59
Transaction Calculation Form
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Calculated Field	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Calculated Field created correctly with Currency format.
Transaction Form
	Unacceptable 0 pts	Acceptable Minor Error 0.5 pts	Target 1 pts
Multi-Page Form	Unacceptable Incomplete or two or more errors found.	Acceptable Minor Error One error found.	Target Transaction Form has tab control and Subforms are correct.

Subjects:

Business

Types:

Assignment

Discuss this rubric