• 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)

    voice recognition for this project, requiring the user to input data via speaking into a microphone; it would be feasible. This is because voice recognition software is not currently at an advanced enough level to ensure 100% accuracy in the conversion of voice to data.

  2. Marked by a teacher

    Ecommerce Case Study

    It will be essential for cuckoo games to keep the information their customer trust them with safe, not only to help the customer returning but also to help build a better reputation for the company. Cuckoo games will need to be aware of potential DOS attacks that will aim to

  1. Marked by a teacher

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

    The head of finance will be able to alter the data within this spreadsheet as the business is not persistent and each event will bring a different outcome so he will be able to input new data and alter the spreadsheet to allow specific information to be included.

  2. The Impact of Mobile Phones on social Interaction

    Another finding that was also made was that users felt that the only time that they chose to use voice communication with peers was in the case of urgency. Another major finding of the focus group was that many young people felt that SMS allowed them to feel more comfortable

  1. A2 ICT CouseWork

    then we would take a screenshot of doing so and explain how this is good. It is important we test our HTML and PHP code for any errors, as our website could be appear to be fine on some browsers; as these browser's may ignore the problem but other browser's

  2. Wjec alevel ict Creating a mailmerge

    Total Amount Payable after Discount Calculation The Total Amount Payable field is a simple calculation to add up the Total Discount field and the Amount after VAT field. To do the calculation I inserted a field and placed the formula {=sum(b17,b18)}.

  1. From the e-commerce strategy you gave me earlier I understand that by having a ...

    The Sale of Goods Act The Sale of Goods Act of 1979 says all products sold within the United Kingdom must be as described, must be of satisfactory quality and fit for the purpose it was designed for. Any goods must be the same you see them in the store or match the description in the catalogue or brochure.

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

    ________________ Computer Misuse Act 1990- In Detail Computer misuses are criminal offences which are committed using a computer. The computer misuse act 1990 was designed to protect the integrity of computer systems by stopping hackers. They could use, steal and damage information.

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