Transcript MEAGer
MADBAGS Microsoft Access DataBase Automated Grading System 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 What does MADBAGS grade? (continued) • Queries – SELECT Type • Fields • Table names plus Join clauses • Where criteria • Total queries – DELETE Type • Table Names • Where criteria – Update Type • Table name • Col=expr List • Where critera What does MADBAGS not grade? • Form components • Macros • Report components • Modules • Data Access Pages Screenshot How to use MADBAGS • Variable point grading scale • Enter number of points deducted for – Incorrect field names, field type, field size – Mistyped data – Missing queries Amount deducted for the following errors: •Missing query fields •Missing/incorrect query criteria •Missing/incorrect joins •Sort order Amount deducted for the following errors: – Missing primary keys – Missing indices – Missing relations – Missing/incorrect validation rules and/or validation text 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 Options: Deduct Extraneous • Extra tables, fields, records, queries, etc. are counted against the student 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 A’s errors were also made by student B? Grader Output E R R O R S Table Errors placed in “E R R O R S” table in student database Grade Report Errors Report Possible Plagiarism