• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

GNVQ Sports Catalogue Group.

Extracts from this document...

Introduction

GNVQ Sports Catalogue Group The GNVQ Sports Catalogue Group is a reasonable sized business that sells a wide variety of mail order sporting goods. The GNVQ Sports Catalogue Group store their customers and product details on paper. The paper-based method is time consuming because on a spreadsheet the calculations are done for you automatically (when you have entered in the function) and all you have to do is print the final outcome of the data. When it is paper based you will have lots of papers and you have to do the calculations by hand. That is why I must design a spreadsheet that meets customer requirements. The GNVQ Sports Catalogue Group store their customers and product details in paper. The paper-based method is time consuming because on a spreadsheet the calculations are done for you automatically (when you have entered in the function) and all you have to do is print the final outcome of the data. When it is paper based you will have lots of papers and you have to do the calculations by hand. To meet the users needs the spreadsheet must be the following things: - * Make it easy to use. ...read more.

Middle

Searching a precise item on the spreadsheet is quick and easy than searching through lots of paper. Sorting the spreadsheet data into an order so that the user can understand in a way they can so that the user can understand it in some way they can. The aids that can be provided to help with the data processing are error messages. When you are validating data something may go wrong. An error message will appear telling you what's wrong and then you have to go and resolve it. After the data has been processed into the spreadsheet this data needs to be presented in a different way apart from the spreadsheet itself. The output information can be presented in either a bar chart or a pie chart. This is an easier of identifying on how much the company need to order on a certain product. * Macros will also be used within the spreadsheet. The macro will be used in the spreadsheet called in the customer table. When you want to add a new customer you click on the new customer button and a blank customer profile will appear. ...read more.

Conclusion

To add up the product price and delivery cost SUM can be used to create a total cost amount. There will be messages that will appear to tell the user what is needed to be done in each cell, which they click on. So if a customers ID number is required then it will pop up and tell the user that a they should input an ID number, and where there is a drop down menu it will tell the user to select the appropriate data from the drop down list. The formulae will calculate the totals for each data type once it has been entered. The following formats will be used: Alphanumeric - Customer name, address, postal code, e-mail address, product name, product description, Number - Product ID, customer ID Numeric - Quantity, phone number, date Currency - Product cost, delivery cost and total price Output The output information will need to include the following things: - * Customer Details (customer name, address, postal code, phone number, ID number and e-mail address) * Product details (product name, description, ID number, quantity and price) * Order details (Customer name, product name, product ID, date ordered, paid, quantity, product cost, delivery cost and total price) Komal Kumari Spreadsheet Specification Unit 3 - 1 - ...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. Producing documents for a company. Spreadsheet, Invoice and Website.

    The company would need to store the data online and update the data via the Internet. The data would be entered in a web-browser. This alternative is good and easy to update. Although this alternative doesn't cover all the user requirements, but most of them.

  2. System requirements analysis

    the patient's problems or their symptoms that they then send to the doctor to see so that the doctor is aware of this and they have an ides of the problem of the patient and this reduces the amount of time that the patient has to spend in the hospital

  1. Main aims and functions of Buckingham Bingo.

    It also sells bingo markers which you need in order to play your bingo. * Once this department has finished selling their bingo books etc. it works out how much money has been made and what prize money should be used for each page in the bingo book.

  2. Develop a spreadsheet application for the Ibis Hotel.

    Pallet is in charge of the hotel and he is the general manager. He looks after his fellow 3 managers and other staff. All the important information is recorded into separate files like staff salary, pay slip and so on; and stored into the storeroom.

  1. Model Price Chart.

    as it is intended for other uses, whereas Excel is specialised in this sort of work. I will be able to present the data given clearly in Excel, and I can make calculations using simple formula that I have learnt previously.

  2. ICT Job Applications - Enricé's Tapas Bar.

    equivalent Qualifications 2 Text N/A Graphics A A Level or equivalent Qualifications 3 Text N/A Information Technology A A Level or equivalent Qualifications 4 Text N/A Graphics A A Level or equivalent Qualifications 5 Text N/A Information Technology A A Level or equivalent Qualifications 6 Text N/A PE C Degree

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

  2. Mr Ariel Sharon is the owner of a small, but very busy, independent sports' ...

    * A database package could be used. The quantity could be stored but databases are not well suited to applications that require a lot of calculations. * A spreadsheet could be used. Separate worksheets can be used for the user to enter the selected shoe's name, and to store the very up-to-date numbers of shoes remaining and their latest prices.

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