• 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
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  56. 56
  57. 57
  58. 58
  59. 59
  60. 60
  61. 61
  62. 62
  63. 63
  64. 64
  65. 65
  66. 66
  67. 67
  68. 68
  69. 69
  70. 70
  71. 71
  72. 72
  73. 73

ict as level coursework

Extracts from this document...


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.


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.


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)

    If the user speaks into the microphone, the software may convert it to a different, similar sounding word. This would be problematic for the system in the amount of time and money wasted from corrections and incorrect information. Thus, we would say that it is not technically feasible.

  2. Marked by a teacher

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

    The computer based system would perform automatic calculations which would improve company efficiency as it would reduce the time needed to calculate costs previous to this system. Aside from finance as well, there are problems located within the administration of the company.

  1. The Impact of Mobile Phones on social Interaction

    Similarly due to this cost issue, SMS has become such a common method of communication amongst peer groups that it has now become a "mindset" or "norm" amongst this community and age group and is no longer something that users even think about when using.

  2. ICT 3b evaluation

    When his costumer wants to go to a certain location and the driver does not know it helps him find out. Navigators also help the Driver miss traffic or get the shortest route to the location or the longest route.

  1. Using ICT to communicate

    they will need to phone the school to arrange an appointment once they have received their GCSE results, and of when school will start and what the students will be doing. 5.2 Audience The audience of this letter are students that have just finished their GCSE's and want to continue to do A levels at St John's School.

  2. ICT AS-Level Coursework

    2. The system is very unreliable in that it sometimes doesn't work so they have to have professionals to come and sort out the system. 3. The system is very limited to responses, it can only handle data recollection, taking off stock when it has been sold and giving a final total at the end of the day.

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

  2. Applied ICT in business scenario answers

    It can be initially expensive this option. If not, they can advertise its products on other websites, what is cheaper. They can use pop-ups that are windows that appear on users windows and grab their attention. The problem with this is that users get upset quickly. Another way of advertisement can be by emails to customers.

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