ICT CMS

. 

Software Details:

Hardware details:

Data sources:

Data collection:

I am planning to collect all the Data needed for the sales system that will satisfy my End-user through ways such as the internet, I will use the internet to figure out people's views and ideas of cilantro and its products, I will also use it to obtain information needed from My END-USER via email. I will collect all the information needed for the sales system using a data capture form created by my End-User which will contain information such as the names and prices of products and details about A.G café's stocks

Data input:

The sales system I am creating contains dropdown validation lists which I have created so that I can reduce the risk of error. All the data in the sales system I have inputted manually to avoid many mistakes. I then used the spelling check to input my data. All the data that was inputted in the sales system I have received from my end-user through a data capture form as my end-user is a reliable account and the data was validated using the spelling and grammar check. The main devices used when inputting the data was the keyboard to type in the data and the mouse to help choose items from the dropdown validation lists.

Data processing:

Data flow:

        

        

Data output:

The sales system I am producing has very simple procedures such as browsing through the dropdown validation lists and choosing the items required then clicking on the print receipt macro button in order to satisfy the customer and provide them with a proper invoice at the greatest speed. The receipt will be the only item which I will output as a hardcopy using a printer. The receipt is mainly printed to keep financial records, to keep the customers aware of the money they are consuming and the café aware of the profit they are gaining. All the other features of my sales system will be outputted visually such as the dropdown validation lists, charts showing weekly profit and other data concerning stock.

Test plans:

Macro test#1:

        

V-lookup test#2:

        

Dropdown validation list test#3:

Chart test#4:

Formula test#5:

        

Effectiveness:

I have a few objectives which I aimed for concerning the A.G café sales system; my objectives are:

• Entering text and numeric data,
• Creating dropdown validation lists
• Creating charts
• Using complex formulae
• Using macros
• Using Validation

The problem with A.G cafes old sales system is that it was a manual system, due to this issue customers were complaining and not satisfied and employees were having hard time:

• Slow service
• Mathematical and spelling errors on receipt
• Shortage in many products due to manual organisation of stock
• Employees not able to calculate profit

My sales system product was very effective it managed to solve all my End-users problems, I managed to solve the issue of speed of service using dropdown validation lists in order to simplify and speed up the process of choosing products and I used macros to speed up the process of printing. The issue of Mathematical errors was solved using simple functions such as sum; the same method was used to help calculate profit.

I inserted conditional formatting in order to identify the user if there is a shortage in stock in a certain product so stock organisation became much simpler. I used the help of validation tom make sure that there are no spelling errors on the receipt in order to raise A.G cafes image. I included complex formulae such as V-lookup to link and identify information from other tables to the receipt. In conclusion I successfully and effectively managed to obtain my objectives to satisfy my End-users needs and have managed to insert all my End-users ideas which I have received in my memos.

Improvements

Although I have a created a sales system of many fine features, I believe that I could have added some extra features or altered the design slightly to give the overall sales system a more a more professional and sophisticated display such as:

• Generate graphs to show increase/decrease in profit
• Use more complex formulae
• Include my end-user more through the process

Use of tools

V-lookups

I used v-lookups to link the combo boxes and data with the receipt:

 

Macros

I used Macros to speed up the process of printing and to link to other data:

Dropdown validation lists

I used dropdown validation lists to display the A.G café products and to reduce the risk of any typing errors and to increase the process of choosing the products needed:

Charts

I used charts to display the weekly profit gained from a certain area of sale: