A Class Grading Application

Overview:

MyGateway serves as an intermediate course grade repository. At the end of the semester this repository is uploaded to a site where the final grades are entered and then recorded. The purpose of this project is to provide a simple simulation of the second and third stages of this process, entering final grades and uploading them to a database repository.

The Second Stage Client:

The Client

After Uploading:

The Data Base

The Fields:

Last Name, First Name, and Year cannot be edited. Test 1, Test 2 and Final Grade can be edited.

The Actions:

Recompute Grades enters the changed test grades in the internal store to be uploaded and recomputes and enters the final grades, using an internal algorithm.

Change Final Grade simply enters the changed final grades in the internal store to be uploaded.

Upload Class uploads the grades to the database store.

The Code (some notes. Would have links to the code):

  1. The Client Application- Rather than uploading the class in a single step, student records are uploaded individually. The consideration is possible future enhancements of the Application. It is also the case that the first stage of the grade entry process is not present, that data that would be produced at that stage is just included as class instances in the source.

  2. The Client-Servlet Connector

  3. The Servlet

  4. The database connector.

  5. The SQL Create Table Script