Student Marking Application Overview

***** This project works on Windows ONLY *****

This project creates a detailed report on the grades of each student. To open the application, the user is required to click on the “Student Marking Application” tab and click on the button. When opening the application, the user Is greeted by a user form consisting of three option buttons and three command buttons.

First, the user should select the “1. Import Data” option and click continue. A file dialog will appear which will allow the user to select the “registrar.mdb” file, which Is the database that will be used to retrieve the data required for the final report.

Second, the user should select the “2. List courses” button. Upon clicking continue, another user form will appear, prompting the user to select a course from the given options. Once a course is selected, each student’s first name, last name and student ID will be displayed on a worksheet titled “Student Details”.

Finally, the user should open the user form again and select the “3. Generate Report” button. After clicking continue, Excel will display the course name, student ID, the grades of four assignments, the midterm exam, and the final exam, as well as the final grade of each student based on the weights shown below on the sheet named “Grades Data”. Additionally, the program will also show the average grade of the glass, the standard deviation, the maximum grade, and the minimum grade. A histogram of the final grades will also be generated. A Word document containing the histogram, “Grades Data” report and a paragraph explaining the program will be automatically generated in this step. This Word document will be saved in the same folder the workbook is located in. Additionally, there is also a “Display Class Average” button, which quickly shows the class average through a message box.