• 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

I have been asked to design a system for the United Kingdom Awarding Body (UKAB), an imaginary exam board. This system is going to be used for the monitoring of its post-examination re-marks.

Extracts from this document...

Introduction

Introduction: I have been asked to design a system for the United Kingdom Awarding Body (UKAB), an imaginary exam board. This system is going to be used for the monitoring of its post-examination re-marks. System Specification: The system specification needs to store the following data: * Candidate name * Candidate number * Centre number * Subject Reference Code * Original mark * Re-mark mark * Whether the centre requested the return of the script It was also necessary to store the grade boundaries for each of the subjects. For the system I was asked to build the following table was provided for the grade boundaries of each subject: Subject Reference Grade Boundaries (%) Code A B C D E 01325 75 67 60 54 48 20094 70 60 50 40 30 28181 90 78 66 54 42 54821 85 79 74 64 55 64773 68 60 52 46 40 The system needed to be able to produce hard copies of the following: * A daily list of any re-marks completed where a mark change has affected the grade; * A daily list of any re-marks still outstanding, i.e. that have not been completed within a three-week period; * A list of re-marks that have been requested for a particular subject; * A list of re-marks that have been requested from a particular centre. The system also needed to be able to produce documents which could be returned to the centre giving the results of the re-marking. The document needed to show the UKAB logo and also the following details: * Centre number (integer) * Candidate name (string) * Candidate number (integer) * Subject Reference Code (integer) * Original Mark (integer) * Original Grade (text) * Either the re-mark mark and grade, if changed, or a sentence to say that there has been no change (integer/text) Processes: The user of the system would need to be able to carry out the following processes: * Record information about candidates * Amend/delete information about candidates * Record re-marks * Query so as to obtain the information for the hard copies which I listed above. ...read more.

Middle

My other main option for creating this database was to use Delphi, which is a form of Pascal. I have already covered most of the Pascal syntax and it would have been the best alternative choice, however I did not do this for the reasons above. On top of this I wanted to expand my knowledge of systems creation by experimenting with Visual Basic and also Access. Hardware: The hardware which I will be initially creating my solution on is my home PC. This PC was built by me and therefore I am very familiar with the hardware that I will be using. The hardware is of a medium to high specification: * AMD Athlon XP 1800+ (clocked at 1533 MHz) * 512 MB DDR PC2100 RAM * 40 GB Hard drive However I wanted to ensure that the software that I was creating would work on a PC of lower specification so that anyone that was using it would not be forced to upgrade their systems to use my database. I therefore did some testing on the PC's at my College which were of a lower specification: * Intel Pentium III 800 MHz * 128 MB SD RAM * 10 GB Hard drive Design: Tables: Following are screen shots of the tables in my database: Candidate Design View: As can be seen in the properties of the candidate name attribute, I have changed the field size to 20. Also it can be seen that the primary key is a composite one made up of candidate number and centre number. Candidate Table View: Centre Design View: In the above view, the focus is on the centre number attribute, as can be seen the field size is set to long integer, also for the format I have altered it to 00000. This represents the number of digits that I was to be shown at any time, this is a work around of the problem that if a centre number begins with a zero then it will still be kept. ...read more.

Conclusion

preview Preview opened 6 Check outstanding re-marks report opens Click outstanding re-marks button Outstanding re-marks report preview Preview opened 7 Check subject report opens Click subject report button Pop up box then report preview After entering criteria, opened 8 Check centre report opens Click centre report button Pop up box then report preview After entering criteria, opened 9 Check candidate report opens Click candidate report button 3 popup boxes then one of 2 reports After entering criteria, opened 10 Check exit button Click exit button Form closes Form closed 11 Check auto grade feature for original mark Insert mark Equivalent grade is generated Grade generated 12 Check auto grade feature for re-mark mark Insert mark Equivalent grade is generated Grade generated 13 Check validation rule for candidate number Insert 5 digit code Rejection of the code Rejected 14 Check validation rule for centre number Insert number larger than 80000 Rejection of the code Rejected 15 Check Validation for subject reference code Insert 6 digit code Rejection of the code Rejected 16 Check validation for original mark Insert number larger than 100 Rejection of the number Rejected 17 Check validation code for re-mark mark Insert number larger than 100 Rejection of the number Rejected 18 Check validation code for original grade Insert the letter "G" Rejection of the letter Rejected 19 Check validation code for re-mark grade Insert the letter "H" Rejection of the letter Rejected 20 Check auto subject reference code feature Insert word "business" Generation of the code "20094" Generated 21 Check auto subject name feature Insert code "01325" Generation of word "Art" Generated 22 Auto date feature Enter date field Generation of todays date Generated 23 Check that Auto grade feature works for alterations Change an existing mark Regeneration of grade to new grade Generated 24 Check validation of dates Insert "abc" into date received Rejection of date Rejected 25 Check that Duplicate Centre Numbers cannot be inputted Insert "66528" in new record Rejection of data Rejected ?? ?? ?? ?? 1 ...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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    The greater the interaction between the computer and the user, the greater the benefit is that can be obtained from building a quick system and letting the user play with it. Systems with little user interaction, such as batch processing or systems that mostly do calculations benefit little from prototyping.

  2. Visual basic

    'Function To Make All Fields Invisible O1.Visible = False O2.Visible = False O3.Visible = False O4.Visible = False O5.Visible = False O6.Visible = False O7.Visible = False O8.Visible = False O9.Visible = False X1.Visible = False X2.Visible = False X3.Visible = False X4.Visible = False X5.Visible = False X6.Visible =

  1. Computing Project

    anything inappropriate from being entered into the system which will help in increasing the integrity of the data entered.. I will also use input masks for things like the post code or telephone of a member as there all the post codes and telephone numbers are in one standard form for all members so this will also improve integrity.

  2. The Global Positioning System

    The data from all monitor stations is relayed back to Schriever AFB, where it is analysed. It is then decided if any corrections need to be made to any satellites. If any corrections are needed, the data is uploaded to the satellite.

  1. ICT Sample Work Welcome Centre Requirements

    Tony sometimes has to handwrite quotations too for the same reasons. Scope The scope for this task is to find a way of entering booking details for conferences, and to create a quotation for that conference. Creating invoices will not be included in this task.

  2. Computing Project

    My system is designed to help the instructor, the instructor has many problems with the current system, and many times it has cost him jobless hours. The current system is very old and has a lot of potential problems and I wish to make a system that eradicates these obvious problems.

  1. Logo design

    and the logos were more accurate and professional than they would have been if I used paint. Advantages and disadvantages of software chosen AO1N Advantages: * It's quick * It's easy to use * There are different designs to choose from Disadvantages: * No instructions on how to use the

  2. You have been asked to create a database to handle various account combinations of ...

    It is therefore necessary to capture the essence of the business and model around those core concepts to be able to handle changes properly. Be consistent with other models in the system Different models of the same system can be integrated or cross checked against each other for consistency.

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