• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28

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.

Extracts from this document...

Introduction

Documentation 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. ...read more.

Middle

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? ...read more.

Conclusion

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. Validation and Testing ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Computer Aided Design Package

    up the drawings that they produce during the day * Monitor for the user to view what they are doing while using the computer Other hardware that will be needed that is not part of the computer and is not needed to get the computer working, but will be required

  2. I have been given the task to design a database for a company called ...

    There are several rules for passwords, these include: * Passwords should be at least 6 characters * Passwords must not be displayed on the screen but must be masked by asterisks. * Files containing passwords must be encrypted * Passwords must be kept confidential * Passwords must be changed regularly

  1. ICT Sample Work Welcome Centre Requirements

    He looks after the technical requirements of a conference such as IT needs and P.A. equipment. Anita Fax is the Administrator, who has responsibility for accounts and organising the monthly payroll for the employees. There are also 4 other part time staff, including a cleaner as well as conference assistants.

  2. I have been asked to design a system for the United Kingdom Awarding Body ...

    This would mean that there could be multiple candidates with the same candidate number; however the candidate number and centre number combined would always be unique. For the subject entity, subject reference code was the only sensible primary key as it was the only unique attribute in the entity.

  1. White Soul System Designs - creating a computer system.

    Problem Definition I will speak to both staff members to get a general idea about the store and just a brief look at the current problem at hand 02/01/03 Objectives I will look at how the current system run, what processes are carried out for members to the company and

  2. AQA Computing CPT3

    will also reset the fuel timer / dispensed total (variable - fuelClock), the to pay total (variable - totalToPay), the pump will add the pay total for the current transaction to the total takings for the day (variable - totalTakings), and the pump will add the dispensed total for the

  1. Creating a computer system for Wooten Basset Rugby Club

    These are Players, Rivals, Fixtures, Players-Fixtures and Tournament. 2.2 Attribute Design Following are description of all the attributes to be stored in the system: 2.3 Form Design In order for the user to interact with the system, it must be presented in a user friendly interface. Within Access this is done using forms and reports, each form should

  2. Robot Prototype design principles.

    118-121]. The programmers in our studies experienced severe visibility problems due to the proliferation of windows and hidden functionality. Unfortunately, much of the visibility problem is inherent in the task: a star diagram planning tool is intended to help programmers to discover relationships amongst syntactically separated pieces of code.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work