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

    A company which does its business mainly using ICT or even traditional mail services can locate almost anywhere. Call centres are used by business organisation such as banks, insurance companies and also retailers such as Tesco to process enquiries and transactions.

  2. The Entourage System: A Feasibility Study

    for the casting director in selecting actors for roles.\ * Randomized display allows the casting director to be able to see different actors' faces for every search allowing him to widen his selection scope. Saving searches * Beneficial for casting director when a wide range of result is generated from

  1. The purpose of this document is to define the Context of Cain Motors Information ...

    Change Costs: The change in the costs will be noticeable, by the fact that the larger (higher-risk) areas of development would be completed first, which means that any failure or delays in the construction of the product would be offset by the later stages.

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

    Applied electrostatically or by fluidised bed, these plastic coatings come in an almost unlimited range of colours. As there are no volatile thinners used, all of the oversprayed materials are recovered and reused. The coatings are applied dry, melted, flowed and fused, making a pinhole free finish for beauty, long wear and superb corrosion resistance.

  1. Converting a Formerly Paper Based System to Excel

    This could be strengthened by efficient stocktaking. * Wages Employees are currently being paid 'cash in hand' at the end of each fortnight, therefore there is no proper record of hours worked, and they may be over or under paid.

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

    Picard 1989), the case of women who are marginalized from the new development efforts they resisted and derailed the development initiatives (Mather 1997). There are several cases like that, where the agency intervention has failed due to the inability of aid workers to predict the political implications of their intervention in rural areas of the Third World.

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

    of the employees may be careless which can result in theft of customer information which means this information can be used illegally for other companies. The current system we have adopted is slow, insecure and difficult to use in various situations.

  2. Fusions Acquisitions: Compaq - HP Merger.

    tolerance *# 1 in high performance technical computing *# 1 in storage 2. Grow and achieve critical mass in services *Benchmark profitability in customer services *Grow Compaq financial services *Expand managed services *Sharper focus in systems integration 3. Improve PC economics and increase supply chain velocity *Return to profitability *3-5%

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