• 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

1st year project

Extracts from this document...


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.


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.


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)

    this completed form will be collected by a member of staff who will then input the details into the computer system at a convenient time that day. In the interview, Fred made clear that he wanted a unique customer identification number assigned to each customer.

  2. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    This would allow more organisation within the company as there will be less margin for mistakes to be made, and will allow all records to be maintained and kept up to date. This will allow in the future for EVDOP to contact them with other information, which may not be

  1. Marked by a teacher

    Ecommerce Case Study

    talking themselves up or may not have any experience in this particular area. Cuckoo games must ensure that any extra employees that are hired are either experienced in this exact line of work or have suitable qualifications. This is because the company is putting their entire website in their hands,

  2. Feasibility Report

    that if hackers or deadly viruses were to hit the system, files from the previous Back Ups can be easily accessed and restored back on to each of the computer systems. The employment of an ICT technician can be in charge of the Back Ups, alongside keeping each of the computer systems fully functionally and fully updated.

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

  2. ICT 3b evaluation

    It also allows him to choose a route, which could allow him to direct his way away from traffic, camera's or congestion charge Zones. The Sat-Nav can also allow Tom to find the longest route to a destination, which could mean that he would be getting more money, as he will be charging the customer an extra amount of money.

  1. Free essay

    ICT organisation project

    Green and pink are also common in articles. At the bottom corner of each page is a white page number, placed in a blue coloured circle. The title of the magazine "Borough Life" is capitalised and emboldened along with the edition name -"Spring 2009."

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

    The equipment that they provide for the workplace must be in good condition and safe for employees to use.

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