The post examination marks of the board - Sample Essay

Introduction For my computing course, I have been presented with a request from an imaginary examination board to design a system that monitors the post examination marks of the board. The system will be faced with a scenario where a centre (where the exam papers are sat) decides that a certain students examination grades are lower than expected and ask for the paper/script to be remarked. For me to successfully design a system that fulfils all the requirements, I had to decided to use Microsoft Access. This was because I felt more confident using this program then in using Pascal, which was another available option.

System design I will use three tables to help me perform the task required. Here is how they will be laid out, and what fields they will contain. Candidate Table Field Name Data type Description Candidate Name Text The first name of the candidate. Candidate Surname Text The second name of the candidate. Candidate Number Text The candidate’s unique identifier. Centre Number Number The ID number of the Centre where the Candidate came from. Centre Name Text The name of the centre where the exams were taken. Subject Reference Code Text The code by which the Exams for each subject are known. Original Mark.

Number The original mark of the exam paper sent for remarking Re-mark Mark Number The Mark of the paper/script after it has been remarked. Original Grade Text The original grade of the exam paper/script sent for remarking Re-mark Grade Text The grade of the paper/script after it has remarked. Date Re-mark Received Date/Time The date the paper/script was received by the remarking board Date Re-mark Returned Date/Time The date the Paper/script was sent back to the centre which requested the re-mark Return Deadline Met? Text Has the paper/script been sent back within 3 weeks? Centre table Field Name.

Data type Description Centre Name Text The name of the centre where the exams were taken. Centre Number Number The ID number of the Centre where the Candidate came from. Candidate Name Text The first name of the candidate. Candidate Surname Text The second name of the candidate. Candidate Number Text The candidate’s unique identifier. Subject Remark Requested? Yes/No Whether a remark of the paper/script has been requested Subject Reference Code Text The code by which the Exams for each subject are known. Date of Re-mark Request Date/Time The date the paper/script was sent off to the remarking board.

Date Re-mark Returned Date/Time The date the Paper/script was returned to the centre which requested the re-mark Remark Return Outstanding? Text Have the papers which have been sent off been returned Subject table Field Name Data type Description Subject Reference code Text The code by which the Exams for each subject are known. Minimum Mark for A Number Minimum amount of marks required to get an A grade Minimum Mark for B Number Minimum amount of marks required to get a B grade Minimum Mark for C Number Minimum amount of marks required to get a C grade Minimum Mark for D.

Number Minimum amount of marks required to get a D grade Minimum Mark for E Number Minimum amount of marks required to get an E grade Entity relationship Diagram This diagram represents the relationship between the three tables I will be using to fulfil this task. One Centre will hold many Candidates. Many Candidates will do one subject. One to Many. Many to One. This is how the relationship diagram looks when created on Microsoft Access. Implementation These are what the tables look like in Design and Datasheet view. Candidate table Centre table Subject table. User Interface.

Main Page – This is where a user can gain access to all the other forms containing the different details Candidate form Centre Form Subject form Queries Here is an example of how a query will look in design view. This is an example of an update query, which updates the table according to the values inputted. All together there were 50 update queries: 25 for the original grade and 25 for the Re-mark grade. This is an example of a search query. The particular query was to search how many candidates belong to a certain centre. When the search is complete, it will display the Candidate name, Candidate Surname, Candidate Number and Centre name.