• 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

    could be problems from time to time with this type of file on Engineering ? Us's CAM machine, when these problems arise it will slow the construction process down. P3/M2 I will have to either buy a new PC from a store or make the computers myself; whichever approach is

  2. Smart Card System

    the former, and historically newly explored computational approaches to finding large `probable' primes, such as the Fermat test, provide the latter.) Now E_K is easily computed from the pair (pq,e)---but, as far as anyone knows, there is no easy way to compute D_K from the pair (pq,e).

  1. Robot Prototype design principles.

    Because there is no restructuring engine, the programmer must also revisit all of these related program locations in order to carry out the actual restructuring changes. Other visibility problems were due to design. For example, on tool start-up only a tool bar was displayed.

  2. ICT Sample Work Welcome Centre Requirements

    He may also create invoices for a conference that has taken place to request payment. He will also need to keep track of payments for conferences by customers, and chase any outstanding payments. He is also very hands-on in his role, and he will support his staff with serving and room set-up when required.

  1. Creating a computer system for Wooten Basset Rugby Club

    SELECT tblPlayer.Name, tblPlayer.MembershipNumber, Sum([tblPlayers-Fixtures].Penalties) AS TotalPenalties FROM tblPlayer INNER JOIN [tblPlayers-Fixtures] ON tblPlayer.MembershipNumber=[tblPlayers-Fixtures].MembershipNumber GROUP BY tblPlayer.Name, tblPlayer.MembershipNumber; SELECT [tblPlayers-Fixtures].MembershipNumber, tblPlayer.Name, Sum([tblPlayers-Fixtures].Tries) AS TotalTries FROM tblPlayer INNER JOIN [tblPlayers-Fixtures] ON tblPlayer.MembershipNumber = [tblPlayers-Fixtures].MembershipNumber GROUP BY [tblPlayers-Fixtures].MembershipNumber, tblPlayer.Name; SELECT [tblPlayers-Fixtures].MembershipNumber, tblPlayer.Name, Sum([tblPlayers-Fixtures].DropKicks) AS TotalDropKicks FROM tblPlayer INNER JOIN [tblPlayers-Fixtures] ON tblPlayer.MembershipNumber=[tblPlayers-Fixtures].MembershipNumber GROUP BY [tblPlayers-Fixtures].MembershipNumber, tblPlayer.Name; 2.

  2. AQA Computing CPT3

    and the dispensed petrol clock (variable - fuelClock). The button will also change the current pump status of "Pump Is In Use" to "Pump Stopped, Replace Nozzle". The Replace Nozzle button will change the current status of the pump from "Pump Stopped, Replace Nozzle" to "Awaiting Payment", this will allow

  1. Membership System For "Abbey Court Leisure health and fitness" - computer system design

    to charge the members their annual fee, inform them the date that they need to pay the money by, welcome the members and make them aware of the different facilities available. * Monitor -this will be needed to view your data * A floppy disk/disks - will be needed to

  2. Logo design

    Final Logo The logo I have chosen to use is: Logo build What software I used AO1A I used www.logoyes.com What software I could have used AO1O, AO1L I could have used paint or photo shop. Why I selected the software I did AO1K Because it was easy to use

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