• 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

An I.T. System for a Games Retailer

Extracts from this document...


Problem Identification A friend (Mr. Bat) owns and manages a games retailers company in East London called 'GAMEZ'. He requires an I.T system to ensure faster service for his customers and a more reliable ordering system. The problems are the current system is that because it is paper based things get lost and invoices are hard to create and find. Member information is not safe, anyone could access as the information is stored in a binder on the counter. Background to the problem The manager needs to be able to view member information, view all products in stock and add or remove products form the list. He also needs to create invoices quickly and efficiently. As the company is relatively new there are only 10 members, the member information needs to be displayed showing date of birth, address, name, telephone number, post code etc. The manager has the basic knowledge needed to run an I.T system, knowing how to use V Look Up functions, knowing the basic principles on how to work a spreadsheet. The gain will be that the manager will spend less time looking for member information, creating invoices and looking for products. The time wasted now could be used to make another sale or serve another customer. The end user(s) will be the manager and maybe anyone who he has employed, most likely they will all carry out the same actions needed to be done. ...read more.


to find a product number, then the actual product has to be found in the list which is not in any order. Creating a New Invoice- * New invoice slip is taken out * Order information is manually entered on the invoice slip * The invoice slip is then stored underneath the till in a box * Box has searched in order to find an old invoice Aims and Objectives 1. To make an overall better system to work with, making adding new member information, product information, and creating invoices a simple a fast procedure. 2. To make an attractive interface, which is easy to operate. Each process should be fast and efficient. 3. To allow the user to access or view member information, product information, or an invoice by simple using macros. 4. To allow new products/members to be added/deleted by using a macro. This would cut down on errors, and enable the new products/members to be inserted in the table in alphabetical or numerical order. Also when an old product/member is removed it would be possible for a macro to shift the cells up to fill the gap. At the moment when a new product/member is added it/one is put at the bottom of the list (not in any order) 5. To have macros to clear an invoice, update an invoice table, display member information, also to have an exit macro which saves the spreadsheet. ...read more.


3) Buttons N/A There will be buttons where you single click to get to a certain page 4) Macros N/A The use of macros will be used in order to make the buttons possible. Rough Sketches Main MenuMembers Products Invoice Row/Column Heading Description & format of Data Comment Example Unit Price Price of a single Item This is used so that if the exchange rate changes so does the price for that item. =D7*$E$4 Total Price of Invoice Calculates the cost of the full order. Formula: (sum of cost all items ordered) =SUM(F12:F25) Platform What platform the product is on Formula =IF(B12<>"", VLOOKUP(B12, Products,2,FALSE),"") Game What Game it is Formula =IF(B12<>"", VLOOKUP(B12, Products,3,FALSE),"") Total Price Total price of one product Formula =IF(A12>0,(A12*E12),"") Macro Designs Macro Name: Add Product/Add Member File Name: MENUSYSTEM.XLS Description: Creates a new row for a new product, the information has to entered manually using a keyboard. This macro also copies all needed formula's so that there Is no need to create new formula's. Design: The user must click on the button that says ADD PRODUCT/MEMBER and then when the new row is inserted the new information should be added accordingly. Operation: The macro should be started by clicking on the ADD PRODUCT/MEMBER button on the spreadsheet Final Choice of design Main Menu I think this best suits the company because it is stylish, modern and attractive. It is simple, it shows everything clearly. The rest of the spreadsheet shall carry the same theme throughout. MAIN MENU MEMBERS PRODUCTS INVOICE ?? ?? ?? ?? Ryan Sutherland 7132 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 ICT in Business 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 ICT in Business essays

  1. Business Aims and Objectives.

    Cash and carry Cash and carry wholesalers seemed to be a growth area for the sale of goods. These large warehouse organisations still exist and help to supply small retailers, but the growth in size of most types of retail business has limited their progress.

  2. The process of electroplating and how it is used to protect products.

    What this means is that if there is a number of raw components that is being electroplating the amount raw materials needed to coat it will be depending on the size, shape of the raw component. Its also explains again how the process works of electroplating works.

  1. The Use of Geographical Information Systems (GIS) And International Technology Transfer by Non-Governmental ...

    (1987) in Heslop,L. A. McGregor and Griffith M (2001) A checklist of "Must meet" criteria to enable in assessing whether or not to process with new products development projects Management capabilities are available Cooper (1993) in Heslop,L. A. McGregor and Griffith M (2001) Commercial readiness of technologies fall under two required measures of success: technical strength and market strength.

  2. Investigating the current system at a new car company.

    We need a system which everyone will find easy to use and to find information about cars, clients as quickly as possible. 7.Q: Do you feel the information is secure enough? 7.A: The information is not secure as all employees have access and some careless mistakes are made when information goes missing.

  1. Ao1 : aims and objectives

    These varieties of customers can be organised as privately and commercially. For example, the bank and the suppliers are private customers however the actual consumers of Tesco's products and services are commercial customers. * By operation or process. Tesco uses many different operations of production of their products and services.

  2. This case study is based on HMV which is one of the largest retailers ...

    are two methods which are usually taken up These are: field research which is data directly collected from the market is used, this is also known as primary data Hmv uses its sales figures of a particular product to carry out its field research; this is also done by carrying

  1. The Entourage System: A Feasibility Study

    In order to get the most out of the interfaces, there are certain guidelines we will follow in the design. * Pages should allow excellent picture quality to be displayed whilst paying attention to maintain fast response rates in uploading and downloading.

  2. Blue Water Estate Agent (BWEA) - design a computer based system

    It can be accessed from any working computer with the Internet. This way, people will find out about all houses and prices. It will be easy and efficient. Collect information from Potential Users They are going to collect information by using a questionnaire.

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