MADBAGS

1
MADBAGS

• Microsoft Access DataBaseAutomated Grading System

2
What does MADBAGS grade?

• Table Structure
• Field Names
• Field Types
• Field Sizes
• Table Data
• Presence of
• Forms
• Reports

• Field attributes
• Default values
• Required fields
• Validation rules
• Validation text
• Indexes
• Primary Keys
• Relations

3
What does MADBAGS grade? (continued)

• DELETE Type
• Table Names
• Where criteria
• Update Type
• Table name
• Colexpr List
• Where critera

• Queries
• SELECT Type
• Fields
• Table names plus Join clauses
• Where criteria
• Total queries

4
What does MADBAGS not grade?

• Form components
• Report components
• Data Access Pages

• Macros
• Modules

5
Screenshot
6
(No Transcript)
7
How to use MADBAGS
8
(No Transcript)
9

• Variable point grading scale
• Enter number of points deducted for
• Incorrect field names, field type, field size
• Mistyped data
• Missing queries

10

• Amount deducted for the following errors

• Missing query fields
• Missing/incorrect query criteria
• Missing/incorrect joins
• Sort order

11

• Amount deducted for the following errors
• Missing primary keys
• Missing indices
• Missing relations
• Missing/incorrect validation rules and/or
  validation text

12
Options Only Grade Tables

• Only grades table structure and table data
• Useful with first class assignments
• Avoids grading more advanced features (for
  example, queries, indexing, relations) before
  being covered in class
• Avoids error overload hides details that might
  be more easily handled manually

13
Options Deduct Extraneous

• Extra tables, fields, records, queries, etc. are
  counted against the student

14
Plagiarism

• Helps discover possible plagiarism
• Considers a pair of students at a time
• How many errors do they have in common?
• More errors, more evidence of plagiarism
• Input is minimum errors to be included in
  report
• What percent of a student As errors were also
  made by student B?

15
Grader Output
16
E R R O R S Table

• Errors placed in E R R O R S table in student
  database

17
Grade Report
18
Errors Report
19
Possible Plagiarism