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

Make a system, which can print of invoices for customers who place an order via the telephone, which will show details of price, vat, delivery charge and other calculations.

Extracts from this document...


Problem My friend owns a bookshop in his local town called "The Book Warehouse". They buy books in bulk straight from the publishers for cheap prices and then sell them off separately for retail prices. That's how they make their money. The company is divided into two parts. One part deals with everyday High street customers and the other part is phone based. My friend takes care of the phone based part on his own. Customers from all over the country phone the shop and order their books. My friend writes down the name of the book that the caller wants and their phone number. The reason he takes their phone number is because he has to find out how much the books costs and then has to calculate the V.A.T, delivery charge and maybe a discount if a large quantity of books are ordered. This takes too long and so my friend just decides to call the caller back instead of the caller staying online. When my friend has called the caller and they have decided to order the books, my friend then has to fill out an invoice with all the calculations twice. ...read more.


Here are a list of possible spreadsheet packages: Spreadsheet QC �149.00 Microsoft Excel 2002 �281.86 Lotus 1-2-3 Millennium Edition �270.74 Crystal Deluxe �339.99 Quattro Pro �139.99 I am going to use Microsoft Excel as it has a variety of tools on offer, which I think will be well suited to my system. I have also chosen this package as it is cheaper than most of the other packages, as my friend is on a low budget. My friend is already familiar with some Microsoft packages as he did a management course using Microsoft Word. For this reason I am going to use Microsoft Excel for the system. As he knows the basic layout of Microsoft Office already, then I see no point on making him learn something completely different. Tools His new computer came with a laser desk printer, so he can use this for fast, good quality printouts. This will make the company look professional. Tools im going to use in Excel: Vlookup: This function helps you locate data in a list. It searches vertically down the leftmost column of a list and then reads across the row to find the data or value in the column you specify. ...read more.


System Objectives * The system should be user friendly. I am going to do this by making a homepage, which would have macros on it. These macros would be able to take the user from sheet to sheet without getting lost or stuck. The other sheets will have macros on it to take the user back to the homepage or to other sheets. There will be macros in the invoice sheet. These macros will help the user in various situations. I.E. suppose the user has done one invoice and then needs to do another one, instead of the user having to clear all the data from the past order manually, the user can just click the macro and it will clear everything for him. Another macro allows him to print the invoice just by clicking it. * Minimal amount of effort required by the system. The user should just type a few numbers in the Vlookup and all the information should come up. The computer should then calculate the total price, V.A.T, delivery charge and various other calculations automatically, leaving the user to only click the print macro to print the invoice. * All the calculations should be worked out by the system correctly, all the macros should work correctly and all the Vlookups should work. ...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. Creating a computer system for a video rental shop

    X Telephone number X X X X X X Post code X X X X X X Videos ID X X X X X X Title of the video X X X X X X Videos ISBN number X X X X Author X X X X X X Edition

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    The data entered can be converted into many different things such as rapports and forms as well as searching for specific data. This alternative does not cover all the user requirements. Filing Cabinet (Paper and pen) Advantages: * No need to know how computers work.

  1. Travel Agent Database - Effects of New System The new system will affect ...

    This is because the will be studying with all types of people, some who are familiar with computers. This encourages the employees from the experience of others. They would learn all sorts of things and not just how to manage a database.

  2. Create a power point presentation for people who dont understand cricket so I can ...

    on it 7 Ways of scoring runs Text explaining how many batsman play and how they can get runs So the audience knows how the batsman get runs 8 Rules: Ways of getting out The 7 most common dismissals for a batsman The audience would know how a batsmen can

  1. System analysisThe purpose of the new system is to extend the current computerised cottage ...

    A booking ref number must be in the form of BK 99 99 99 F. The first two and the last characters must be letters. The other six characters are numbers. The total length is nine characters. Any other format is rejected.

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

    assist in approaching a wider audience. This could be done using the Internet and e-mail to approach a wider audience/customer base. > Must be a more productive method than the previously used method, e.g. must allow more work to be completed in as short a time even with an increased customer base.

  1. I am investigating into Price

    � < 24 999 | | | 3 64 25 000 ? � < 29 999 | | | 3 67 30 000 ? � < 34 999 0 67 35 000 ? � < 39 999 | | | 3 70 40 000 ?

  2. drum kit costing system

    Sabian AA 8 inch splash � 63.67 Sabian AA 14" Mini-china � 100.77 Sabian AA 18" Medium thin crash � 142.77 Sabian B8 16" crash � 60.17 Sabian B8 20" ride � 83.97 Sabian AA Metal-X 10" splash � 74.17 Sabian AA Metal-X 18" china � 142.77 Zildjian Avedis 8"

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