• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  • Level: GCSE
  • Subject: ICT
  • Word count: 914

computerise a system for Super Sports

Extracts from this document...

Introduction

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. ...read more.

Middle

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: I used the date function on all my sheets to display the date I used the VlookUp function on my costs sheet to look up the costs shoes & sole increment I used the % Calculation to calculate the cost of the shoes with the quality sole I used a chart on my Order sheet to display the total number of orders. I failed to use the pivot tables. Super Sports User Manual 1) ...read more.

Conclusion

This screen just simplifies the cost of each trainer. Select the "Back to Welcome Page" to navigate back to the welcome page. By clicking on the following icon from the main screen will take you to the customer details form. when this page loads the following dialog box will appear as well. By clicking on new, you can add the details of a new customer. When you have completed all the fields you will need to click the close button to save the changes. Appraisal I think that my model will work fine and meet the majority of the requirements. I think that if I could re do my work I would spend more time using formulas and I would tidy up the interface as the one I have created is not very appealing. I didn't plan my assignment as well as I would have liked to do, for this reason I think I would next time use a gantt chart to set myself deadlines and to get the topic done a bit more effectively. ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. ICT PROJECT

    End With With Application .DisplayFormulaBar = True .DisplayStatusBar = True End With ActiveWindow.DisplayHeadings = True Application.CommandBars("Control Toolbox").Visible = True Application.CommandBars("Drawing").Visible = True Application.CommandBars("Formatting").Visible = True End Sub Student List I will used the same list box to generate report parent.

  2. System requirements analysis

    her to write and it was not as awkward as it would have been if she did not have the earphone as she would only have one hand free to type slowing her down. Also I asked her if she had received any kind of training to use the system

  1. a level ict project

    Plus, the system doesn't require any special training, since it's similar to the current system already in place; this meets the requirements of easy data entry as well as navigation, allowing the system to produce maximum productivity with virtually immediate affect.

  2. The new system is required to calculate the costs of a new car as ...

    research into the ideas and also it is possible that the Internet would be required for the transmission of information to customers of Auto Cruisers, or completed car specifications from customers could be received from the Internet (These options are available, but Mr Cruiser is not yet considering such a big move).

  1. drum kit costing system

    The users will have to state the quantity and also all the items they want, just like in the previous tables. The customer will be able to change anything easily and the total will always change and come up automatically when the order is completed.

  2. Excel user guide

    Then select Next. Second step - The second step will illustrate the chart source data within the bar chart. This will allow you to arrange or edit your data. This will also allow you to change the format in which you would like your data to be presented.

  1. Main aims and functions of Buckingham Bingo.

    supervisor has to then put a new order of stock in which has to be approved by the office. * At the end of each session the money is totalled up and is then handed in to the cash office.

  2. IT system for local video store.

    How many staff are employed? The store currently employs about 10 people with a manger working there full time. What are the current methods of data storage and recall? Member's details are held In a 2 boxes a black and a red box, if you wanted to retrieve the details you would have to take it out of the box.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work