• 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)

    We are advocates of Interactive Prototyping, especially in combination with business analysis and user feedback sessions. However, there are times when the use of alternative approaches makes more sense. Benefits of Software Prototyping The main benefit of software prototyping is in obtaining feedback on a proposed design at an early stage in a project.

  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

    will pop up telling the user that the username and password is incorrect and to re-enter it correctly. I will also use combo boxes where I think data doesn't really need to be typed into the system manually by the user but can be selected from a list to prevent

  2. ICT Sample Work Welcome Centre Requirements

    However, Quotations will be viewed by Customers as these are the target audience of this document. ASSESSMENT OF SKILLS OF USER(S) Tony will use the solution, but has very limited ICT skills. He is a complete novice at using computers.

  1. Smart Card System

    Conversely, Microsoft's Win32s installs a 32-bit wsock32.dll thunk layer in 16-bit Windows environments (Windows version 3.1 and Windows for Workgroups 3.11) over any vendor's WinSock DLL currently in use. LANs are capable of transmitting data at very fast rates, much faster than data can be transmitted over a telephone line;

  2. Computing Project

    Student number Number, 8 A Unique number given to each student for easy reference. Student address Text, 50 Full address of student, including postal address. Lesson code Number 5 A code that determines what sort of lesson they take,

  1. This report aimed to replicate Stroop's (1935) experiment. Using the repeated measures design and ...

    The main reason for this is that individual differences are eliminated and the time period for which to execute the experiment is minimised. This design, however, introduces order effects which include fatigue and practice effects. These effects can be minimised through counterbalancing, this involves splitting the participants into two equal groups.

  2. The Global Positioning System

    So how does the whole system work? In the NavStar system, there are 3 components. There are the satellites in space, there are US Air Force control stations, and there are the receivers. The three components, while all are necessary, are not linked together.

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