• 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
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73

ict as level coursework

Extracts from this document...

Introduction

CONTENTS PAGE Name Pages _____________________________________________________________________ Specification 2- 15 Implementation 15-44 Testing 44-55 User Documentation 55-67 Evaluation 67-71 Background on company Welcome to Magic Herbal Products, which was founded by Sarah Lenington in 2003, who travelled across the world in search of some of the rarest herbal and organic remedies. Sarah was born in London and studied dermatology at a top university. Her passion was making others feel good about themselves so she decided to take up the opportunity to travel several countries in 1997 in the hope of finding natural ingredients instead of artificial products that are prone to cause skin deterioration and allergic reactions. Her discoveries of mineral oils and powders as well as plant extracts were tested in labs for over three years. This was a major procedure to ensure the ingredients were compatible with both skin and hair. It was important that all ingredients used in each product was natural and was not tested on animals. The ingredients were found in Indonesia, Malaysia, India and also Egypt. What makes Magic Herbal products so different to any other brand is the purity of the products as well as their campaign against testing products on animals. Furthermore the packaging of all their products is recycled to ensure they are doing their bit for the environment. The Organic Cosmetics store is located in the centre of London with two people working in it that are in charge of customer service, stocking the products and distributing the products by postage to customers that order by mail. Current system The current system is a paper based system meaning that all customer details, store details, bills and employee information is all stored on paper and is filed. Once a customer wants to purchase any of the herbal products over the phone the employee will have to fill out customer details manually on a sheet containing contact details, billing information, product information and the total of items purchased. ...read more.

Middle

Therefore all we have to do from here is plus the total before discount and how much that has to be subtracted. =D23-D24 This is the grand total of purchases after a 10% discount. Now the invoice is complete it, all the information should display on the user form a well such as price, product name and quantity. I have to select a list box and go on row source and enter the cell I want it to show from the invoice. This shows that I want it to go to the invoice spreadsheet to cell c14, which is the product name. I must do this for each list box, text box and combo box that I want linked to the invoice. Therefore the information on the user form and on the invoice is the same. Above is the final layout of my 'buy products' user form. This is another important user form as orders are processed on it. 'Magic Herbal Company' has many problems with their old system such as it taking to long to make an order or it being unprofessional. Firstly, the combo boxes make it very easy to purchase a product. This is because once it has been selected the product name and price will show up automatically due to the V LOOK UPS that were done on the invoice. Therefore this diminishes the ordering process to be long. The presentation has to be careful as there is much more text boxes, combo boxes etc on the user form. However, the layout is clear and concise which means that the user will not get confused and also that it maintains its professionalism. Invoice Below is the final copy of my invoice. As you can see it has been printed on an A4 sheet of paper showing that it has fulfilled it user requirement. The invoice is a representation of the business therefore when designing it careful attention to detail was required. ...read more.

Conclusion

So if a customer wants to order one bottle of serum, the user must still fill in the other combo boxes and then to cancel the unwanted order, all the quantites must be filled in with 0, because that a unwanted products � 0 which amounts to just the desired product that will be purchased. This factor also wastes time as the user has to ensure all combo boxes have a catalogue number in them and that they are multiplied by 0. Improvements for the future From these cons with my system I have come up with improvements that would make my system better if I were to do this again. At the moment anyone can access the system and make orders. However it would be more beneficial to the company if there was more security. This can consist of entering a password and username before the system opens. This way only authorised people can access the system which means customer details are secure, hence improving customer service. The 'buy products' user form uses a combo box that give the options of what catalogue numbers are available to purchase. However as mentioned previously this meant that only one product of each category can be purchased. This is a problem because a customer may want more than one type of shampoo or conditioner and so forth. Therefore a better method of showing which products are available to purchase is using a option button. This will enable the user to click on any of the products that they desire to purchase. This way even products of the same type can be purchased e.g. two different shampoos can be selected which couldn't be done with the combo boxes. On a whole the system is a success as it is dramatically more enhanced, professional and easier than the paper based system. Additionally most of my user requirements were met, those that weren't can be resolved in time where the whole system will work efficiently. ?? ?? ?? ?? Pawaneet Perhar Heston Community School-13130 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 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)

    cases in may not meet the demands of the proposed system, depending on what is required from it. Once the database is constructed and the system is completed, it must undergo rigorous testing. I will design attesting strategy and test the system according to that plan.

  2. Marked by a teacher

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

    An interview will benefit me greatly in identifying the client?s requirements in a number of ways; firstly it will allow me to get a form of direct feedback from my client. This will occur as the answers being given I can ensure that they are from the clients in question.

  1. Marked by a teacher

    Ecommerce Case Study

    Not only is the customer able to find the product faster but it makes it easier for cuckoo games to promote offer they have available and any special deals that are currently running helping to encourage multi buys and return customers.

  2. A2 ICT CouseWork

    The Third column will have the heading of "Description" where I shall describe what I did to accomplish this, and how the test was successful. The fourth column will have the heading of "Screenshot" which will include a screenshot of how I met this point, this will act as evidence.

  1. Implementing a new system for Mastercare.

    Mastercare will need to provide a printer for the system because it is not currency connected to a one and there isn't one available so one will need to be purchased in order to maximise efficiency and to be able to accord to the system objectives (creating and printing invoices and stock reports)

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

    For example in the job description it tells the potential employee that they have to treat customers (guests) in a ?friendly and efficient manner?. So this tells the employee that they will have to be friendly and treat their guests nicely.

  1. AO3 Investigate how search engines work

    For example searching " universities in England OR universities in the UK " indicates you don't really care if your don't get sites containing one keywords, just as long as you get the other. Meaning that if you got a website containing universities all over the U.K that will be great.

  2. Businesses now have to take certain precautions to ensure theirs and customer data is ...

    Most websites have the protection of a firewall which denies network transmissions to pass through from the public internet therefore not allowing unauthorised access to the data. Firewalls have different security levels for each operating system, and these are set according to system preferences.

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