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

computerise a system for Super Sports

Extracts from this document...


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.


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.


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. Model Price Chart.

    drinks predicted to be sold by the price to the school, and then therefore the total amount of money being spent on Sports Day. This gave me the total amount that needs to be raised to cover the cost. I accounted for all the types of weather.

  2. System requirements analysis

    use Microsoft Excel and it is quite self-explanatory and this means that the hospital does not need to spend money on training the staff and the receptionist to use this software. Also, another reason that I used Microsoft Excel is that most computers have this software and this means that

  1. 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.

  2. Create an IT system for my karate club.

    It is simply collected at the beginning and data is usually lost or damaged in some way. Also if they do pay for competitions or have to pay there is no bill produced and again it is all reliant on honesty, but not only the members being honest, if the

  1. GNVQ Sports Catalogue Group.

    The information that needs to be presented: - * Product identification number * Product name * Product description * Price * Quantity An invoice needs to be made so that the customer knows add the company knows that they have ordered.


    easy to use automated system to calculate her student's marks for her, which will enable her to solve her problem. Thee are the following things she expects to get from a computerised system. Input * She wants the new system to enable her to make management decisions that she uses

  1. Main aims and functions of Buckingham Bingo.

    Buffet * The main function of this department is to prepare and cook fresh food for customers to purchase. There are several sections to this department, the hot plate sells freshly cooked hot meals, the salad bar sells sandwich's, salad's etc, Snack bar sells small snacks like crisps, tea and coffee, cold drinks etc.

  2. Ict - Improvement Of The Sports Day Programme

    The Data Needed To Produce The Output The data needed to produce the output is specified in the booklet and is as follows. * The data for the school crest is on a Alison Goldsmiths computer so can be given through email or disk.

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