• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43

I have been given the task of creating a system for a hospital to keep records of their loan equipment. It needs to be able to keep records of what equipment has been borrowed, by whom and when, and also if any equipment is unavailable as it is in repair.

Extracts from this document...


CANDIDATE NAME PAPER 3 COMPUTING COURSEWORK CENTRE NUMBER: CANDIDATE NUMBER: INTRODUCTION 5 SYSTEMS LIFE CYCLE 5 GATHERING DATA 6 PROBLEMS OF EXISTING SYSTEM 6 OBJECTIVES OF NEW SYSTEM 7 DESIGN 8 Feasibility of Using a Computer Based System: 8 Performance Requirements: 8 Costs: 8 Hardware 9 Software 9 Excel: 9 Access: 10 High Level Languages: 11 Evaluation of Software: 11 DATA REQUIREMENTS: 12 DATA FLOW 13 Data Flow Diagrams: 13 ENTITY-RELATIONSHIP DIAGRAMS 15 SYSTEM DESIGN 16 Top Down Design: 16 Jackson Structure Diagram: 16 User Interface: 17 Interface Styles: 18 1. Command Line Interface (e.g. MSDOS) 18 2. Menu's 18 Full Screen Menu: 18 Pull-Down Menu: 19 Pop-Up Menu: 19 3. Natural Language 19 4. Forms & Dialogue Boxes 20 Advantages of Using a Common User Interface: 20 MY DESIGN: 21 Outputs: 21 Hard Copy of Equipment: 21 Weekly Report: 21 Menus: 22 Methods of Data Entry: 23 Tables: 24 Security and Integrity of Data: 25 Validation Rules: 25 Back-Ups 25 Security: 25 Passwords 25 Encryption 25 Password Locks 25 IMPLEMENTATION 26 Entering Data Stores: 26 Data Entry Page: 27 Loan Equipment Macro: 29 Validation Rules To Prevent Human Error: 30 Viewing Patient Details: 32 Mail Merge Letter 33 Patient Search Facilities: 34 Managers Area: 35 Main Menu 36 Making the Spreadsheet User Friendly: 37 Security 38 Testing the Buttons: 39 Navigation Buttons: 39 Operation Buttons: 40 Testing Validation Rules: 41 MAINTENANCE: 42 User Documentation 42 System Documentation 42 Introduction I have been given the task of creating a system for a hospital to keep records of their loan equipment. It needs to be able to keep records of what equipment has been borrowed, by whom and when, and also if any equipment is unavailable as it is in repair. Systems Life Cycle We have already been given the information for a problem definition, feasibility study and analysis, but have been told that we do not need to do these stages of design. ...read more.


To make data entry easy I have used validation rules on the data entry cells. When the cell is selected the yellow information box appears, giving the user guidance on how to enter the data. I have set the validation rule on this particular cell to allow only numbers and in the format dd/mm/yy, if the user enters anything else the following error message appears informing the user that they have entered incorrect information. When the user is entering the equipment the user wants to loan, I have made a drop down menu so that it is easier for the user to enter the information and leaves less room for error. The user can easily select the appropriate equipment with the mouse. I have set the validation rule so that it will only accept values in the cell from the drop down menu. As there are no other pieces of equipment available to loan this protects the system from typing errors and mistakes. The user will only have to use a mouse and a keyboard to input the data and only the mouse for the operation of the system (e.g. using the buttons). Tables: My data on patients and equipment will be stored in tables on a spreadsheet. I have designed tables to show the equipment in stock, equipment ID codes, patient records and equipment due for return. All tables will have a bold outline with a thin cross-divide to show the separate cells. The titles will be in bold font with a red background, this is to clearly show the divide between titles and data. Security and Integrity of Data: Validation Rules: A validation rule specifies a test, which has to be performed on any data entered into the cell. If that data does not pass the test an error message comes up on the screen, which contains the text specified in the validation rule box. ...read more.


* County - This only allows Kent, so I entered Sussex, but again it picked it up giving me an error message explaining that the county was not in the hospitals attachment area. * Contact Number - Only allows telephone numbers, I entered the value "123four", an error message appeared informing me that only phone numbers were allowed to be entered in this cell * Ward Number - Only allowing values from the drop down menu I entered ward 11 (drop down menu goes up to Ward 10), it returned an error message saying invalid ward number * Patient Equipment - This is also a drop down list allowing only the values from it. To test it I entered "bandage" but again the test proved correct and informed me that the value I entered was invalid * Loan Duration - I have set a validation rule on this cell to only allow positive integers. To test it I entered first "-2" and then "1.5" but both times it returned an error message saying that they were invalid and to enter a positive integer value. Maintenance: Maintenance is important as it ensures the long life of the system, e.g. If the business changes so may the requirements of the system, by resolving bugs or program errors, which arise after the system has been implemented, and to enhance the functionality of the system when users require it. I am not required to produce user documentation and system documentation. However if we had been required to produce documentation I would include the following: User Documentation * Installation Instructions * Instructions on how to start and run the system. As well as a guide for using the different functions. * Over view of the system and what it does * Trouble shooting guide on possible errors and how users should deal with them System Documentation * Data Flow diagrams * Data entity diagrams Computing Paper 3 Coursework 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. Peer reviewed

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    It has become useful to workers has it allows them to access their business and complete their task without having to actually visit the office. To the various individuals they use it for their own personal needs and it has really helped people to stay focused and punctual on anything they attain to do via the ipohnes.

  2. Peer reviewed

    Networking Diagrams and Case Study

    3 star(s)

    use more than one workstation, so creating a LAN network on each premise will cater for this, and then allow each of the connected workstations to also access the internet. The LAN will also allow each store to utilize other peripheral devices, such as printers, which I?d assume would be required for some activities on the premises.

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

    pay, according to contractual requirements, which is composed of payments and deductions. Different factors determine whether such payments and deductions increase or reduce the taxable income. Such factors include the statutory regulations of India. Individual gross values are grouped together as bases for taxes according to the specifications of India and its states/regions and pay scale regulations for a profession.

  2. 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

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

    No one else can read it as only the data receiver has the decoder. Once the data receiver receives the encrypted data, it can be decoded by applying the decoder to the message and then it can be read normally.

  2. Hardware and Software

    because i think CRT monitors are still considered to have a better colour range and are easier to calibrate colour accuracy. These monitors are still very popular in graphic arts where high quality reproduction is important. Benefits: 1. The designs would be seen in better and true colours because most CRT monitors are capable of displaying unlimited colours.

  1. Discuss the relationship that exists in the UK between the legal rules that govern ...

    This also relates in part to The Combined Code 2003 S1A.7: "All directors should be submitted for re-election at regular intervals, subject to continued satisfactory performance. The board should ensure planned and progressive refreshing of the board." This again can be compared to The companies Act 1985 Table A: Articles

  2. Different ways of data capture

    *Another reason why a document may look different on another computer is that the fonts are not the same. A different font will be used and this will change the layout. UPGRADABILITY Upgrades to software are common about every 2 yrs.

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