• 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
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  • Level: GCSE
  • Subject: ICT
  • Word count: 5048

A secondary school holds many different exams around the school year, students who attend the exams need to know where, when and what the exams are, and also the particular seat assigned to them - Create a systems update for this.

Extracts from this document...

Introduction

TABLE OF CONTENTS INTRODUCTION 4 Background 4 The Current System 4 REQUIREMENTS OF THE NEW SYSTEM 5 REQUIREMENTS OF THE NEW SYSTEM 6 General objectives 6 Specific Objectives - Quantitative 6 Specific Objectives - Qualitative 6 CONSTRAINTS 7 Hardware 7 Software 7 User's IT skills and knowledge 7 SPECIFICATION 8 SPECIFICATION 9 Requirements Specification 9 INPUT, OUTPUT AND PROCESSING NEEDS 9 Input 9 Processes 10 Outputs 11 DESIGN 12 Tables 12 Forms 15 CANDIDATE INFORMATION 15 Find a candidate 15 Find a Candidates ID number 16 Find Details about a candidate 16 Find a list of exams a candidate has been entered for 16 View a list of all candidates on this system 16 Enter a new candidate 16 EXAM DETAILS 17 Find Exams Being Taken on a particular Date 17 Find Exams Being Taken by a Particular Candidate 17 Enter a new exam 17 View a List of all Exams 17 EXAM HANDOUT SHEETS 17 Print sheet for all Candidates 18 Print Sheet for Specific Candidate 18 Queries 19 Relationships 19 IMPLEMENTATION 19 26/02/03 - 22 24 CREATED: EXAMS TABLE "TBLEXAMS"; 24 Design 24 LAYOUT 24 24 Design 25 Layout 26 FIND CANDIDATE/DETAILS 32 TESTING 35 Introduction Background A secondary school holds many different exams around the school year, students who attend the exams need to know where, when and what the exams are, and also the particular seat assigned to them. There are about 200-300 end user's (candidates), and one administrator who inputs all candidate details, exam courses available in the school, and which candidates are taking which courses. The administrator then has to supply each candidate with their candidate number, a list of all exam courses they are taking, the location of the exam and which seat has been assigned to them. The Current System The current system is an A3 page of a plan of the seating arrangement, with a candidate number assigned to each separate seat. ...read more.

Middle

Y X AutoNumber 4 4 digit number beginning with 7 7*** This is the candidateID number used to identify an individual candidate 7061 CandidateFirstName Y Text 20 The Candidates first name Bob CandidateSurname Y X Text 20 The Candidates surname Hotchkins CandidateTelephone Y X Number 13 5 digits in brackets followed by 6 digits (*****)****** The Candidates Telephone Number (01761)453541 Key: R=Required Y (Yes) N (No) I=Indexed Not Indexed X No Duplicates ? Duplicates OK Table Design - Exams Database File mainproject.mdb Table Name tblexams Related to: Table Name Foreign Key Table Name Foreign Key General table description: Field Name R I Data Type Length Input Mask/Validation Rule Default Value Description Typical Data ExamPaper Y ? Lookup Text 20 The foreign looking up in the ExamDetails table 12 CandidateID Y ? Lookup Text 20 The foreign looking up in the CandidateDetails table 7061 Date Y ? Date/Time 20 2 numbers, then 2 numbers, then 2 numbers **/**/** The date at which an exam is being held 26/07/03 Key: R=Required Y (Yes) N (No) I=Indexed Not Indexed X No Duplicates ? Duplicates OK Forms The first page you will see will be this: From this page you can navigate to 2 sub-menus: Candidate Information The first sub menu will hold information about all the candidates currently entered into the system, and the ability to enter new candidates. From this sub menu, you can navigate to 2 places: Find a candidate This button will bring up a sub menu with the following options: Find a Candidates ID number This button will bring up a search query, which will ask you to enter the Candidates surname. The query will then search the database and display all results found. No other information is asked for because this part of the system needs to work quickly; entering a surname and locating the correct candidateID should be available in 15 seconds from starting the query. ...read more.

Conclusion

Their main negative view is that the system does not allow change of exam details very well, for example if a new exam needs to be entered, they have to use normal navigation buttons at the bottom of the page to get to the end record, and then type it all in manually. Other improvements are listed below: * A greater number of exam detail forms, such as the ones that exist for candidate details * A search form for an exam timetable - find out which exams are being taken on a particular day, and which candidates have been entered for them I have completed most of the objectives I set out to do: * The candidate's details must be entered to assign them a candidate number - when a new candidate is entered in the form, an autonumber field assigns them their candidate number * The candidate's details must be entered to find out the candidates number - I created a form which contains a list of the candidates which, once selected, displays the candidates ID number * The candidate's details must be entered to find out the details about exams they are taking - I created a form which displays the candidates details, and contains a subform which displays the exams they are taking * The candidates' details must be entered so that they can be assigned their various exams & the reports can be handed out to the correct people - a Report creates the handout sheets, which can be accessed through the menu * The exam details must be entered so that an exam paper number can be assigned - An autonumber gives the exam their number once the details are entered into the form * Candidates' details must be laid out for inputting new candidates - a form lays out all the details in an easy to read manner Matthew Stone Candidate Number: 7232 Centre Number: 50749 Page 1 of 46 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    This can be extremely dangerous for me as it can be hard to distinguish what exactly is a message from a friend or a computerised message containing a virus. These viruses can then nest into my computer and grow more dangerous as time passes.

  2. Explain the difference between primary and secondary sources of data, with examples.

    say exactly how they feel, so the results will be more valid. Often when carrying out research, working with others will often help your work to become more valid and reliable. Using unreliable data collection can lead to validity problems with the data; this means that the data would be inaccurate.

  1. Financial Model to help organise the year eleven prom

    of tickets or the "raw data" sheet to add or view the decorations, catering, music. After I had done this I decided to make the whole program automatic, so on the user input screen I added the choice of returning to the welcome screen or to moving on to the "Raw Data" screen.

  2. ICT PROJECT

    Although this data form deletes the student from the student list in under a minute, the data form does not delete the student's entries in the marking archive. This means that data pivoted from the marking archive is sure to be up-to-date as it may contain data for students who have left.

  1. ICT Report 2b: ICT in Organisations

    Also, a disadvantage to Boots is that it takes while to burn and then to read off it from another computer as the CD drive will have to read it for 10 seconds at least before showing the data on it.

  2. Free essay

    security issue

    Spyware - Is a computer software that is secretly installed on to your computer and can take control over something's that you do on it. It can install software which you did not want on your computer also it can make you go on websites that you did not click

  1. Database design.

    Structured Query language. Database Structure Acceptable data In this database there are certain fields that need certain data ranges. These are things like the patient number, this field needs to have numbers that above 10000, as the patient number cannot begin with a zero.

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    We also have problem with storage. Currently there are cards all over the place and they take up a lot of space. It is also a messy process and there is not a lot of organisation. Also all the members details are on printed papers and take up a lot space.

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