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

    Perfective maintenance is performed when the users of the system, through repeated use, become aware of certain changes that would enhance the performance of the system on one or more variables such as speed, accuracy or consistency. Whilst a system does not require such modifications, and will run adequately without them, they do improve the system.

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

    This form of advertising will allow the user to expand the audience and improve business at EVDOP Live. They will use various forms of media to approach various members of the public to advertise key events. They will use podcasts to give key information regarding the dates time etc of events, likewise with radio adverts.

  2. A2 ICT CouseWork

    I test these different processes for any anomalies, as problems could occur such as loss of information or nothing being sent, this could be due to problems with my PHP code, meaning that our form's do nothing on the website and are pointless.

  1. Wjec alevel ict Creating a mailmerge

    using the mail merge toolbar Testing the Mail Merge document Before the database was fully constructed I first tested if the mail merged data was set up correctly and the right information had been brought across from the Access Database.

  2. The Impact of Mobile Phones on social Interaction

    has commented that there are nearly 400 million mobile phones in use globally with another 250,000 being added everyday. Similarly, a 1999 House of Commons science and technology report (2) predicted that by 2000, 50% of all calls would be made using mobile phones.

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

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

    One way to reduce this is to take a 10 minute rest in between working with technology like this. Also employers should provide screen filters to remove harmful rays emitted by a screen. Also employees should be provided with the latest equipment so that they don?t cause problems such as

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