Introduction :: Computer Science

Introduction============I sacrifice been asked to create a solution to computerise a carcass forSuper Sports who sell sports apparels. The system that I get out create willfollow the specification given to me. I will include some hatful drawnsketches of the mannequins I will create.I hope for the system to be user friendly and easy to navigatethroughout. The new system will have to stock data, calculate totals andquantities. I will possess use of command buttons and macros within excelto navigate and to record data. I will also 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 get to ofa user guide, this guid e will aim to train the staff in using thesoftware.Description of Development.I started off with a black spreadsheet form Microsoft Excel. I changedthe rearwardsground 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 situation This shoe s 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