Criteria

Level 1

Level 2

Level 3

Points
Off

DB Ex 1 -
Final Document

Responsibilities

None (6pts)

Superficial

Appropriate

/20

Desired Reports

None (6pts)

Superficial

Appropriate

Level 1 2 3 - Item II.C exception criteria
Level 1 2 3 - Item II.E exception criteria

Required Files

None (8pts)

Superficial

Appropriate

Resubmit
DB Ex 2

Transaction File

Level 1 2 3 - at least 8 fields consistent with DB Ex 1, III.A.
At least 12 records.  5 values of Associate ID.

/30

Database
Exercise 5

Personnel File

Level 1 2 3 - At least 4 fields consistent with DB Ex 1, III.B.
Exactly 5 records.  Associate ID values consistent w Transaction File.

Database
Exercise 6

Personnel Report

Level 1 2 3 - all Trans file fields (name and value) appear
Level 1 2 3 - all Associate ID values appear
"DB Ex 6" in title.  No join (8pts).
View data by Associate ID, not Transaction ID.
Only 1 page wide.

Database
Exercise 7

Personnel Exception Report

Level 1 2 3 - at least 2 records.  No more than 10 records.
Level 1 2 3 - appropriate Associate ID values appear
Level 1 2 3 - text box explaining exception criteria
"DB Ex 7" in title.  No join (8pts).

/30

Exception criteria

Level 1 2 3 - 3 different fields
(C1 and C2) or (C3 and C4). Consistent w DB Ex 1, II.E

Portfolio
Exercise 6 -
Update Database
Description

Hyperlink (10 pts)

Does not work

Does work

/20

Long description

Level 1 2 3 - clear explanation of your developed skill.
Level 1 2 3 - explicit reference to database object (cites report, query, …).
Level 1 2 3 - verbose, too informal, poor grammar.

Slide 8 (4 pts)

Level 1 2 3 - clear concise question.

Comments

Cannot use any duplication of my AppMIS.mdb.
Would benefit from review by SJU Writing Center.

Grammar

There/their,    I/i,    then/than    Excel (not excel)

Following
Instructions

-50 - no printout of DB Ex 1 - Final Document.
-10 - pages out of sequence, or not stapled.
-30 - Grading Rubric not included.
-10 - unnecessary pages or required pages not submitted.
-10 - not printing PowerPoint 6 slides per page.

Grade