• 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

This system is designed for the monitoring of post examination re-marks for any test papers that a centre has requested to be re-marked.

Extracts from this document...

Introduction

Contents Page. Requirement of Brief Evidence Page Reference Design Definition of data requirements Top down design. Data relationships. Inputs Processes Outputs. 2 3 3 3 3 User interface design including outputs, forms and reports. Software choices. Report design. Visual basic interface. Letter design. 4 5 5 6 Method of data entry, including validation Validation checks. Error messages 6 7 Record structure, file organisation and processing Candidate table. Fields in tables Links between tables. 7 8 8 Security and integrity of data Security. 9 System design Flow chart. Links between interface 10 11 Implementation / Testing Hard copy output to prove the correct working of the system. Design of queries Design of reports Test data. Test runs - print screens. 12 13 14 15,16,17 Hard copy solution. Visual Basic codes. 18,19,20,21 Appendix A - Printouts of test data runs. Reports for UKAB Letter to exam centre. 22 This system is designed for the monitoring of post examination re-marks for any test papers that a centre has requested to be re-marked. The top down design helps to clarify the problem and separate it out into smaller working units. Diagram 1 Top Down Design. Diagram 2 helps to show the relationship between the different units identified in the top down design. Data Requirements Diagram 3 Data Relationship. 1. Inputs i. Candidate number- Integer - 4 digits long. Note: Candidate number is unique in centres but not between centres. ii. Surname - String iii. First name - String iv. Centre number- integer - Range 10000 to 80000 v. Centre name - String vi. Centre address 1 - String vii. Town - String viii. County - String ix. Post code - String x. Subject reference code- integer - 5 digits xi. Original mark- integer - range 0 to 100 xii. Re-mark mark- integer - range 0 to 100 xiii. Whether the centre requested the return of the script- Boolean xiv. ...read more.

Middle

These are things such as address of the centre, the town and county. The address is made up of four fields. To help identify candidates more easily their forename and surname have been added. These extra fields are required because the UKAB would need to send back the re-marked results to the centre and would need to know the address of the centre. Date re-mark requested and date re-marked has also been added to allow for the calculation of the number of weeks and days that it has taken to re-mark the work. This will tell us if it has been completed within the three-week period. A unique number has been added because candidate numbers are only unique in centre but not between centres. It is therefore easier to search on unique number rather than candidate number. A table called grade boundaries has also been created. This contains the subject reference code and grade boundaries for each grade in that subject. The candidate and grade boundary tables are linked together via the subject code field, see print screen below. Security and integrity of data. To improve security a password could be added to stop unauthorised users opening and editing the data. The print screens below show the security check that has been added to the system. It currently works on one individual name only. The network manager could add more security by giving different levels of access to employees thus allowing certain individuals the ability to view and not change the data. Employees will also have their own log on identification code, which will also help to improve security. The system should be housed in a secure room with limited access. Regular backups are required and need be stored in a separate fire safe unit. The trained operator will also need to make regular saves of the information to reduce loss of data due to unforeseen incidence. ...read more.

Conclusion

If Text3 = 64773 And Text8 < 68 Then Text5 = "B" If Text3 = 64773 And Text8 < 60 Then Text5 = "C" If Text3 = 64773 And Text8 < 52 Then Text5 = "D" If Text3 = 64773 And Text8 < 46 Then Text5 = "E" If Text3 = 64773 And Text8 < 40 Then Text5 = "U" End If End Sub Code for form 2 Private Sub Command1_Click() Form2.Hide 'Hide form 2 End Sub Private Sub Command2_Click() promt$ = "Enter the new record, and then click the left arrow button." reply = MsgBox(Pompt$, vbOKCancel, "Add Record") If reply = vbOK Then 'if the user clicks ok Text1.SetFocus 'move cursor to Title box Adodc1.Recordset.AddNew 'and get new record End If End Sub Private Sub Form_Load() End Sub Code for form 3 Private Sub Command1_Click() Form3.Hide 'Hide form 3 End Sub Private Sub Command2_Click() promt$ = "Enter the new record, and then click the left arrow button." reply = MsgBox(Pompt$, vbOKCancel, "Add Record") If reply = vbOK Then 'if the user clicks ok Text1.SetFocus 'move cursor to Title box Adodc1.Recordset.AddNew 'and get new record End If End Sub Private Sub Form_Load() End Sub Code for form 4 Private Sub Command1_Click() Form4.Hide 'Hide form 4 End Sub Private Sub Form_Load() End Sub Code for form 5 Private Sub Command1_Click() Form5.Hide 'Hide form 5 End Sub Private Sub Form_Load() End Sub Code for form 6 Private Sub cmdFind_Click() prompt$ = "Enter the subject reference code" SearchStr$ = InputBox(prompt$, "Subject Search") Recordset.Find = "Subject code" Recordset.Seek "=", SearchStr$ If Recordset.NoMatch Then Recordset.MoveFirst End If End Sub Private Sub Command1_Click() Form6.Hide 'Hide form 6 End Sub Private Sub Form_Load() End Sub Code for form 7 Private Sub Command1_Click() Form7.Hide 'Hide form 7 End Sub Private Sub Command2_Click() prompt$ = "Enter the centre number" SearchStr$ = InputBox(prompt$, "Centre Search") Recordset.Index = "Centre no" Recordset.Seek "=", SearchStr$ If Recordset.NoMatch Then Recordset.MoveFirst End If End Sub Appendix A - Hard Copies of Test Data. 1 BHASVIC 56120 Michael Bridges 7083 ...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. Visual basic

    * The project is made up of modules. * Each module is made up of Procedures. * 4 type of Procedures: o Event Procedures (e.g., button click) o VB Procedures and Functions (e.g., IsNumeric) o User Defined Sub Programs o User Defined Functions Objects make programming much easier * Instead of having to do everything through statements, Objects make programming much easier.

  2. Computing Project

    Login Form procedure TFMLogin.BtnLoginClick(Sender: TObject); This procedure is used by the user to login to the system and gain access to the main menu Main MenuForm procedure TFmMenu.BtnRegAMemClick(Sender: TObject); This procedure diplays the Regester A Member Form procedure TFmMenu.BtnAddDVDClick(Sender: TObject); This procedure displays the Add DVD Form procedure TFmMenu.BtnRntDVDClick(Sender: TObject);

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    meaning: For example, you can also specify in this infotype that payment should be effected by cheque/bank transfer. * Recurring payments/deductions infotype (0014) in which you capture the details of periodic/regular earnings or deductions. For Mastek, Indian payroll, they will be Medical Reimbursement, Reimbursement of Books, Leave Without Pay, Guesthouse Deduction, Personal Courier and Personal STD/ISD Phone Call.

  2. GCSE I.T Security Case Study - Riverside Leisure Centre

    parent's religious beliefs preventing their child's right to hospital treatment and life. * Or where processing is necessary for legal reasons, e.g. obtaining legal advice, exercising or defending legal rights, for the administration of justice. Or * The processing is carried out as part of the lawful activities of any non-profit making political, philosophical, religious, or trade union organisation.

  1. System I designed in order to produce a promotion package for her newly formed ...

    (I.e., correct errors, add and delete records, fields). * Show my data collection methods suitable for the printouts and other output that I may require. * Do printouts showing simple and complex searches for specific information. * Show evidence that I have chosen a data handling package and constructed a database.

  2. The Global Positioning System

    When a binary 1 in the C/A data is transmitted at the same time as a data bit in the telemetry, the addition will invert the adjacent binary bits, turning 1 to 0 and vice versa. The telemetry code can easily be removed in the receiver.

  1. Evalutation of a Spreadsheet

    This is why it is always a good idea to back up. * String of errors possible - if once piece of data is entered incorrectly into a cell, it could have an effect on various other things on the spreadsheet.

  2. ICT Sample Work Welcome Centre Requirements

    Catering requirements for food and beverages, as well as the hire of equipment will also be recorded. This information will all be recorded in a central paper-based diary, which can often become messy as customers sometimes phone to cancel or amend their booking, meaning that the handwriting can become unreadable.

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