• 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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    Both project managers and users involved in the project should have some prototyping experiences or, at a minimum, be trained in the purposes and use of prototyping. If experimentation and learning are needed before there can be full commitment to a project, prototyping can be successfully used.

  2. Peer reviewed

    Networking Diagrams and Case Study

    3 star(s)

    This also gives DingoMobile the reassurance that any required expansions to the network are basically a cable connection away. Considerations for the LAN ? The LAN aspect of this network solution may not be as effective, if some premises find it difficult to run cables connecting all of their computers/peripherals together.

  1. Peer reviewed

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

    3 star(s)

    The negative impact I think that the phone has brought to the economy aspect is that many people indulge themselves in criminal activities in order to get money and purchase the iphones. Another impact it has had on the society is it has become an easier way of communication with

  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. System Analysis The aim of the Jewellery store system is to make the work ...

    determine the various data inputs to the system, plan how data will flow through the system, designs required outputs, and writes program specifications. During this phase, analysts employ a variety of tools such as data flow diagrams, data dictionaries, and the Gantt chart (a graph depicting design events, personnel assignments, and time schedules).

  2. Principles of Software Design & Development - A system needs to be created which ...

    I decided the best way to include this into the application was to change to the code of the 'reset' button to save the items of the list into variables as well as its initial job of resetting it. Total Multiplication Yes No Buttons Yes Yes.

  1. Describe the hardware and software used to create and edit graphic images and compare ...

    Printers also have environmental concerns due to the amount of paper used. Not only are that but toner and ink made with chemicals that can also cause environmental damage. Plotter A plotter is a printer that interprets commands from a computer to make line drawings on paper with one or more automated pens.

  2. Computing project - testing my library system

    on the right was correctly displayed when user confirm that he wanted to continue the book in question. Test Data : (b) Choice is ?No? Expected Result : Issue transaction stops Display message ?More issue of books? Comments : The issue transaction was correctly stopped and user was asked if he had more books to issue.

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