Introduction :: Computer Science

Introduction ============ I have been asked to create a solution to computerise a system for Super Sports who sell sports shoes. The system that I will create will follow the specification given to me. I will include some hand drawn sketches of the forms I will create. I hope for the system to be user friendly and easy to navigate throughout. The new system will have to store data, calculate totals and quantities. I will make use of command buttons and macros within excel to navigate and to record data. I will also make se of the following advanced functions. Macro’s Linked to Command Buttons On-Screen Help Filtering Data Use of the IF Function Pivot Tables The VlookUp Function I also need to make a web page that has pictures of all the available shoes with details and descriptions of all for sale. Also on the page I will give all these details plus the company’s contact details. I will include relevant documentation for this solution in the form of a user guide, this guide will aim to train the staff in using the software. Description of Development. I started off with a black spreadsheet form Microsoft Excel. I changed the background colour of the whole sheet. I added a selection of command buttons to the form to navigate through the system; I also added a title to the page. I then renamed the sheet to â€Å"Welcome Page† I than added some more sheets as I thought I would need them as I progressed through the application. I then moved onto the second sheet, which I called â€Å"Cost† On this form I used the â€Å"VlookUp function to link the shoe type with price, this will make sure tat the quality, shoe and price are all correct. I also used some validation on this form, in the type of list validation, this allows the user to select data from this list box only. I added a Command button to this page to navigate back to the welcome screen. I then created a total sheet, all this sheet does is hold the total amount of shoes sold. I then created the sheet called â€Å"Shoes† This shoes hold the prices per pair of shoes and the increment for the quality sole. The next sheet I made was the Orders Sheet, this sheet holds all the details of orders placed. It also has a graph which I have made to display the amount of orders placed. The final sheet is called customer Details, I have set this sheet up to store the details of all customers that place orders through super sports. Throughout this project I have used the following advanced features: