Download
1 / 19
190 likes | 342 Views
MADBAGS. Microsoft Access DataBase Automated Grading System. 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.
E N D
MADBAGS Microsoft Access DataBaseAutomated Grading System
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?
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 grade? (continued)
Form components Report components Data Access Pages Macros Modules What does MADBAGS not grade?
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?
E R R O R S Table Errors placed in “E R R O R S” table in student database
