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

    * Can sort and search data * Large range of formulas for performing complex calculations * Can produce graphs * Good for large computations * Offers good automation features * Supports User Interface/Menu * Relatively easy to develop and maintain * Complex searches limited and must be physically created each

  2. System requirements analysis

    The e-mail system is Microsoft Outlook and it is very easy to use. In my interview with the receptionist I asked her if she found it easy to use the system and she replied that she had found it quite difficult to use in the beginning but as she progressed

  1. Main aims and functions of Buckingham Bingo.

    They then pass this money on to the cash office and then deal with any problems that the office has with the money. * They then make the prize money, envelopes are filled with the correct amount of money and it is then double checked before it is passed on to the customer.

  2. Develop a spreadsheet application for the Ibis Hotel.

    Many thanks. Yours sincerely, Mr Singh Manager. The current system At present the hotel is using file-based system. There is 20 staff in the hotel and some of them are part time and the rest are full time. Each day is divided into 3 shifts - day, evening and night.

  1. Model Price Chart.

    �0.25 There are once again, two different programmes that I would be able to use for this task. They are Microsoft Excel and Microsoft Access. I have chosen Microsoft Excel, however, as my previous work with both of these programmes has shown me that Access could over complicate this task

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

    Date of Application Date/Time DD/MM/YYYY, from today. 28/11/2002 Interview Boolean Yes/No Yes Date of Interview Date/Time DD/MM/YYYY, from today. 28/11/2002 Offer Job Boolean Yes/No Yes Start Date Date/Time DD/MM/YYYY, from today. 28/11/2002 Start Time Date/Time DD/MM/YYYY, from today. 28/11/2002 Working Hours per Week Date/Time N/A 20 hours Hourly Wage Currency �NNN.NN form.

  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