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

spreadsheet project

Extracts from this document...

Introduction

Information Communication Technology Spreadsheet project. Analysis The company has issued its tour guides with laptop computers that have Microsoft Windows XP and Microsoft Office XP installed. They have asked you to produce a spreadsheet template to help the tour guides efficiently record sales of these additional trips and tickets. The tour guide travels out from Paris with the guests to Calais, where the tour guide gets off, and the coach continues its journey to London. The outward coach returns to Paris later that day with the new guests and collects the tour guide who has waited in Calais. The tour guide will take orders for the additional trips and tickets from guest parties/families as the coach continues on to Paris. Before leaving Paris, the tour guide will have received an e-mail with an Excel attachment complete with the guest list for the coach, so they will not need to enter the party/family names. Excel is perfect software for designing spreadsheets, as it allows you to make a template. ...read more.

Middle

Advantages and disadvantages. * Much quicker and easier * Cheaper to write them out * Able to make lots of copies * Don't strain your eyes as much * Have special programs designed for making spreadsheets * Not that reliable as the computer could crash or you could lose your document * Able to use data validation and spell check * Easy to distribute via email Design Using computer software such as excel is a perfect programme for designing spread sheets, as it calculates all of the data for you and sorts it out into order. I would defiantly use excel to make spread sheets because you can use complex data validation to make the sheet how you would like, also excel can add, subtract, multiply information for you so you don't have to use a calculator. Excel has another good option as it allows you to create fields of information which can then be created into a graph or table. The design of my spread sheet was very important as I had to think about whom the audience was and how my design and layout would affect them. ...read more.

Conclusion

Evaluation Overall I think that my spread sheet meets the specifications set as it contains all the right information which is professionally set which contains the right formatting and validation. My spread sheet designed on the computer is much better then simply writing it down in a sales book as it is much easier to distribute to the head office as it can send it by email via an attachment. Also it is much more uncommon that mistakes will occur as it is designed on a computer which checks for spelling mistakes and other common errors. By introducing spread sheet making this will make the company look much more professional as you have it all organised and type up. This will also benefit the company by saving a lot of time and money as you don't need to employ lots of people to write down the data by hand, because instead you can just type it up in excel which does most of the calculations for you. Spread sheets are a critical must have in any business as they make it easy to distribute data from one place to another and they improve the development of any business as it saves time and money. ...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 Software 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 Software essays

  1. Powerpoint review project

    A traditional slideshow would not do this as it would be harder to use and handle. Quantative Objectives The objectives that I am going to set for my presentation are: Background colours: These will be used to make the presentation colourful and to make it stand out more and interesting.

  2. Aids and Barriers to Communication

    For example if someone was colour blind and couldn't see the colour red it can be easily being changed so the can see the colour.

  1. Database design for a games shop.

    that once I have entered it I can't delete it quickly and without wasting time, further to the problem if I have to delete a record I have to do it manually. This is a key problem with the database, when a customer calls me to find out about a

  2. What is a computer registry?

    Related values are DWORD_LITTLE_ENDIAN (least significant byte is at the lowest address) and REG_DWORD_BIG_ENDIAN (least significant byte is at the highest address). Expandable String Value REG_EXPAND_SZ A variable-length data string. This data type includes variables that are resolved when a program or service uses the data.

  1. Database Review of Document

    validation rules, combo boxes and other ways to ensure that only valid data is put in. I cannot stop people putting in ridiculous values, e.g, saying someone is 35 when they are 25. For this, I suggest they should go on an IT course for databases to ensure data integrity is kept to the highest standards.

  2. Appropriate Software To do this project I am going to use excel because ...

    Flow of Data Product sales will be taken weekly over the course of one month. The expenditure is subtracted from the income to make the profit. From then on the profits for the different products will be weighed up against the expenditures, therefore coming to the grand profit for the month.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    a certain level, and the number of merits they had received from doing the tests. First of all, I wrote a nested IF function to tell me what area the child needed to improve (either reading or writing), depending on if it had said I needed to inform their parents.

  2. Information and Communical technology

    * Browser How will I input the data? Data Data Type Source Input Data Ref No Text Previous documents Keyboard Surname Text Customer Keyboard Last Purchase Date Date Invoice Keyboard Price Currency Company pricing policy Keyboard Title Text Lookup list Mouse Paid Yes/No Receipt Mouse Address 1 Text Customer Keyboard Telephone number Text Customer Keyboard Method of payment

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