• 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


    3. The system will generate automated reports of each student by click of a button showing their performance that can be sent to parent. 4. It will be easy and clear to use. 5. The new system will produce an average performance percentage for each student.

  2. System requirements analysis

    the data gets destroyed or lost by the system then the second computer can be used. The doctors, nurses and the receptionists of the hospital can only view the system. Each one of these members has their own account login and password and they can only view the files that are relevant to them.

  1. a level ict project

    However, there're noticeable disadvantages, it doesn't meet Victor's primary objective being computer based, which hinders his plans for advancing with technology through his business, therefore it is still liable to the faults of the current system. In addition, there's no verification or validation, there's no method to ensure data is

  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

    They will be able to choose from a selection of drum kits, cymbals, snare drums, accessories and much more. Processing Required The system will have to be able to achieve: * Calculate the total price for the accessories and drum kits.

  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.

    * If a customer has a problem an item of food etc. a member has to deal with it until the customer is satisfied. Bar * The main function of this department is to supply the customers with alcohol, snacks and cold drinks.

  2. IT system for local video store.

    What is the process for a member taking out a video? When a member joins they are given a membership card with their surname on, the customers detail are held then on small sized cards, and put into a little black box, when a video is taken out, the staff

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