• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 7132

Mr Ariel Sharon is the owner of a small, but very busy, independent sports' shoes store named "ShoeShop". It is located in the centre of Londonand new and old customers are constantly popping in with questions.

Extracts from this document...


IDENTIFY Statement of the problem Mr Ariel Sharon is the owner of a small, but very busy, independent sports' shoes store named "ShoeShop(c)". It is located in the centre of London and new and old customers are constantly popping in with questions. The most common question is "Is this shoe available in [this] size?" The sales assistants employed at the shop cannot always answer this sort of question very easily because it is very time-consuming and sometimes difficult for the assistant to quickly go and check in the storage room at the back of the shop for the shoe's availability. Currently, a shop assistant has to go to the storage room, then to the particular brand's (e.g. adidas(r)) section, and then start looking for the customer's preferred shoe model and check if the appropriate size is available. It would be even more time-consuming if Mr Ariel Sharon wanted to find out the exact number of shoes remaining for a certain model or size as the shoes would have to manually be counted by the assistant. This is unreliable as the assistant may not search adequately, and may convey the message that the shoe is not available when in fact it is. The customer would also want to know the latest price of the shoe, and the labels which have the price printed on them may have outdated prices which would most likely alter the customer's choice. What Mr Ariel Sharon really needs is a system that will let the customer or sales assistant input the shoe model and then display the shoe's availability in each size and the latest price in "�'s". Having a system such as this will allow Mr Ariel Sharon and the rest of the assistants more time to talk to other customers and increase the quality of service provided by ShoeShop(c). It would also allow Mr Ariel Sharon to keep an eye on the stock and to ensure it is sufficient. ...read more.


Task 5: Password protect stock file The spreadsheet file, "STOCK-ShoeShop(c)", will be protected with a password. This means that no body can open the stock list file without the password which has been chosen by Mr Ariel Sharon. When it has been opened by inputting the password, the cells can be modified or deleted as the cells have not been protected; Mr Ariel Sharon is aware of this and says that one password is enough for the file. Task 6-7: Create search file, "- Home -" sheet, insert heading and logo images (Design Sheet 2) After creating the stock file and saving it, I will have to create the other spreadsheet file and name it "SEARCH-ShoeShop(c)". I will also rename "sheet1" in the new file as "- Home -" which will be the starting sheet for the system's users. Once this is done I will insert the large heading of "ShoeShop(c)", and will also obtain the logos from the relevant sports brand's web pages on the internet and insert them into the sheet along with the brief word art message. Task 8: Enter formulae next to each logo The formulae entered will simply equal the "STOCK REMAINING" in the stock file: Next to the adidas logo - ='[STOCK-ShoeShop(c).xls]adidas(r)'!$E$3 Next to the FiLA logo - ='[STOCK-ShoeShop(c).xls]FiLA(r)'!$E$3 Next to the N I K E logo - ='[STOCK-ShoeShop(c).xls]N I K E(r)'!$E$3 Next to the PUMA logo - ='[STOCK-ShoeShop(c).xls]PUMA(r)'!$E$3 Next to the Reebok logo - ='[STOCK-ShoeShop(c).xls]Reebok(r)'!$E$3 Next to the UMBRO logo - ='[STOCK-ShoeShop(c).xls]UMBRO(r)'!$E$3 "E3" being the cell reference to the "STOCK REMAINING". Similar formulaes will be put next to the other logos, but with different sheet references. Task 9-10: Create Search sheets and enter formulae, smarten up sheets, assign logos macros (Design Sheet 3) After finishing off the home sheet, I will make six additional sheets with the following names: "SEARCH-adidas(r)" "SEARCH-FiLA(r)" "SEARCH-N I K E(r)" "SEARCH-PUMA(r)" "SEARCH-Reebok(r)" ...read more.


It searches for the shoe and clearly displays the quantity remaining in all sizes and the latest price of the shoe in less than one second. It also gives the total quantity remaining for all the sizes added up. If there are no shoes remaining then the system automatically displays an apology sentence and therefore giving a clear answer to the user's enquiry. The system handles all valid quantity values entered and rejects invalid user entries. Also, the system did not involve any additional hardware or software costs. User feedback on solution Mr Ariel Sharon was very pleased with the spreadsheet; however he foresaw some problems in using it as the exact spelling of the preferred shoe's model name has to be entered by the user and some customers may not be aware of the correct spelling or may not be too familiar with key boards and so there is a strong possibility that they input the correct shoe name but with a different spelling and the system would show N/A (not available). He agreed that it would have been extremely complicated to include a search feature which brings a result, even if it is not exact, based on the information input, it would also be time-consuming to keep up to date. Further suggestions for improvements The system would be even more useful if it included an easy facility to add new shoes and update formulae. It would have also been useful if the system would also lookup and display the shoe's picture and more details concerning the shoe. When the user presses the 'Restart' button the screen flicks briefly and the cell selection is changed before selecting the input cell. I think this is a slight problem from the macro I recorded but it would be possible to write a macro preventing this so that all unnecessary movements of the screen or selections are invisible. 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 GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    * Results; I completed this test; it was also successful, proving my system is user friendly. Simple Documentation For this task, I will only complete a simple user documentation. As this Web page is very simple, and does not have any complex features or relations, it is very simple to

  2. Video Rental Shop I.T. System

    Application software is programs that are designed to do a task on the computer e.g. databases, word processors spreadsheets etc. A database can be used to store, sort, and search and retrieve information. You can also make database forms, database reports and Macros with your information.

  1. Creating a computer system for a video rental shop

    Reports are produced for all reserved and overdue videos. Member details information The purpose of the system * Information about Members, videos, borrowing, borrowing line and reservation information will be stored in five separate files. * Allows entry of information via data entry screens about members, videos and borrowing or reserving * Allows the updating and the deletion of

  2. I am going to explain how ICT helps the functional areas of Nab Wood ...

    Fax machines are used by almost all the functional departments in order to send fax to each other. For example if HR department asks the manager to send the details of a customer. He will ask the receptionist to fax HR department the details.

  1. task2-report-template 3

    3 DESIGN [TOTAL: 12 MARKS] 3.1 Produce Designs for the Data Structure [3 marks] 3.1.1 Data Structure [1] Field Name Field Type Field Length Model Text String Brand Text String Processor Type Text String Memory Size Number Integer Hard Drive Capacity Number Integer New or old Text 3 Price Currency

  2. OCR Nationals Unit 21 - Task 8

    and I have saved it, I will now import it into Flash to add it onto the advertsing banner with the Space Background that I had just made. I imported the shuttle into the Library by clicking on file and then Import, and then Import to Library just like I did previously with the space picture.

  1. System requirements analysis

    The receptionist may also want to send out information letters to the health centres patients and/or the staff, he/she will then print out these letters by the use of a printer. The doctor will need to use a specialised printer to print out prescriptions for patients.

  2. Financial Model to help organise the year eleven prom

    3-�175 Firm 3-�200 Firm 3-�300 Firm 4-�150 Firm 4-�175 This would end up in a complete mess, because you would have to add up a catering firm with a decoration firm, then add it to music and then finally to the venue. Changing one firm of a cost each time.

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