Interview with my end user
To find out more about the system I will be making I have interviewed the end user of the system to see what system the are currently using. Extracts from the interview can be see bellow;
What system do you currently use for your company?
“I currently use a simple system using paper for storing details, orders and bills & receipts.”
What problems do you have with the current system?
“The current system is extremely hard and time consuming to update. Also, it is hard to keep an accurate check on stock levels and the actual system is very large to store as it is all on paper and I have no back-up of the system if it were to be destroyed. EG. By fire.”
Why do you want a new system?
“I need a new system because the amount of space the current paper system is taking up is growing as the company grows. A computerised system would only take up a set amount of space and would not need any extra space than the original size. Also, having a computerised system would be easier to use as updating information on goods, stock levels and customers would be as easy as the click of a button.”
Do you have any computer knowledge, or any other employees who would use the system?
“Yes, I have a good understanding of ICT and computers as I did an A-level course on ICT. However, my 2 employees have little or no experience with computers or ICT and would possibly need training to use the system. So I would need the system to be as simple as possible!”
Spreadsheet Design
Below is a list of the spreadsheets that I intend on using along with a brief description of what they will contain and the function it will have within the system itself.
Order Form
The order form will be used by the company to process the orders which the customer can place. It will have spaces for name & address, Product name & number, cost, quantity & total. As these cells are filled in the sub-total cell will calculate the sub-total of the order without the postage & packaging added on. The total cell will then work out the total cost of the order, including costs for postage & packaging.
Previous Orders
This sheet will save all the orders from customers which have been processed using the ‘Order Form’ ad save them in a separate sheet incase any orders should be queried.
Countries
This sheet contains a list of all the countries to which the ‘Post-it’ people will deliver.
Catalogue
The catalogue sheet will have a list of products which the customer can order, along with the price of the product including size’s large & small.
Postage & Packaging
This sheet will contain all the details for the countries to which the company will deliver including the currency, postage & packaging costs and the symbol for the country (EG. United Kingdom = UK)
Contents of the individual sheet
Each sheet within my design will contain different types of cells with different functions. Using tables I shall show what each cell will do, along with a brief description.
Order form
Previous Orders
When the ‘Process Invoice’ button is pressed on the ‘Order Form’ sheet then the following items will be transferred to the ‘Previous Orders’ sheet so that the company can keep a track of who has ordered what from their company.
Countries
Catalogue