• 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
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  • Level: GCSE
  • Subject: ICT
  • Word count: 5282

Yourprice.com Information Technology Investigation

Extracts from this document...


Contents Page no. 1 Analysis 1.1 problem specification 1.2 user requirements 1.3 analysis of current system 1.4 input, processing and output needs 1.5 information requirements 2 Design 2.1 design of input 2.2 design of output 2.3 data checking and data controls 2.4 data structures 2.5 processing requirements 2.6 specialist software features 2.7 hardware requirements 2.8 software requirements 3 Software Development 3.1 hardware and software configuration 3.2 develop data and processing structures 3.3 user interface 3.4 data checking 3.5 annotated listings 4 Testing 4.1 testing strategy 4.2 test plans 4.3 test results 6 Evaluation 6.1 evaluations of results against the requirement specification 6.2 future developments 6.3 statements of limitations Analysis Problem Identification 1.1 Yourprice.com is a global Internet based music shop. As it is solely based on the Internet general maintenance costs and staff costs are considerably less than normal retail outlets. The company has been running for three years and recently shopping over the Internet has become more popular and therefore there have been many extra orders and with this, increasing demands by customers. The current computerised system is having problems dealing with the extra orders and staffs currently have to work overtime to make up for the inefficient system. The main reason for this is that each of the systems databases are completely detached from each other and therefore the relations between the customers file and stock file for example have to be done manually. Yourprice.com currently employs thirty-seven people. Eight of these employees are responsible for receiving orders via the Internet and other office work such as employee wages etc. Five employees make sure that orders and received by the twelve employees based in the warehouse who are responsible for making up the orders and making sure that they are correctly packaged and dispatched on time, four employees are responsible for dealing with customer enquiries and complaints, three are in charge of advertising and public relations and there are five managerial staff. ...read more.


The system will also have to calculate a subtotal, and an overall total for each order. The overall total will be calculated by adding postage and packaging on to the sub total. The distance the order has to be sent calculates this. The system will also need to be able to search for item details and customer details and it will need to be able to produce reports for each part of the system. As well as this it will have to be able to be easily amended and it should have options to add, delete and amend records. For example if a customer has changed their address the system will have to handle this so that the items are dispatched to the correct address. On the next page I have shown a list of all of the information requirements. Design Design of input 2.1 Over the next few pages I have included the pencil and paper designs of many of the layouts, buttons etc. displaying the design of the new system. Design of Output 2.2 Over the next few pages I have included the pencil and paper designs of many of the expected outputs from the system including reports, address labels and standard letters. Data checking and 2.3 Data controls This is the validation and verification of the data in the system to make sure that it is accurate, complete and reasonable. Data verification checks are the checks, which I can perform manually although data validation checks are those that the computer can detect automatically and produce error messages for. I have given a brief description of each validation check below. Presence check The data is checked to discover if and fields have been left Blank in a record that should not have been left blank. e.g. a mandatory field such as customer ID. Type check Each field is given a format and this format is reserved only or the characters identical to it, i.e a numeric field will only allow numbers whereas an alphabetical field will only allow letters. ...read more.


Test previous record button- to make sure you can go back to the last record. 14. Sub-total formula- Make sure that it equals the product of the quantity and the item price. 15. Balloon help on Item number field- to make sure it appears. 16. Included layout- to make sure that when item details are updated they are also updated in item file. 17. Quick report- print an Ad- Hoc report Item file 18. Amend record- so that item details can be updated 19. Item description list- to see if list appears. 20. Balloon help on sales rank field- to ensure that appears when required. 21. Uniqueness check- to ensure that items have their own unique item number. 22. Presence check- to make sure that a mandatory field isn't left empty. 23. Type check- to make sure that contents of a field are the correct format. 24. Test help screen button- to ensure that the help screen appears when the button is clicked. Test plans 4.2 Over the next few pages I have displayed my test plan sheets. These show the selection of tests that I will perform and the order that the tests will be performed in. I will follow the test plan sheets carefully using screen dumps to demonstrate the outcomes of the tests as mentioned previously. Test results 4.3 These are the details of the outcomes of all my tests. The results consist of screen dumps, test detail sheet and also whether or not the tests were successful. Evaluation of test outcomes Each test was determined successful if the actual results met the expected results. As you can determine from the following tests twenty-three out of the twenty-four tests were successful although the test that failed was repeated and was successful the second time. In conclusion therefore I am pleased with the test results as they prove that the new system has been implemented successfully and is working according to plan. Evaluation Evaluation of results 6.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 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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    People who don't have access to a printer or photocopier at home can use the library. This means that people save money on not having to purchase their own printer and photocopier as they can simply use the library. People can print out work or photocopy posters and such using the library.

  2. ICT Developments

    "International boundaries are ignored, as businesses are able to transfer information on a global scale. Employees can access intranet sites to keep abreast of company activity; the public can find information about companies without expensive postal searches or visiting in person."

  1. Creating a computer system for a video rental shop

    To check for the 3NF, It shows that all non-key attributes are mutually independent The second Table is video table. It contains: Video ID Title Publisher Year of publication ISBN number Author name All the attributes values are atomic, therefore it is normalised to the 1NF To check for the 2 NF.

  2. task2-report-template 3

    Auto Colour Text String Title Text String First name Text 15 Surname Text 15 Address Text String Telephone number Number Integer Order date Number Integer Order item Text String Field Name Validation Rule Error Message Postcode => 5 Must be equal to or more than 5 New or old "new"

  1. System requirements analysis

    Later on when the health centre is more developed, they can even send out emails to the patients and doctors instead of sending them letters (which are time consuming).

  2. Planning a system to handle school records.

    * The system should automatically calculate the cumulative marks, percentage and graph of individual student in every subject, * The system should allow user to gain accurate result in calculation. * The user should able to enter all the data and easily view it.

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

    windows and also when you are underground. * Also when one base station has too many people connected to it, it can sometimes disconnect your call. Personal Needs When it comes to using my phone personally, I use it to make phone calls to my family to let them know where I am or when I will back home.

  2. Computer Studies Past paper definitions

    ability to "add to its knowledge"/learn from previous experience examples: chess, medical diagnosis, mineral prospecting, car diagnostics, tax calculations, etc. [2] (b) Electronic scabbing allows managers to switch ... word processing/computer processing duties ... from striking clerks in one country/location to non-striking clerks in another [2] (c)

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