22BSB130 Business Programming Assessment

System Requirements/Deliverable:

Deliver an Excel Macro-Enabled Workbook (00000xx-22BSB130-S2CWxism) capable of:

1. Displaying the status (Valid, Invalid or Missing) of individual option choices. The status must be shown in column B of the worksheet "Status", next to the student ID.
   1. Valid-options selected meet all requirements, Le., credits exactly match requirements for each semester, unavailable modules not selected, no missing prerequisites, no excluded combinations, and minimum number of accredited modules chosen (the last requirement is for HRM students only)
   2. Invalid-options selected violate at least one requirement
   3. Missing- no options have been recorded for the student in question
2. Providing more detailed information about the status of each student's option choices in columns C onwards in the Status worksheet. The client has not specified the exact format/layout of the information provided.
3. Processing records in the Requests worksheet, by updating the contents of worksheet PartC. Option choices must be written in the correct row/column. If a student has already chosen options, previous option choices must be removed and replaced with the new option choices.
4. Reporting: Information provision must include, but is not necessarily limited to the following. The client has not specified the format/layout of the information provided.
   1. Module registration numbers - number of students registered for modules
   2. Class lists - list of students registered for modules