• 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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Additional payments infotype (0015) in which you capture the details of annual or irregular earnings or deductions. For Mastek, Indian payroll, they will be LTA and Performance Pay. * Contract elements infotype (0016) * Monitoring dates infotype (0019) * Family details infotype (0021)* * Membership fees infotype (0057), which

  1. Computing Project

    Variables List Register a Member Form Variable Global/Local MemberID Local Add New DVD Form Variable Global/Local DVDID Local Rent Out a DVD Form Variable Global/Local Xmem Local dpmm Local Return DVD Form Variable Global/Local Xmem Local Overdue Loans Form Variable Global/Local dpmm Local row Local Annotated Listing of Program Code

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

    The processing must safeguard the rights and freedoms of the data subjects. It must be limited to members or persons in regular contact with the organisation and it must not disclose any personal data to others without the data subject's consent.

  1. ICT Sample Work Welcome Centre Requirements

    This could then lead to mistakes being made such as double-bookings, or not getting everyone's requirements correct for a conference. Chris Ruck, one of the team, will sometimes word process the quotation onto a basic blank template produced in Word Processing software (MS Word).

  2. Smart Card System

    The Smart Card is different. By using multi directional interaction between the card and the reader true authentication of identity can be met in a more powerful way that is much more secure than the traditional magnetic stripe card. The cardholders' identity is held on the card via a secret key.

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    by another concentric physical channel, both running along the same axis. The outer channel serves as a ground. Many of these cables or pairs of coaxial tubes can be placed in a single outer sheathing and, with repeaters, they can carry information for a great distance.

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

    I found that Pop music was the most popular with people and classical the least popular. Most people would pay between �10-15 for a music CD. This is because the best CD's are highly priced therefore most customers are prepared to take that risk and spend over the limit just to get the latest music.

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