Reference no: EM131111688

Students at an Open University type college take a number of modules each.
Each module is either 100% coursework (C), 50% coursework and 50% exam (B), or 100% exam (E).
New modules may be introduced. An existing module may be dropped, as long as no student is registered on it.
Students must pass at least 4 modules, of which at least 2 must be 100% exam(E). The pass mark is 40%. Once they have passed at least 4 or more modules, including at least 2 100% exam(E) modules, then they have finished the course and graduate. The class of degree is the average of the 2 best E modules and the two best of the remaining modules, including any E modules which are not the best. When a student graduates he or she is registered as an alumnus.
A new student may join at any time
A student's final grade is determined by the average of their best 3 modules.
70 - 100 1st
60 - 69 2.1
50 - 59 2.2
40 - 49 3rd
0 - 39 Fail
Students can do courseworks or take exams at any time they like* but once they have completed the coursework and/or exam for a module they cannot retake it, regardless of whether they pass or fail.
A database, implemented in VBA is required to monitor all this.
*Courseworks and exams are produced by assessment goblins using ancient magic

Attachment:- Project Task.rar