• 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

1st year project

Extracts from this document...

Introduction

Foresters Solicitors ICT Project Rani Sanghera-Warren Table of Contents 2 1 Introduction 3 2 Specification 4 3 Implementation 10 Choice of Software 4 Testing 12 5 Evaluation 14 6 User Documentation 15 1. Introduction The End User The end user for this project is a solicitors firm called Foresters. There are four solicitors working in the office, one trainee solicitor and a receptionist, they all have access to there own computers and they all need access to the diary/log book, filing cabinet and other information. They require a scheduling piece of software to be used by all the staff. It will be used to look up information on clients, staff and prisoners and will also work out the release dates for individual prisoners. The system in place The system the company currently have in place is a simple paper based system, so, for example if a the company took on a new client they would have to rite the clients details on a 'client form sheet' and put it in the companies folder in the filing cabinet, all the records are then sorted alphabetically. A lot of time is spend ensuring this is done correctly, and this system has a lot of room for error, if the staff are tired or in a rush mistakes are easily made and this then causes great difficulties in the future when that member of staff is looking for the clients records. The possible systems that could replace the old one are: 1. A spreadsheet where the end user will be able to input and view data. 2. An interface where the end user will be able to input and view data. 3. A user form where the end user will be able to input and view data. The problem with the current system There are clear disadvantages to using this system, for example: * Information can be easily lost or misplaced If this happened it could result in problems such as missing release dates etc. ...read more.

Middle

is performed automatically, end sum is right Implementation Before I started my project I had to collect data from my end user, the data from Foresters included information on clients, staff and prisoners. Once I had this data I was able to start my project. Staff Data The screen shot above shows a list of Staff names and their contact details in a spreadsheet in Excel. This information is what is displayed below in the actual interface. This is where the data above is shown, on the opening screen. Client Data Above is a list of all the client details that Foresters gave me. This includes their names, addresses, contact numbers and legal information such as when they are next due in court. This information was then shown on the client details screen on the user form. To do this I had to do an advance filter, to filter threw all the reference numbers of the clients sp that specific clients could be recognised. Client form- Advanced Filter Once I had got my data into a list, I started creating a user form but before I could carry this out I had to run an advanced filter. An advanced filter searched threw all the data to find, and single out the piece you want to view. To create an advance filter I first had to copy the column headings in to three separate areas leaving enough space between each so that the required amount of data could be displayed (like below). Once I had made a criteria range i.e. copied the headings to two other separate places, I had to run a filter with once client from the client details sheet. Too do this I when to 'Data'/'Filter'/'Advanced Filter' the picture below illustrates what will then appear on the screen. I then made a macro which recorded the advanced filter. Once I had recorded the macro I found it in visual basics and matched the field source to clients on the spreadsheet and then entered this formula (below) ...read more.

Conclusion

Here you can see a list of all the staff details and two buttons leading to client information and a prison list. If you decided to press client information a form like this will then appear. Use the drop down box on the right to select the client you are looking for, once this is done all the other boxes will be filled automatically as shown below. Once you have finished viewing this information click close to go back, then you can select 'Prisonlist' you will then be show this screen. You then select the prison you would like to search for prisoners in, for example you may want to click onto 'Belmarsh' in which case you will be redirected to this form. All four of the prison forms are identical to the one above. Once you have selected the required prison you then select the prisoner you're looking for by their surname and all the other text boxes will be filled automatically. Finally when you are finished viewing all the information you simply press the close button, and then press it again on the main form. Glossary of technical terms A B C D Desktop Dialogue box Drop box The background behind all your windows, menus, and dialog boxes, your virtual desk A special window used by computer programs or operating systems to display information to the user, or get a response if needed A user interface control element which allows the user to choose one value from a list. E F Filtering Form G H Hyperlink I Input Interface Data that is entered into the computer threw some sort of device A hardware and software link that connects two computer systems J K L M Macros Mouse click Mouse press Module testing Testing there v lookup buttons N O Output R R.M.B U Unit testing ?? ?? ?? ?? Rani Sanghera-Warren Set 4 AS report rani2 - 36 - ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    moved to an archive file; UR10: enable the total price of vehicle rental to be calculated automatically; UR11: enable vehicle details to be added/edited/deleted/ displayed onscreen/printed; UR12: enable the age of a customer to be calculated automatically, taking miles travelled into account; UR13: enable the age of a staff member

  2. Threats to Data

    These records should be deleted. 6. Processed in line with the rights of the individual. Each individual customer of transactional website has the right to privacy, and all data has to be processed with this principle in mind. 7. Kept secure.

  1. Feasibility Report

    Recommendations I have suggested three of the following alternatives for the new system within the Perfect Pie Company; firstly Bespoke Software, off the shelf software, and customized of the shelf software. The alternative I am going to recommend for the Perfect Pie Company is Customized Of The Shelf Software (COTS)

  2. Free essay

    ICT organisation project

    Each page includes a page number. The graphics used throughout the magazine are photographs which help to promote the community ethos of the magazine. Font style The main font style used is traditional and clear, Times New Roman. This shows clarity and is easy to read, which is a requirement as such a wide range of people will access the magazine.

  1. A2 ICT CouseWork

    As we are not that well , so we have too try to reach everyone on the interne t. So I feel it is important we do these tests before we put our website online. Process Testing The Process's within the website are seen as the most complex parts of

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    The employer knows the capability of the employee and aims to the standard which means that they know the level of effort of them. Professionalism- The employee does the work to the best of their ability in a professional standard, does the work to the best of work.

  1. Explain the function of computer hardware components

    USB Flash Drive A USB stores digital data like, videos, images, word documents etc. USB drives can usually be removable and rewriteable. They are commonly used for storage, back-up and transfer of computer files. They are durable because they do not have any moving parts therefore it cannot be damaged easily.

  2. ICT revision notes - IT project management

    âHow often are they used? âHow the is the data collected? âWho are the documents sent to? âWhat do they do with them? âSystems analysts' then use formal graphic and tabular methods such as DFDs to represent the current system.

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