• 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. 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. Different types of technology How I use ICT at home and at school

    This can lead to being abused or assaulted in real life, having data or my identity stolen, having my details stolen and other things. MSN need to give a better awareness to kids of the dangers it holds. Another danger that can happen through MSN are viruses .MSN is full

  1. ICT PROJECT

    When different student is selected change should be reflected under form As expected Implementation This is the main menu which the user will see, when she opens the system to take the marks. The main menu consists of Macro's which will enable my end user to click and go to the specific sheet which she needs.

  2. ICT Report 2b: ICT in Organisations

    For example, a research scientist may need to make notes on a product they are researching, or they may need to make detailed reports on a product they are thinking of producing, stating its purposes, target market, price and so forth.

  1. This report I will be writing, will be on the way I do activities ...

    the necessary people at the same time and in one conversation making it more like speaking to them in person. Ways it can be improved to meet my social needs are that it should be more easily accessed, you should be able to use these IM services on your mobile

  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. Free essay

    security issue

    You can purchase Keylogger's off the internet. Malware - Is a software, its task is to damage a computer system such as to give a computer system a virus.

  2. Database design.

    Number 3 >000< No Rent_Customer_ID Customer ID number Number 6 Foreign No Rent_Video_ID Video ID Number Number 4 Foreign >9999< No Rent_date_out Date Of Video Rented out Date __/__/__ No Rent_date_returned Date of video returned Date __/__/__ No Table Customer Entity Types Description Data type Length Key Validation Input Masks

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