• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  • Level: GCSE
  • Subject: ICT
  • Word count: 1800

Spreadsheet Report

Extracts from this document...

Introduction

Spreadsheet report 1) describe what the user needs The purpose of my spreadsheet is to model the cost of a Limo hiring service. The limos can be hired on a daily basis for a minimum of a day and a maximum of two days there will be a discount for a hiring the limo for more than �50 the discount will be 5% and if the client has hired more than �100 than they will get 10% discount. This means that when it is finished you will be able to see when a limo is being hired, on what date and how long for. Describe the data needed For my spreadsheet to be successful it needs to have the following data: * Hiring costs * Details of limos * Details of customers * Prices * Discounts 3) Describe the worksheets, formulas and functions you plan to use I will collect data from the Internet due to the range of sources and data available. I will collect data from theses websites: * www.limo.org * www.limos.com * www.limospros.com Worksheet 1- Limo Details Column Name Description Format 1 Registration Registration Number of Limo General 2 Limo name Name of Limo General 3 Cost per hour Price per hour Accounting 4 Seats How many seats Number 5 Booked How many times been booked General Worksheet 2- Hirer Details Column Name Description Format 1 Hirer Name Name of Hirer Text 2 ...read more.

Middle

* Click on format * Go to column * Click on width and * Finally a window should appear, and then you can change the column width 6) Once I had everything saved in my folder, I then began to insert data which was needed for the boat information. * First I typed in headings for the worksheet; I then highlighted them all and formatted them to be bold. This was so that the titles stuck out from everything else. * Then I began to insert data into the worksheet in the correct headings that it was needed for: Registration, Limo name, Cost per hour and Seats 7) I changed the format of the cells by. * Right Clicking any Cell * Clicking on "Format Cell" * format Cell window should appear * Then e.g. click on Number and change the format of cell to Time And * Finally click on ok and the cell is formatted. I also added border, patterns and changed the alignment. This is how I done it Border: * Highlight where you want a border * Click on format * Click on cell * A window should appear * Click on Border and * Choose what kind of border u want * Then press ok Here is an example I completed the same for patterns and alignment. ...read more.

Conclusion

This result is also shown in the print off at the back of this report. 8 Sort at least one worksheet into a selected order I decided to sort the data in order of my choice in one of my worksheet. This was the "Hirer Details" worksheet. Here is an example o f how I did this. * Highlight the cells you want to sort * Click on Data * Click on sort * A window should come up * Choose how you want to sort the data: ascending / descending Here is some screenshots how I done it. Here is the Result 9 Describe how you ensured that your work was accurate and safe I kept backups of my spreadsheet report on floppy, on lgfl, on my h-drive and on my computer at home. Here is a screenshot of the file being sent to floppy Here my work is on floppy. Here is a screenshot of the file on my home computer. Here my file is on lgfl To make sure that I didn't have any errors on my work I proof read my work and did a spell check. I also did a spelling and grammar check. I made my work accurate, I checked all the formulae I used and they were correct. I checked all my formulas my clicking on tools then on options, clicking on view and selecting/ticking formulas. ?? ?? ?? ?? ...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. The aim of my project is to make the task of the allocation of ...

    the amount of adults and concessions, and allow their prices to be changed in an easy way. The spreadsheet permits Mr. Brown to easily change the values of each calculation by changing the appropriate square, for example to change the pricing of any show, all the user must do it

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

    Step 11 Following that, I copied and pasted the two tables and pasted them next to the "reading" table; these two new tables were for "Writing." I then changed the scores for each term; fortunately all my functions were correct so they changed the values automatically.

  1. AQA GCSE ICT Specification B

    We would like to be able to create a complete new order on one sheet. We would like to be able to access ready made delivery notes and receipts from the new order screen. We would like to be able to search for old orders and information easily by order number.

  2. Logo Report

    The plane image stands out because the wings extend out of the silver circle. The "A" is very bold because of it's large size and it has a beautiful shape. This logo is very compact and attractive. Ryan Air is an Irish Airline company who specialise in cheap flights.

  1. Research, collect and describe graphics

    Pos: Easily noticed. Neg: The way that they are repetitious and the same banner is displayed on every part of the site can be putting-off for most users. Size: Compact - snugs in well with the website as a whole.

  2. ICT BTEC UNIT 2 - REPORT

    one of the strongest security systems in all of the operating systems in this table. Disadvantages for Linux are as follows: it takes a long time to learn which could be seen as a disadvantage because people want things instantly now days.

  1. Payments Spreadsheet task. - formulas and fomatting

    In order for me to workout the average amount per month the function which I used was AVERAGE. For the running total per pupil, a formula is used to workout the amount a pupil has paid throughout the months except December and the running total keeps a record of the

  2. Software Report

    It includes many features, however, I will not be using them all, below is a brief description of what each of the programmes I'll be using does: * Office Word - a word processing programme * Office Excel - a spreadsheet that also has abilities like a database * Office

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