Introduction :: Computer Science

Introduction============I postulate been asked to create a solution to computerise a dodge forSuper Sports who sell sports brake shoes. The system that I forget create willfollow the specification given to me. I will include some return drawnsketches of the micturates I will create.I hope for the system to be user friendly and easy to navigatethroughout. The new system will have to investment company data, calculate totals andquantities. I will guess use of command buttons and macros within excelto navigate and to record data. I will to a fault make se of the followingadvanced functions.Macros Linked to Command ButtonsOn-Screen HelpFiltering DataUse of the IF FunctionPivot TablesThe VlookUp FunctionI also need to make a web page that has pictures of all the availableshoes with details and descriptions of all for sale. Also on the pageI will give all these details plus the companys contact details.I will include relevant documentation for this solution in the form ofa user gui de, this guide will aim to train the staff in using thesoftware.Description of Development.I started off with a black spreadsheet form Microsoft Excel. I changedthe standground colour of the whole sheet. I added a selection ofcommand buttons to the form to navigate through the system I alsoadded a title to the page. I then renamed the sheet to Welcome PageI than added some more sheets as I thought I would need them as Iprogressed through the application.I then moved onto the second sheet, which I called Cost On this formI used the VlookUp function to link the shoe type with price, thiswill make sure tat the quality, shoe and price are all correct. I alsoused 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 aCommand button to this page to navigate back to the welcome screen.I then created a total sheet, all this sheet does is hold the totalamount of shoes sold.I then created the sheet called habilitate This shoes hold the prices perpair of shoes and the increment for the quality sole.The next sheet I made was the Orders Sheet, this sheet holds all thedetails of orders placed. It also has a graph which I have made todisplay the amount of orders placed.The final sheet is called customer Details, I have set this sheet upto store the details of all customers that place orders through supersports.Throughout this project I have used the following advanced features