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

    Even when a system is up-and-running and fully operational, unforeseen circumstances can cause problems to arise. I will therefore need to be capable of addressing any problems that may arise in the system, as well as being able to make modifications should circumstances change.

  2. Marked by a teacher

    Ecommerce Case Study

    Although this is a general problem for e-commerce this will not be applicable to cuckoo games as they have no intention of defrauding their customers. However it may be important to consider support in order to reassure their customers encase of delay in delivery such as postage strikes or problems.

  1. Marked by a teacher

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

    With the various online features that EVDOP live will offer in terms of advertising the user of the system will be utilising various forms of media to help advertising. The user will take an active role in using online blogs, radio adverts and even podcasts.

  2. A2 ICT CouseWork

    website; is my contact us form, in this process something is sent and formatted by the customer . The reason why process testing could be seen as one of the most important testing section's is due to the fact, that these processes give our website the interactivity; so our customers

  1. The Impact of Mobile Phones on social Interaction

    Although these figures clearly reflect the popularity and growth of mobile phones in society, nevertheless it is important to understand how society has perceived mobile phones and the impact that they have had on their social interaction. The questionnaire research carried out in Northampton showed that 92% of people interviewed

  2. Employee attributes and their value

    Personal Determination This attribute is particularly valuable to employers whereby the employee will stop at nothing to get a job done or find a solution. For example, the 3 sales persons who work for IT services will have to persist with customers and capture a deal.

  1. Free essay

    The following report will outline how a business communicates effectively and efficiently within their ...

    You can insert audio/video directly onto a presentation slide. This makes your presentation seamless as you no longer have to bring along a VHS player with you. PowerPoint's are good ways to effectively get across short bullet points of information.

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

    For example if a computer keeps on freezing and doesn?t respond then an employee may get angry or stressed due to this. This can be reduce by the employee calling for IT support or the employer providing the correct equipment for the employee so that they don?t get into trouble with the equipment.

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