An I.T. System for a Games Retailer

Ryan Sutherland 7132

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. The general I.T knowledge of the end users vary, as a result I am going to make a very simple system and make all the facilities, macros, dropdown boxes for example as easy to use as possible using names on the toolbar and buttons.

Solution to Problem

To solve the above problems I am going to create a menu system which will contain several macros to format all of the information for the company ‘GAMEZ’. There will be buttons for adding/deleting product information and amending member information. There will be a button to clear an invoice. There will a button to exit the menu and save it.

End User Requirements

User Skills

The end user is familiar with Microsoft Excel and has knowledge of macros and knows how to use a keyboard. The end user is not able to create spreadsheet which can show product information and member information.

User Requirements

The end user will have to know how to navigate Microsoft Excel. A handout explaining how to create macros (if needed) will be created along with the menu system. The user has to know the basic settings of the macro system for example the set up of buttons on the main menu etc. The user will have to study the handout correctly in order to use the menu system correctly.

Overall system structure

Mr. Bat requires an Excel based I.T system that will allow him to input product/member numbers and view the data ...